Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 ALLOWGIFTTYPEONETIMEDONATION bit   Default = 0 Allow gift type one-time donation
 ALLOWGIFTTYPERECURRING bit   Default = 0 Allow gift type recurring
 ALLOWGIFTTYPEPLEDGE bit   Default = 0 Allow gift type pledge
 ISENABLEDONATIONS bit   Default = 1 Enable donations
 ISENABLERECURRINGGIFTS bit   Default = 1 Enable recurring gifts
 ISENABLEPLEDGES bit   Default = 1 Enable pledges
 ISALLOWTEAMDONATIONS bit   Default = 1 Allow gifts team
 ISALLOWCOMPANYDONATIONS bit   Default = 1 Allow gifts company
 ISALLOWEVENTDONATIONS bit   Default = 1 Allow gifts event
 MINIMUMDONATIONAMOUNT money   Default = 5 Gift amount minimum
 MAXIMUMTRANSACTIONAMOUNT money   Default = 0 Maximum
 ISALLOWDONATIONSFROMORGS bit   Default = 0 Allow gifts from organizations
 ISFREQUENCYAVAILONLINEMONTHLYGIFT bit   Default = 1 Monthly
 ISFREQUENCYAVAILONLINEANNUALLYGIFT bit   Default = 0 Annually
 ISFREQUENCYAVAILONLINESEMIANNUALLYGIFT bit   Default = 0 Semi-Annually
 ISFREQUENCYAVAILONLINEQUARTERLYGIFT bit   Default = 0 Quarterly
 ISFREQUENCYAVAILONLINEBIMONTHLYGIFT bit   Default = 0 Bimonthly
 ISFREQUENCYAVAILONLINESEMIMONTHLYGIFT bit   Default = 0 Semi-Monthly
 ISFREQUENCYAVAILONLINEBIWEEKLYGIFT bit   Default = 0 BiWeekly
 ISFREQUENCYAVAILONLINEWEEKLYGIFT bit   Default = 0 Weekly
 ISFREQUENCYAVAILONLINESINGLEGIFT bit   Default = 0 Single Payment
 ISALLOWDONORTOSELECTSTARTDATEGIFT tinyint   Default = 1 Allow donor to select start date
 STARTDATEONORBEFOREGIFT datetime Start date must be before
 ISSTARTDATESAMEASDAYTOSUBMITGIFT bit   Default = 0 Start date will be day the form is submitted
 DONORONORBEFOREDATEGIFT datetime Donors must schedule recurring gifts to end on or before this date
 ISFREQUENCYAVAILONLINEMONTHLYPLEDGE bit   Default = 0 Monthly
 ISFREQUENCYAVAILONLINEANNUALLYPLEDGE bit   Default = 0 Annually
 ISFREQUENCYAVAILONLINESEMIANNUALLYPLEDGE bit   Default = 0 Semi-Annually
 ISFREQUENCYAVAILONLINEQUARTERLYPLEDGE bit   Default = 0 Quarterly
 ISFREQUENCYAVAILONLINEBIMONTHLYPLEDGE bit   Default = 0 Bimonthly
 ISFREQUENCYAVAILONLINESEMIMONTHLYPLEDGE bit   Default = 0 Semi-Monthly
 ISFREQUENCYAVAILONLINEBIWEEKLYPLEDGE bit   Default = 0 BiWeekly
 ISFREQUENCYAVAILONLINEWEEKLYPLEDGE bit   Default = 0 Weekly
 ISFREQUENCYAVAILONLINESINGLEPLEDGE bit   Default = 1 Single Payment
 ISALLOWDONORTOSELECTSTARTDATEPLEDGE tinyint   Default = 1 Allow donor to select start date
 STARTDATEONORBEFOREPLEDGE datetime Start date must be before
 ISSTARTDATESAMEASDAYTOSUBMITPLEDGE bit   Default = 0 Start date will be day the form is submitted
 DONORONORBEFOREDATEPLEDGE datetime Donors must schedule last pledge payment on or before this date
 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.
 ISUNPAIDPLEDGES bit   Default = 0 Unpaid pledges
 ISUNPAIDRECURRINGGIFTS bit   Default = 0 Unpaid recurring gifts
 ISSPONSORSHIPREVENUE bit   Default = 0 Sponsorship revenue
 ISUNPAIDSPONSORSHIPREVENUE bit   Default = 0 Unpaid sponsorship revenue
 ISREGISTRATIONREVENUE bit   Default = 0 Registration revenue
 ISPENDINGMATCHINGGIFTS bit   Default = 0 Pending matching gifts
 UNCONFIRMEDPARTICIPANTGIFTENTRY bit   Default = 1 Unconfirmed Participant gift entry
 ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR bit   Default = 1 Allow participants to enter cash and checks from donors
 COPYSOURCEID uniqueidentifier Original copy from ID
 COPYBATCHGUID uniqueidentifier Copy batch ID
 ISALLOWHOUSEHOLDDONATIONS bit   Default = 1

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_FAFEVENTDONATIONOPTIONSCONFIG_DATEADDED DATEADDED    
 IX_FAFEVENTDONATIONOPTIONSCONFIG_DATECHANGED DATECHANGED      
 PK_FAFEVENTDONATIONOPTIONSCONFIG ID  
 UIX_FAFEVENTDONATIONOPTIONSCONFIG_EVENTID EVENTID    

Trigger Name Description
 TR_FAFEVENTDONATIONOPTIONSCONFIG_AUDIT_UPDATE
 TR_FAFEVENTDONATIONOPTIONSCONFIG_AUDIT_DELETE

Entity-Relationship diagram of this table