FA NEED column definitions . Pennant Financial Aid Home . Data Warehouse Home

Financial Aid Bio table

(dwngss_pf.fa_need)

Explanation

This table displays need, income, and other financial aid data points on individual financial aid applicants for a given aid year. One row per aid applicant per aid year.

Source

The warehouse Financial Aid Need (dwngss_pf.fa_need) 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_RORSTAT, FAISMGR_RCRAPP1, FAISMGR_RCRAPP2, FAISMGR_RCRAPP3, FAISMGR_RCRAPP4, FAISMGR_RCRIMP1, FAISMGR_ROBUSDF, FAISMGR_RNROVRD, and FAISMGR_ROBNYUD.

Common Uses

• Identify data points tied to income for a given student.

Cautions and notes

• This table providesinformation by aid year. Use caution when joining to other tables that are period based or term based as results may end up being duplicated.

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