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_FUND

Description Fund Dimension table provides information for the hierarchy of the fund. This information includes the fund pool information as well as the two fund types and five levels that may have been assigned to the fund. 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
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

B_FUND

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

B_FUND_DESC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

B_FUND_DESC

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

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

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

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

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

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

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

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

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

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