v_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.[DIM_PROSPECTPLANSITE].[PROSPECTPLANSITEFACTID] | |
| PROSPECTPLANSITESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_PROSPECTPLANSITE].[PROSPECTPLANSITESYSTEMID] |
| SITESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_PROSPECTPLANSITE].[SITESYSTEMID] |
| SITEDIMID | int | yes | BBDW.[DIM_PROSPECTPLANSITE].[SITEDIMID] |
| PROSPECTPLANDIMID | int | yes | BBDW.[DIM_PROSPECTPLANSITE].[PROSPECTPLANDIMID] |
Definition
Copy
create view [BBDW].[v_DIM_PROSPECTPLANSITE] as
select
[PROSPECTPLANSITEFACTID],
[PROSPECTPLANSITESYSTEMID],
[SITESYSTEMID],
[SITEDIMID],
[PROSPECTPLANDIMID]
from [BBDW].[DIM_PROSPECTPLANSITE];