v_FACT_CAMPAIGNSITE
Contains information about sites associated with campaigns.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CAMPAIGNSITEFACTID | int | BBDW.[FACT_CAMPAIGNSITE].[CAMPAIGNSITEFACTID] | |
| CAMPAIGNSITESYSTEMID | uniqueidentifier | yes | BBDW.[FACT_CAMPAIGNSITE].[CAMPAIGNSITESYSTEMID] |
| SITESYSTEMID | uniqueidentifier | yes | BBDW.[FACT_CAMPAIGNSITE].[SITESYSTEMID] |
| SITEDIMID | int | yes | BBDW.[FACT_CAMPAIGNSITE].[SITEDIMID] |
| CAMPAIGNDIMID | int | yes | BBDW.[FACT_CAMPAIGNSITE].[CAMPAIGNDIMID] |
Definition
Copy
CREATE view [BBDW].[v_FACT_CAMPAIGNSITE] as
select
cs.[CAMPAIGNSITEFACTID],
cs.[CAMPAIGNSITESYSTEMID],
cs.[SITESYSTEMID],
cs.[SITEDIMID],
cs.[CAMPAIGNDIMID]
from BBDW.[FACT_CAMPAIGNSITE] cs