FACT_OPPORTUNITYCAMPAIGN_STAGE

Intermediate storage for relating campaigns to opportunities.

Fields

Field	Field Type	Null	Notes	Description
OPPORTUNITYCAMPAIGNSYSTEMID	uniqueidentifier	yes		dbo.[OPPORTUNITYCAMPAIGN].[ID]
OPPORTUNITYFACTID	int	yes		Reference key to the opportunity fact, derived from dbo.[OPPORTUNITYCAMPAIGN].[OPPORTUNITYID]
CAMPAIGNDIMID	int	yes		Reference key to the campaign dimension, derived from dbo.[OPPORTUNITYCAMPAIGN].[CAMPAIGNID]
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.