RETURN TO FACT TABLE REPORTS LIST
Financial Aid Student Star

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_FINANCIAL_AID_STUDENT

Description Financial Aid Student Fact table provides measures that may be compared and displayed based on the dimensions in this star schema. This set of measures is stored per person per time frame.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
ACADEMIC_STUDY_KEY Key for the academic study dimension. NUMBER

ETL GENERATED

NA

NO

NO

FINANCIAL AID STUDENT

AGE Calculated by a function that subtracts the birth date from the load date. NUMBER

PERSON

FUNCTION

NO

NO

FINANCIAL AID STUDENT

AWARD_ACCEPTED_AMOUNT Displays the amount of awards that have been accepted. NUMBER

AWARD_BY_PERSON

AWARD_ACCEPT_AMOUNT

NO

NO

FINANCIAL AID STUDENT

AWARD_AUTHORIZED_AMOUNT Displays the amount of awards that are authorized. NUMBER

AWARD_BY_PERSON

AWARD_AUTHORIZED_AMOUNT

NO

NO

FINANCIAL AID STUDENT

AWARD_CANCELED_AMOUNT Displays the amount of the cancelled award. NUMBER

AWARD_BY_PERSON

AWARD_CANCEL_AMOUNT

NO

NO

FINANCIAL AID STUDENT

AWARD_DECLINED_AMOUNT Displays the amount of awards that have been declined. NUMBER

AWARD_BY_PERSON

AWARD_DECLINE_AMOUNT

NO

NO

FINANCIAL AID STUDENT

AWARD_OFFERED_AMOUNT Displays the amount of all original awards for the FUND in the specified aid year. NUMBER

AWARD_BY_PERSON

ORIGINAL_OFFER_AMOUNT

NO

NO

FINANCIAL AID STUDENT

AWARD_PAID_AMOUNT Displays the amount of awards that have been paid for the FUND for the time dimension NUMBER

AWARD_BY_PERSON

AWARD_PAID_AMOUNT

NO

NO

FINANCIAL AID STUDENT

DEMOGRAPHIC_KEY Key for the demographic dimension. NUMBER

ETL GENERATED

NA

NO

NO

FINANCIAL AID STUDENT

ENROLLMENT_STATUS_KEY Key for the enrollment dimension. NUMBER

ETL GENERATED

NA

NO

NO

FINANCIAL AID STUDENT

FAMILY_INCOME Student's family income as recorded in the ODS. NUMBER

NEED_ANALYSIS

FM_TOTAL_INCOME

NO

NO

FINANCIAL AID STUDENT

FINANCIAL_AID_FUND_KEY Key for the fund dimension. NUMBER

ETL GENERATED

NA

NO

NO

FINANCIAL AID STUDENT

MULTI_SOURCE_KEY Key for the multi source dimension. NUMBER

ETL GENERATED

NA

NO

NO

FINANCIAL AID STUDENT

PERSON_UID System internally generated ID to uniquely identify the person. NUMBER

PERSON

PERSON_UID

NO

NO

FINANCIAL AID STUDENT

STUDENT_KEY Key for the student dimension. NUMBER

ETL GENERATED

NA

NO

NO

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 STUDENT

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

ETL GENERATED

NA

NO

NO

FINANCIAL AID STUDENT

TIME_KEY Key for the time dimension. NUMBER

ETL GENERATED

NA

NO

NO

FINANCIAL AID STUDENT



Ver: 3.1