Penn Computing

University of Pennsylvania
Penn Computing << go backback
FA_AWARD_IM_MV column definitions . Pennant Financial Aid Home . Data Warehouse Home

Financial Aid Need Institutional Methodology materialized view



Needs analysis data based on institional methodology. This is a materalized view.


The warehouse Financial Aid Need Instititional Methodology materialized view (dwngss_pf.fa_need_im_mv) is generated each day after the tables within the DWNGSS_PF schema are 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_RCRAPP2, FAISMGR_RCRAPP3, FAISMGR_RCRAPP4, FAISMGR_RCRIMP1, FAISMGR_ROBUSDF, FAISMGR_RNROVRD, FAISMGR_RCRSARI, FAISGR_RCRTRUS, FAISMGR_RCRHOME, FAISMGR_RCRPARI and FAISMGR_ROBNYUD. The materialized view looks at dwngss_pf.fa_award_aidy amd provides totals so that an aid applicant appears for one row per aid year.

Common Uses

  • Looking for institutional methodology information for needs analysis.


Primary Key Indexed Data Elements Related Tables



Cautions and notes

  • This table is a materialized view. If you are trying to trace the information back to the source table in the ODS and in the corresponding Banner table, you will need to look at the fields from the original tables and then match those fields to the Banner database.
FA_NEED_IM_MV column definitions . Pennant Financial Aid Home . Data Warehouse Home

Questions about this page? Email us at

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania