DIM_EVENT
Contains information about an event.
Primary Key
| Primary Key | Field Type |
|---|---|
| EVENTDIMID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| EVENTSYSTEMID | uniqueidentifier | [dbo].[EVENT].[ID] | ||
| EVENTSTARTDATEDIMID | int | yes | Reference key to the date dimension for event start date, derived from [dbo].[EVENT].[STARTDATE] | |
| EVENTSTARTDATE | datetime | yes | [dbo].[EVENT].[STARTDATE] | |
| EVENTENDDATEDIMID | int | yes | Reference key to the date dimension for event end date, derived from [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 from dbo.[EVENTHIERARCHY].[HIERARCHYPATH] | |
| PARENTEVENTSYSTEMID | uniqueidentifier | yes | Derived from dbo.[EVENTHIERARCHY].[HIERARCHYPATH] | |
| APPEALDIMID | int | yes | Reference key to appeal dimension, derived from [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 | hierarchyid | yes | [dbo].[EVENT].[HIERARCHYPATH] | |
| EVENTSTARTTIMEDIMID | int | yes | Reference to the time dimension, derived from [dbo].[EVENT].[STARTTIME] | |
| EVENTSTARTTIME | UDT_HOURMINUTE | [dbo].[EVENT].[STARTTIME] | ||
| EVENTSTARTDATETIMEOFFSET | datetimeoffset | yes | [dbo].[EVENT].[STARTDATETIMEWITHOFFSET] | |
| EVENTENDTIMEDIMID | int | yes | Reference to the time dimension, derived from [dbo].[EVENT].[ENDTIME] | |
| EVENTENDTIME | UDT_HOURMINUTE | [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] |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_DIM_EVENT_EVENTSYSTEMID | EVENTSYSTEMID | |||
| PK_DIM_EVENT | EVENTDIMID | yes | yes | yes |