v_FACT_TRIBUTESITE
Contains information about sites associated with prospect plans.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| TRIBUTESITEFACTID | int | BBDW.[FACT_TRIBUTESITE].[TRIBUTESITEFACTID] | |
| TRIBUTESITESYSTEMID | uniqueidentifier | yes | BBDW.[FACT_TRIBUTESITE].[TRIBUTESITESYSTEMID] |
| SITESYSTEMID | uniqueidentifier | yes | BBDW.[FACT_TRIBUTESITE].[SITESYSTEMID] |
| SITEDIMID | int | yes | BBDW.[FACT_TRIBUTESITE].[SITEDIMID] |
| TRIBUTEDIMID | int | yes | BBDW.[FACT_TRIBUTESITE].[TRIBUTEDIMID] |
Definition
Copy
create view [BBDW].[v_FACT_TRIBUTESITE] as
select
ts.[TRIBUTESITEFACTID],
ts.[TRIBUTESITESYSTEMID],
ts.[SITESYSTEMID],
ts.[SITEDIMID],
ts.[TRIBUTEDIMID]
from BBDW.[FACT_TRIBUTESITE] ts