FAFRAISEDTOTAL_CATEGORIZED

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
GIFTCOUNT_ALL	int		Default = 0
GIFTCOUNT_ONLINE	int		Default = 0
GIFTCOUNT_OFFLINE	int		Default = 0
GIFTCOUNT_FROMEMAIL	int		Default = 0
GIFTCOUNT_FROMSOCIALMEDIA	int		Default = 0
GIFTCOUNT_SELF	int		Default = 0
AMOUNT_ALL	money		Default = 0
AMOUNT_ONLINE	money		Default = 0
AMOUNT_OFFLINE	money		Default = 0
AMOUNT_FROMEMAIL	money		Default = 0
AMOUNT_FROMSOCIALMEDIA	money		Default = 0
AMOUNT_SELF	money		Default = 0
AMOUNTPENDING	money		Default = 0
DATECHANGED	datetime	yes	Default = getdate()

Foreign Keys

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

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_FAFRAISEDTOTAL_CATEGORIZED_CONSTITUENTID	CONSTITUENTID
IX_FAFRAISEDTOTAL_CATEGORIZED_EVENTID_CONSTITUENTID	EVENTID, CONSTITUENTID
PK_FAFRAISEDTOTAL_CATEGORIZED	ID	yes	yes	yes