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.
  
  

SID, AID_YEAR, BUDGET_TYPE
     

FA_APPLICATION
FA_BUDGET

• 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