FACT_EVENTPRICE_STAGE
The Event price fact table contains information about event prices (registration options).
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| EVENTPRICESYSTEMID | uniqueidentifier | yes | dbo.[EVENTPRICE].[ID] | |
| EVENTDIMID | int | yes | Reference key to the event dimension, derived using [dbo].[EVENTPRICE].[EVENTID] | |
| NAME | nvarchar(200) | yes | dbo.[EVENTPRICE].[NAME] | |
| RECEIPTAMOUNT | money | yes | dbo.[EVENTPRICE].[RECEIPTAMOUNT] | |
| COST | money | yes | dbo.[EVENTPRICE].[COST] | |
| REGISTRATIONCOUNT | int | yes | dbo.[EVENTPRICE].[REGISTRATIONCOUNT] | |
| 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 |