v_FACT_PROSPECTFUNDINGINTERESTSITE
Contains information about sites associated with PROSPECTFUNDINGINTERESTs.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| PROSPECTFUNDINGINTERESTSITEFACTID | int | BBDW.[FACT_PROSPECTFUNDINGINTERESTSITE].[PROSPECTFUNDINGINTERESTSITEFACTID] | |
| PROSPECTFUNDINGINTERESTSITESYSTEMID | uniqueidentifier | yes | BBDW.[FACT_PROSPECTFUNDINGINTERESTSITE].[PROSPECTFUNDINGINTERESTSITESYSTEMID] |
| SITEDIMID | int | yes | BBDW.[FACT_PROSPECTFUNDINGINTERESTSITE].[SITEDIMID] |
| PROSPECTFUNDINGINTERESTDIMID | int | yes | BBDW.[FACT_PROSPECTFUNDINGINTERESTSITE].[PROSPECTFUNDINGINTERESTDIMID] |
Definition
Copy
create view [BBDW].[v_FACT_PROSPECTFUNDINGINTERESTSITE] as
select
es.[PROSPECTFUNDINGINTERESTSITEFACTID],
es.[PROSPECTFUNDINGINTERESTSITESYSTEMID],
es.[SITEDIMID],
es.[PROSPECTFUNDINGINTERESTDIMID]
from BBDW.[FACT_PROSPECTFUNDINGINTERESTSITE] es