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

Financial Aid Cost of Attendance table

(dwngss_pf.fa_coa)

Explanation

Applicant cost of attendance for a given aid year based on institutional methodology.

Source

The warehouse Financial Cost of Attendance (dwngss_pf.fa_coa) 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_RBRAPBG, FAISMGR_RBRAPBC, FASIGMR_RBRACMP, FASIMGR_RPTNEED, FAISMGR_RBRAPBT, and FAISMGR_RTVPBGP. The calculation for cost of attendance is based on the RKNEED.F_CALC_BUDGET_AMT function.

Common Uses

• Viewing the cost of attenance for individual students for a given aid year.

Cautions and notes

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

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