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

Financial Aid Comments Flat table

(dwngss_pf.fa_comments_flat)

Explanation

ISIR comments listed for a student for a given aid year. These comments are listed in one row in the similar format as the original Banner table.

Source

The warehouse Financial Aid Comments Flat (dwngss_pf.fa_comments_flat) 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 one row per student per aid year. Keep in mind that to get all the associated comment codes, you would have to look at all fields that include comment codes. This table lists 20 total columns that house comment codes.

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