RETURN TO DIMENSION TABLE 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)

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

RECEIVABLE_ACCOUNTING

ACCOUNT

B_ACCOUNT

NO

NO

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

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)

GENERAL_LEDGER

GRANT_AND_PROJECT

OPERATING_LEDGER

RECEIVABLE_ACCOUNTING

ACCOUNT_DESC

B_ACCOUNT_DESC

NO

NO

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

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

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

ACCOUNT_LEVEL_1

NO

NO

RECEIVABLE REVENUE

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

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

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

ACCOUNT_DESC_1

NO

NO

RECEIVABLE REVENUE

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

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

ACCOUNT_HIERARCHY

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

ACCOUNT_DESC_1

NO

NO

RECEIVABLE REVENUE

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

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

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

ACCOUNT_LEVEL_2

NO

NO

RECEIVABLE REVENUE

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

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

GENERAL_LEDGER

GRANT_AND_PROJECT

OPERATING_LEDGER

ACCOUNT_DESC_2

NO

NO

RECEIVABLE REVENUE

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

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

ACCOUNT_HIERARCHY

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

ACCOUNT_DESC_2

NO

NO

RECEIVABLE REVENUE

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

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

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

ACCOUNT_LEVEL_3

NO

NO

RECEIVABLE REVENUE

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

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

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

ACCOUNT_DESC_3

NO

NO

RECEIVABLE REVENUE

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

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

ACCOUNT_HIERARCHY

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

ACCOUNT_DESC_3

NO

NO

RECEIVABLE REVENUE

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

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

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

ACCOUNT_LEVEL_4

NO

NO

RECEIVABLE REVENUE

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

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

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

ACCOUNT_DESC_4

NO

NO

RECEIVABLE REVENUE

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

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

ACCOUNT_HIERARCHY

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

ACCOUNT_DESC_4

NO

NO

RECEIVABLE REVENUE

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

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

ACCOUNT_HIERARCHY

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

ACCOUNT_POOL

NO

NO

RECEIVABLE REVENUE

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

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

ACCOUNT_HIERARCHY

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

ACCOUNT_POOL_DESC

NO

NO

RECEIVABLE REVENUE

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

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

ACCOUNT_HIERARCHY

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

ACCOUNT_POOL_DESC

NO

NO

RECEIVABLE REVENUE

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

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

ACCOUNT_HIERARCHY

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

ACCOUNT_DESC

NO

NO

RECEIVABLE REVENUE

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

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

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

ACCOUNT_TYPE

NO

NO

RECEIVABLE REVENUE

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

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

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

ACCOUNT_TYPE_DESC

NO

NO

RECEIVABLE REVENUE

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

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

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

ACCOUNT_TYPE_LEVEL_1

NO

NO

RECEIVABLE REVENUE

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

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

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

ACCOUNT_TYPE_DESC_1

NO

NO

RECEIVABLE REVENUE

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

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

ACCOUNT_HIERARCHY

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

ACCOUNT_TYPE_DESC_1

NO

NO

RECEIVABLE REVENUE

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

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

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

ACCOUNT_TYPE_LEVEL_2

NO

NO

RECEIVABLE REVENUE

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

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

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

ACCOUNT_TYPE_DESC_2

NO

NO

RECEIVABLE REVENUE

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

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

ACCOUNT_HIERARCHY

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

ACCOUNT_TYPE_DESC_2

NO

NO

RECEIVABLE REVENUE

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

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

ACCOUNT_HIERARCHY

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

ACCOUNT_TYPE_DESC

NO

NO

RECEIVABLE REVENUE

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

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

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

INTERNAL_ACCOUNT_TYPE

NO

NO

RECEIVABLE REVENUE

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

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

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

INTERNAL_ACCOUNT_TYPE_DESC

NO

NO

RECEIVABLE REVENUE

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

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

ACCOUNT_HIERARCHY

GENERAL_LEDGER

GRANT_LEDGER

OPERATING_LEDGER

INTERNAL_ACCOUNT_TYPE_DESC

NO

NO

RECEIVABLE REVENUE

GENERAL LEDGER

GRANT AND PROJECT

OPERATING LEDGER

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: 3.1