FAFEVENTDONATIONOPTIONSCONFIG

Friends Asking Friends Donation Options

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

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	yes		Start date must be before
ISSTARTDATESAMEASDAYTOSUBMITGIFT	bit		Default = 0	Start date will be day the form is submitted
DONORONORBEFOREDATEGIFT	datetime	yes		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	yes		Start date must be before
ISSTARTDATESAMEASDAYTOSUBMITPLEDGE	bit		Default = 0	Start date will be day the form is submitted
DONORONORBEFOREDATEPLEDGE	datetime	yes		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)	yes	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	yes		Original copy from ID
COPYBATCHGUID	uniqueidentifier	yes		Copy batch ID
ISALLOWHOUSEHOLDDONATIONS	bit		Default = 1

Foreign Keys

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.

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_FAFEVENTDONATIONOPTIONSCONFIG_DATEADDED	DATEADDED			yes
IX_FAFEVENTDONATIONOPTIONSCONFIG_DATECHANGED	DATECHANGED
PK_FAFEVENTDONATIONOPTIONSCONFIG	ID	yes	yes
UIX_FAFEVENTDONATIONOPTIONSCONFIG_EVENTID	EVENTID	yes

Triggers

Trigger Name	Description
TR_FAFEVENTDONATIONOPTIONSCONFIG_AUDIT_UPDATE
TR_FAFEVENTDONATIONOPTIONSCONFIG_AUDIT_DELETE