Penn Computing

University of Pennsylvania
Penn Computing << go backback
CN_APPLICATION_PERSONAL Table - Data Element Index   Tables and Data Elements   Graduate Admissions Home   Data Warehouse Home

CN_APPLICATION_PERSONAL Table

(gradadm.cn_application_personal)

Explanation
The Applicants table contains biographic/demographic information on people who apply to graduate admissions programs. A person is considered an applicant once their application is submitted. An applicant can have one or more applications to one or more programs in or more more academic terms. 

Common Usage examples

  • Get the name of applicants to include in a report.
  • Find international applicants (whose country of citizenship is not US and whose visa type is not PR).
  • Sort applicants by specific demographics (by ethnicity, by sex, etc.)

Primary Key Indexed Data Elements Related Tables
APPLICANT_ID,RECORD_SOURCE
     
APPLICANT_ID,RECORD_SOURCE,
PENN_ID,FIRST_NAME,LAST_NAME,BIRTH_DATE
CN_APPLICATION, CN_PROGRAMS, CN_ADDRESS

Cautions
  • This table is a point-in-time snapshot as of date it was submitted. Use CN_ENROLLMENT for most current data for an application.
  • Applicant_ID cannot alone uniquely identify a person; the record consists of BOTH Applicant_ID and Record_Source. 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 cn_people_v view, which uses all of the columns in the cn_application_personal tables, plus the program_key so the applicant can be tied to their corresponding academic programs in the cn_program table.
  • Data in the Applicant table are considered point-in-time, as-of the time of application. Data for matriculated students is maintained in SRS. Thus some data points, for example Visa, can be different in the admissions data collection from the regular student data collection.

Source

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

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


Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania