Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 GOALISSET bit   Default = 0 Goal List is set
 SOCIALNETWORKISSET bit   Default = 0 Social Network is set
 LABELISSET bit   Default = 0 Label list is set
 TEAMHIERARCHYISSET bit   Default = 0 Team Hierarchy is set
 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.
 MERCHANTACCOUNTSET bit   Default = 0 Merchant Account Flag
 SPONSORSHIPOPTIONISSET bit   Default = 0 Sponsorship options flag
 REGISTRATIONOPTIONISSET bit   Default = 0 Registration options flag
 INCENTIVEOPTIONISSET bit   Default = 0 Incentive options flag
 INCENTIVELEVELISSET bit   Default = 0 Incentive level flag
 FUNDRAISINGCOACHISSET bit   Default = 0 Fundraising coaches flag
 DONATIONOPTIONSISSET bit   Default = 0 Donation options flag
 REVENUERULESISSET bit   Default = 0 Revenue rules level flag
 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_EVENTFAFCONFIG_DATEADDED DATEADDED    
 IX_EVENTFAFCONFIG_DATECHANGED DATECHANGED      
 PK_EVENTFAFCONFIG ID  
 UIX_EVENTFAFCONFIG_EVENTID EVENTID    

Trigger Name Description
 TR_EVENTFAFCONFIG_AUDIT_UPDATE
 TR_EVENTFAFCONFIG_AUDIT_DELETE

Entity-Relationship diagram of this table