| Data element |
Definition |
| Appfee_Pay_Type Indexed - no
Format - Varchar2(400)
May be Null? Y | Payment method for application fee. |
| Appfee_Payment Indexed - no
Format - Number
May be Null? Y | Application fee payment amount. Value will be zero if no fee existed or if a waiver was accepted. |
| Appfee_Waiver_Code Indexed - no
Format - Varchar2(200)
May be Null? Y | Application fee waiver code, if payment amount= 0.
|
| Applicant_Id_In_Source Indexed - no
Format - Number
May be Null? Y | Applicant ID. This is not guaranteed to be unique witihn a given record source, since an applicant may apply for mutiple programs and/or terms.
For CollegeNet records, the Applicant_ID is the profile_id.
For AY records, the Applicant_ID is the same as the Application_ID. |
| Application_Id_In_Source Indexed - yes
Format - Number
May be Null? Y | Application ID. This may/may not be unique for a particular record source.
For records from CollegeNet record sources (CNS or CNW), the Application_ID is unique and also known as the xact_id.
For AY records, uniqueness is ensured by the combination of (application_id or applicant_id), record_source, program_id and application_term. |
| Application_Key Indexed - yes
Format - Number
May be Null? N | Unique identifier for Graduate Admissions application in the data warehouse. This is not the AY application ID or the ColllegeNet application ID. |
| Application_Term Indexed - no
Format - Varchar2(20)
May be Null? Y | Desired starting term. In SRS term format such as 2014C, 2015A, or 2015B. |
| Cn_Certificate_Code Indexed - no
Format - Varchar2(40)
May be Null? Y | The code associated with a certificate in the CN system.
For CN Shared system: NOCERT, PH, GIS, GHRC, etc
For CN Wharton system: not used |
| Cn_Certificate_Desc Indexed - no
Format - Varchar2(320)
May be Null? Y | The certificate description in the CN system.
For CN Shared system: 'Global human rights certificate"', 'time based interactive media', etc
For CN Wharton system: not used |
| Cn_Concentration_Code Indexed - no
Format - Varchar2(12)
May be Null? Y | The certificate code in the CN system.
For CN Shared system: 'CBG', 113
For CN Wharton system: not used |
| Cn_Concentration_Code2 Indexed - no
Format - Varchar2(12)
May be Null? Y | The certificate code in the CN system.
For CN Shared system: 'CBG', 113
For CN Wharton system: not used |
| Cn_Concentration_Code3 Indexed - no
Format - Varchar2(12)
May be Null? Y | The certificate code in the CN system.
For CN Shared system: 'CBG', 113
For CN Wharton system: not used |
| Cn_Concentration_Desc Indexed - no
Format - Varchar2(400)
May be Null? Y | The certificate description in the CN system.
For CN Shared system: 'Cancer Biology','Cell Developmental and Molecular Biology'
For CN Wharton system: not used |
| Cn_Concentration_Desc2 Indexed - no
Format - Varchar2(400)
May be Null? Y | The certificate description in the CN system.
For CN Shared system: 'Cancer Biology','Cell Developmental and Molecular Biology'
For CN Wharton system: not used |
| Cn_Concentration_Desc3 Indexed - no
Format - Varchar2(400)
May be Null? Y | The certificate description in the CN system.
For CN Shared system: 'Cancer Biology','Cell Developmental and Molecular Biology'
For CN Wharton system: not used |
| Cn_Organization Indexed - no
Format - Varchar2(40)
May be Null? Y | CN_Organization is the organization associated with the program in the CN system.
For CN Shared system: BGS, ED, EG, FA, GAS, NU, PLE, SW
For CN Wharton system: WH |
| Cross_Disciplinary_Yn Indexed - no
Format - Varchar2(4)
May be Null? Y | |
| Enrollment_Status Indexed - no
Format - Varchar2(400)
May be Null? Y | Enrollment status. Values may include 'PTP', 'Part-time Penn employee', 'FT', full-time, 'PT', part-time |
| Hha_Career_Office Indexed - no
Format - Varchar2(4)
May be Null? Y | How Heard About the program: Career Office |
| Hha_Current_Student Indexed - no
Format - Varchar2(4)
May be Null? Y | How Heard About the program: Current Student |
| Hha_Employer_Supvsr Indexed - no
Format - Varchar2(4)
May be Null? Y | How Heard About the program: Employer or Supervisor |
| Hha_Newspaper_Magzne Indexed - no
Format - Varchar2(4)
May be Null? Y | How Heard About the program: Newspaper or magazine |
| Hha_Oncampus_Event Indexed - no
Format - Varchar2(4)
May be Null? Y | How Heard About the program: On-campus event |
| Hha_Other_Event Indexed - no
Format - Varchar2(4)
May be Null? Y | How Heard About the program: Other event |
| Hha_Other_Event_Desc Indexed - no
Format - Varchar2(240)
May be Null? Y | How Heard About the program: Other event descrip |
| Hha_Other_Media Indexed - no
Format - Varchar2(4)
May be Null? Y | How Heard About the program: Other media |
| Hha_Other_Media_Desc Indexed - no
Format - Varchar2(240)
May be Null? Y | How Heard About the program: Other media descrip |
| Hha_Other_Online Indexed - no
Format - Varchar2(4)
May be Null? Y | How Heard About the program: Other Online source |
| Hha_Other_Online_Desc Indexed - no
Format - Varchar2(240)
May be Null? Y | How Heard About the program: Other Online source descrip |
| Hha_Other_Print Indexed - no
Format - Varchar2(4)
May be Null? Y | How Heard About the program: Other print media |
| Hha_Other_Print_Desc Indexed - no
Format - Varchar2(240)
May be Null? Y | How Heard About the program: Other print media descrip |
| Hha_Other_Wordofmouth Indexed - no
Format - Varchar2(4)
May be Null? Y | How Heard About the program: Other word-of-mouth |
| Hha_Other_Wordofmouth_Desc Indexed - no
Format - Varchar2(240)
May be Null? Y | How Heard About the program: Other word-of-mouth descrip |
| Hha_Penn_Alumni Indexed - no
Format - Varchar2(4)
May be Null? Y | How Heard About the program: Penn Alum |
| Hha_Penn_Web Indexed - no
Format - Varchar2(4)
May be Null? Y | How Heard About the program: Penn website |
| Hha_Poster_Billboard Indexed - no
Format - Varchar2(4)
May be Null? Y | How Heard About the program: Poster or Billboard |
| Hha_Prof_Advisor Indexed - no
Format - Varchar2(4)
May be Null? Y | How Heard About the program: Professor or Advisor |
| Hha_Radio Indexed - no
Format - Varchar2(4)
May be Null? Y | How Heard About the program: Radio |
| Hha_Recruitment_Fair Indexed - no
Format - Varchar2(4)
May be Null? Y | How Heard About the program: Recruitment fair |
| Hha_Recruitment_Fair_Desc Indexed - no
Format - Varchar2(240)
May be Null? Y | How Heard About the program: Recruitment fair descrip |
| Hha_Social_Media Indexed - no
Format - Varchar2(4)
May be Null? Y | How Heard About the program: Social media |
| Hha_Tv Indexed - no
Format - Varchar2(4)
May be Null? Y | How Heard About the program: Television |
| Hha_Usnews_Wrldrpt Indexed - no
Format - Varchar2(4)
May be Null? Y | How Heard About the program: US News World Report |
| Hha_Viewbook_Brochure Indexed - no
Format - Varchar2(4)
May be Null? Y | How Heard About the program: Viewbook or brochure |
| Hha_Web_Ad Indexed - no
Format - Varchar2(4)
May be Null? Y | How Heard About the program: Web Advertisement |
| Hha_Web_Ad_Desc Indexed - no
Format - Varchar2(240)
May be Null? Y | How Heard About the program: Web Advertisement descrip |
| Hha_Web_Search Indexed - no
Format - Varchar2(4)
May be Null? Y | How Heard About the program: Web Search |
| Last_Updated_Date Indexed - no
Format - Date
May be Null? Y | Date the record was last updated in the warehouse. |
| Program_Desc Indexed - no
Format - Varchar2(480)
May be Null? Y | Description of the program applied to. |
| Program_Id Indexed - no
Format - Number
May be Null? N | Unique identifier for Graduate Admissions Program in the data warehouse. The Program_ID must exist in the CN_Programs table. |
| Record_Source Indexed - yes
Format - Varchar2(80)
May be Null? Y | Record Source / system of origin for the application. AY=Apply Yourself, CNS= CollegeNet Shared, CNW=CollegeNet Wharton, or non-AY uploaded (DEN, LAW, MED) |
| Srs_Concentration Indexed - no
Format - Varchar2(12)
May be Null? Y | SRS Concentration |
| Srs_Degree Indexed - no
Format - Varchar2(12)
May be Null? Y | SRS Degree code |
| Srs_Division Indexed - no
Format - Varchar2(12)
May be Null? Y | SRS Division code |
| Srs_Major Indexed - no
Format - Varchar2(16)
May be Null? Y | SRS Major |
| Srs_School Indexed - no
Format - Varchar2(8)
May be Null? Y | SRS School code |
| Submitted_Date Indexed - no
Format - Date
May be Null? Y | Date the application was submitted to Penn. This date should be populated for all applications. |
| Uploaded_Sprdsheet_School Indexed - no
Format - Varchar2(12)
May be Null? Y | |
| Uploaded_Sprdsheet_System_Id Indexed - no
Format - Varchar2(400)
May be Null? Y | |
