Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 REGAMOUNT money   Default = 0
 RECEIVEDAMOUNT money   Default = 0
 UNPAIDPLEDGEAMOUNT money   Default = 0
 UNPAIDRECURRINGAMOUNT money   Default = 0
 MATCHINGGIFTCLAIMAMOUNT money   Default = 0
 UNCONFIRMEDOFFLINEAMOUNT money   Default = 0
 DATECHANGED datetime Default = getdate()
 DONORCOUNT int   Default = 0
 GIFTCOUNT_DONATION int   Default = 0
 GIFTCOUNT_UNPAIDPLEDGES_ON int   Default = 0
 GIFTCOUNT_UNPAIDPLEDGES_OFF int   Default = 0
 GIFTCOUNT_PENDINGMATCHINGGIFTS_ON int   Default = 0
 GIFTCOUNT_PENDINGMATCHINGGIFTS_OFF int   Default = 0
 GIFTCOUNT_UNPAIDRECURRINGGIFTS_ON int   Default = 0
 GIFTCOUNT_UNPAIDRECURRINGGIFTS_OFF int   Default = 0
 GIFTCOUNT_UNCONFIRMEDPARTICIPANTGIFTENTRY_ON int   Default = 0
 GIFTCOUNT_UNCONFIRMEDPARTICIPANTGIFTENTRY_OFF int   Default = 0

Foreign Key Field Type Null Notes Description
 EVENTID uniqueidentifier   EVENT.ID
 CONSTITUENTID uniqueidentifier CONSTITUENT.LOCALID

Index Name Field(s) Unique Primary Clustered
 IX_FAFRAISEDTOTAL_CONSTITUENTID CONSTITUENTID      
 IX_FAFRAISEDTOTAL_EVENTID_CONSTITUENTID EVENTID, CONSTITUENTID      
 PK_FAFRAISEDTOTAL ID

Entity-Relationship diagram of this table