FACT_OPPORTUNITYDESIGNATIONCAMPAIGN_STAGE

Intermediate storage for relating opportunities to campaigns, designations and campaign priorities.

Fields

Field	Field Type	Null	Notes	Description
OPPORTUNITYDESIGNATIONCAMPAIGNSYSTEMID	uniqueidentifier	yes		dbo.[OPPORTUNITYDESIGNATIONCAMPAIGN].[ID]
OPPORTUNITYFACTID	int	yes		Reference key to the opportunity fact, derived from dbo.[OPPORTUNITYDESIGNATION].[OPPORTUNITYID]
DESIGNATIONDIMID	int	yes		Reference key to the designation dimension, derived from dbo.[OPPORTUNITYDESIGNATION].[DESIGNATIONID]
CAMPAIGNDIMID	int	yes		Reference key to the campaign dimension, derived from dbo.[OPPORTUNITYDESIGNATIONCAMPAIGN].[CAMPAIGNID]
CAMPAIGNPRIORITYDIMID	int	yes		Reference key to the campaign priority dimension, derived from dbo.[OPPORTUNITYDESIGNATIONCAMPAIGN].[NAME]
ISINCLUDED	bit	yes		Flag indicating when data should be included in results.
ETLCONTROLID	int	yes		ID generated through the ETL process
SOURCEDIMID	int	yes		Source system used.