v_FACT_EVENTSITE
Contains information about sites associated with EVENTs.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| EVENTSITEFACTID | int | BBDW.[FACT_EVENTSITE].[EVENTSITEFACTID] | |
| EVENTSITESYSTEMID | uniqueidentifier | yes | BBDW.[FACT_EVENTSITE].[EVENTSITESYSTEMID] |
| SITESYSTEMID | uniqueidentifier | yes | BBDW.[FACT_EVENTSITE].[SITESYSTEMID] |
| SITEDIMID | int | yes | BBDW.[FACT_EVENTSITE].[SITEDIMID] |
| EVENTDIMID | int | yes | BBDW.[FACT_EVENTSITE].[EVENTDIMID] |
Definition
Copy
CREATE view [BBDW].[v_FACT_EVENTSITE] as
select
es.[EVENTSITEFACTID],
es.[EVENTSITESYSTEMID],
es.[SITESYSTEMID],
es.[SITEDIMID],
es.[EVENTDIMID]
from BBDW.[FACT_EVENTSITE] es