Stores information pertaining to a marketing effort.
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
CODE
|
nvarchar(10)
|
false
|
|
Source code component for this marketing effort.
|
|
NAME
|
nvarchar(100)
|
false
|
|
A name for the marketing effort.
|
|
DESCRIPTION
|
nvarchar(255)
|
false
|
|
A description about the marketing effort.
|
|
ACTIVE
|
bit
|
false
|
|
Whether the marketing effort is activated or not.
|
|
ACTIVATEDATE
|
datetime
|
true
|
|
The date the marketing effort was activated.
|
|
SAMPLESIZE
|
int
|
false
|
|
The percent or number of records to use for the test marketing effort.
|
|
SAMPLESIZETYPECODE
|
tinyint
|
false
|
|
The sample size type.
|
|
MANUALCALCULATIONMODE
|
bit
|
false
|
|
Whether or not a marketing effort is using manual calculation mode.
|
|
IDINTEGER
|
int
|
false
|
|
An integer key that can be used to uniquely identify this marketing effort.
|
|
DATEADDED
|
datetime
|
false
|
|
Indicates the date this record was added.
|
|
DATECHANGED
|
datetime
|
false
|
|
Indicates the date this record was last changed.
|
|
TS
|
timestamp
|
false
|
|
Timestamp.
|
|
TSLONG
|
bigint (Computed)
|
true
|
|
Numeric representation of the timestamp.
|
|
MAILDATE
|
datetime
|
true
|
|
The date the marketing effort was sent out.
|
|
HOUSEHOLDINGTYPECODE
|
tinyint
|
false
|
|
The type of household processing to use in this marketing effort.
|
|
MAILINGTYPECODE
|
tinyint
|
false
|
|
The type of marketing effort.
|
|
ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE
|
tinyint
|
false
|
|
Indicates the type of date to be used when considering seasonal addresses.
|
|
ADDRESSPROCESSINGOPTIONSEASONALASOFDATE
|
datetime
|
true
|
|
The specific date to be used when considering seasonal addresses.
|
|
USEADDRESSPROCESSING
|
bit
|
false
|
|
Determines whether or not to apply address processing options when performing calculations and exporting a marketing effort.
|
|
SAMPLESIZETYPE
|
nvarchar(7) (Computed)
|
true
|
|
Provides a translation for the 'SAMPLESIZETYPECODE' field.
|
|
ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPE
|
nvarchar(15) (Computed)
|
true
|
|
Provides a translation for the 'ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE' field.
|
|
RUNACTIVATEANDEXPORT
|
bit
|
false
|
|
Run activate and export upon process completion.
|
|
HOUSEHOLDINGINCLUDEINDIVIDUALSWITHNOHOUSEHOLD
|
bit
|
false
|
|
Determines whether or not to include qualifying individuals who are not members of any household.
|
|
HOUSEHOLDINGINCLUDEHOUSEHOLDSWITHNOMEMBERS
|
bit
|
false
|
|
Determines whether or not to include qualifying households which do not have any members.
|
|
HOUSEHOLDINGONERECORDPERHOUSEHOLD
|
bit
|
false
|
|
Determines whether or not to only accept one person per household during household processing.
|
|
HOUSEHOLDINGTYPE
|
nvarchar(40) (Computed)
|
true
|
|
Provides a translation for the 'HOUSEHOLDINGTYPECODE' field.
|
|
EXCLUDESPOUSE
|
bit
|
false
|
|
Determines whether or not exclude the spouse name from the name format if the spouse is included in the mailing.
|
|
OVERRIDEBUSINESSUNITS
|
bit
|
false
|
|
Determines whether the business units on the effort are being overridden by the segment.
|
|
COMMUNICATIONTYPECODE
|
tinyint
|
false
|
|
Indicates the communication type of the marketing effort.
|
|
MAILINGFAMILYTYPECODE
|
tinyint (Computed)
|
true
|
|
Indicates whether the marketing effort is using direct marketing, public media, or other communication type.
|
|
MAILINGFAMILYTYPE
|
varchar(23) (Computed)
|
false
|
|
Indicates whether the marketing effort is using direct marketing, public media, or other communication type.
|
|
CREATEOUTPUTIDSET
|
bit
|
false
|
|
Designates whether or not an ID set should be created as a result of the mailing activation process.
|
|
OUTPUTIDSETNAME
|
nvarchar(100)
|
false
|
|
The name of the output ID set to be created by the mailing activation process.
|
|
OVERWRITEOUTPUTIDSET
|
bit
|
false
|
|
Designates whether or not to overwrite the output ID set if one with the same name already exists.
|
|
COMMUNICATIONTYPE
|
nvarchar(16) (Computed)
|
true
|
|
Provides a translation for the 'COMMUNICATIONTYPECODE' field.
|
|
MAILINGTYPE
|
nvarchar(25) (Computed)
|
true
|
|
Provides a translation for the 'MAILINGTYPECODE' field.
|
|
ISHISTORICAL
|
bit
|
false
|
|
|
|
DUEDATE
|
datetime
|
true
|
|
|
|
CHANNELCODE
|
tinyint
|
false
|
|
|
|
CHANNEL
|
nvarchar(13) (Computed)
|
true
|
|
|
|
ALLOWRESERVINGFINDERNUMBERS
|
bit
|
false
|
|
|
|
ALLOWSPECIFYBUDGET
|
bit
|
false
|
|
|
|
ALLOWEXCLUDEPREVIOUSEFFORTS
|
bit
|
false
|
|
|
Indexes
| Index Name |
Field(s) |
Unique |
Primary |
Clustered |
|
IX_MKTSEGMENTATION_ADDRESSPROCESSINGOPTIONID
|
ADDRESSPROCESSINGOPTIONID
|
False
|
False
|
False
|
|
IX_MKTSEGMENTATION_BASECURRENCYID
|
|
False
|
False
|
False
|
|
IX_MKTSEGMENTATION_DATEADDED
|
|
False
|
False
|
True
|
|
IX_MKTSEGMENTATION_DATECHANGED
|
|
False
|
False
|
False
|
|
IX_MKTSEGMENTATION_ID
|
|
False
|
False
|
False
|
|
IX_MKTSEGMENTATION_MARKETINGPLANITEMID
|
|
False
|
False
|
False
|
|
IX_MKTSEGMENTATION_NAMEFORMATPARAMETERID
|
|
False
|
False
|
False
|
|
IX_MKTSEGMENTATION_OWNERID
|
|
False
|
False
|
False
|
|
IX_MKTSEGMENTATION_PARENTSEGMENTATIONID
|
|
False
|
False
|
False
|
|
IX_MKTSEGMENTATION_PARTDEFINITIONVALUESID
|
|
False
|
False
|
False
|
|
IX_MKTSEGMENTATION_SITEID
|
|
False
|
False
|
False
|
|
IX_MKTSEGMENTATION_SOURCECODEID
|
|
False
|
False
|
False
|
|
IX_MKTSEGMENTATION_IDINTEGER
|
|
True
|
False
|
False
|
|
PK_MKTSEGMENTATION
|
|
True
|
True
|
False
|
