FACT_REGISTRATIONTOTAL_STAGE
Contains aggregate information about event registrations.
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| EVENTREGISTRANTFACTID | int | yes | Reference key from event registration fact table BBDW.[FACT_EVENTREGISTRANT] | |
| EVENTREGISTRANTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_EVENTREGISTRANT].[EVENTREGISTRANTSYSTEMID] | |
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_EVENTREGISTRANT].[CONSTITUENTSYSTEMID] | |
| CONSTITUENTDIMID | int | yes | BBDW.[FACT_EVENTREGISTRANT].[CONSTITUENTDIMID] | |
| EVENTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_EVENTREGISTRANT].[EVENTSYSTEMID] | |
| EVENTDIMID | int | yes | BBDW.[DIM_EVENT].[EVENTDIMID] | |
| ISINCLUDED | bit | yes | Flag indicating when data should be included in results. | |
| ETLCONTROLID | int | yes | ID generated through the ETL process. | |
| SOURCEDIMID | int | yes | Source system used. |