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

SCHOOL_CODE

• 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