RETURN TO BANNER EDW META DATA REPORTS LIST
Financial Aid Award By Aid Year Star  

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_FINAID_AWARD_AID_YEAR

Description Financial Aid Award fact table provides information about the financial aid awards for the financial aid applicant for the aid year. This information includes the amount and date by processing status for the award (offered, accepted, declined, canceled, authorized, memo, paid).

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
AWARD_ACCEPTED_AMOUNT Accepted amount for the financial aid award for the person for the aid year. NUMBER

AWARD_BY_AID_YEAR

TOTAL_ACCEPT_AMOUNT

NO

NO FINANCIAL AID AWARD BY AID YEAR
AWARD_ACCEPTED_DATE Date the award was accepted by the person. DATE

AWARD_BY_AID_YEAR

TOTAL_ACCEPT_DATE

NO

NO FINANCIAL AID AWARD BY AID YEAR
AWARD_AUTHORIZED_AMOUNT Authorized amount for the financial aid award for the person for the aid year. NUMBER

AWARD_BY_AID_YEAR

ANNUAL_AWARD_AUTHORIZE_AMOUNT

NO

NO FINANCIAL AID AWARD BY AID YEAR
AWARD_AUTHORIZED_DATE Date of the award was authorization. DATE

AWARD_BY_AID_YEAR

ANNUAL_AWARD_AUTHORIZE_DATE

NO

NO FINANCIAL AID AWARD BY AID YEAR
AWARD_CANCELED_AMOUNT Canceled amount for the financial aid award for the person for the aid year. NUMBER

AWARD_BY_AID_YEAR

ANNUAL_AWARD_CANCEL_AMOUNT

NO

NO FINANCIAL AID AWARD BY AID YEAR
AWARD_CANCELED_DATE Date that the award was cancelled by the institution. DATE

AWARD_BY_AID_YEAR

ANNUAL_AWARD_CANCEL_DATE

NO

NO FINANCIAL AID AWARD BY AID YEAR
AWARD_DECLINED_AMOUNT Declined amount for the financial aid award for the person for the aid year. NUMBER

AWARD_BY_AID_YEAR

TOTAL_DECLINE_AMOUNT

NO

NO FINANCIAL AID AWARD BY AID YEAR
AWARD_DECLINED_DATE Date the award was declined by the person. DATE

AWARD_BY_AID_YEAR

TOTAL_DECLINE_DATE

NO

NO FINANCIAL AID AWARD BY AID YEAR
AWARD_MEMO_AMOUNT Memo amount for the financial aid award for the person for the aid year. This amount is intended but does not yet fit into any of the other financial aid amount groupings. NUMBER

AWARD_BY_AID_YEAR

ANNUAL_AWARD_MEMO_AMOUNT

NO

NO FINANCIAL AID AWARD BY AID YEAR
AWARD_MEMO_EXPIRATION_DATE Date the memo will expire. DATE

AWARD_BY_AID_YEAR

ANNUAL_AWARD_MEMO_DATE

NO

NO FINANCIAL AID AWARD BY AID YEAR
AWARD_OFFERED_AMOUNT Offered amount for the financial aid award for the person for the aid year. NUMBER

AWARD_BY_AID_YEAR

OFFER_AMOUNT

NO

NO FINANCIAL AID AWARD BY AID YEAR
AWARD_OFFERED_DATE Date the award was offered to the person. DATE

AWARD_BY_AID_YEAR

OFFER_DATE

NO

NO FINANCIAL AID AWARD BY AID YEAR
AWARD_ORIGINAL_OFFERED_AMOUNT Original offered amount for the financial aid award for the person for the aid year. NUMBER

AWARD_BY_AID_YEAR

TOTAL_OFFER_AMOUNT

NO

NO FINANCIAL AID AWARD BY AID YEAR
AWARD_ORIGINAL_OFFERED_DATE Date the original award offer was made to the person. DATE

AWARD_BY_AID_YEAR

TOTAL_ORIGINAL_OFFER_DATE

NO

NO FINANCIAL AID AWARD BY AID YEAR
AWARD_PAID_AMOUNT Paid or Disbursed amount for the financial aid award for the person for the aid year. NUMBER

AWARD_BY_AID_YEAR

TOTAL_PAID_AMOUNT

NO

NO FINANCIAL AID AWARD BY AID YEAR
AWARD_PAID_DATE Date the award was paid or disbursed by the institution. DATE

AWARD_BY_AID_YEAR

TOTAL_PAID_DATE

NO

NO FINANCIAL AID AWARD BY AID YEAR
DEMOGRAPHIC_KEY Key for the demographic dimension. NUMBER

ETL_GENERATED

NA

NO

NO FINANCIAL AID AWARD BY AID YEAR
FINAID_AWARD_AIDY_GROUP_KEY Key for the financial aid award aid year group dimension. NUMBER

ETL_GENERATED

NA

NO

NO FINANCIAL AID AWARD BY AID YEAR
FINANCIAL_AID_FUND_KEY Key for the financial aid fund dimension. NUMBER

ETL_GENERATED

NA

NO

NO FINANCIAL AID AWARD BY AID YEAR
FINANCIAL_AID_FUND_STATUS_KEY Key for the financial aid fund status dimension. NUMBER

ETL_GENERATED

NA

NO

NO FINANCIAL AID AWARD BY AID YEAR
FINANCIAL_AID_STATUS_KEY Key for the financial aid status dimension. NUMBER

ETL_GENERATED

NA

NO

NO FINANCIAL AID AWARD BY AID YEAR
FINANCIAL_AID_YEAR_KEY Key for the financial aid year dimension. NUMBER

ETL_GENERATED

NA

NO

NO FINANCIAL AID AWARD BY AID YEAR
MULTI_SOURCE_KEY Key for the multi source dimension. NUMBER

ETL_GENERATED

NA

NO

NO FINANCIAL AID AWARD BY AID YEAR
PERSON_UID Key for the person dimension. NUMBER

AWARD_BY_AID_YEAR

PERSON_UID

NO

NO FINANCIAL AID AWARD BY AID YEAR
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 AWARD BY AID YEAR
SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

ETL_GENERATED

NA

NO

NO FINANCIAL AID AWARD BY AID YEAR


Ver: 9.0