GA_SCHOOLS Table - Data Element Index   Tables and Data Elements   Graduate Admissions Home   Data Warehouse Home

GA_SCHOOLS Table

(gradadm.ga_schools)

Explanation
The Schools table contains the Academic History, including the institutions, degrees, and dates of attendance, as provided by applicants.

Common Usage examples

• Examine the number of applicants who previously attended a particular school.
  
  

APPLICANT_ID,RECORD_SOURCE,
REC_NUMBER
     
      

NAME, INSTITUTION_CODE, CITY

GA_APPLICANT, GA_APPLICATION

• Historically, institution data was collected as freeform unvalidated text. Finding a particular institution involves searching for matching text strings in the institution name.

Source

• Data are extracted nightly from Apply Yourself and loaded to the school staging tables, and from there a process moves Academic History information to the ga_schools table. For schools who do not use Apply Yourself, datasets are batch uploaded to the warehouse at the school's discretion using the Admission Supplement web application

GA_SCHOOLS Table - Data Element Index   Tables and Data Elements   GraduateAdmissions Home   Data Warehouse Home