Penn Computing

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

Financial Aid Award Aggregate Summary materialized view

(dwngss_pf.fa_award_agg_summary_mv)

Explanation

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.

Source

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.

Common Uses

  • Having one record per financial aid applicant to see overall numbers and totals for awards within a given aid year.

 

Primary Key Indexed Data Elements Related Tables

AIDY_CODE
PIDM
TR_REQ_CODE

FA_AWARD_AIDY
FA_AWARD_PERIOD
FA_AWARD_AGG_DETAIL_MV

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 within this database.
FA_AWARD_AGG_SUMMARY column definitions . Pennant Financial Aid Home . Data Warehouse Home


Questions about this page? Email us at da-staff@isc.upenn.edu

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