|<< go back|
Financial Aid Award Aggregate Detail materialized view
Aggregate totals by aid year; source type indicator (Grant, Scholarship, Loan or Work Study); and fund source (Institutional, Outside, Federal, or State) for a aid applicant within a given financial aid year. This is a materalized view.
The warehouse Financial Aid Award Detail Summary (dwngss_pf.fa_award_agg_detail_mv) materialized view 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_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 firstname.lastname@example.org
|Information Systems and Computing|
University of Pennsylvania