RETURN TO DIMENSION TABLE REPORTS LIST
Financial Aid Pre-Student Star Financial Aid Student Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_FINANCIAL_AID_FUND

Description Financial Aid Fund Dimension table provides information about the financial aid fund. This information includes name of the fund, type and source of fund that will identify if the funds are considered grant, scholarship, and loan or work as well as if the funds are federal, institutional or other. 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
FINANCIAL_AID_FUND_KEY Key for the fund dimension. NUMBER

ETL GENERATED

NA

NO

NO

FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT

FINANCIAL_AID_SOURCE_TYPE Indicator for the financial aid source type associated with the fund code. For example, institutional, federal, state/province or other source. VARCHAR2(63)

FINAID_FUND

FUND_SOURCE_TYPE

NO

NO

FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT

FINANCIAL_AID_SOURCE_TYPE_LD Long description for the fund source type. VARCHAR2(255)

FINAID_FUND

FUND_SOURCE_TYPE_DESC

NO

NO

FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT

FINANCIAL_AID_SOURCE_TYPE_SD Short description for the fund source type. VARCHAR2(255)

FINAID_FUND

FUND_SOURCE_TYPE_DESC

NO

NO

FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT

FINANCIAL_AID_TYPE Indicator for the financial aid fund type code used to classify the fund code. For example, scholarships, grants, loans or work (employment). VARCHAR2(63)

FINAID_FUND

FINANCIAL_AID_TYPE

NO

NO

FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT

FINANCIAL_AID_TYPE_LD Long description for the fund type code. VARCHAR2(255)

FINAID_FUND

FINANCIAL_AID_TYPE_DESC

NO

NO

FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT

FINANCIAL_AID_TYPE_SD Short description for the fund type code. VARCHAR2(255)

FINAID_FUND

FINANCIAL_AID_TYPE_DESC

NO

NO

FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT

FUND Financial Aid Fund that represents a unique fiscal entity. This data will come from either the ODS FINAID Fund or the Award by Person reporting view as appropriate for the star scheme. VARCHAR2(63)

FINAID_FUND

FUND

NO

NO

FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT

FUND_LD Identifies the long or full title of the financial aid fund code. VARCHAR2(255)

FINAID_FUND

FUND_TITLE

NO

NO

FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT

FUND_SD Identifies a short title for the financial aid fund code. VARCHAR2(255)

FINAID_FUND

FUND_TITLE

NO

NO

FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT

FUND_SOURCE Identifies the financial aid fund source associated with the fund code. VARCHAR2(63)

FINAID_FUND

FUND_SOURCE

NO

NO

FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT

FUND_SOURCE_LD Long description for the fund source. VARCHAR2(255)

FINAID_FUND

FUND_SOURCE_DESC

NO

NO

FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT

FUND_SOURCE_SD Short description for the fund source. VARCHAR2(255)

FINAID_FUND

FUND_SOURCE_DESC

NO

NO

FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT

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)

FINAID_FUND

FUND_TYPE

NO

NO

FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT

FUND_TYPE_LD Long description for the fund type code. VARCHAR2(255)

FINAID_FUND

FUND_TYPE_DESC

NO

NO

FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT

FUND_TYPE_SD Short description for the fund type code. VARCHAR2(255)

FINAID_FUND

FUND_TYPE_DESC

NO

NO

FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT

SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)

ETL GENERATED

NA

NO

NO

FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT

SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

ETL GENERATED

NA

NO

NO

FINANCIAL AID PRE-STUDENT, FINANCIAL AID STUDENT



Ver: 3.1