Penn Computing

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

APPLICATION Table

(dwsfa.fa_application)

Explanation
The student's application for financial aid containing the base information for the application, including the students' admission status, application status, application term, financial information and parent information.

Common Usage examples

  • List incoming students for whom we have not yet received FAFSA information.
  • Count students in a specific aid term by application status.

Primary Key Indexed Data Elements Related Tables
SID, SAM_TERM
 
FA_BIO, FA_COST_ATTENDANCE

Cautions
  • Some students may have a PennID that begins with zero. Such numbers are temporary place-holders, and are not real PennIDs from PennCommunity. They should not be extracted or used outside of the Data Warehouse. Generally these appear when there is a timing issue, and the real PennID will appear in the warehouse in a subsequent load.
  • 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_APPLICATION 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