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

Financial Aid Year Period table

(dwngss_pf.fa_aidy_period)

Explanation

This table includes aid year and period information for financial aid based on rules specified from set-up in Banner.

Source

The warehouse Financial Aid Year Period (dwngss_pf.fa_aidy_period) 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_ROBINST, FAISMGR_RORPRDS, and SATURN_STVTERM.

Common Uses

• Getting aid year and period information.

Cautions and notes

• When using this table to for descriptions, keep in mind if you need to include the period and aid year with your join or if you just need the period or if you just need the aid year.

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