FACT_FUNDRAISERTEAMTOTALEXTENSION_STAGE

Contains additional aggregate group information.

Fields

Field	Field Type	Null	Notes	Description
FUNDRAISERTEAMSYSTEMID	uniqueidentifier	yes		dbo.[FAFGROUPSUMMARYINFORMATION_CATEGORIZED].[ID]
EVENTSYSTEMID	uniqueidentifier	yes		dbo.[FAFGROUPSUMMARYINFORMATION_CATEGORIZED].[EVENTID]
COUNTGIFTSFROMEMAIL	int	yes		dbo.[FAFGROUPSUMMARYINFORMATION_CATEGORIZED].[GIFTCOUNT_FROMEMAIL]
COUNTGIFTSFROMSOCIALMEDIA	int	yes		dbo.[FAFGROUPSUMMARYINFORMATION_CATEGORIZED].[GIFTCOUNT_FROMSOCIALMEDIA]
COUNTONLINEGIFTS	int	yes		dbo.[FAFGROUPSUMMARYINFORMATION_CATEGORIZED].[GIFTCOUNT_ONLINE]
AMOUNTFROMEMAIL	money	yes		dbo.[FAFGROUPSUMMARYINFORMATION_CATEGORIZED].[AMOUNT_FROMEMAIL]
AMOUNTFROMSOCIALMEDIA	money	yes		dbo.[FAFGROUPSUMMARYINFORMATION_CATEGORIZED].[AMOUNT_FROMSOCIALMEDIA]
AMOUNTONLINE	money	yes		dbo.[FAFGROUPSUMMARYINFORMATION_CATEGORIZED].[AMOUNT_ONLINE]
AMOUNTOFFLINE	money	yes		dbo.[FAFGROUPSUMMARYINFORMATION_CATEGORIZED].[AMOUNT_OFFLINE]
AMOUNTSELFDONATION	money	yes		dbo.[FAFGROUPSUMMARYINFORMATION_CATEGORIZED].[AMOUNT_SELF]
AMOUNTPENDING	money	yes		dbo.[FAFGROUPSUMMARYINFORMATION_CATEGORIZED].[AMOUNT_PENDING]
COUNTOFFLINEGIFTS	int	yes		dbo.[FAFGROUPSUMMARYINFORMATION_CATEGORIZED].[GIFTCOUNT_OFFLINE]
COUNTGIFTSBYPARTICIPANTS	int	yes		dbo.[FAFGROUPSUMMARYINFORMATION_CATEGORIZED].[GIFTCOUNT_PARTICIPANTS]
AMOUNTBYPARTICIPANTS	money	yes		dbo.[FAFGROUPSUMMARYINFORMATION_CATEGORIZED].[AMOUNT_PARTICIPANTS]
COUNTGIFTSSELFDONATION	int	yes		dbo.[FAFGROUPSUMMARYINFORMATION_CATEGORIZED].[GIFTCOUNT_SELF]
COUNTSOCIALMEDIAPOSTS	int	yes		dbo.[FAFGROUPSUMMARYINFORMATION_CATEGORIZED].[COUNT_SOCIALMEDIAPOSTS]