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

Financial Aid Bio table

(dwngss_pf.fa_bio)

Explanation

Biographical information on financial aid applicant by aid year.

Source

The warehouse Financial Aid Bio (dwngss_pf.fa_bio) 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_ROBUSDF, SATURN_SPBPERS, FAISMGR_RCRAPP1, FAISMGR_RCRAPP2, FAISMGR_RCRAPP3, FAISMGR_RCRAPP4, FAISMGR_RCRIMP1, FAISMGR_RCRIMP3, FAISMGR_ROBNYUD.

Common Uses

• Identifying specific characteristics of student or aid applicant groups such as first generation, number in college, maritial status, residency, etc.

Cautions and notes

• This table provides fund award information by aid year. Use caution when joining to other tables that are period based or term based. The aid year includes mulitple student term and periods.

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