| Field |
Field Type |
Null |
Notes |
Description |
 CODE |
nvarchar(10) |
|
Default = '' |
Source code component for this marketing effort. |
| NAME |
nvarchar(100) |
|
Default = '' |
A name for the marketing effort. |
| DESCRIPTION |
nvarchar(255) |
|
Default = '' |
A description about the marketing effort. |
| ACTIVE |
bit |
|
Default = 0 |
Whether the marketing effort is activated or not. |
| ACTIVATEDATE |
datetime |
 |
|
The date the marketing effort was activated. |
| SAMPLESIZE |
int |
|
Default = 100 |
The percent or number of records to use for the test marketing effort. |
| SAMPLESIZETYPECODE |
tinyint |
|
Default = 0 |
The sample size type. |
| MANUALCALCULATIONMODE |
bit |
|
Default = 1 |
Whether or not a marketing effort is using manual calculation mode. |
| IDINTEGER |
int |
|
|
An integer key that can be used to uniquely identify this marketing effort. |
| DATEADDED |
datetime |
|
Default = getdate() |
Indicates the date this record was added. |
| DATECHANGED |
datetime |
|
Default = getdate() |
Indicates the date this record was last changed. |
| TS |
timestamp |
|
|
Timestamp. |
 TSLONG |
bigint (Computed) |
|
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
| MAILDATE |
datetime |
|
|
The date the marketing effort was sent out. |
| HOUSEHOLDINGTYPECODE |
tinyint |
|
Default = 0 |
The type of household processing to use in this marketing effort. |
| MAILINGTYPECODE |
tinyint |
|
Default = 0 |
The type of marketing effort. |
| ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE |
tinyint |
|
Default = 0 |
Indicates the type of date to be used when considering seasonal addresses. |
| ADDRESSPROCESSINGOPTIONSEASONALASOFDATE |
datetime |
|
|
The specific date to be used when considering seasonal addresses. |
| USEADDRESSPROCESSING |
bit |
|
Default = 0 |
Determines whether or not to apply address processing options when performing calculations and exporting a marketing effort. |
| RUNACTIVATEANDEXPORT |
bit |
|
Default = 0 |
Run activate and export upon process completion. |
| HOUSEHOLDINGINCLUDEINDIVIDUALSWITHNOHOUSEHOLD |
bit |
|
Default = 0 |
Determines whether or not to include qualifying individuals who are not members of any household. |
| HOUSEHOLDINGINCLUDEHOUSEHOLDSWITHNOMEMBERS |
bit |
|
Default = 0 |
Determines whether or not to include qualifying households which do not have any members. |
| HOUSEHOLDINGONERECORDPERHOUSEHOLD |
bit |
|
Default = 0 |
Determines whether or not to only accept one person per household during household processing. |
| SAMPLESIZETYPE |
nvarchar(7) (Computed) |
|
CASE [SAMPLESIZETYPECODE] WHEN 0 THEN N'Percent' WHEN 1 THEN N'Records' END |
Provides a translation for the 'SAMPLESIZETYPECODE' field. |
| HOUSEHOLDINGTYPE |
nvarchar(40) (Computed) |
|
CASE [HOUSEHOLDINGTYPECODE] WHEN 0 THEN N'All qualifying constituents' WHEN 1 THEN N'Qualifying individuals and organizations' WHEN 2 THEN N'Qualifying households' END |
Provides a translation for the 'HOUSEHOLDINGTYPECODE' field. |
| ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPE |
nvarchar(15) (Computed) |
|
CASE [ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE] WHEN 0 THEN N'Today' WHEN 1 THEN N'<Specific date>' END |
Provides a translation for the 'ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE' field. |
| EXCLUDESPOUSE |
bit |
|
Default = 0 |
Determines whether or not exclude the spouse name from the name format if the spouse is included in the mailing. |
| OVERRIDEBUSINESSUNITS |
bit |
|
Default = 0 |
Determines whether the business units on the effort are being overridden by the segment. |
| COMMUNICATIONTYPECODE |
tinyint |
|
Default = 0 |
Indicates the communication type of the marketing effort. |
| MAILINGFAMILYTYPECODE |
tinyint (Computed) |
|
convert(tinyint, case when [COMMUNICATIONTYPECODE] > 0 then 3 when [MAILINGTYPECODE] = 4 then 2 else 1 end) |
Indicates whether the marketing effort is using direct marketing, public media, or other communication type. |
| MAILINGFAMILYTYPE |
varchar(23) (Computed) |
|
case when [COMMUNICATIONTYPECODE] > 0 then 'Other communication' when [MAILINGTYPECODE] = 4 then 'Public media effort' else 'Direct marketing effort' end |
Indicates whether the marketing effort is using direct marketing, public media, or other communication type. |
| CREATEOUTPUTIDSET |
bit |
|
Default = 0 |
Designates whether or not an ID set should be created as a result of the mailing activation process. |
| OUTPUTIDSETNAME |
nvarchar(100) |
|
Default = '' |
The name of the output ID set to be created by the mailing activation process. |
| OVERWRITEOUTPUTIDSET |
bit |
|
Default = 0 |
Designates whether or not to overwrite the output ID set if one with the same name already exists. |
| COMMUNICATIONTYPE |
nvarchar(16) (Computed) |
|
CASE [COMMUNICATIONTYPECODE] WHEN 0 THEN N'Marketing effort' WHEN 1 THEN N'Appeal mailing' WHEN 2 THEN N'Event invitation' WHEN 3 THEN N'Acknowledgement' WHEN 4 THEN N'Reminder' END |
|
| MAILINGTYPE |
nvarchar(25) (Computed) |
|
CASE [MAILINGTYPECODE] WHEN 0 THEN N'Direct marketing effort' WHEN 1 THEN N'Marketing acknowledgement' WHEN 2 THEN N'Membership effort' WHEN 3 THEN N'Sponsorship effort' WHEN 4 THEN N'Public media effort' WHEN 5 THEN N'Communication revenue' END |
|
| ISHISTORICAL |
bit |
|
Default = 0 |
|
| Index Name |
Field(s) |
Unique |
Primary |
Clustered |
 IX_MKTSEGMENTATION_ADDRESSPROCESSINGOPTIONID |
ADDRESSPROCESSINGOPTIONID |
|
|
|
| IX_MKTSEGMENTATION_BASECURRENCYID |
BASECURRENCYID |
|
|
|
 IX_MKTSEGMENTATION_DATEADDED |
DATEADDED |
|
|
|
| IX_MKTSEGMENTATION_DATECHANGED |
DATECHANGED |
|
|
|
| IX_MKTSEGMENTATION_ID |
ID |
|
|
|
| IX_MKTSEGMENTATION_MARKETINGPLANITEMID |
MARKETINGPLANITEMID |
|
|
|
| IX_MKTSEGMENTATION_NAMEFORMATPARAMETERID |
NAMEFORMATPARAMETERID |
|
|
|
| IX_MKTSEGMENTATION_PARENTSEGMENTATIONID |
PARENTSEGMENTATIONID |
|
|
|
| IX_MKTSEGMENTATION_PARTDEFINITIONVALUESID |
PARTDEFINITIONVALUESID |
|
|
|
| IX_MKTSEGMENTATION_SITEID |
SITEID |
|
|
|
| IX_MKTSEGMENTATION_SOURCECODEID |
SOURCECODEID |
|
|
|
| IX_MKTSEGMENTATION_IDINTEGER |
IDINTEGER |
|
|
|
 PK_MKTSEGMENTATION |
ID |
|
|
|
MARKETINGPLANITEMID
TR_MKTSEGMENTATION_AUDIT_ETLDELETEDID