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

Financial Aid Budget Component by Period table

(dwngss_pf.fa_budget_comp_by_period)

Explanation

Applicant period budget component table.

Source

The warehouse Financial Aid Bio (dwngss_pf.fa_award_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_RBRAPBG, FAISMGR_RTVPBGP, FAISMGR_RTVPBTP, FAISMGR_RTVPBCP, and FAISMGR_RTVABRC.

Common Uses

• Identify budget components for individual applicants for a given aid year.

Cautions and notes

• When joining to this table, keep in mind that the table is based on period rather than aid year. If your other tables are based on aid year, your join may duplicate the information from the other table.

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