FA USER DEFINED NON AIDY column definitions . Pennant Financial Aid Home . Data Warehouse Home

Financial Aid User Defined Non-Aid Year

(dwngss_pf.fa_user_defined_non_aidy)

Explanation

This table provides the user defined field from Banner that are not specific to an aid year. The source table allows for over 300 values to be entered by Financial Aid staff.

Source

The warehouse Financial Aid User Defined Non-Aid Year (dwngss_pf.fa_user_defined_non_aidy) 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 FAISMGR_ROBNYUD.

Common Uses

• Add a user defined field to query to filter students or add additional column for output.

Cautions and notes

• The column names correspond with the source field. They are listed as VALUE_1, VALUE_2, VALUE_3. You will have to know which field you need. Documentation and the Business Objects Universe will only display fields that were previously identified as needed during the documentation process. Additional fields/values may be active and being used by the Financial Aid staff.

FA USER DEFINED NON AIDY column definitions . Pennant Financial Aid Home . Data Warehouse Home