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_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 Financial Aid Fund code to be associated with information in this record. VARCHAR2(63)
RECEIVABLE_ACCOUNTING

B_FUND

NO
NO 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 Long name for the financial aid fund code. VARCHAR2(255)
RECEIVABLE_ACCOUNTING

B_FUND_DESC

NO
NO 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

FUND_LEVEL_1

NO
NO RECEIVABLE REVENUE

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

FUND_DESC_1

NO
NO RECEIVABLE REVENUE

FUND_LEVEL_1_SD Short hierarchy description or title appropriate for this Level. VARCHAR2(255)
FUND_HIERARCHY

FUND_DESC_1

NO
NO RECEIVABLE REVENUE

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

FUND_LEVEL_2

NO
NO RECEIVABLE REVENUE

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

FUND_DESC_2

NO
NO RECEIVABLE REVENUE

FUND_LEVEL_2_SD Short hierarchy description or title appropriate for this Level. VARCHAR2(255)
FUND_HIERARCHY

FUND_DESC_2

NO
NO RECEIVABLE REVENUE

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

FUND_LEVEL_3

NO
NO RECEIVABLE REVENUE

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

FUND_DESC_3

NO
NO RECEIVABLE REVENUE

FUND_LEVEL_3_SD Short hierarchy description or title appropriate for this Level. VARCHAR2(255)
FUND_HIERARCHY

FUND_DESC_3

NO
NO RECEIVABLE REVENUE

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

FUND_LEVEL_4

NO
NO RECEIVABLE REVENUE

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

FUND_DESC_4

NO
NO RECEIVABLE REVENUE

FUND_LEVEL_4_SD Short hierarchy description or title appropriate for this Level. VARCHAR2(255)
FUND_HIERARCHY

FUND_DESC_4

NO
NO RECEIVABLE REVENUE

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

FUND_LEVEL_5

NO
NO RECEIVABLE REVENUE

FUND_LEVEL_5_LD Long hierarchy description or title appropriate for this Level. VARCHAR2(255)
FUND_HIERARCHY

FUND_DESC_5

NO
NO RECEIVABLE REVENUE

FUND_LEVEL_5_SD Short hierarchy description or title appropriate for this Level. VARCHAR2(255)
FUND_HIERARCHY

FUND_DESC_5

NO
NO RECEIVABLE REVENUE

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 Short name for the financial aid fund code. VARCHAR2(255)
RECEIVABLE_ACCOUNTING

B_FUND_DESC

NO
NO RECEIVABLE REVENUE

FUND_TYPE Fund type code to be associated with the fund as defined by the institution. VARCHAR2(63)
FUND_HIERARCHY

FUND_TYPE

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

FUND_TYPE_LD Long description for the institution's fund type. VARCHAR2(255)
FUND_HIERARCHY

FUND_TYPE_DESC

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

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

FUND_TYPE_LEVEL_1

NO
NO RECEIVABLE REVENUE

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

FUND_TYPE_DESC_1

NO
NO RECEIVABLE REVENUE

FUND_TYPE_LEVEL_1_SD Short hierarchy description or title appropriate for this Level. VARCHAR2(255)
FUND_HIERARCHY

FUND_TYPE_DESC_1

NO
NO RECEIVABLE REVENUE

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

FUND_TYPE_LEVEL_2

NO
NO RECEIVABLE REVENUE

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

FUND_TYPE_DESC_2

NO
NO RECEIVABLE REVENUE

FUND_TYPE_LEVEL_2_SD Short hierarchy description or title appropriate for this Level. VARCHAR2(255)
FUND_HIERARCHY

FUND_TYPE_DESC_2

NO
NO RECEIVABLE REVENUE

FUND_TYPE_SD Short description for the institution's fund type. VARCHAR2(255)
FUND_HIERARCHY

FUND_TYPE_DESC

