MKTCOMMUNICATIONTEMPLATEDEFAULT

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
DESCRIPTION	nvarchar(255)		Default = ''
DESCRIPTIONLOCKED	bit		Default = 0
ALLOWRESERVINGFINDERNUMBERS	bit		Default = 0
DATEADDED	datetime		Default = getdate()
DATECHANGED	datetime		Default = getdate()
TS	timestamp
TSLONG	bigint (Computed)	yes	CONVERT(bigint, TS)
CHANNELCODE	tinyint		Default = 255
CHANNELCODELOCKED	bit		Default = 0
ALLOWSPECIFYBUDGET	bit		Default = 0
ALLOWSPECIFYBUDGETLOCKED	bit		Default = 0
ALLOWRESERVINGFINDERNUMBERSLOCKED	bit		Default = 0
APPEALLOCKED	bit		Default = 0
SOURCECODELOCKED	bit		Default = 0
MAILEXPORTDEFINITIONIDLOCKED	bit		Default = 0
PHONEEXPORTDEFINITIONIDLOCKED	bit		Default = 0
EMAILEXPORTDEFINITIONIDLOCKED	bit		Default = 0
EXPORTDESCRIPTION	nvarchar(255)		Default = ''
CURRENCYSYMBOLDISPLAYSETTINGCODELOCKED	bit		Default = 0
CURRENCYDECIMALDIGITSDISPLAYSETTINGCODELOCKED	bit		Default = 0
CURRENCYGROUPSEPARATORDISPLAYSETTINGCODELOCKED	bit		Default = 0
CURRENCYDECIMALSEPARATORDISPLAYSETTINGCODELOCKED	bit		Default = 0
DATEFORMATLOCKED	bit		Default = 0
FUZZYDATEFORMATLOCKED	bit		Default = 0
MONTHDAYFORMATLOCKED	bit		Default = 0
HOURMINUTEFORMATLOCKED	bit		Default = 0
USEADDRESSPROCESSING	bit		Default = 0
ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE	tinyint		Default = 0
ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPE	nvarchar(15) (Computed)	yes	CASE [ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE] WHEN 0 THEN N'Today' WHEN 1 THEN N<Specific date> END
ADDRESSPROCESSINGOPTIONSEASONALASOFDATE	datetime	yes
ADDRESSPROCESSINGLOCKED	bit		Default = 0
EXPORTDESCRIPTIONLOCKED	bit		Default = 0
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
HOUSEHOLDINGTYPECODE	tinyint		Default = 0
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
HOUSEHOLDINGINCLUDEINDIVIDUALSWITHNOHOUSEHOLD	bit		Default = 0
HOUSEHOLDINGINCLUDEHOUSEHOLDSWITHNOMEMBERS	bit		Default = 0
HOUSEHOLDINGONERECORDPERHOUSEHOLD	bit		Default = 0
HOUSEHOLDINGLOCKED	bit		Default = 0
INCLUDESELECTIONSLOCKED	bit		Default = 0
KPISLOCKED	bit		Default = 0
EXCLUDESELECTIONSLOCKED	bit		Default = 0
EXCLUDEDECEASED	bit		Default = 1
EXCLUDEDECEASEDLOCKED	bit		Default = 0
EXCLUDEINACTIVE	bit		Default = 1
EXCLUDEINACTIVELOCKED	bit		Default = 0
EXCLUSIONASOFDATE	datetime	yes
EXCLUSIONDATETYPECODE	tinyint		Default = 0
EXCLUSIONDATETYPE	nvarchar(15) (Computed)	yes	CASE [EXCLUSIONDATETYPECODE] WHEN 0 THEN N'Today' WHEN 1 THEN N<Specific date> END
EXCLUSIONASOFDATELOCKED	bit		Default = 0
EXCLUSIONSLOCKED	bit		Default = 0
ASKLADDEROVERRIDESLOCKED	bit		Default = 0
RUNSEGMENTATIONSEGMENTREFRESHPROCESS	bit		Default = 0
RUNSEGMENTATIONSEGMENTREFRESHPROCESSLOCKED	bit		Default = 0
RUNMARKETINGEXCLUSIONSREPORT	bit		Default = 1
RUNMARKETINGEXCLUSIONSREPORTLOCKED	bit		Default = 0
CACHESOURCEANALYSISRULEDATA	bit		Default = 0
CACHESOURCEANALYSISRULEDATALOCKED	bit		Default = 0
RUNSEGMENTATIONSEGMENTCALCULATEPROCESS	bit		Default = 1
RUNSEGMENTATIONSEGMENTREFRESHPROCESSACTIVATE	bit		Default = 0
RUNMARKETINGEXCLUSIONSREPORTACTIVATE	bit		Default = 1
CACHESOURCEANALYSISRULEDATAACTIVATE	bit		Default = 0
ACTIVATEOPTIONSLOCKED	bit		Default = 0
EXPORTAFTERACTIVATE	bit		Default = 0
EXPORTAFTERACTIVATELOCKED	bit		Default = 0
ALLOWEXCLUDEPREVIOUSEFFORTS	bit		Default = 0
ALLOWEXCLUDEPREVIOUSEFFORTSLOCKED	bit		Default = 0
SEEDSLOCKED	bit		Default = 0
BUSINESSUNITSLOCKED	bit		Default = 0
CACHESOURCEANALYSISRULEDATAACTIVATELOCKED	bit		Default = 0
CSVLINEBREAKCODELOCKED	bit		Default = 0

Foreign Keys

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

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_MKTCOMMUNICATIONTEMPLATEDEFAULT_ADDRESSPROCESSINGOPTIONID	ADDRESSPROCESSINGOPTIONID
IX_MKTCOMMUNICATIONTEMPLATEDEFAULT_BUSINESSPROCESSEXPORTFORMATID	BUSINESSPROCESSEXPORTFORMATID
IX_MKTCOMMUNICATIONTEMPLATEDEFAULT_COMMUNICATIONTEMPLATEID	COMMUNICATIONTEMPLATEID
IX_MKTCOMMUNICATIONTEMPLATEDEFAULT_DATEADDED	DATEADDED			yes
IX_MKTCOMMUNICATIONTEMPLATEDEFAULT_DATECHANGED	DATECHANGED
IX_MKTCOMMUNICATIONTEMPLATEDEFAULT_NAMEFORMATPARAMETERID	NAMEFORMATPARAMETERID
PK_MKTCOMMUNICATIONTEMPLATEDEFAULT	ID	yes	yes
UC_MKTCOMMUNICATIONTEMPLATEDEFAULT_COMMUNICATIONTEMPLATEID	COMMUNICATIONTEMPLATEID	yes

Triggers

Trigger Name	Description
TR_MKTCOMMUNICATIONTEMPLATEDEFAULT_AUDIT_UPDATE
TR_MKTCOMMUNICATIONTEMPLATEDEFAULT_AUDIT_DELETE