MKTCOMMUNICATIONTEMPLATE
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | uniqueidentifier |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| NAME | nvarchar(100) | Default = '' | ||
| DESCRIPTION | nvarchar(255) | Default = '' | ||
| TEMPLATETYPECODE | tinyint | Default = 0 | ||
| TEMPLATETYPE | nvarchar(11) (Computed) | yes | CASE [TEMPLATETYPECODE] WHEN 0 THEN N'Constituent' END | |
| OVERRIDEAPPEALBUSINESSUNITS | bit | Default = 0 | ||
| DATEADDED | datetime | Default = getdate() | ||
| DATECHANGED | datetime | Default = getdate() | ||
| TS | timestamp | |||
| TSLONG | bigint (Computed) | yes | CONVERT(bigint, TS) | |
| ISACTIVE | bit | Default = 1 | ||
| OVERRIDEASKLADDERS | bit | Default = 0 | ||
| INCLUDESEEDS | bit | Default = 0 | ||
| ALLOWEFFORTBUSINESSUNITSOVERRIDE | bit | Default = 0 | ||
| ALLOWEFFORTADDRESSPROCESSINGOVERRIDE | bit | Default = 0 |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| ADDEDBYID | uniqueidentifier | CHANGEAGENT.ID | ||
| CHANGEDBYID | uniqueidentifier | CHANGEAGENT.ID | ||
| SITEID | uniqueidentifier | yes | SITE.ID | |
| BASECURRENCYID | uniqueidentifier | yes | CURRENCY.ID | |
| MKTSEGMENTATIONID | uniqueidentifier | yes | MKTSEGMENTATION.ID | |
| PARENTCOMMUNICATIONTEMPLATEID | uniqueidentifier | yes | MKTCOMMUNICATIONTEMPLATE.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_MKTCOMMUNICATIONTEMPLATE_BASECURRENCYID | BASECURRENCYID | |||
| IX_MKTCOMMUNICATIONTEMPLATE_DATEADDED | DATEADDED | yes | ||
| IX_MKTCOMMUNICATIONTEMPLATE_DATECHANGED | DATECHANGED | |||
| IX_MKTCOMMUNICATIONTEMPLATE_PARENTCOMMUNICATIONTEMPLATEID | PARENTCOMMUNICATIONTEMPLATEID | |||
| PK_MKTCOMMUNICATIONTEMPLATE | ID | yes | yes | |
| UIX_MKTCOMMUNICATIONTEMPLATE_MKTSEGMENTATIONID_PARENTCOMMUNICATIONTEMPLATEID_NAME | MKTSEGMENTATIONID, PARENTCOMMUNICATIONTEMPLATEID, NAME | yes |
Triggers
| Trigger Name | Description |
|---|---|
| TR_MKTCOMMUNICATIONTEMPLATE_AUDIT_UPDATE | |
| TR_MKTCOMMUNICATIONTEMPLATE_AUDIT_DELETE | |
| TR_MKTCOMMUNICATIONTEMPLATE_IU_BASECURRENCYID |
Referenced by
| Referenced by | Field |
|---|---|
| MKTCOMMUNICATIONTEMPLATEDEFAULT | COMMUNICATIONTEMPLATEID |
| MKTCOMMUNICATIONTEMPLATEDEFAULTAPPEAL | COMMUNICATIONTEMPLATEID |
| MKTCOMMUNICATIONTEMPLATEDEFAULTASKLADDEROVERRIDE | COMMUNICATIONTEMPLATEID |
| MKTCOMMUNICATIONTEMPLATEDEFAULTBUSINESSUNIT | COMMUNICATIONTEMPLATEID |
| MKTCOMMUNICATIONTEMPLATEDEFAULTFILTERSELECTION | COMMUNICATIONTEMPLATEID |
| MKTCOMMUNICATIONTEMPLATEDEFAULTKPI | COMMUNICATIONTEMPLATEID |
| MKTCOMMUNICATIONTEMPLATEDEFAULTSEED | COMMUNICATIONTEMPLATEID |
| MKTCOMMUNICATIONTEMPLATEDEFAULTSOLICITCODES | COMMUNICATIONTEMPLATEID |
| MKTCOMMUNICATIONTEMPLATEEXAMPLE | ID |