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

Financial Aid Fund Base table

(dwngss_pf.fa_fund_base)

Explanation

Fund/Award base table includes information such as if the fund code is associated with a detail code, federal ID, if it is a grant/scholarship, etc.

Source

The warehouse Financial Cost of Attendance (dwngss_pf.fa_fund_base) 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_RFRBASE, FAISMGR_RTVFSRC, FAISMGR_RTVFTYP, TAISMGR_TBBDETC and TAISMGR_TTVDCAT.

Common Uses

• Looking up individual fund code information.

Cautions and notes

• This table includes fund information but does not include indivudal award amounts.

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