CN_APPLICATION Table

(gradadm.cn_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

CN_APPLICATION_PERSONAL, CN_PROGRAMS, AY_DECISIONS, CN_RECOMMENDER,
CN_ACAD_HISTORY, CN_ACAD_HISTORY_HS
      

• This table is a point-in-time snapshot as of date it was submitted. Use CN_ENROLLMENT for most current data for an application.
• 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.

Source

• Data are extracted nightly from CollegeNet and loaded for all newly submitted applications. cn_application is not affected by CN enrollment reports. It is also populated via spreadsheets uploaded using the Admissions Supplement web application.

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