DIM_PROSPECTPLAN

Contains information about prospect plans.

Primary Key

Primary Key	Field Type
PROSPECTPLANDIMID	int

Fields

Field	Field Type	Null	Notes	Description
PROSPECTPLANSYSTEMID	uniqueidentifier	yes		dbo.[PROSPECTPLAN].[ID]
CONSTITUENTSYSTEMID	uniqueidentifier	yes		dbo.[PROSPECTPLAN].[PROSPECTID]
CONSTITUENTDIMID	int	yes		Reference key to the constituent dimension, derived from dbo.[PROSPECTPLAN].[PROSPECTID]
PROSPECTSTATUS	nvarchar(100)	yes		dbo.[PROSPECTPLANSTATUSCODE].[DESCRIPTION]
RESEARCHSTATUSCONFIRMED	bit	yes		dbo.[PROSPECT].[RESEARCHSTATUSCONFIRMED]
PROSPECTPLANNAME	nvarchar(100)	yes		dbo.[PROSPECTPLAN].[NAME]
PROSPECTPLANSTATUS	nvarchar(100)	yes		dbo.[PROSPECTPLANSTATUSCODE].[DESCRIPTION]
PROSPECTPLANTYPE	nvarchar(100)	yes		dbo.[PROSPECTPLANTYPECODE].[DESCRIPTION]
PROSPECTMANAGERFUNDRAISERDIMID	int	yes		Reference key to the fundraiser dimension, derived from dbo.[PROSPECT].[PROSPECTMANAGERFUNDRAISERID]
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]
PRIMARYFUNDRAISERSTARTDATE	datetime	yes		dbo.[PROSPECTPLAN].[PRIMARYMANAGERSTARTDATE]
PRIMARYFUNDRAISERSTARTDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[PROSPECTPLAN].[PRIMARYMANAGERSTARTDATE]
PRIMARYFUNDRAISERENDDATE	datetime	yes		dbo.[PROSPECTPLAN].[PRIMARYMANAGERENDDATE]
PRIMARYFUNDRAISERENDDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[PROSPECTPLAN].[PRIMARYMANAGERENDDATE]
SECONDARYFUNDRAISERSTARTDATE	datetime	yes		dbo.[PROSPECTPLAN].[SECONDARYMANAGERSTARTDATE]
SECONDARYFUNDRAISERSTARTDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[PROSPECTPLAN].[SECONDARYMANAGERSTARTDATE]
SECONDARYFUNDRAISERENDDATE	datetime	yes		dbo.[PROSPECTPLAN].[SECONDARYMANAGERENDDATE]
SECONDARYFUNDRAISERENDDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[PROSPECTPLAN].[SECONDARYMANAGERENDDATE]
NARRATIVE	nvarchar(1000)	yes		dbo.[PROSPECTPLAN].[NARRATIVE]
PROSPECTPLANISACTIVE	bit	yes		dbo.[PROSPECTPLAN].[ISACTIVE]
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.
PRIMARYFUNDRAISERSYSTEMID	uniqueidentifier	yes		dbo.[PROSPECTPLAN].[PRIMARYMANAGERFUNDRAISERID]
SECONDARYFUNDRAISERSYSTEMID	uniqueidentifier	yes		dbo.[PROSPECTPLAN].[SECONDARYMANAGERFUNDRAISERID]

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_DIM_PROSPECTPLAN_CONSTITUENTDIMID	CONSTITUENTDIMID
IX_DIM_PROSPECTPLAN_PRIMARYFUNDRAISERDIMID	PRIMARYFUNDRAISERDIMID
IX_DIM_PROSPECTPLAN_PRIMARYFUNDRAISERENDDATEDIMID	PRIMARYFUNDRAISERENDDATEDIMID
IX_DIM_PROSPECTPLAN_PRIMARYFUNDRAISERSTARTDATEDIMID	PRIMARYFUNDRAISERSTARTDATEDIMID
IX_DIM_PROSPECTPLAN_PROSPECTMANAGERFUNDRAISERDIMID	PROSPECTMANAGERFUNDRAISERDIMID
IX_DIM_PROSPECTPLAN_PROSPECTPLANSYSTEMID	PROSPECTPLANSYSTEMID
IX_DIM_PROSPECTPLAN_SECONDARYFUNDRAISERDIMID	SECONDARYFUNDRAISERDIMID
IX_DIM_PROSPECTPLAN_SECONDARYFUNDRAISERENDDATEDIMID	SECONDARYFUNDRAISERENDDATEDIMID
IX_DIM_PROSPECTPLAN_SECONDARYFUNDRAISERSTARTDATEDIMID	SECONDARYFUNDRAISERSTARTDATEDIMID
PK_DIM_PROSPECTPLAN	PROSPECTPLANDIMID	yes	yes	yes