Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 ALLOWPARTICIPANTCHOOSEBENEFITCODE tinyint   Default = 0 Type of Benefit (1 or all)
 ALLOWPARTICIPANTONLYRECEIVEBENEFITLEVELCODE tinyint   Default = 1 Type of Benefit (each or highest level)
 ALLOWPARTICIPANTONLYRECEIVEBENEFITLEVEL nvarchar(65) (Computed) CASE [ALLOWPARTICIPANTONLYRECEIVEBENEFITLEVELCODE] WHEN 0 THEN N'Allow participant to only receive benefits from each level' WHEN 1 THEN N'Allow participant to only receive benefits from the highest level' END Provides a translation for the 'ALLOWPARTICIPANTONLYRECEIVEBENEFITLEVELCODE' 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) CONVERT(bigint, TS) Numeric representation of the timestamp.
 ALLOWPARTICIPANTSWAIVEBENEFITS bit   Default = 1 Allow participant to waive benefits
 FUNDRAISINGCOACHESACTIVATEINDIVIDUAL bit   Default = 0 Activate fundraising coaches for individual participants
 FUNDRAISINGCOACHESACTIVATEHOUSEHOLDS bit   Default = 0 Activate fundraising coaches for households
 FUNDRAISINGCOACHESACTIVATETEAMS bit   Default = 0 Activate fundraising coaches for teams
 FUNDRAISINGCOACHESACTIVATECOMPANIES bit   Default = 0 Activate fundraising coaches for companies
 FCGROUPASSIGNMENTSLIMIT smallint   Default = ((50)) Fundraising coach can have a number of group assignments
 FCGROUPSASSIGNMENTCODE tinyint   Default = 0 Assign groups to fundraising coaches (Automatic or Manual)
 FCGROUPSASSIGNMENT nvarchar(50) (Computed) CASE [FCGROUPSASSIGNMENTCODE] WHEN 0 THEN N'Automatically assign groups to fundraising coaches' WHEN 1 THEN N'Manually assign groups to fundraising coaches' WHEN 2 THEN N'None' END Provides a translation for the 'FCGROUPSASSIGNMENTCODE' field.
 ACFMPENDINGDONATIONS bit   Default = 0 Activate/In-Activate for Pending Donation checkbox
 ACFMPENDINGMATCHINGGIFTS bit   Default = 0 Activate/In-Activate for Pending Matching Gifts checkbox
 ACFMOUTSTANDINGRECURRINGDONATIONS bit   Default = 0 Activate/In-Activate for Outstanding Recurring Donations checkbox
 REGISTRATIONFORMENDDATE datetime Date that registration form will turn off
 DONATIONFORMENDDATE datetime Date that donation form will be turn off
 SPONSORSHIPFORMENDDATE datetime Date that sponsorship form will be turn off
 REGISTRATIONREDIRECTLINK UDT_WEBADDRESS   Default = '' Link to redirect to when registration form turns off
 DONATIONREDIRECTLINK UDT_WEBADDRESS   Default = '' Link to redirect to when donation form turns off
 SPONSORSHIPREDIRECTLINK UDT_WEBADDRESS   Default = '' Link to redirect to when donation form turns off
 ALLOWPARTICIPANTCHOOSEBENEFIT nvarchar(41) (Computed) CASE [ALLOWPARTICIPANTCHOOSEBENEFITCODE] WHEN 0 THEN N'Allow participant to choose one benefit' WHEN 1 THEN N' Allow participant to choose all benefits' END Provides a translation for the 'ALLOWPARTICIPANTCHOOSEBENEFITCODE' field.
 COPYSOURCEID uniqueidentifier Original copy from ID
 COPYBATCHGUID uniqueidentifier Copy batch ID

Foreign Key Field Type Null Notes Description
 EVENTID uniqueidentifier   EVENT.ID Foreign Key to Event table
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_EVENTATTRIBUTES_DATEADDED DATEADDED    
 IX_EVENTATTRIBUTES_DATECHANGED DATECHANGED      
 IX_EVENTATTRIBUTES_EVENTID EVENTID      
 PK_EVENTATTRIBUTES ID  

Trigger Name Description
 TR_EVENTATTRIBUTES_AUDIT_UPDATE
 TR_EVENTATTRIBUTES_AUDIT_DELETE

Entity-Relationship diagram of this table