DIM_PLANNEDGIFT_STAGE

Staging table for the planned gift dimension.

Fields

Field	Field Type	Null	Notes	Description
PLANNEDGIFTSYSTEMID	uniqueidentifier	yes		dbo.[PLANNEDGIFT].[ID]
CONSTITUENTSYSTEMID	uniqueidentifier	yes		dbo.[PLANNEDGIFT].[CONSTITUENTID]
FINANCIALTRANSACTIONSYSTEMID	uniqueidentifier	yes		dbo.[PLANNEDGIFTREVENUE].[REVENUEID]
PROSPECTPLANSYSTEMID	uniqueidentifier	yes		dbo.[PLANNEDGIFT].[PROSPECTPLANID]
SUBTYPE	nvarchar(100)	yes		dbo.[PLANNEDGIFT].[SUBTYPE] or dbo.[PLANNEDGIFTOTHERSUBTYPECODE].[DESCRIPTION] depending on the planned gift vehicle
VEHICLE	nvarchar(50)	yes		dbo.[PLANNEDGIFT].[VEHICLE]
STATUS	nvarchar(25)	yes		dbo.[PLANNEDGIFT].[STATUS]
EXPECTEDMATURITY	int	yes		dbo.[PLANNEDGIFT].[EXPECTEDMATURITY]
ISREVOCABLE	bit	yes		dbo.[PLANNEDGIFT].[ISREVOCABLE]
ISANONYMOUS	bit	yes		dbo.[PLANNEDGIFT].[ISANONYMOUS]
ISLIVINGTRUST	bit	yes		dbo.[PLANNEDGIFT].[ISLIVINGTRUST]
GIFTISCONTINGENT	bit	yes		dbo.[PLANNEDGIFT].[ISCONTINGENT]
GIFTVALUEISNOMINAL	bit	yes		dbo.[PLANNEDGIFT].[GIFTVALUEISNOMINAL]
TOTALGIFTAMOUNT	money	yes		Default value of zero. Total Gift Amount is calculated later on the dimension table
ORIGINALGIFTAMOUNT	money	yes		Calculated using dbo.[PLANNEDGIFTDESIGNATION].[ORGANIZATIONAMOUNT] or dbo.[PLANNEDGIFT].[ORGANIZATIONEXPECTEDGIFTAMOUNT]
ORIGINALGIFTDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[PLANNEDGIFT].[GIFTDATE]
ORIGINALGIFTDATE	datetime	yes		dbo.[PLANNEDGIFT].[GIFTDATE]
RECOGNITIONAMOUNT	money	yes		dbo.[PLANNEDGIFT].[ORGANIZATIONRECOGNITIONAMOUNT]
NETPRESENTVALUE	money	yes		dbo.[PLANNEDGIFT].[ORGANIZATIONNETPRESENTVALUE]
REALIZEDAMOUNT	money	yes		dbo.[PLANNEDGIFT].[ORGANIZATIONREALIZEDAMOUNT] or automatic calculation
AUTOCALCULATEREALIZEDAMOUNT	bit	yes		dbo.[PLANNEDGIFT].[AUTOCALCULATEREALIZEDAMOUNT]
REMAINDERMANPERCENT	decimal(6, 5)	yes		dbo.[PLANNEDGIFT].[REMAINDERMANPERCENT]
REMAINDERVALUE	money	yes		dbo.[PLANNEDGIFT].[REMAINDERVALUE]
REMAINDERVALUEDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[PLANNEDGIFT].[REMAINDERVALUEDATE]
REMAINDERVALUEDATE	datetime	yes		dbo.[PLANNEDGIFT].[REMAINDERVALUEDATE]
PROBATESTATUS	nvarchar(50)	yes		dbo.[PLANNEDGIFT].[PROBATESTATUS]
PROBATEDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[PLANNEDGIFT].[PROBATEDATE]
PROBATEDATE	datetime	yes		dbo.[PLANNEDGIFT].[PROBATEDATE]
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.