FACT_OPPORTUNITY_STAGE

Intermediate storage table for prospect opportunities.

Fields

Field	Field Type	Null	Notes	Description
OPPORTUNITYSYSTEMID	uniqueidentifier	yes		dbo.[OPPORTUNITY].[ID]
PROSPECTPLANDIMID	int	yes		Reference key to the constituent dimension, derived from dbo.[OPPORTUNITY].[PROSPECTPLANID]
CONSTITUENTDIMID	int	yes		Reference key to the constituent dimension, derived from dbo.[PROSPECTPLAN].[PROSPECTID]
CONSTITUENTSYSTEMID	uniqueidentifier	yes		dbo.[PROSPECTPLAN].[PROSPECTID]
PRIMARYFUNDRAISERDIMID	int	yes		Reference key to the fundraiser dimension, derived from dbo.[PROSPECTPLAN].[PRIMARYMANAGERFUNDRAISERID]
SECONDARYFUNDRAISERDIMID	int	yes		Reference key to the fundraiser dimension, derived from dbo.[PROSPECTPLAN].[SECONDARYMANAGERFUNDRAISERID]
OPPORTUNITYSTATUS	nvarchar(100)	yes		dbo.[OPPORTUNITY].[STATUS]
OPPORTUNITYTYPE	nvarchar(100)	yes		dbo.[OPPORTUNITYTYPECODE].[DESCRIPTION]
OPPORTUNITYLIKELIHOODTYPE	nvarchar(100)	yes		dbo.[LIKELIHOODTYPECODE].[DESCRIPTION]
EXPECTEDASKAMOUNT	money	yes		dbo.[OPPORTUNITY].[EXPECTEDASKAMOUNT]
EXPECTEDASKDATE	datetime	yes		dbo.[OPPORTUNITY].[EXPECTEDASKDATE]
EXPECTEDASKDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[OPPORTUNITY].[EXPECTEDASKDATE]
ASKAMOUNT	money	yes		dbo.[OPPORTUNITY].[ASKAMOUNT]
ASKDATE	datetime	yes		dbo.[OPPORTUNITY].[ASKDATE]
ASKDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[OPPORTUNITY].[ASKDATE]
OPPORTUNITYAMOUNT	money	yes		dbo.[OPPORTUNITY].[AMOUNT]
RESPONSEDATE	datetime	yes		dbo.[OPPORTUNITY].[RESPONSEDATE]
RESPONSEDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[OPPORTUNITY].[RESPONSEDATE]
ISINCLUDED	bit	yes		Flag indicating when data should be included in results.
ETLCONTROLID	int	yes		ID generated through the ETL process
SOURCEDIMID	tinyint	yes		Source system used.