| 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 |
yes |
|
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) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
| MAILDATE |
datetime |
yes |
|
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 |
yes |
|
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. |
| SAMPLESIZETYPE |
nvarchar(7) (Computed) |
yes |
CASE [SAMPLESIZETYPECODE] WHEN 0 THEN N'Percent' WHEN 1 THEN N'Records' END |
Provides a translation for the 'SAMPLESIZETYPECODE' field. |
| ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPE |
nvarchar(15) (Computed) |
yes |
CASE [ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE] WHEN 0 THEN N'Today' WHEN 1 THEN N<Specific date> END |
Provides a translation for the 'ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE' field. |
| 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. |
| HOUSEHOLDINGTYPE |
nvarchar(40) (Computed) |
yes |
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. |
| 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) |
yes |
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) |
yes |
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 |
Provides a translation for the 'COMMUNICATIONTYPECODE' field. |
| MAILINGTYPE |
nvarchar(25) (Computed) |
yes |
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 |
Provides a translation for the 'MAILINGTYPECODE' field. |
| ISHISTORICAL |
bit |
|
Default = 0 |
|
| DUEDATE |
datetime |
yes |
|
|
| CHANNELCODE |
tinyint |
|
Default = 255 |
|
| CHANNEL |
nvarchar(13) (Computed) |
yes |
CASE [CHANNELCODE] WHEN 0 THEN N'Mail' WHEN 1 THEN N'Email' WHEN 2 THEN N'Phone' WHEN 255 THEN N'Multi-channel' END |
|
| ALLOWRESERVINGFINDERNUMBERS |
bit |
|
Default = 0 |
|
| ALLOWSPECIFYBUDGET |
bit |
|
Default = 0 |
|
| ALLOWEXCLUDEPREVIOUSEFFORTS |
bit |
|
Default = 0 |
|