FA REVAL CMT column definitions . Pennant Financial Aid Home . Data Warehouse Home

Financial Aid Revaluation Comment Table

(dwngss_pf.fa_reval_cmt)

Explanation

This table lists students who recieved Penn grants and also had re-evals done. The EIF, CSEF, REVAL1_5, REVAL_IVY columns indicate the amount change that was inputted by Financial Aid staff.

Source

The warehouse Financial Aid Revaluation Comment Table (dwngss_pf.fa_reval_cmt) 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 SATURN_SPRIDEN and GENERAL_GORSDAV.

Common Uses

• Looking at changes in reevaluation of what was awarded for specific individual students.

Cautions and notes

• This table is based on aid year. Keep in mind that the Penn grants are awarded by period. When joining to other tables such as award tables and requirement tables, make sure that your ouptput is not duplicating the amounts from this table.

FA REVAL CMT column definitions . Pennant Financial Aid Home . Data Warehouse Home