Primary Key Field Type
 ID uniqueidentifier

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
 CONFIRMATIONTYPE nvarchar(59) (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 or household participant' 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 or household participant' WHEN 32 THEN N'Like added to comment - fundraising group' WHEN 33 THEN N'Notifications - Marketing' WHEN 50 THEN N'Donation additional notification' WHEN 51 THEN N'Donation additional notification(no link)' WHEN 97 THEN N'RequestReceived' WHEN 98 THEN N'RequestApproved' WHEN 99 THEN N'RequestDeclined' WHEN 100 THEN N'Participant Communication' END Provides a translation for the 'CONFIRMATIONTYPECODE' field.

Foreign Key Field Type Null Notes Description
 EVENTID uniqueidentifier   EVENT.ID Event ID
 EMAILTEMPLATEID int   EmailTemplate.ID EventTemplate ID
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 NCNOTIFICATIONID int NC_Notification.ID NetCommunity Nofication ID

Index Name Field(s) Unique Primary Clustered
 IX_EVENTEMAILTEMPLATE_DATEADDED DATEADDED    
 IX_EVENTEMAILTEMPLATE_DATECHANGED DATECHANGED      
 IX_EVENTEMAILTEMPLATE_EVENTID EVENTID      
 PK_EVENTEMAILTEMPLATE ID  

Trigger Name Description
 TR_EVENTEMAILTEMPLATE_AUDIT_UPDATE
 TR_EVENTEMAILTEMPLATE_AUDIT_DELETE

Entity-Relationship diagram of this table