V_QUERY_BBDW_EVENT
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| EVENTSYSTEMID | uniqueidentifier | ||
| EVENTDIMID | int | ||
| EVENTNAME | nvarchar(255) | yes | |
| EVENTSTARTDATEDIMID | int | yes | |
| EVENTSTARTDATE | datetime | yes | |
| EVENTENDDATEDIMID | int | yes | |
| EVENTENDDATE | datetime | yes | |
| EVENTLOOKUPID | nvarchar(100) | yes | |
| EVENTSTARTTIME | UDT_HOURMINUTE | ||
| EVENTENDTIME | UDT_HOURMINUTE | ||
| EVENTCAPACITY | int | yes | |
| EVENTCATEGORY | nvarchar(255) | yes | |
| EVENTTYPE | nvarchar(86) | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_EVENT] as
select
[EVENTSYSTEMID],
[EVENTDIMID],
[EVENTNAME],
[EVENTSTARTDATEDIMID],
[EVENTSTARTDATE],
[EVENTENDDATEDIMID],
[EVENTENDDATE],
[EVENTLOOKUPID],
[EVENTSTARTTIME],
[EVENTENDTIME],
[EVENTCAPACITY],
[EVENTCATEGORY],
[EVENTTYPE]
from BBDW.[DIM_EVENT]
where [EVENTDIMID] > 0