DIM_REVENUECODE

Contains type code values for revenue records.

Primary Key

Primary Key	Field Type
REVENUECODEDIMID	int

Fields

Field	Field Type	Null	Notes	Description
REVENUEPAYMENTMETHODCODE	int	yes		dbo.[REVENUEPAYMENTMETHOD].[PAYMENTMETHODCODE]
REVENUEPAYMENTMETHOD	nvarchar(50)	yes		dbo.[REVENUEPAYMENTMETHOD].[PAYMENTMETHOD]
REVENUETRANSACTIONTYPECODE	int	yes		dbo.[FINANCIALTRANSACTION].[TYPECODE]
REVENUETRANSACTIONTYPE	nvarchar(50)	yes		dbo.[FINANCIALTRANSACTION].[TYPE]
REVENUEPOSTSTATUSCODE	int	yes		dbo.[FINANCIALTRANSACTION].[POSTSTATUSCODE]
REVENUEPOSTSTATUS	nvarchar(50)	yes		dbo.[FINANCIALTRANSACTION].[POSTSTATUS]
REVENUERECEIPTTYPECODE	int	yes		dbo.[REVENUE_EXT].[RECEIPTTYPECODE]
REVENUERECEIPTTYPE	nvarchar(50)	yes		dbo.[REVENUE_EXT].[RECEIPTTYPE]
REVENUEAPPLICATIONTYPECODE	int	yes		dbo.[REVENUESPLIT_EXT].[TYPECODE]
REVENUEAPPLICATIONTYPE	nvarchar(50)	yes		dbo.[REVENUESPLIT_EXT].[TYPE]
REVENUEAPPLICATIONCODE	int	yes		dbo.[REVENUESPLIT_EXT].[APPLICATIONCODE]
REVENUEAPPLICATION	nvarchar(50)	yes		dbo.[REVENUESPLIT_EXT].[APPLICATION]
FINANCIALTRANSACTIONLINEITEMTYPECODE	int	yes		dbo.[FINANCIALTRANSACTIONLINEITEM].[TYPECODE]
FINANCIALTRANSACTIONLINEITEMTYPE	nvarchar(50)	yes		dbo.[FINANCIALTRANSACTIONLINEITEM].[TYPE]
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.
FINANCIALTRANSACTIONLINEITEMPOSTSTATUSCODE	int	yes		dbo.[FINANCIALTRANSACTIONLINEITEM].[POSTSTATUSCODE]
FINANCIALTRANSACTIONLINEITEMPOSTSTATUS	nvarchar(50)	yes		dbo.[FINANCIALTRANSACTIONLINEITEM].[POSTSTATUS]

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_DIM_REVENUECODE_REVENUECODE	REVENUEPAYMENTMETHODCODE, REVENUETRANSACTIONTYPECODE, REVENUEPOSTSTATUSCODE, REVENUERECEIPTTYPECODE, REVENUEAPPLICATIONTYPECODE, REVENUEAPPLICATIONCODE, FINANCIALTRANSACTIONLINEITEMTYPECODE
PK_DIM_REVENUECODE	REVENUECODEDIMID	yes	yes	yes