v_FACT_OPPORTUNITYDESIGNATION
Link between Opportunities and Designations, based on the OPPORTUNITYDESIGNATION table.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| OPPORTUNITYDESIGNATIONFACTID | int | BBDW.[FACT_OPPORTUNITYDESIGNATION].[OPPORTUNITYDESIGNATIONFACTID] | |
| OPPORTUNITYDESIGNATIONSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_OPPORTUNITYDESIGNATION].[OPPORTUNITYDESIGNATIONSYSTEMID] |
| OPPORTUNITYFACTID | int | yes | BBDW.[FACT_OPPORTUNITYDESIGNATION].[OPPORTUNITYFACTID] |
| DESIGNATIONDIMID | int | yes | BBDW.[FACT_OPPORTUNITYDESIGNATION].[DESIGNATIONDIMID] |
Definition
Copy
create view [BBDW].[v_FACT_OPPORTUNITYDESIGNATION] as
select
[OPPORTUNITYDESIGNATIONFACTID],
[OPPORTUNITYDESIGNATIONSYSTEMID],
[OPPORTUNITYFACTID],
[DESIGNATIONDIMID]
from [BBDW].[FACT_OPPORTUNITYDESIGNATION];