DIM_PROSPECTPLANSITE
Contains information about sites associated with prospect plans. Used for backward compatibility with previous [BBDW].[DIM_PROSPECTPLANSITE] table
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| PROSPECTPLANSITEFACTID | int | BBDW.[FACT_PROSPECTPLANSITE].[PROSPECTPLANSITEFACTID] | |
| PROSPECTPLANSITESYSTEMID | uniqueidentifier | yes | BBDW.[FACT_PROSPECTPLANSITE].[PROSPECTPLANSITESYSTEMID] |
| SITESYSTEMID | uniqueidentifier | yes | BBDW.[FACT_PROSPECTPLANSITE].[SITESYSTEMID] |
| SITEDIMID | int | yes | BBDW.[FACT_PROSPECTPLANSITE].[SITEDIMID] |
| PROSPECTPLANDIMID | int | yes | BBDW.[FACT_PROSPECTPLANSITE].[PROSPECTPLANDIMID] |
Definition
Copy
create view [BBDW].[DIM_PROSPECTPLANSITE] as
select
ps.[PROSPECTPLANSITEFACTID],
ps.[PROSPECTPLANSITESYSTEMID],
ps.[SITESYSTEMID],
ps.[SITEDIMID],
ps.[PROSPECTPLANDIMID]
from BBDW.[FACT_PROSPECTPLANSITE] ps