FA_AWARD_AIDY column definitions . Pennant Financial Aid Home . Data Warehouse Home

Financial Award Aid Year table

(dwngss_pf.fa_award_aidy)

Explanation

Award details by student by aid year.

Source

The warehouse Financial Aid Award Aidy (dwngss_pf.fa_award_aidy) table is refreshed in batch mode from the Operational Data Store (ODS), which gets its data from the Banner database. The UPENN_ODS source tables are FAISMGR_RPRAWRD, FAISMGR_RFRBASE, FAISMGR_ROBINST, FAISMGR_RTVAWST, FAISMGR_RTVFSRC, FAISMGR_RTVFSCR, FAISMGR_RTVFTYP, TAISMGR_TBBDETC, TAISMGR_TBBDETC, TAISMGR_TTVDCAT.

Common Uses

• Looking at student or applicant award information for a given aid year. Looking at overall amounts awarded by fund source, fund type, fund code, etc.

Cautions and notes

• This table provides fund award information by aid year. If you are looking for period based information, please use the FA_AWARD_PERIOD table instead. In addition, use caution when joining to other tables that are period based or term based. The aid year includes mulitple student term and periods.

FA_AWARD_AIDY column definitions . Pennant Student Records Home . Data Warehouse Home