FA NAME INFO column definitions . Pennant Financial Aid Home . Data Warehouse Home

Financial Aid Name Information table

(dwngss_pf.fa_name_info)

Explanation

Financial aid applicant name information. The table include prefix, suffix, pennkey, penn ID and other related information.

Source

The warehouse Financial Aid Name Information (dwngss_pf.fa_name_info) 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 SATURN_SPRIDEN and SATURN_SPBPERS.

Common Uses

• Join to another table within the database and bring in a student's formal name.

Cautions and notes

• Other tables also have the Penn ID.

FA Name Info column definitions . Pennant Financial Aid Home . Data Warehouse Home