DIM_EVENT_STAGE
Intermediate storage table for events
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| EVENTSYSTEMID | uniqueidentifier | yes | [dbo].[EVENT].[ID] | |
| EVENTSTARTDATEDIMID | int | yes | Reference key to the date dimension, derived using [dbo].[EVENT].[STARTDATE] | |
| EVENTSTARTDATE | datetime | yes | [dbo].[EVENT].[STARTDATE] | |
| EVENTENDDATEDIMID | int | yes | Reference key to the date dimension, derived using [dbo].[EVENT].[ENDDATE] | |
| EVENTENDDATE | datetime | yes | [dbo].[EVENT].[ENDDATE] | |
| EVENTCATEGORY | nvarchar(255) | yes | [dbo].[EVENTCATEGORYCODE].[DESCRIPTION] | |
| PARENTEVENTDIMID | int | yes | Reference key to the event dimension, derived using [dbo].[EVENT].[HIERARCHYPATH] | |
| PARENTEVENTSYSTEMID | uniqueidentifier | yes | Derived using [dbo].[EVENT].[HIERARCHYPATH] | |
| APPEALDIMID | int | yes | Reference key to the appeal dimension, derived using [dbo].[EVENT].[APPEALID] | |
| EVENTNAME | nvarchar(255) | yes | [dbo].[EVENT].[NAME] | |
| EVENTDESCRIPTION | nvarchar(255) | yes | [dbo].[EVENT].[DESCRIPTION] | |
| EVENTISACTIVE | bit | yes | [dbo].[EVENT].[ISACTIVE] | |
| 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. | |
| EVENTLOOKUPID | nvarchar(100) | yes | [dbo].[EVENT].[LOOKUPID] | |
| EVENTCAPACITY | int | yes | [dbo].[EVENT].[CAPACITY] | |
| EVENTPROGRAM | nvarchar(100) | yes | [dbo].[PROGRAM].[NAME] | |
| EVENTHIERARCHYPATH_TEXT | nvarchar(500) | yes | [dbo].[EVENTHIERARCHY].[HIERARCHYPATH] converted to nvarchar(500) | |
| EVENTSTARTTIMEDIMID | int | yes | Reference to the time dimension, derived from [dbo].[EVENT].[STARTTIME] | |
| EVENTSTARTTIME | char(4) | yes | [dbo].[EVENT].[STARTTIME] | |
| EVENTSTARTDATETIMEOFFSET | datetimeoffset | yes | [dbo].[EVENT].[STARTDATETIMEWITHOFFSET] | |
| EVENTENDTIMEDIMID | int | yes | Reference to the time dimension, derived from [dbo].[EVENT].[ENDTIME] | |
| EVENTENDTIME | char(4) | yes | [dbo].[EVENT].[ENDTIME] | |
| EVENTENDDATETIMEOFFSET | datetimeoffset | yes | [dbo].[EVENT].[ENDDATETIMEWITHOFFSET] | |
| EVENTTYPE | nvarchar(86) | yes | dbo.[EVENTEXTENSION].[EVENTTYPE] | |
| PRIORYEAREVENTSYSTEMID | uniqueidentifier | yes | dbo.[EVENTEXTENSION].[PRIORYEAREVENTID] | |
| PRIORYEAREVENTDIMID | int | yes | Reference key to the prior year event dimension, derived from [dbo].[DIM_EVENT].[PRIORYEAREVENTSYSTEMID] |