v_FACT_OPPORTUNITYDESIGNATIONCAMPAIGN
Relates opportunities to campaigns, designations and campaign priorities.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| OPPORTUNITYDESIGNATIONCAMPAIGNFACTID | int | BBDW.[FACT_OPPORTUNITYDESIGNATIONCAMPAIGN].[OPPORTUNITYDESIGNATIONCAMPAIGNFACTID] | |
| OPPORTUNITYDESIGNATIONCAMPAIGNSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_OPPORTUNITYDESIGNATIONCAMPAIGN].[OPPORTUNITYDESIGNATIONCAMPAIGNSYSTEMID] |
| OPPORTUNITYFACTID | int | yes | BBDW.[FACT_OPPORTUNITYDESIGNATIONCAMPAIGN].[OPPORTUNITYFACTID] |
| DESIGNATIONDIMID | int | yes | BBDW.[FACT_OPPORTUNITYDESIGNATIONCAMPAIGN].[DESIGNATIONDIMID] |
| CAMPAIGNDIMID | int | yes | BBDW.[FACT_OPPORTUNITYDESIGNATIONCAMPAIGN].[CAMPAIGNDIMID] |
| CAMPAIGNPRIORITYDIMID | int | yes | BBDW.[FACT_OPPORTUNITYDESIGNATIONCAMPAIGN].[CAMPAIGNPRIORITYDIMID] |
Definition
Copy
create view [BBDW].[v_FACT_OPPORTUNITYDESIGNATIONCAMPAIGN] as
select
[OPPORTUNITYDESIGNATIONCAMPAIGNFACTID],
[OPPORTUNITYDESIGNATIONCAMPAIGNSYSTEMID],
[OPPORTUNITYFACTID],
[DESIGNATIONDIMID],
[CAMPAIGNDIMID],
[CAMPAIGNPRIORITYDIMID]
from [BBDW].[FACT_OPPORTUNITYDESIGNATIONCAMPAIGN];