Dimension Table Target: WDT

	RETURN TO BANNER EDW META DATA REPORTS LIST
	General Ledger Star Grant And Project Star Operating Ledger Star Receivable Revenue Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_ACCOUNT

Description Account Dimension table provides information for the hierarchy of the account. This information includes internal account type and account pool information as well as the two account types and four levels that may have been assigned to the account. It uses the cleansing rules in the EDW for the short and long descriptions.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name

ACCOUNT "Defined value representing an account. Accounts are either Assets, Liability, Control, Fund Balance, Revenue, Labor, Expenditure or Transfer." This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme. VARCHAR2(63)
RECEIVABLE_ACCOUNTING

B_ACCOUNT

NO
NO RECEIVABLE REVENUE

ACCOUNT_KEY Key for the account dimension. NUMBER
ETL GENERATED

NA

NO
NO GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE

ACCOUNT_LD Long description of the responsible account. This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme. VARCHAR2(255)
RECEIVABLE_ACCOUNTING

B_ACCOUNT_DESC

NO
NO RECEIVABLE REVENUE

ACCOUNT_LEVEL_1 "Defined value representing an account. Accounts are either Assets, Liability, Control, Fund Balance, Revenue, Labor, Expenditure or Transfer." This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme. VARCHAR2(63)
ACCOUNT_HIERARCHY

ACCOUNT_LEVEL_1

NO
NO RECEIVABLE REVENUE

ACCOUNT_LEVEL_1_LD Long description or title for the account level. This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme. VARCHAR2(255)
ACCOUNT_HIERARCHY

ACCOUNT_DESC_1

NO
NO RECEIVABLE REVENUE

ACCOUNT_LEVEL_1_SD Short description or title for the account level. VARCHAR2(255)
ACCOUNT_HIERARCHY

ACCOUNT_DESC_1

NO
NO RECEIVABLE REVENUE

ACCOUNT_LEVEL_2 "Defined value representing an account. Accounts are either Assets, Liability, Control, Fund Balance, Revenue, Labor, Expenditure or Transfer." This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme. VARCHAR2(63)
ACCOUNT_HIERARCHY

ACCOUNT_LEVEL_2

NO
NO RECEIVABLE REVENUE

ACCOUNT_LEVEL_2_LD Long description or title for the account level. This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme. VARCHAR2(255)
ACCOUNT_HIERARCHY

ACCOUNT_DESC_2

NO
NO RECEIVABLE REVENUE

ACCOUNT_LEVEL_2_SD Short description or title for the account level. VARCHAR2(255)
ACCOUNT_HIERARCHY

ACCOUNT_DESC_2

NO
NO RECEIVABLE REVENUE

ACCOUNT_LEVEL_3 "Defined value representing an account. Accounts are either Assets, Liability, Control, Fund Balance, Revenue, Labor, Expenditure or Transfer." This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme. VARCHAR2(63)
ACCOUNT_HIERARCHY

ACCOUNT_LEVEL_3

NO
NO RECEIVABLE REVENUE

ACCOUNT_LEVEL_3_LD Long description or title for the account level. This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme. VARCHAR2(255)
ACCOUNT_HIERARCHY

ACCOUNT_DESC_3

NO
NO RECEIVABLE REVENUE

ACCOUNT_LEVEL_3_SD Short description or title for the account level. VARCHAR2(255)
ACCOUNT_HIERARCHY

ACCOUNT_DESC_3

NO
NO RECEIVABLE REVENUE

ACCOUNT_LEVEL_4 "Defined value representing an account. Accounts are either Assets, Liability, Control, Fund Balance, Revenue, Labor, Expenditure or Transfer." This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme. VARCHAR2(63)
ACCOUNT_HIERARCHY

ACCOUNT_LEVEL_4

NO
NO RECEIVABLE REVENUE

ACCOUNT_LEVEL_4_LD Long description or title for the account level. This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme. VARCHAR2(255)
ACCOUNT_HIERARCHY

ACCOUNT_DESC_4

NO
NO RECEIVABLE REVENUE

ACCOUNT_LEVEL_4_SD Short description or title for the account level. VARCHAR2(255)
ACCOUNT_HIERARCHY

