| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
|
FUND
|
Fund that is responsible for the asset. 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
|
FUND FUND FUND B_FUND
|
NO NO NO NO
|
NO
|
GENERAL LEDGER GRANT AND PROJECT OPERATING LEDGER RECEIVABLE REVENUE
|
|
FUND_KEY
|
Key for the fund dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE
|
|
FUND_LD
|
Identifies the long or full title of the financial aid fund code.
|
VARCHAR2(255)
|
GENERAL_LEDGER GRANT_LEDGER OPERATING_LEDGER RECEIVABLE_ACCOUNTING
|
FUND_DESC FUND_DESC FUND_DESC B_FUND_DESC
|
NO NO NO NO
|
NO
|
GENERAL LEDGER GRANT AND PROJECT OPERATING LEDGER RECEIVABLE REVENUE
|
|
FUND_LEVEL_1
|
Primary fund within the fund hierarchy. 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)
|
FUND_HIERARCHY GENERAL_LEDGER GRANT_LEDGER OPERATING_LEDGER
|
FUND_LEVEL_1 FUND_LEVEL_1 FUND_LEVEL_1 FUND_LEVEL_1
|
NO NO NO NO
|
NO
|
RECEIVABLE REVENUE GENERAL LEDGER GRANT AND PROJECT OPERATING LEDGER
|
|
FUND_LEVEL_1_LD
|
Long hierarchy description or title appropriate for this 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)
|
FUND_HIERARCHY GENERAL_LEDGER GRANT_LEDGER OPERATING_LEDGER
|
FUND_DESC_1 FUND_DESC_1 FUND_DESC_1 FUND_DESC_1
|
NO NO NO NO
|
NO
|
RECEIVABLE REVENUE GENERAL LEDGER GRANT AND PROJECT OPERATING LEDGER
|
|
FUND_LEVEL_1_SD
|
Short hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUND_HIERARCHY GENERAL_LEDGER GRANT_LEDGER OPERATING_LEDGER
|
FUND_DESC_1 FUND_DESC_1 FUND_DESC_1 FUND_DESC_1
|
NO NO NO NO
|
NO
|
RECEIVABLE REVENUE GENERAL LEDGER GRANT AND PROJECT OPERATING LEDGER
|
|
FUND_LEVEL_2
|
Level 2 fund within this fund hierarchy. 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)
|
FUND_HIERARCHY GENERAL_LEDGER GRANT_LEDGER OPERATING_LEDGER
|
FUND_LEVEL_2 FUND_LEVEL_2 FUND_LEVEL_2 FUND_LEVEL_2
|
NO NO NO NO
|
NO
|
RECEIVABLE REVENUE GENERAL LEDGER GRANT AND PROJECT OPERATING LEDGER
|
|
FUND_LEVEL_2_LD
|
Long hierarchy description or title appropriate for this 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)
|
FUND_HIERARCHY GENERAL_LEDGER GRANT_LEDGER OPERATING_LEDGER
|
FUND_DESC_2 FUND_DESC_2 FUND_DESC_2 FUND_DESC_2
|
NO NO NO NO
|
NO
|
RECEIVABLE REVENUE GENERAL LEDGER GRANT AND PROJECT OPERATING LEDGER
|
|
FUND_LEVEL_2_SD
|
Short hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUND_HIERARCHY GENERAL_LEDGER GRANT_LEDGER OPERATING_LEDGER
|
FUND_DESC_2 FUND_DESC_2 FUND_DESC_2 FUND_DESC_2
|
NO NO NO NO
|
NO
|
RECEIVABLE REVENUE GENERAL LEDGER GRANT AND PROJECT OPERATING LEDGER
|
|
FUND_LEVEL_3
|
Level 3 fund within this fund hierarchy. 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)
|
FUND_HIERARCHY GENERAL_LEDGER GRANT_LEDGER OPERATING_LEDGER
|
FUND_LEVEL_3 FUND_LEVEL_3 FUND_LEVEL_3 FUND_LEVEL_3
|
NO NO NO NO
|
NO
|
RECEIVABLE REVENUE GENERAL LEDGER GRANT AND PROJECT OPERATING LEDGER
|
|
FUND_LEVEL_3_LD
|
Long hierarchy description or title appropriate for this 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)
|
FUND_HIERARCHY GENERAL_LEDGER GRANT_LEDGER OPERATING_LEDGER
|
FUND_DESC_3 FUND_DESC_3 FUND_DESC_3 FUND_DESC_3
|
NO NO NO NO
|
NO
|
RECEIVABLE REVENUE GENERAL LEDGER GRANT AND PROJECT OPERATING LEDGER
|
|
FUND_LEVEL_3_SD
|
Short hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUND_HIERARCHY GENERAL_LEDGER GRANT_LEDGER OPERATING_LEDGER
|
FUND_DESC_3 FUND_DESC_3 FUND_DESC_3 FUND_DESC_3
|
NO NO NO NO
|
NO
|
RECEIVABLE REVENUE GENERAL LEDGER GRANT AND PROJECT OPERATING LEDGER
|
|
FUND_LEVEL_4
|
Level 4 fund within this fund hierarchy. 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)
|
FUND_HIERARCHY GENERAL_LEDGER GRANT_LEDGER OPERATING_LEDGER
|
FUND_LEVEL_4 FUND_LEVEL_4 FUND_LEVEL_4 FUND_LEVEL_4
|
NO NO NO NO
|
NO
|
RECEIVABLE REVENUE GENERAL LEDGER GRANT AND PROJECT OPERATING LEDGER
|
|
FUND_LEVEL_4_LD
|
Long hierarchy description or title appropriate for this 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)
|
FUND_HIERARCHY GENERAL_LEDGER GRANT_LEDGER OPERATING_LEDGER
|
FUND_DESC_4 FUND_DESC_4 FUND_DESC_4 FUND_DESC_4
|
NO NO NO NO
|
NO
|
RECEIVABLE REVENUE GENERAL LEDGER GRANT AND PROJECT OPERATING LEDGER
|
|
FUND_LEVEL_4_SD
|
Short hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUND_HIERARCHY GENERAL_LEDGER GRANT_LEDGER OPERATING_LEDGER
|
FUND_DESC_4 FUND_DESC_4 FUND_DESC_4 FUND_DESC_4
|
NO NO NO NO
|
NO
|
RECEIVABLE REVENUE GENERAL LEDGER GRANT AND PROJECT OPERATING LEDGER
|
|
FUND_LEVEL_5
|
Level 5 fund within this fund hierarchy. 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)
|
FUND_HIERARCHY GENERAL_LEDGER GRANT_LEDGER OPERATING_LEDGER
|
FUND_LEVEL_5 FUND_LEVEL_5 FUND_LEVEL_5 FUND_LEVEL_5
|
NO NO NO NO
|
NO
|
RECEIVABLE REVENUE GENERAL LEDGER GRANT AND PROJECT OPERATING LEDGER
|
|
FUND_LEVEL_5_LD
|
Long hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUND_HIERARCHY GENERAL_LEDGER GRANT_LEDGER OPERATING_LEDGER
|
FUND_DESC_5 FUND_DESC_5 FUND_DESC_5 FUND_DESC_5
|
NO NO NO NO
|
NO
|
RECEIVABLE REVENUE GENERAL LEDGER GRANT AND PROJECT OPERATING LEDGER
|
|
FUND_LEVEL_5_SD
|
Short hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUND_HIERARCHY GENERAL_LEDGER GRANT_LEDGER OPERATING_LEDGER
|
FUND_DESC_5 FUND_DESC_5 FUND_DESC_5 FUND_DESC_5
|
NO NO NO NO
|
NO
|
RECEIVABLE REVENUE GENERAL LEDGER GRANT AND PROJECT OPERATING LEDGER
|
|
FUND_POOL
|
Fund responsible for controlling the budget.
|
VARCHAR2(63)
|
FUND_HIERARCHY
|
FUND_POOL
|
NO
|
NO
|
GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE
|
|
FUND_POOL_LD
|
Long description assigned to the fund pool.
|
VARCHAR2(255)
|
FUND_HIERARCHY
|
FUND_POOL_DESC
|
NO
|
NO
|
GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE
|
|
FUND_POOL_SD
|
Short description assigned to the fund pool.
|
VARCHAR2(255)
|
FUND_HIERARCHY
|
FUND_POOL_DESC
|
NO
|
NO
|
GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE
|
|
FUND_SD
|
Identifies a short title for the financial aid fund code.
|
VARCHAR2(255)
|
GENERAL_LEDGER GRANT_LEDGER OPERATING_LEDGER RECEIVABLE_ACCOUNTING
|
FUND_DESC FUND_DESC FUND_DESC B_FUND_DESC
|
NO NO NO NO
|
NO
|
GENERAL LEDGER GRANT AND PROJECT OPERATING LEDGER RECEIVABLE REVENUE
|
|
FUND_TYPE
|
Identifies the financial aid fund type code used to classify the fund code. For example, scholarships, grants, loans, employment and whether it is institutional, federal or other for grouping.
|
VARCHAR2(63)
|
FUND_HIERARCHY GENERAL_LEDGER GRANT_LEDGER OPERATING_LEDGER
|
FUND_TYPE FUND_TYPE FUND_TYPE FUND_TYPE
|
NO NO NO NO
|
NO
|
RECEIVABLE REVENUE GENERAL LEDGER GRANT AND PROJECT OPERATING LEDGER
|
|
FUND_TYPE_LD
|
Long description for the fund type code.
|
VARCHAR2(255)
|
FUND_HIERARCHY GENERAL_LEDGER GRANT_LEDGER OPERATING_LEDGER
|
FUND_TYPE_DESC FUND_TYPE_DESC FUND_TYPE_DESC FUND_TYPE_DESC
|
NO NO NO NO
|
NO
|
RECEIVABLE REVENUE GENERAL LEDGER GRANT AND PROJECT OPERATING LEDGER
|
|
FUND_TYPE_LEVEL_1
|
Primary fund type within this fund hierarchy. 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)
|
FUND_HIERARCHY GENERAL_LEDGER GRANT_LEDGER OPERATING_LEDGER
|
FUND_TYPE_LEVEL_1 FUND_TYPE_LEVEL_1 FUND_TYPE_LEVEL_1 FUND_TYPE_LEVEL_1
|
NO NO NO NO
|
NO
|
RECEIVABLE REVENUE GENERAL LEDGER GRANT AND PROJECT OPERATING LEDGER
|
|
FUND_TYPE_LEVEL_1_LD
|
Long hierarchy description or title appropriate for this 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)
|
FUND_HIERARCHY GENERAL_LEDGER GRANT_LEDGER OPERATING_LEDGER
|
FUND_TYPE_DESC_1 FUND_TYPE_DESC_1 FUND_TYPE_DESC_1 FUND_TYPE_DESC_1
|
NO NO NO NO
|
NO
|
RECEIVABLE REVENUE GENERAL LEDGER GRANT AND PROJECT OPERATING LEDGER
|
|
FUND_TYPE_LEVEL_1_SD
|
Short hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUND_HIERARCHY GENERAL_LEDGER GRANT_LEDGER OPERATING_LEDGER
|
FUND_TYPE_DESC_1 FUND_TYPE_DESC_1 FUND_TYPE_DESC_1 FUND_TYPE_DESC_1
|
NO NO NO NO
|
NO
|
RECEIVABLE REVENUE GENERAL LEDGER GRANT AND PROJECT OPERATING LEDGER
|
|
FUND_TYPE_LEVEL_2
|
Secondary fund type within this fund hierarchy. 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)
|
FUND_HIERARCHY GENERAL_LEDGER GRANT_LEDGER OPERATING_LEDGER
|
FUND_TYPE_LEVEL_2 FUND_TYPE_LEVEL_2 FUND_TYPE_LEVEL_2 FUND_TYPE_LEVEL_2
|
NO NO NO NO
|
NO
|
RECEIVABLE REVENUE GENERAL LEDGER GRANT AND PROJECT OPERATING LEDGER
|
|
FUND_TYPE_LEVEL_2_LD
|
Long hierarchy description or title appropriate for this 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)
|
FUND_HIERARCHY GENERAL_LEDGER GRANT_LEDGER OPERATING_LEDGER
|
FUND_TYPE_DESC_2 FUND_TYPE_DESC_2 FUND_TYPE_DESC_2 FUND_TYPE_DESC_2
|
NO NO NO NO
|
NO
|
RECEIVABLE REVENUE GENERAL LEDGER GRANT AND PROJECT OPERATING LEDGER
|
|
FUND_TYPE_LEVEL_2_SD
|
Short hierarchy description or title appropriate for this Level.
|
VARCHAR2(255)
|
FUND_HIERARCHY GENERAL_LEDGER GRANT_LEDGER OPERATING_LEDGER
|
FUND_TYPE_DESC_2 FUND_TYPE_DESC_2 FUND_TYPE_DESC_2 FUND_TYPE_DESC_2
|
NO NO NO NO
|
NO
|
RECEIVABLE REVENUE GENERAL LEDGER GRANT AND PROJECT OPERATING LEDGER
|
|
FUND_TYPE_SD
|
Short description for the fund type code.
|
VARCHAR2(255)
|
FUND_HIERARCHY GENERAL_LEDGER GRANT_LEDGER OPERATING_LEDGER
|
FUND_TYPE_DESC FUND_TYPE_DESC FUND_TYPE_DESC FUND_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
|