Penn Computing

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

COST_ATTENDANCE Table

(dwsfa.fa_cost_attendance)

Explanation
Contains the amounts for each budget category per student per academic year, which can be summarized up to determine total cost of attendance for a student or group of students.

Common Usage examples

  • Calculate the total anticipated cost of attendance for a specified student.

Primary Key Indexed Data Elements Related Tables
SID, AID_YEAR, BUDGET_TYPE
     
 
FA_APPLICATION
FA_BUDGET

Cautions
  • Although SID is the record key, it is a protected field, and cannot be seen or used in Data Warehouse reports. Tables in the Business Objects universe are joined on Penn_ID.
  • The lookup for BUDGET_TYPE from the FA_COST_ATTENDANCE table to the BUDGET table uses the column in the BUDGET table called BUDGET_TYPE.

Source

  • Data are extracted nightly from the Student Aid Management system (SAM) on the administrative mainframe.
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