FACT_REGISTRATIONTOTALRAISED_STAGE

Contains aggregate information about event registrations.

Fields

Field	Field Type	Null	Notes	Description
CONSTITUENTSYSTEMID	uniqueidentifier	yes		dbo.[REGISTRANT].[ID]
EVENTSYSTEMID	uniqueidentifier	yes		dbo.[REGISTRANT].[EVENTID]
GIFTSRECEIVED	int	yes		dbo.[FAFRAISEDTOTAL_CATEGORIZED].[GIFTCOUNT_ALL]
GIFTSFROMEMAIL	int	yes		dbo.[FAFRAISEDTOTAL_CATEGORIZED].[GIFTCOUNT_FROMEMAIL]
GIFTSFROMSOCIALMEDIA	int	yes		dbo.[FAFRAISEDTOTAL_CATEGORIZED].[GIFTCOUNT_FROMSOCIALMEDIA]
OFFLINEGIFTS	int	yes		dbo.[FAFRAISEDTOTAL_CATEGORIZED].[GIFTCOUNT_OFFLINE]
ONLINEGIFTS	int	yes		dbo.[FAFRAISEDTOTAL_CATEGORIZED].[GIFTCOUNT_ONLINE]
AMOUNTRAISED	money	yes		dbo.[FAFRAISEDTOTAL].[RECEIVEDAMOUNT]
AMOUNTFROMEMAIL	money	yes		dbo.[FAFRAISEDTOTAL_CATEGORIZED].[AMOUNT_FROMEMAIL]
AMOUNTONLINE	money	yes		dbo.[FAFRAISEDTOTAL_CATEGORIZED].[AMOUNT_ONLINE]
AMOUNTFROMSOCIALMEDIA	money	yes		dbo.[FAFRAISEDTOTAL_CATEGORIZED].[AMOUNT_FROMSOCIALMEDIA]
AMOUNTOFFLINE	money	yes		dbo.[FAFRAISEDTOTAL_CATEGORIZED].[AMOUNT_OFFLINE]
AMOUNTSELFDONATION	money	yes		dbo.[FAFRAISEDTOTAL_CATEGORIZED].[AMOUNT_SELF]