DIM_PURPOSELEVEL

The purpose level dimension contains information about designation purposes.

Primary Key

Primary Key	Field Type
PURPOSELEVELDIMID	int

Fields

Field	Field Type	Null	Notes	Description
PURPOSELEVELSYSTEMID	uniqueidentifier	yes		dbo.[DESIGNATIONLEVEL].[ID]
PURPOSELEVELNAME	nvarchar(100)	yes		dbo.[DESIGNATIONLEVEL].[NAME]
PURPOSELEVELPUBLICNAME	nvarchar(512)	yes		dbo.[DESIGNATIONLEVEL].[VANITYNAME]
PURPOSELEVELDESCRIPTION	nvarchar(255)	yes		dbo.[DESIGNATIONLEVEL].[DESCRIPTION]
PURPOSELEVELLOOKUPID	nvarchar(100)	yes		dbo.[DESIGNATIONLEVEL].[USERID]
PURPOSELEVELISENDOWED	bit	yes		dbo.[DESIGNATIONLEVEL].[ISENDOWED]
PURPOSELEVELENDOWMENTMINAMOUNT	money	yes		dbo.[DESIGNATIONLEVEL].[ENDOWMENTMINAMOUNT]
PURPOSELEVELENDOWMENTTARGETDATE	datetime	yes		dbo.[DESIGNATIONLEVEL].[ENDOWMENTTARGETDATE]
PURPOSELEVELENDOWMENTMINAMOUNTMETDATE	datetime	yes		dbo.[DESIGNATIONLEVEL].[ENDOWMENTMINAMOUNTDATEMET]
PURPOSELEVELISFULLYFUNDED	bit	yes		dbo.[DESIGNATIONLEVEL].[ISFULLYFUNDED]
PURPOSELEVELISACCEPTINGFUNDS	bit	yes		dbo.[DESIGNATIONLEVEL].[ISACCEPTINGFUNDS]
PURPOSELEVELISDISBURSINGMONEY	bit	yes		dbo.[DESIGNATIONLEVEL].[ISDISBURSINGMONEY]
PURPOSELEVELISINCOMETOPRINCIPAL	bit	yes		dbo.[DESIGNATIONLEVEL].[ISINCOMETOPRINCIPAL]
PURPOSELEVELINCOMETOPRINCIPALPERCENT	decimal(5, 2)	yes		dbo.[DESIGNATIONLEVEL].[INCOMETOPRINCIPALPERCENT]
PURPOSELEVELFREQUENCY	nvarchar(30)	yes		dbo.[DESIGNATIONLEVEL].[TIMEPERIOD]
PURPOSELEVELCATEGORY	nvarchar(100)	yes		dbo.[DESIGNATIONLEVELCATEGORYCODE].[DESCRIPTION]
PURPOSELEVELTYPE	nvarchar(100)	yes		dbo.[DESIGNATIONLEVELTYPE].[DESCRIPTION]
PURPOSELEVELREPORT1CODE	nvarchar(100)	yes		dbo.[DESIGNATIONREPORT1CODE].[DESCRIPTION]
PURPOSELEVELREPORT2CODE	nvarchar(100)	yes		dbo.[DESIGNATIONREPORT2CODE].[DESCRIPTION]
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.
SITEDIMID	int	yes		Reference key to the site dimension, derived from [dbo].[DESIGNATIONLEVEL].[SITEID]
SITESYSTEMID	uniqueidentifier	yes		[dbo].[DESIGNATIONLEVEL].[SITEID]

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_DIM_PURPOSELEVEL_PURPOSELEVELSYSTEMID	PURPOSELEVELSYSTEMID
IX_DIM_PURPOSELEVEL_SITEDIMID	SITEDIMID
IX_DIM_PURPOSELEVEL_SOURCEDIMID	SOURCEDIMID
PK_DIM_PURPOSELEVEL	PURPOSELEVELDIMID	yes	yes	yes