FACT_PLANNEDGIFTADDITION_STAGE

Staging table for the planned gift addition fact.

Fields

Field	Field Type	Null	Notes	Description
PLANNEDGIFTADDITIONSYSTEMID	uniqueidentifier	yes		dbo.[PLANNEDGIFTADDITION].[ID]
PLANNEDGIFTSYSTEMID	uniqueidentifier	yes		dbo.[PLANNEDGIFTADDITION].[PLANNEDGIFTID]
FINANCIALTRANSACTIONSYSTEMID	uniqueidentifier	yes		dbo.[PLANNEDGIFTADDITIONREVENUE].[REVENUEID]
GIFTAMOUNT	money	yes		Calculated using dbo.[PLANNEDGIFTADDITIONDESIGNATION].[ORGANIZATIONAMOUNT] or dbo.[PLANNEDGIFTADDITION].[ORGANIZATIONEXPECTEDGIFTAMOUNT]
RECOGNITIONAMOUNT	money	yes		dbo.[PLANNEDGIFTADDITION].[RECOGNITIONAMOUNT]
GIFTDATE	datetime	yes		dbo.[PLANNEDGIFTADDITION].[GIFTDATE]
GIFTDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[PLANNEDGIFTADDITION].[GIFTDATE]
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.