![]() |
||
![]() |
![]() |
<< go back![]() |
FA_AWARD_FM_MV column definitions . Pennant Financial Aid Home . Data Warehouse HomeFinancial Aid Need Federal Methodology Materialized View(dwngss_pf.fa_need_fm_mv) Explanation Needs analysis data based on federal methodology. This is a materalized view. Source The warehouse Financial Aid Need Federal Methodology Materialized View (dwngss_pf.fa_need_fm_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_need_ede and dwngss_pf.fa_need amd provides informaiton so that an aid applicant appears for one row per aid year. Common Uses
Cautions and notes
Questions about this page? Email us at da-staff@isc.upenn.edu | ||||||
Information Systems and Computing University of Pennsylvania |