DIM_FUNDINGREQUEST

contains information about funding requests.

Primary Key

Primary Key	Field Type
FUNDINGREQUESTDIMID	int

Fields

Field	Field Type	Null	Notes	Description
FUNDINGREQUESTSYSTEMID	uniqueidentifier	yes		dbo.[FUNDINGREQUEST].[ID]
FUNDINGPLANMANAGERCONSTITUENTDIMID	int	yes		Reference key to the constituent dimension, derived from dbo.[FUNDINGPLAN].[FUNDINGPLANMANAGERID]
FUNDINGPLANMANAGERCONSTITUENTSYSTEMID	uniqueidentifier	yes		dbo.[FUNDINGPLAN].[FUNDINGPLANMANAGERID]
FUNDINGPLANNAME	nvarchar(150)	yes		dbo.[FUNDINGPLAN].[NAME]
FUNDINGPLANDESCRIPTION	nvarchar(500)	yes		dbo.[FUNDINGPLAN].[DESCRIPTION]
FUNDINGNEEDAMOUNT	money	yes		dbo.[FUNDINGPLAN].[FUNDINGNEED]
FUNDINGPLANNEEDEDDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[FUNDINGPLAN].[DATENEEDED]
FUNDINGPLANNEEDEDDATE	datetime	yes		dbo.[FUNDINGPLAN].[DATENEEDED]
FUNDINGPLANDEPARTMENT	nvarchar(100)	yes		dbo.[FUNDINGPLANDEPARTMENTCODE].[DESCRIPTION]
FUNDINGPLANPROGRAM	nvarchar(100)	yes		dbo.[FUNDINGPLANPROGRAMCODE].[DESCRIPTION]
FUNDINGPLANISACTIVE	bit	yes		Reverse of dbo.[FUNDINGPLAN].[ISINACTIVE]
SITEDIMID	int	yes		Reference key to the site dimension, derived from dbo.[FUNDINGPLAN].[SITEID]
SUBMITTEDDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[FUNDINGREQUEST].[DATESUBMITTED]
SUBMITTEDDATE	datetime	yes		dbo.[FUNDINGREQUEST].[DATESUBMITTED]
REQUESTEDAMOUNT	money	yes		dbo.[FUNDINGREQUEST].[AMOUNTREQUESTED]
AWARDEDAMOUNT	money	yes		dbo.[FUNDINGREQUEST].[AMOUNTAWARDED]
FUNDINGREQUESTCOMMENT	nvarchar(500)	yes		dbo.[FUNDINGREQUEST].[COMMENT]
PRIMARYMANAGERCONSTITUENTDIMID	int	yes		Reference key to the constituent dimension, derived from dbo.[FUNDINGREQUEST].[PRIMARYMANAGERID]
PRIMARYMANAGERCONSTITUENTSYSTEMID	uniqueidentifier	yes		dbo.[FUNDINGREQUEST].[PRIMARYMANAGERID]
SECONDARYMANAGERCONSTITUENTDIMID	int	yes		Reference key to the constituent dimension, derived from dbo.[FUNDINGREQUEST].[SECONDARYMANAGERID]
SECONDARYMANAGERCONSTITUENTSYSTEMID	uniqueidentifier	yes		dbo.[FUNDINGREQUEST].[SECONDARYMANAGERID]
FUNDINGREQUESTSTAGE	nvarchar(100)	yes		dbo.[FUNDINGREQUESTSTAGECODE].[DESCRIPTION]
FUNDINGREQUESTSTATUS	nvarchar(100)	yes		dbo.[FUNDINGREQUESTSTATUSCODE].[DESCRIPTION]
FUNDINGREQUESTTYPE	nvarchar(100)	yes		dbo.[FUNDINGREQUESTTYPECODE].[DESCRIPTION]
ISINCLUDED	int	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.

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_DIM_FUNDINGREQUEST_FUNDINGPLANMANAGERCONSTITUENTDIMID	FUNDINGPLANMANAGERCONSTITUENTDIMID
IX_DIM_FUNDINGREQUEST_FUNDINGPLANMANAGERCONSTITUENTSYSTEMID	FUNDINGPLANMANAGERCONSTITUENTSYSTEMID
IX_DIM_FUNDINGREQUEST_FUNDINGPLANNEEDEDDATEDIMID	FUNDINGPLANNEEDEDDATEDIMID
IX_DIM_FUNDINGREQUEST_PRIMARYMANAGERCONSTITUENTDIMID	PRIMARYMANAGERCONSTITUENTDIMID
IX_DIM_FUNDINGREQUEST_PRIMARYMANAGERCONSTITUENTSYSTEMID	PRIMARYMANAGERCONSTITUENTSYSTEMID
IX_DIM_FUNDINGREQUEST_SECONDARYMANAGERCONSTITUENTDIMID	SECONDARYMANAGERCONSTITUENTDIMID
IX_DIM_FUNDINGREQUEST_SECONDARYMANAGERCONSTITUENTSYSTEMID	SECONDARYMANAGERCONSTITUENTSYSTEMID
IX_DIM_FUNDINGREQUEST_SITEDIMID	SITEDIMID
IX_DIM_FUNDINGREQUEST_SUBMITTEDDATEDIMID	SUBMITTEDDATEDIMID
PK_DIM_FUNDINGREQUEST	FUNDINGREQUESTDIMID	yes	yes	yes