MKTCOMMUNICATIONTEMPLATEDEFAULT (4.0SP20)

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes
COMMUNICATIONTEMPLATEID	uniqueidentifier	false	MKTCOMMUNICATIONTEMPLATE.ID
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID
MAILEXPORTDEFINITIONID	uniqueidentifier	true	EXPORTDEFINITION.ID
PHONEEXPORTDEFINITIONID	uniqueidentifier	true	EXPORTDEFINITION.ID
EMAILEXPORTDEFINITIONID	uniqueidentifier	true	EXPORTDEFINITION.ID
BUSINESSPROCESSEXPORTFORMATID	uniqueidentifier	true	BUSINESSPROCESSEXPORTFORMAT.ID
ADDRESSPROCESSINGOPTIONID	uniqueidentifier	true	ADDRESSPROCESSINGOPTION.ID
NAMEFORMATPARAMETERID	uniqueidentifier	true	NAMEFORMATPARAMETER.ID
COMMUNICATIONNAMESCHEMEID	uniqueidentifier	true	MKTCOMMUNICATIONNAMESCHEME.ID
SOURCECODEID	uniqueidentifier	true	MKTSOURCECODE.ID

Fields
Field	Field Type	Null	Notes
DESCRIPTION	nvarchar(255)	false	''
DESCRIPTIONLOCKED	bit	false	0
ALLOWRESERVINGFINDERNUMBERS	bit	false	0
DATEADDED	datetime	false	getdate()
DATECHANGED	datetime	false	getdate()
TS	timestamp	false
TSLONG	bigint (Computed)	true
CHANNELCODE	tinyint	false	255
CHANNELCODELOCKED	bit	false	0
ALLOWSPECIFYBUDGET	bit	false	0
ALLOWSPECIFYBUDGETLOCKED	bit	false	0
ALLOWRESERVINGFINDERNUMBERSLOCKED	bit	false	0
APPEALLOCKED	bit	false	0
SOURCECODELOCKED	bit	false	0
MAILEXPORTDEFINITIONIDLOCKED	bit	false	0
PHONEEXPORTDEFINITIONIDLOCKED	bit	false	0
EMAILEXPORTDEFINITIONIDLOCKED	bit	false	0
EXPORTDESCRIPTION	nvarchar(255)	false	''
CURRENCYSYMBOLDISPLAYSETTINGCODELOCKED	bit	false	0
CURRENCYDECIMALDIGITSDISPLAYSETTINGCODELOCKED	bit	false	0
CURRENCYGROUPSEPARATORDISPLAYSETTINGCODELOCKED	bit	false	0
CURRENCYDECIMALSEPARATORDISPLAYSETTINGCODELOCKED	bit	false	0
DATEFORMATLOCKED	bit	false	0
FUZZYDATEFORMATLOCKED	bit	false	0
MONTHDAYFORMATLOCKED	bit	false	0
HOURMINUTEFORMATLOCKED	bit	false	0
USEADDRESSPROCESSING	bit	false	0
ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE	tinyint	false	0
ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPE	nvarchar(15) (Computed)	true
ADDRESSPROCESSINGOPTIONSEASONALASOFDATE	datetime	true
ADDRESSPROCESSINGLOCKED	bit	false	0
EXPORTDESCRIPTIONLOCKED	bit	false	0
CHANNEL	nvarchar(13) (Computed)	true
HOUSEHOLDINGTYPECODE	tinyint	false	0
HOUSEHOLDINGTYPE	nvarchar(40) (Computed)	true
HOUSEHOLDINGINCLUDEINDIVIDUALSWITHNOHOUSEHOLD	bit	false	0
HOUSEHOLDINGINCLUDEHOUSEHOLDSWITHNOMEMBERS	bit	false	0
HOUSEHOLDINGONERECORDPERHOUSEHOLD	bit	false	0
HOUSEHOLDINGLOCKED	bit	false	0
INCLUDESELECTIONSLOCKED	bit	false	0
KPISLOCKED	bit	false	0
EXCLUDESELECTIONSLOCKED	bit	false	0
EXCLUDEDECEASED	bit	false	1
EXCLUDEDECEASEDLOCKED	bit	false	0
EXCLUDEINACTIVE	bit	false	1
EXCLUDEINACTIVELOCKED	bit	false	0
EXCLUSIONASOFDATE	datetime	true
EXCLUSIONDATETYPECODE	tinyint	false	0
EXCLUSIONDATETYPE	nvarchar(15) (Computed)	true
EXCLUSIONASOFDATELOCKED	bit	false	0
EXCLUSIONSLOCKED	bit	false	0
ASKLADDEROVERRIDESLOCKED	bit	false	0
RUNSEGMENTATIONSEGMENTREFRESHPROCESS	bit	false	0
RUNSEGMENTATIONSEGMENTREFRESHPROCESSLOCKED	bit	false	0
RUNMARKETINGEXCLUSIONSREPORT	bit	false	1
RUNMARKETINGEXCLUSIONSREPORTLOCKED	bit	false	0
CACHESOURCEANALYSISRULEDATA	bit	false	0
CACHESOURCEANALYSISRULEDATALOCKED	bit	false	0
RUNSEGMENTATIONSEGMENTCALCULATEPROCESS	bit	false	1
RUNSEGMENTATIONSEGMENTREFRESHPROCESSACTIVATE	bit	false	0
RUNMARKETINGEXCLUSIONSREPORTACTIVATE	bit	false	1
CACHESOURCEANALYSISRULEDATAACTIVATE	bit	false	0
ACTIVATEOPTIONSLOCKED	bit	false	0
EXPORTAFTERACTIVATE	bit	false	0
EXPORTAFTERACTIVATELOCKED	bit	false	0
ALLOWEXCLUDEPREVIOUSEFFORTS	bit	false	0
ALLOWEXCLUDEPREVIOUSEFFORTSLOCKED	bit	false	0
SEEDSLOCKED	bit	false	0
BUSINESSUNITSLOCKED	bit	false	0
CACHESOURCEANALYSISRULEDATAACTIVATELOCKED	bit	false	0
CSVLINEBREAKCODELOCKED	bit	false	0

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_MKTCOMMUNICATIONTEMPLATEDEFAULT_ADDRESSPROCESSINGOPTIONID	ADDRESSPROCESSINGOPTIONID	False	False	False
IX_MKTCOMMUNICATIONTEMPLATEDEFAULT_BUSINESSPROCESSEXPORTFORMATID	BUSINESSPROCESSEXPORTFORMATID	False	False	False
IX_MKTCOMMUNICATIONTEMPLATEDEFAULT_COMMUNICATIONTEMPLATEID	COMMUNICATIONTEMPLATEID	False	False	False
IX_MKTCOMMUNICATIONTEMPLATEDEFAULT_DATEADDED	DATEADDED	False	False	True
IX_MKTCOMMUNICATIONTEMPLATEDEFAULT_DATECHANGED	DATECHANGED	False	False	False
IX_MKTCOMMUNICATIONTEMPLATEDEFAULT_NAMEFORMATPARAMETERID	NAMEFORMATPARAMETERID	False	False	False
PK_MKTCOMMUNICATIONTEMPLATEDEFAULT	ID	True	True	False
UC_MKTCOMMUNICATIONTEMPLATEDEFAULT_COMMUNICATIONTEMPLATEID	COMMUNICATIONTEMPLATEID	True	False	False

Triggers
Trigger Name	Description
TR_MKTCOMMUNICATIONTEMPLATEDEFAULT_AUDIT_UPDATE
TR_MKTCOMMUNICATIONTEMPLATEDEFAULT_AUDIT_DELETE