FACT_REVENUEOPPORTUNITY_STAGE

Intermediate storage for relating opportunities to revenue applications.

Fields

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