FA COMMENTS VERTICAL column definitions . Pennant Financial Aid Home . Data Warehouse Home

Financial Aid Comments Vertical table

(dwngss_pf.fa_comments_vertical)

Explanation

ISIR comments listed for a student for a given aid year. These comments are listed as one row per comment per aid year for a student.

Source

The warehouse Financial Aid Comments Vertical (dwngss_pf.fa_comments_vertical) 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_RCRAPP1, FAISMGR_RCRESAR and FAISMGR_RTVINFC.

Common Uses

• Get the comment codes associated with a student. Find specific students who have a specific comment code that may need follow up.

Cautions and notes

• This table has muliple rows per student per aid year. If you join to this table, it may duplicate output unless you control for that by using group by or distict functions.

FA COMMENTS VERTICAL column definitions . Pennant Financial Aid Home . Data Warehouse Home