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

Financial Aid Award by Aid Year table

(dwngss_pf.fa_award_aidy)

Explanation

Award details by student by aid year.

Source

The warehouse Financial Aid Award by Aid Year (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, and TAISMGR_TBBDETC.

Common Uses

• Getting aid year award information for a student

Cautions and notes

• This table is by aid year without period information split out. If you join to other tables that have records by period, you may end up duplicating information.

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