ACCOUNT_DESC_4

NO
NO RECEIVABLE REVENUE

ACCOUNT_POOL Account responsible for controlling the budget. VARCHAR2(63)
ACCOUNT_HIERARCHY

ACCOUNT_POOL

NO
NO RECEIVABLE REVENUE

ACCOUNT_POOL_LD Long description assigned to the fund pool. VARCHAR2(255)
ACCOUNT_HIERARCHY

ACCOUNT_POOL_DESC

NO
NO RECEIVABLE REVENUE

ACCOUNT_POOL_SD Short description assigned to the fund pool. VARCHAR2(255)
ACCOUNT_HIERARCHY

ACCOUNT_POOL_DESC

NO
NO RECEIVABLE REVENUE

ACCOUNT_SD Short description of the responsible account. VARCHAR2(255)
ACCOUNT_HIERARCHY

ACCOUNT_DESC

NO
NO RECEIVABLE REVENUE

ACCOUNT_TYPE "Classifies an account type i.e., asset, revenue, etc. for reporting purposes." This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme. VARCHAR2(63)
ACCOUNT_HIERARCHY

ACCOUNT_TYPE

NO
NO GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE

ACCOUNT_TYPE_LD Long description or title for the account type. This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme. VARCHAR2(255)
ACCOUNT_HIERARCHY

ACCOUNT_TYPE_DESC

NO
NO GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE

ACCOUNT_TYPE_LEVEL_1 "Classifies an account type i.e., asset, revenue, etc. for reporting purposes." This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme. VARCHAR2(63)
ACCOUNT_HIERARCHY

ACCOUNT_TYPE_LEVEL_1

NO
NO RECEIVABLE REVENUE

ACCOUNT_TYPE_LEVEL_1_LD Long description or title for the account type. This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme. VARCHAR2(255)
ACCOUNT_HIERARCHY

ACCOUNT_TYPE_DESC_1

NO
NO RECEIVABLE REVENUE

ACCOUNT_TYPE_LEVEL_1_SD Short description or title for the account type. VARCHAR2(255)
ACCOUNT_HIERARCHY

ACCOUNT_TYPE_DESC_1

NO
NO RECEIVABLE REVENUE

ACCOUNT_TYPE_LEVEL_2 "Classifies an account type i.e., asset, revenue, etc. for reporting purposes." This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme. VARCHAR2(63)
ACCOUNT_HIERARCHY

ACCOUNT_TYPE_LEVEL_2

NO
NO RECEIVABLE REVENUE

ACCOUNT_TYPE_LEVEL_2_LD Long description or title for the account type. This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme. VARCHAR2(255)
ACCOUNT_HIERARCHY

ACCOUNT_TYPE_DESC_2

NO
NO RECEIVABLE REVENUE

ACCOUNT_TYPE_LEVEL_2_SD Short description or title for the account type. VARCHAR2(255)
ACCOUNT_HIERARCHY

ACCOUNT_TYPE_DESC_2

NO
NO RECEIVABLE REVENUE

ACCOUNT_TYPE_SD Short description or title for the account type. VARCHAR2(255)
ACCOUNT_HIERARCHY

ACCOUNT_TYPE_DESC

NO
NO GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE

INTERNAL_ACCOUNT_TYPE "Classifies an internal account type i.e., asset, revenue, etc. for reporting purposes." This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme. VARCHAR2(63)
ACCOUNT_HIERARCHY

INTERNAL_ACCOUNT_TYPE

NO
NO RECEIVABLE REVENUE

INTERNAL_ACCOUNT_TYPE_LD Long description or title for the internal account type. This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme. VARCHAR2(255)
ACCOUNT_HIERARCHY

INTERNAL_ACCOUNT_TYPE_DESC

NO
NO RECEIVABLE REVENUE

INTERNAL_ACCOUNT_TYPE_SD Short description or title for the internal account type. VARCHAR2(255)
ACCOUNT_HIERARCHY

INTERNAL_ACCOUNT_TYPE_DESC

NO
NO RECEIVABLE REVENUE

SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)
ETL GENERATED

NA

NO
NO GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE

SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE
ETL GENERATED

NA

NO
NO GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE

Ver: 9.0

Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACCOUNT	"Defined value representing an account. Accounts are either Assets, Liability, Control, Fund Balance, Revenue, Labor, Expenditure or Transfer." This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme.	VARCHAR2(63)	RECEIVABLE_ACCOUNTING	B_ACCOUNT	NO	NO	RECEIVABLE REVENUE
ACCOUNT_KEY	Key for the account dimension.	NUMBER	ETL GENERATED	NA	NO	NO	GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE
ACCOUNT_LD	Long description of the responsible account. This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme.	VARCHAR2(255)	RECEIVABLE_ACCOUNTING	B_ACCOUNT_DESC	NO	NO	RECEIVABLE REVENUE
ACCOUNT_LEVEL_1	"Defined value representing an account. Accounts are either Assets, Liability, Control, Fund Balance, Revenue, Labor, Expenditure or Transfer." This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme.	VARCHAR2(63)	ACCOUNT_HIERARCHY	ACCOUNT_LEVEL_1	NO	NO	RECEIVABLE REVENUE
ACCOUNT_LEVEL_1_LD	Long description or title for the account level. This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme.	VARCHAR2(255)	ACCOUNT_HIERARCHY	ACCOUNT_DESC_1	NO	NO	RECEIVABLE REVENUE
ACCOUNT_LEVEL_1_SD	Short description or title for the account level.	VARCHAR2(255)	ACCOUNT_HIERARCHY	ACCOUNT_DESC_1	NO	NO	RECEIVABLE REVENUE
ACCOUNT_LEVEL_2	"Defined value representing an account. Accounts are either Assets, Liability, Control, Fund Balance, Revenue, Labor, Expenditure or Transfer." This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme.	VARCHAR2(63)	ACCOUNT_HIERARCHY	ACCOUNT_LEVEL_2	NO	NO	RECEIVABLE REVENUE
ACCOUNT_LEVEL_2_LD	Long description or title for the account level. This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme.	VARCHAR2(255)	ACCOUNT_HIERARCHY	ACCOUNT_DESC_2	NO	NO	RECEIVABLE REVENUE
ACCOUNT_LEVEL_2_SD	Short description or title for the account level.	VARCHAR2(255)	ACCOUNT_HIERARCHY	ACCOUNT_DESC_2	NO	NO	RECEIVABLE REVENUE
ACCOUNT_LEVEL_3	"Defined value representing an account. Accounts are either Assets, Liability, Control, Fund Balance, Revenue, Labor, Expenditure or Transfer." This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme.	VARCHAR2(63)	ACCOUNT_HIERARCHY	ACCOUNT_LEVEL_3	NO	NO	RECEIVABLE REVENUE
ACCOUNT_LEVEL_3_LD	Long description or title for the account level. This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme.	VARCHAR2(255)	ACCOUNT_HIERARCHY	ACCOUNT_DESC_3	NO	NO	RECEIVABLE REVENUE
ACCOUNT_LEVEL_3_SD	Short description or title for the account level.	VARCHAR2(255)	ACCOUNT_HIERARCHY	ACCOUNT_DESC_3	NO	NO	RECEIVABLE REVENUE
ACCOUNT_LEVEL_4	"Defined value representing an account. Accounts are either Assets, Liability, Control, Fund Balance, Revenue, Labor, Expenditure or Transfer." This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme.	VARCHAR2(63)	ACCOUNT_HIERARCHY	ACCOUNT_LEVEL_4	NO	NO	RECEIVABLE REVENUE
ACCOUNT_LEVEL_4_LD	Long description or title for the account level. This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme.	VARCHAR2(255)	ACCOUNT_HIERARCHY	ACCOUNT_DESC_4	NO	NO	RECEIVABLE REVENUE
ACCOUNT_LEVEL_4_SD	Short description or title for the account level.	VARCHAR2(255)	ACCOUNT_HIERARCHY	ACCOUNT_DESC_4	NO	NO	RECEIVABLE REVENUE
ACCOUNT_POOL	Account responsible for controlling the budget.	VARCHAR2(63)	ACCOUNT_HIERARCHY	ACCOUNT_POOL	NO	NO	RECEIVABLE REVENUE
ACCOUNT_POOL_LD	Long description assigned to the fund pool.	VARCHAR2(255)	ACCOUNT_HIERARCHY	ACCOUNT_POOL_DESC	NO	NO	RECEIVABLE REVENUE
ACCOUNT_POOL_SD	Short description assigned to the fund pool.	VARCHAR2(255)	ACCOUNT_HIERARCHY	ACCOUNT_POOL_DESC	NO	NO	RECEIVABLE REVENUE
ACCOUNT_SD	Short description of the responsible account.	VARCHAR2(255)	ACCOUNT_HIERARCHY	ACCOUNT_DESC	NO	NO	RECEIVABLE REVENUE
ACCOUNT_TYPE	"Classifies an account type i.e., asset, revenue, etc. for reporting purposes." This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme.	VARCHAR2(63)	ACCOUNT_HIERARCHY	ACCOUNT_TYPE	NO	NO	GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE
ACCOUNT_TYPE_LD	Long description or title for the account type. This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme.	VARCHAR2(255)	ACCOUNT_HIERARCHY	ACCOUNT_TYPE_DESC	NO	NO	GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE
ACCOUNT_TYPE_LEVEL_1	"Classifies an account type i.e., asset, revenue, etc. for reporting purposes." This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme.	VARCHAR2(63)	ACCOUNT_HIERARCHY	ACCOUNT_TYPE_LEVEL_1	NO	NO	RECEIVABLE REVENUE
ACCOUNT_TYPE_LEVEL_1_LD	Long description or title for the account type. This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme.	VARCHAR2(255)	ACCOUNT_HIERARCHY	ACCOUNT_TYPE_DESC_1	NO	NO	RECEIVABLE REVENUE
ACCOUNT_TYPE_LEVEL_1_SD	Short description or title for the account type.	VARCHAR2(255)	ACCOUNT_HIERARCHY	ACCOUNT_TYPE_DESC_1	NO	NO	RECEIVABLE REVENUE
ACCOUNT_TYPE_LEVEL_2	"Classifies an account type i.e., asset, revenue, etc. for reporting purposes." This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme.	VARCHAR2(63)	ACCOUNT_HIERARCHY	ACCOUNT_TYPE_LEVEL_2	NO	NO	RECEIVABLE REVENUE
ACCOUNT_TYPE_LEVEL_2_LD	Long description or title for the account type. This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme.	VARCHAR2(255)	ACCOUNT_HIERARCHY	ACCOUNT_TYPE_DESC_2	NO	NO	RECEIVABLE REVENUE
ACCOUNT_TYPE_LEVEL_2_SD	Short description or title for the account type.	VARCHAR2(255)	ACCOUNT_HIERARCHY	ACCOUNT_TYPE_DESC_2	NO	NO	RECEIVABLE REVENUE
ACCOUNT_TYPE_SD	Short description or title for the account type.	VARCHAR2(255)	ACCOUNT_HIERARCHY	ACCOUNT_TYPE_DESC	NO	NO	GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE
INTERNAL_ACCOUNT_TYPE	"Classifies an internal account type i.e., asset, revenue, etc. for reporting purposes." This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme.	VARCHAR2(63)	ACCOUNT_HIERARCHY	INTERNAL_ACCOUNT_TYPE	NO	NO	RECEIVABLE REVENUE
INTERNAL_ACCOUNT_TYPE_LD	Long description or title for the internal account type. This information will be taken from the ODS Operating Ledger, Grant Ledger or General Ledger reporting view as appropriate for the star scheme.	VARCHAR2(255)	ACCOUNT_HIERARCHY	INTERNAL_ACCOUNT_TYPE_DESC	NO	NO	RECEIVABLE REVENUE
INTERNAL_ACCOUNT_TYPE_SD	Short description or title for the internal account type.	VARCHAR2(255)	ACCOUNT_HIERARCHY	INTERNAL_ACCOUNT_TYPE_DESC	NO	NO	RECEIVABLE REVENUE
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL GENERATED	NA	NO	NO	GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE