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

GA_APPLICATION Table

(gradadm.ga_application)

Explanation
The Application table contains program information and decision data related to an application to a graduate program. An applicant can have one or more applications to one or more programs in or more more academic terms. 

Common Usage examples

• Count applicants, admits, and accepts in a specified program or programs
  
  

APPLICANT_ID,RECORD_SOURCE,
PROGRAM_SOURCE, APPLICATION_TERM
     
      

APPLICANT_ID,RECORD_SOURCE,
PROGRAM_SOURCE, APPLICATION_TERM,
ADMIT_DECISION, ACCEPT_DECISION,
MATRICULATION_COHORT, MATRICULATION_TERM

GA_APPLICANT, GA_PROGRAM, AY_DECISIONS, GA_RECOMMMENDERS,
GA_SCHOOLS
      

• An individual person can have more than one Applicant_ID.
• Because every change to an application is captured in the APPLICATION table, an individual application can have more than one row in this table. Use the Is_Current column to identify the most recent row.
• Beginning in 2011, the Applicant_ID and Record_Source have been exported to SRS along with the academic program information, so that an applicant's information in the Graduate Admissions data can be tied to other student data collections in the Data Warehouse.
• Penn_ID is only populated for admitted students, and historical data collected prior to 2010 may not have Penn_ID. Do not try to join Gradaute Admissions data to other warehouse data using Penn_ID.
• SSN is usually only populated for admitted students, and historical data collected prior to 2011 may not have SSN.
• In the Business Objects Graduate Admissions Reporting universe, the Applicant class points to the ga_people_v view, which uses all of the columns in the ga_applicants tables, plus the program_key so the applicant can be tied to their corresponding academic programs in the ga_program table.

Source

• Data are extracted nightly from Apply Yourself and loaded to the school staging tables, and from there a process moves all application data to the ga_applications 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_APPLICATION Table - Data Element Index   Tables and Data Elements   GraduateAdmissions Home   Data Warehouse Home