Penn Computing

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

FED_SCHOOL_LIST Table

(dwsfa.fa_fed_school_list)

Explanation
Lists colleges and universities with their federal id code, and the institution address.

Common Usage examples



Primary Key Indexed Data Elements Related Tables
SCHOOL_CODE
 
 

Cautions
  • The SCHOOL_CODE in this table uses the institution numbering system that ETS uses, but it also contains alphanumeric codes for some institutions, so this column is not stored in a number format. The SCHOOL_CODE cannot be used to join to tables outside of the financial aid data collection.

Source

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