CN_ENROLLMENT Table

(gradadm.cn_enrollment)

Explanation
The CN_Enrollment table is the central table in this data collection. It contains the most-recent application, applicant, and decision data for all submitted or spreadsheet-uploaded applications to a graduate program for a specific academic term.

An applicant may submit an application for multiple programs in the same academic terms, or across many terms; each instance of these will be a separate record in this table. For example, if he/she may applies for 2 PhD programs in 2015C and 2 PhD programs in 2016C, he/she will have 4 records in CN_Enrollment. 

Common Usage examples

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

APPLICATION_KEY 
     
      

RECORD_SOURCE,
CN_PROGRAM_ID, APPLICATION_TERM

All other tables with names starting with "CN_".
CN_PROGRAMS,  CN_RECOMMENDER,
CN_ACAD_HISTORY, CN_ACAD_HISTORY_HS
      

• Application_Key identifies a unique Application. Application_Key only exists in the data warehouse collection, it is a system-generated sequence number.
• There are 2 other methods for determining unique Applications:
  • 1) (For CollegeNet applications) RECORD_SOURCE plus APPLICATION_ID_IN_SOURCE, when the Record-Source is "CNS" or "CNW".
  • 2) (For ADIT uploaded applications) UPLOADED_SPRDSHEET_SCHOOL plus UPLOADED_SPRDSHEET_SYSTEM_ID.
• Penn_ID in CN_Enrollment was only ever populated for admitted students, and pre-2010 data may not have Penn_ID at all. Do not try to join Gradaute Admissions data to other warehouse data using Penn_ID from CN_Enrollment. It is best to not use it at all.
• SSN should not be used unless absolutely necessary. Historically it was only populated for admitted students, and may not exist in pre-2011 data.

Source

• Data are extracted nightly from CollegeNet and loaded for all newly submitted applications and all applications included in enrollment reports.
• Records are also populated via spreadsheets uploaded using the Admissions Data Import Tool (ADIT).

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