| 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 ACCOUNT ACCOUNT B_ACCOUNT
|
NO NO NO 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 ACCOUNT_DESC ACCOUNT_DESC B_ACCOUNT_DESC
|
NO NO NO 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 ACCOUNT_LEVEL_1 ACCOUNT_LEVEL_1 ACCOUNT_LEVEL_1
|
NO NO NO 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 ACCOUNT_DESC_1 ACCOUNT_DESC_1 ACCOUNT_DESC_1
|
NO NO NO 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 ACCOUNT_DESC_1 ACCOUNT_DESC_1 ACCOUNT_DESC_1
|
NO NO NO 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 ACCOUNT_LEVEL_2 ACCOUNT_LEVEL_2 ACCOUNT_LEVEL_2
|
NO NO NO 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 ACCOUNT_DESC_2 ACCOUNT_DESC_2 ACCOUNT_DESC_2
|
NO NO NO 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 ACCOUNT_DESC_2 ACCOUNT_DESC_2 ACCOUNT_DESC_2
|
NO NO NO 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 ACCOUNT_LEVEL_3 ACCOUNT_LEVEL_3 ACCOUNT_LEVEL_3
|
NO NO NO 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 ACCOUNT_DESC_3 ACCOUNT_DESC_3 ACCOUNT_DESC_3
|
NO NO NO 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 ACCOUNT_DESC_3 ACCOUNT_DESC_3 ACCOUNT_DESC_3
|
NO NO NO 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 ACCOUNT_LEVEL_4 ACCOUNT_LEVEL_4 ACCOUNT_LEVEL_4
|
NO NO NO 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 ACCOUNT_DESC_4 ACCOUNT_DESC_4 ACCOUNT_DESC_4
|
NO NO NO 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 ACCOUNT_DESC_4 ACCOUNT_DESC_4 ACCOUNT_DESC_4
|
NO NO NO 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 ACCOUNT_POOL ACCOUNT_POOL ACCOUNT_POOL
|
NO NO NO 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 ACCOUNT_POOL_DESC ACCOUNT_POOL_DESC ACCOUNT_POOL_DESC
|
NO NO NO 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 ACCOUNT_POOL_DESC ACCOUNT_POOL_DESC ACCOUNT_POOL_DESC
|
NO NO NO 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 ACCOUNT_DESC ACCOUNT_DESC ACCOUNT_DESC
|
NO NO NO 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 ACCOUNT_TYPE ACCOUNT_TYPE ACCOUNT_TYPE
|
NO NO NO 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 ACCOUNT_TYPE_DESC ACCOUNT_TYPE_DESC ACCOUNT_TYPE_DESC
|
NO NO NO 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 ACCOUNT_TYPE_LEVEL_1 ACCOUNT_TYPE_LEVEL_1 ACCOUNT_TYPE_LEVEL_1
|
NO NO NO 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 ACCOUNT_TYPE_DESC_1 ACCOUNT_TYPE_DESC_1 ACCOUNT_TYPE_DESC_1
|
NO NO NO 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 ACCOUNT_TYPE_DESC_1 ACCOUNT_TYPE_DESC_1 ACCOUNT_TYPE_DESC_1
|
NO NO NO 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 ACCOUNT_TYPE_LEVEL_2 ACCOUNT_TYPE_LEVEL_2 ACCOUNT_TYPE_LEVEL_2
|
NO NO NO 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 ACCOUNT_TYPE_DESC_2 ACCOUNT_TYPE_DESC_2 ACCOUNT_TYPE_DESC_2
|
NO NO NO 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 ACCOUNT_TYPE_DESC_2 ACCOUNT_TYPE_DESC_2 ACCOUNT_TYPE_DESC_2
|
NO NO NO 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 ACCOUNT_TYPE_DESC ACCOUNT_TYPE_DESC ACCOUNT_TYPE_DESC
|
NO NO NO 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 INTERNAL_ACCOUNT_TYPE INTERNAL_ACCOUNT_TYPE INTERNAL_ACCOUNT_TYPE
|
NO NO NO 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 INTERNAL_ACCOUNT_TYPE_DESC INTERNAL_ACCOUNT_TYPE_DESC INTERNAL_ACCOUNT_TYPE_DESC
|
NO NO NO 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 INTERNAL_ACCOUNT_TYPE_DESC INTERNAL_ACCOUNT_TYPE_DESC INTERNAL_ACCOUNT_TYPE_DESC
|
NO NO NO 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
|