COMMUNICATIONLETTER
This table holds letters associated with Altru communications.
Primary Key
| Primary Key |
Field Type |
| ID |
uniqueidentifier |
Fields
| Field |
Field Type |
Null |
Notes |
Description |
| COMMUNICATIONTYPECODE |
tinyint |
|
Default = 0 |
0=Marketing effort, 1=Appeal mailing, 2=Event invitation, 3=Acknowledgement, 4=Reminder |
| SEQUENCE |
int |
|
Default = 0 |
The sequence in which this letter will be processed. |
| NAME |
nvarchar(100) |
|
Default = '' |
|
| CHANNELCODE |
tinyint |
|
Default = 0 |
0=Mail, 1=Email, 2=Mail and Email |
| CHANNEL |
nvarchar(14) (Computed) |
yes |
CASE [CHANNELCODE] WHEN 0 THEN N'Mail' WHEN 1 THEN N'Email' WHEN 2 THEN N'Mail and Email' END |
Provides a translation for the 'CHANNELCODE' field. |
| CHANNELPREFERENCECODE |
tinyint |
|
Default = 0 |
0=Email, 1=Mail |
| CHANNELPREFERENCE |
nvarchar(5) (Computed) |
yes |
CASE [CHANNELPREFERENCECODE] WHEN 0 THEN N'Email' WHEN 1 THEN N'Mail' END |
Provides a translation for the 'CHANNELPREFERENCECODE' field. |
| MAILCONTENTHTML |
nvarchar(max) |
|
Default = '' |
|
| EMAILCONTENTHTML |
nvarchar(max) |
|
Default = '' |
|
| EMAILSUBJECT |
nvarchar(4000) |
|
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 |
0=Letter, 1=A4 |
| PAPERSIZE |
nvarchar(6) (Computed) |
yes |
CASE [PAPERSIZECODE] WHEN 0 THEN N'Letter' WHEN 1 THEN N'A4' END |
Provides a translation for the 'PAPERSIZECODE' field. |
| DATEADDED |
datetime |
|
Default = getdate() |
Indicates the date this record was added. |
| DATECHANGED |
datetime |
|
Default = getdate() |
Indicates the date this record was last changed. |
| TS |
timestamp |
|
|
Timestamp. |
| TSLONG |
bigint (Computed) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
| INCLUDEINACTIVE |
bit |
|
Default = 0 |
|
| EMAILREPLYTOADDRESS |
UDT_EMAILADDRESS |
|
Default = '' |
|
| COMMUNICATIONTYPE |
nvarchar(16) (Computed) |
yes |
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 |
Provides a translation for the 'COMMUNICATIONTYPECODE' field. |
| OUTPUTTYPECODE |
tinyint |
|
Default = 0 |
|
| OUTPUTTYPE |
nvarchar(5) (Computed) |
yes |
CASE [OUTPUTTYPECODE] WHEN 0 THEN N'Merge' WHEN 1 THEN N'CSV' END |
|
| RUNSCHEDULED |
bit |
|
Default = 1 |
|
| RUNNOW |
bit |
|
Default = 0 |
|
Foreign Keys
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| IX_COMMUNICATIONLETTER_DATEADDED |
DATEADDED |
|
|
yes |
| 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 |
yes |
yes |
|
| UIX_COMMUNICATIONLETTER_SEGMENTATIONID_NAME |
SEGMENTATIONID, NAME |
yes |
|
|
Triggers
Referenced by