Penn Computing

University of Pennsylvania
Penn Computing << go backback
FA_CUMULATIVE_AID_CAREER Table - Data Element Index   Tables and Data Elements   FinAid Home   Data Warehouse Home

CUMULATIVE_AID_CAREER Table

(dwsfa.fa_cumulative_aid_career)

Explanation
Contains one row per individual student, and the total cumulative amounts, if any, that the student received from each aid source. The table is denormalized, with separate columns for each type of aid source.

Common Usage examples

  • Calculate how much has been distributed to Penn students, in total, for a particular cateogy of aid (e.g., Perkins Loans, State grants, etc.)
  • Calculate the total amount a student has received from all aid sources, for all years.

Primary Key Indexed Data Elements Related Tables
SID
 
FA_BIO

Cautions
  • SID is the social security number, and is a protected column. Warehouse reporting uses PennID and not SID.

Source

  • Data are extracted nightly from the Student Aid Management system (SAM) on the administrative mainframe.
FA_CUMULATIVE_AID_CAREER Table - Data Element Index   Tables and Data Elements   FinAId 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