FACT_REGISTRATIONTOTALGROUP_STAGE
Contains aggregate information about event registrations.
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| FUNDRAISERTEAMSYSTEMID | uniqueidentifier | yes | dbo.[TEAMFUNDRAISINGTEAM].[ID] | |
| FUNDRAISERTEAMDIMID | int | yes | Reference key for fundraiser team dimension table BBDW.[DIM_FUNDRAISERTEAM] | |
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_EVENTREGISTRANT].[CONSTITUENTSYSTEMID] | |
| AMOUNTRAISEDBYGROUP | money | yes | dbo.[FAFGROUPSUMMARYINFORMATION].[TOTALFUNDRAISE] | |
| EVENTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_EVENTREGISTRANT].[EVENTSYSTEMID] | |
| GROUPMEMBERS | int | yes | dbo.[FAFGROUPSUMMARYINFORMATION].[TOTALGROUPS] |