v_DIM_EVENT
The event dimension contains information about events.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| EVENTDIMID | int | BBDW.[DIM_EVENT].[EVENTDIMID] | |
| EVENTSYSTEMID | uniqueidentifier | BBDW.[DIM_EVENT].[EVENTSYSTEMID] | |
| EVENTLOOKUPID | nvarchar(100) | yes | BBDW.[DIM_EVENT].[EVENTLOOKUPID] |
| EVENTSTARTDATEDIMID | int | yes | BBDW.[DIM_EVENT].[EVENTSTARTDATEDIMID] |
| EVENTSTARTDATE | datetime | yes | BBDW.[DIM_EVENT].[EVENTSTARTDATE] |
| EVENTSTARTTIMEDIMID | int | yes | BBDW.[DIM_EVENT].[EVENTSTARTTIMEDIMID] |
| EVENTSTARTTIME | UDT_HOURMINUTE | BBDW.[DIM_EVENT].[EVENTSTARTTIME] | |
| EVENTSTARTDATETIMEOFFSET | datetimeoffset | yes | BBDW.[DIM_EVENT].[EVENTSTARTDATETIMEOFFSET] |
| EVENTENDDATEDIMID | int | yes | BBDW.[DIM_EVENT].[EVENTENDDATEDIMID] |
| EVENTENDDATE | datetime | yes | BBDW.[DIM_EVENT].[EVENTENDDATE] |
| EVENTENDTIMEDIMID | int | yes | BBDW.[DIM_EVENT].[EVENTENDTIMEDIMID] |
| EVENTENDTIME | UDT_HOURMINUTE | BBDW.[DIM_EVENT].[EVENTENDTIME] | |
| EVENTENDDATETIMEOFFSET | datetimeoffset | yes | BBDW.[DIM_EVENT].[EVENTENDDATETIMEOFFSET] |
| EVENTHIERARCHYPATH | hierarchyid | yes | BBDW.[DIM_EVENT].[EVENTHIERARCHYPATH] |
| PARENTEVENTDIMID | int | yes | BBDW.[DIM_EVENT].[PARENTEVENTDIMID] |
| PARENTEVENTSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_EVENT].[PARENTEVENTSYSTEMID] |
| EVENTNAME | nvarchar(255) | yes | BBDW.[DIM_EVENT].[EVENTNAME] |
| EVENTDESCRIPTION | nvarchar(255) | yes | BBDW.[DIM_EVENT].[EVENTDESCRIPTION] |
| EVENTCATEGORY | nvarchar(255) | yes | BBDW.[DIM_EVENT].[EVENTCATEGORY] |
| EVENTPROGRAM | nvarchar(100) | yes | BBDW.[DIM_EVENT].[EVENTPROGRAM] |
| EVENTCAPACITY | int | yes | BBDW.[DIM_EVENT].[EVENTCAPACITY] |
| EVENTISACTIVE | bit | yes | BBDW.[DIM_EVENT].[EVENTISACTIVE] |
| EVENTTYPE | nvarchar(86) | yes | BBDW.[DIM_EVENT].[EVENTTYPE] |
| PRIORYEAREVENTDIMID | int | yes | BBDW.[DIM_EVENT].[PRIORYEAREVENTDIMID] |
Definition
Copy
CREATE view [BBDW].[v_DIM_EVENT] as
select
[EVENTDIMID],
[EVENTSYSTEMID],
[EVENTLOOKUPID],
[EVENTSTARTDATEDIMID],
[EVENTSTARTDATE],
[EVENTSTARTTIMEDIMID],
[EVENTSTARTTIME],
[EVENTSTARTDATETIMEOFFSET],
[EVENTENDDATEDIMID],
[EVENTENDDATE],
[EVENTENDTIMEDIMID],
[EVENTENDTIME],
[EVENTENDDATETIMEOFFSET],
[EVENTHIERARCHYPATH],
[PARENTEVENTDIMID],
[PARENTEVENTSYSTEMID],
[EVENTNAME],
[EVENTDESCRIPTION],
[EVENTCATEGORY],
[EVENTPROGRAM],
[EVENTCAPACITY],
[EVENTISACTIVE],
[EVENTTYPE],
[PRIORYEAREVENTDIMID]
from BBDW.[DIM_EVENT]