|<< go back|
Financial Aid Award Aggregate Summary materialized view
Aggregate totals by aid year and source type indicator (Grant, Scholarship, Loan or Work Study) for an aid applicant within a given financial aid year. This is a materalized view.
The warehouse Financial Aid Award Aggregate Summary (dwngss_pf.fa_award_agg_summary_mv) materialized view is generated each day after the tables within the DWNGSS_PF schema. The tables in 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_RPRAWRD, FAISMGR_RFRBASE, and TAISMGR_TBBDETC. 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.
Cautions and notes
Questions about this page? Email us at email@example.com
|Information Systems and Computing|
University of Pennsylvania