CN_ADDRESS Table

(gradadm.cn_address)

Explanation
The Address table stores the address information for applicants, as captured by the admitting office. Permanent Address is exported to the Student Records System (SRS) along with academic information when the student matriculates. 

Common Usage examples

• Get the permanent address information as-of the time of application.
• Find all applicants whose permanent address is in a specific state or zipcode area, or country, etc.
  
  

APPLICATION_KEY, RECORD_TYPE
     

APPLICATION_KEY, RECORD_TYPE

CN_ENROLLMENT, CN_APPLICATION, CN_APPLICATION_PERSONAL

• Addresses in this table are as-of the time of application or time when choosing to enroll. Once a student has matriculated, address changes are done online in PennInTouch, which updates SRS, but address updates are not sent back from SRS to the Graduate Admissions data in the warehouse.
• Data validation on this table has been improved over time, but older records contain many errors. An automated interface to SRS was introduced in 2011 and this required enforcing some data validation and standards; address records prior to 2011 can be incomplete or incorrect.

Source

• Data are extracted nightly from CollegeNet and loaded for all newly submitted applications and all applications included in enrollment reports. Addresses are also populated via spreadsheets uploaded using the Admissions Supplement web application.

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