NO
NO GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, 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
FUND	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(63)	RECEIVABLE_ACCOUNTING	B_FUND	NO	NO	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	Long name for the financial aid fund code.	VARCHAR2(255)	RECEIVABLE_ACCOUNTING	B_FUND_DESC	NO	NO	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	FUND_LEVEL_1	NO	NO	RECEIVABLE REVENUE
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	FUND_DESC_1	NO	NO	RECEIVABLE REVENUE
FUND_LEVEL_1_SD	Short hierarchy description or title appropriate for this Level.	VARCHAR2(255)	FUND_HIERARCHY	FUND_DESC_1	NO	NO	RECEIVABLE REVENUE
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	FUND_LEVEL_2	NO	NO	RECEIVABLE REVENUE
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	FUND_DESC_2	NO	NO	RECEIVABLE REVENUE
FUND_LEVEL_2_SD	Short hierarchy description or title appropriate for this Level.	VARCHAR2(255)	FUND_HIERARCHY	FUND_DESC_2	NO	NO	RECEIVABLE REVENUE
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	FUND_LEVEL_3	NO	NO	RECEIVABLE REVENUE
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	FUND_DESC_3	NO	NO	RECEIVABLE REVENUE
FUND_LEVEL_3_SD	Short hierarchy description or title appropriate for this Level.	VARCHAR2(255)	FUND_HIERARCHY	FUND_DESC_3	NO	NO	RECEIVABLE REVENUE
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	FUND_LEVEL_4	NO	NO	RECEIVABLE REVENUE
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	FUND_DESC_4	NO	NO	RECEIVABLE REVENUE
FUND_LEVEL_4_SD	Short hierarchy description or title appropriate for this Level.	VARCHAR2(255)	FUND_HIERARCHY	FUND_DESC_4	NO	NO	RECEIVABLE REVENUE
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	FUND_LEVEL_5	NO	NO	RECEIVABLE REVENUE
FUND_LEVEL_5_LD	Long hierarchy description or title appropriate for this Level.	VARCHAR2(255)	FUND_HIERARCHY	FUND_DESC_5	NO	NO	RECEIVABLE REVENUE
FUND_LEVEL_5_SD	Short hierarchy description or title appropriate for this Level.	VARCHAR2(255)	FUND_HIERARCHY	FUND_DESC_5	NO	NO	RECEIVABLE REVENUE
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	Short name for the financial aid fund code.	VARCHAR2(255)	RECEIVABLE_ACCOUNTING	B_FUND_DESC	NO	NO	RECEIVABLE REVENUE
FUND_TYPE	Fund type code to be associated with the fund as defined by the institution.	VARCHAR2(63)	FUND_HIERARCHY	FUND_TYPE	NO	NO	GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE
FUND_TYPE_LD	Long description for the institution's fund type.	VARCHAR2(255)	FUND_HIERARCHY	FUND_TYPE_DESC	NO	NO	GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, RECEIVABLE REVENUE
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	FUND_TYPE_LEVEL_1	NO	NO	RECEIVABLE REVENUE
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	FUND_TYPE_DESC_1	NO	NO	RECEIVABLE REVENUE
FUND_TYPE_LEVEL_1_SD	Short hierarchy description or title appropriate for this Level.	VARCHAR2(255)	FUND_HIERARCHY	FUND_TYPE_DESC_1	NO	NO	RECEIVABLE REVENUE
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	FUND_TYPE_LEVEL_2	NO	NO	RECEIVABLE REVENUE
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	FUND_TYPE_DESC_2	NO	NO	RECEIVABLE REVENUE
FUND_TYPE_LEVEL_2_SD	Short hierarchy description or title appropriate for this Level.	VARCHAR2(255)	FUND_HIERARCHY	FUND_TYPE_DESC_2	NO	NO	RECEIVABLE REVENUE
FUND_TYPE_SD	Short description for the institution's fund type.	VARCHAR2(255)	FUND_HIERARCHY	FUND_TYPE_DESC	NO	NO	GENERAL LEDGER, GRANT AND PROJECT, OPERATING LEDGER, 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