Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
CONFIRMATIONTYPECODE
|
tinyint
|
false
|
|
Email Type code
|
|
DATEADDED
|
datetime
|
false
|
|
Indicates the date this record was added.
|
|
DATECHANGED
|
datetime
|
false
|
|
Indicates the date this record was last changed.
|
|
TS
|
timestamp
|
false
|
|
Timestamp.
|
|
TSLONG
|
bigint (Computed)
|
true
|
|
Numeric representation of the timestamp.
|
|
ISAVAILABLETOINDIVIDUAL
|
bit
|
false
|
|
Allow this participant communication template to individual participants
|
|
ISAVAILABLETOHOUSEHOLD
|
bit
|
false
|
|
Allow this participant communication template to household participants
|
|
ISAVAILABLETOTEAMMEMBER
|
bit
|
false
|
|
Allow this participant communication to team members
|
|
ISAVAILABLETOTEAMLEADER
|
bit
|
false
|
|
Allow this participant communication to team leaders
|
|
ISAVAILABLETOCOMPANYLEADER
|
bit
|
false
|
|
Allow this participant communication to company leaders
|
|
ISAVAILABLETOFUNDRAISINGCOACH
|
bit
|
false
|
|
Allow this participant communication to fundraising coach
|
|
ISAVAILABLETOSPONSOR
|
bit
|
false
|
|
Allow this participant communication to sponsor
|
|
ISACTIVE
|
bit
|
false
|
|
Template is activate or not
|
|
RECIPIENTDONOR
|
bit
|
false
|
|
The recommended contact type to donors
|
|
RECIPIENTPROSPECT
|
bit
|
false
|
|
The recommended contact type to prospects
|
|
RECIPIENTINDIVIDUAL
|
bit
|
false
|
|
The recommended contact type to individuals
|
|
RECIPIENTHOUSEHOLDMEMBER
|
bit
|
false
|
|
The recommended contact type to household members
|
|
RECIPIENTHOUSEHOLDLEADER
|
bit
|
false
|
|
The recommended contact type to household leaders
|
|
RECIPIENTTEAMMEMBER
|
bit
|
false
|
|
The recommended contact type to team members
|
|
RECIPIENTTEAMLEADER
|
bit
|
false
|
|
The recommended contact type to team leaders
|
|
RECIPIENTCOMPANYLEADER
|
bit
|
false
|
|
The recommended contact type to company leaders
|
|
RECIPIENTSTATUSPREVIOUS
|
bit
|
false
|
|
The recipient previous status
|
|
RECIPIENTSTATUSCURRENT
|
bit
|
false
|
|
The recipient current status
|
|
AVAILABLEASLETTER
|
bit
|
false
|
|
Make available as a letter template
|
|
ISAVAILABLETOHOUSEHOLDMEMBER
|
bit
|
false
|
|
|
|
ISDEFAULTFORTASK
|
bit
|
false
|
|
|
|
CONFIRMATIONTYPE
|
nvarchar(51) (Computed)
|
true
|
|
|
