| Primary Key | Field Type |
|---|---|
 ID |
uniqueidentifier |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 COMMUNICATIONTYPECODE |
tinyint | Default = 0 | ||
| SEQUENCE |
int | Default = 0 | ||
| NAME |
nvarchar(100) | Default = '' | ||
| CHANNELCODE |
tinyint | Default = 0 | ||
 CHANNEL |
nvarchar(14) (Computed) |  |
CASE [CHANNELCODE] WHEN 0 THEN N'Mail' WHEN 1 THEN N'Email' WHEN 2 THEN N'Mail and Email' END | |
| CHANNELPREFERENCECODE |
tinyint | Default = 0 | ||
| CHANNELPREFERENCE |
nvarchar(5) (Computed) | |
CASE [CHANNELPREFERENCECODE] WHEN 0 THEN N'Email' WHEN 1 THEN N'Mail' END | |
| MAILCONTENTHTML |
nvarchar(max) | Default = '' | ||
| EMAILCONTENTHTML |
nvarchar(max) | Default = '' | ||
| EMAILSUBJECT |
nvarchar(255) | Default = '' | ||
| EMAILFROMDISPLAYNAME |
nvarchar(255) | Default = '' | ||
| EMAILFROMADDRESS |
UDT_EMAILADDRESS | Default = '' | ||
| MARGINTOP |
decimal(20, 4) | Default = 1 | ||
| MARGINBOTTOM |
decimal(20, 4) | Default = 1 | ||
| MARGINLEFT |
decimal(20, 4) | Default = 1 | ||
| MARGINRIGHT |
decimal(20, 4) | Default = 1 | ||
| PAPERSIZECODE |
tinyint | Default = 0 | ||
| PAPERSIZE |
nvarchar(6) (Computed) | |
CASE [PAPERSIZECODE] WHEN 0 THEN N'Letter' WHEN 1 THEN N'A4' END | |
| DATEADDED |
datetime | Default = getdate() | ||
| DATECHANGED |
datetime | Default = getdate() | ||
| TS |
timestamp | |||
| TSLONG |
bigint (Computed) | |
CONVERT(bigint, TS) | |
| INCLUDEINACTIVE |
bit | Default = 0 | ||
| EMAILREPLYTOADDRESS |
UDT_EMAILADDRESS | Default = '' | ||
| COMMUNICATIONTYPE |
nvarchar(16) (Computed) | |
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 | |
| OUTPUTTYPECODE |
tinyint | Default = 0 | ||
| OUTPUTTYPE |
nvarchar(5) (Computed) | |
CASE [OUTPUTTYPECODE] WHEN 0 THEN N'Merge' WHEN 1 THEN N'CSV' END | |
| RUNSCHEDULED |
bit | Default = 1 | ||
| RUNNOW |
bit | Default = 0 |
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 SEGMENTATIONID |
uniqueidentifier | |
MKTSEGMENTATION.ID | |
| MKTASKLADDERID |
uniqueidentifier | |
MKTASKLADDER.ID | |
| MAILPACKAGEID |
uniqueidentifier | |
MKTPACKAGE.ID | |
| EMAILPACKAGEID |
uniqueidentifier | |
MKTPACKAGE.ID | |
| MAILSEGMENTID |
uniqueidentifier | |
MKTSEGMENT.ID | |
| EMAILSEGMENTID |
uniqueidentifier | |
MKTSEGMENT.ID | |
| ADDEDBYID |
uniqueidentifier | CHANGEAGENT.ID | ||
| CHANGEDBYID |
uniqueidentifier | CHANGEAGENT.ID | ||
| EMAILSTATUSID |
uniqueidentifier | |
EMAILSTATUSGENERALPURPOSE.ID |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_COMMUNICATIONLETTER_DATEADDED |
DATEADDED | |
||
 IX_COMMUNICATIONLETTER_DATECHANGED |
DATECHANGED | |||
| IX_COMMUNICATIONLETTER_EMAILPACKAGEID |
EMAILPACKAGEID | |||
| IX_COMMUNICATIONLETTER_EMAILSEGMENTID |
EMAILSEGMENTID | |||
| IX_COMMUNICATIONLETTER_MAILPACKAGEID |
MAILPACKAGEID | |||
| IX_COMMUNICATIONLETTER_MAILSEGMENTID |
MAILSEGMENTID | |||
| IX_COMMUNICATIONLETTER_MKTASKLADDERID |
MKTASKLADDERID | |||
| PK_COMMUNICATIONLETTER |
ID | |
|
|
| UIX_COMMUNICATIONLETTER_SEGMENTATIONID_NAME |
SEGMENTATIONID, NAME | |
| Trigger Name | Description |
|---|---|
 TR_COMMUNICATIONLETTER_AUDIT_UPDATE |
|
| TR_COMMUNICATIONLETTER_AUDIT_DELETE |
| Referenced by | Field |
|---|---|
 COMMUNICATIONLETTERACTIVITYEXCLUSIONS |
COMMUNICATIONLETTERID |
| COMMUNICATIONLETTEREXCLUDEDSOLICITCODE |
COMMUNICATIONLETTERID |
| COMMUNICATIONLETTERSELECTION |
COMMUNICATIONLETTERID |