| Field |
Field Type |
Null |
Notes |
Description |
 CONFIRMATIONTYPECODE |
tinyint |
|
Default = 1 |
Email Type code |
| 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) |
 |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
| ISAVAILABLETOINDIVIDUAL |
bit |
|
Default = 1 |
Allow this participant communication template to individual participants |
| ISAVAILABLETOHOUSEHOLD |
bit |
|
Default = 1 |
Allow this participant communication template to household participants |
| ISAVAILABLETOTEAMMEMBER |
bit |
|
Default = 1 |
Allow this participant communication to team members |
| ISAVAILABLETOTEAMLEADER |
bit |
|
Default = 1 |
Allow this participant communication to team leaders |
| ISAVAILABLETOCOMPANYLEADER |
bit |
|
Default = 1 |
Allow this participant communication to company leaders |
| ISAVAILABLETOFUNDRAISINGCOACH |
bit |
|
Default = 1 |
Allow this participant communication to fundraising coach |
| ISAVAILABLETOSPONSOR |
bit |
|
Default = 1 |
Allow this participant communication to sponsor |
| ISACTIVE |
bit |
|
Default = 1 |
Template is activate or not |
| RECIPIENTDONOR |
bit |
|
Default = 0 |
The recommended contact type to donors |
| RECIPIENTPROSPECT |
bit |
|
Default = 0 |
The recommended contact type to prospects |
| RECIPIENTINDIVIDUAL |
bit |
|
Default = 0 |
The recommended contact type to individuals |
| RECIPIENTHOUSEHOLDMEMBER |
bit |
|
Default = 0 |
The recommended contact type to household members |
| RECIPIENTHOUSEHOLDLEADER |
bit |
|
Default = 0 |
The recommended contact type to household leaders |
| RECIPIENTTEAMMEMBER |
bit |
|
Default = 0 |
The recommended contact type to team members |
| RECIPIENTTEAMLEADER |
bit |
|
Default = 0 |
The recommended contact type to team leaders |
| RECIPIENTCOMPANYLEADER |
bit |
|
Default = 0 |
The recommended contact type to company leaders |
| RECIPIENTSTATUSPREVIOUS |
bit |
|
Default = 0 |
The recipient previous status |
| RECIPIENTSTATUSCURRENT |
bit |
|
Default = 0 |
The recipient current status |
| AVAILABLEASLETTER |
bit |
|
Default = 0 |
Make available as a letter template |
| ISAVAILABLETOHOUSEHOLDMEMBER |
bit |
|
Default = 1 |
|
| ISDEFAULTFORTASK |
bit |
|
Default = 0 |
|
| CONFIRMATIONTYPE |
nvarchar(51) (Computed) |
|
CASE [CONFIRMATIONTYPECODE] WHEN 1 THEN N'Registration' WHEN 2 THEN N'Sponsorship' WHEN 3 THEN N'Donation' WHEN 4 THEN N'Volunteer' WHEN 5 THEN N'RecurringGiftReminder' WHEN 6 THEN N'ContactUs' WHEN 20 THEN N'Weekly summary' WHEN 21 THEN N'Monthly summary' WHEN 22 THEN N'Donation received ? individual participant' WHEN 23 THEN N'Donation received - fundraising group' WHEN 24 THEN N'Donation received - fundraising group member' WHEN 25 THEN N'New fundraising group member' WHEN 26 THEN N'New fundraising group' WHEN 27 THEN N'Comment received - individual' WHEN 28 THEN N'Comment received - fundraising group' WHEN 29 THEN N'Incentive level achievement' WHEN 30 THEN N'30 day login reminder' WHEN 31 THEN N'Like added to comment - individual' WHEN 32 THEN N'Like added to comment - fundraising group' WHEN 33 THEN N'Notifications - Marketing' WHEN 34 THEN N'Donation transfer received - individual participant' WHEN 35 THEN N'Promotion received' WHEN 50 THEN N'Donation additional notification' WHEN 51 THEN N'Donation additional notification(no link)' WHEN 52 THEN N'Registrant limit reached' WHEN 53 THEN N'Sponsor limit reached' WHEN 97 THEN N'RequestReceived' WHEN 98 THEN N'RequestApproved' WHEN 99 THEN N'RequestDeclined' WHEN 100 THEN N'Participant Communication' WHEN 101 THEN N'Registrant confirmation screen' WHEN 102 THEN N'Sponsor confirmation screen' WHEN 103 THEN N'Donor confirmation screen' WHEN 104 THEN N'Contact confirmation screen' END |
|
ID
EVENTID
IX_EVENTEMAILTEMPLATE_DATEADDED
IX_EVENTEMAILTEMPLATE_DATECHANGED
TR_EVENTEMAILTEMPLATE_AUDIT_UPDATE