| Data element |
Definition |
| Applicant_ID |
Applicant_Id is a numeric key assigned to every application.
To ensure uniqueness, the Record Source, Rec Number,Test Type and Rec Type fields were added.
|
| DAT_Nat_Sci |
Dental Admissions Test (DAT) Natural Science test score; not currently being loaded to the warehouse |
| DAT_Perceptual_Ability |
Dental Admissions Test (DAT) Perceptual Ability test score; not currently being loaded to the warehouse. |
| DAT_Quant_Reason |
Dental Admissions Test (DAT) Quantitative Reasoning test score; not currently being loaded to the warehouse. |
| DAT_Reading_Comp |
Dental Admissions Test (DAT) Reading Comprehension test score; not currently being loaded to the warehouse. |
| GMAT_Quant |
The Graduate Management Admissions Test (GMAT) Quantitative test score. Format is NUMBER(3) |
| GMAT_Quant_Perc |
The Graduate Management Admissions Test (GMAT) Quantitative Percentile, if available. Format is NUMBER(3) |
| GMAT_Total |
The Graduate Management Admissions Test (GMAT) Total test score. Format is NUMBER(3) |
| GMAT_Total_Perc |
The Graduate Management Admissions Test (GMAT) Total Percentile, if available. Format is NUMBER(3) |
| GMAT_Verbal |
The Graduate Management Admissions Test (GMAT) Verbal test score. Format is NUMBER(3) |
| GMAT_Verbal_Perc |
The Graduate Management Admissions Test (GMAT) Verbal Percentile, if available. Format is NUMBER(3) |
| GMAT_Writing |
The Graduate Management Admissions Test (GMAT) Writing test score. Format is NUMBER(3,2) |
| GMAT_Writing_Perc |
The Graduate Management Admissions Test (GMAT) Writing Percentile, if available. Format is NUMBER(3) |
| LSAT_Score |
Law School Admissions Test (LSAT) score. Format is NUMBER(3) |
| MCAT_Biol_Sci |
Medical College Admission Test (MCAT) Biological Sciences test score. Format is NUMBER(3) |
| MCAT_Biol_Sci_Perc |
MCAT Biological Sciences Percentile, if available |
| MCAT_Phys_Sci |
Medical College Admission Test (MCAT) Physical Sciences test score. Format is NUMBER(3) |
| MCAT_Phys_Sci_Perc |
MCAT Physical Sciences Percentile, if available |
| MCAT_Verbal_Reasoning |
Medical College Admission Test (MCAT) Biological Sciences test score. Format is NUMBER(3) |
| MCAT_Verbal_Perc |
MCAT Verbal Reasoning Percentile, if available |
| MCAT_Writing |
Medical College Admission Test (MCAT) Writing test score. Format is a one-byte Character, in a range of J through T. |
| MCAT_Writing_Perc |
MCAT Writing Percentile, if available |
| Rec_Number |
Record Number counts the number of unique tests within a distinct test type and record type. It is not used for ranking or precedence. |
| Rec_Type |
Record Type is the category of the scores:
Reported= Self reported scores
Official = Scores downloaded from Educational Testing Services or entered by the Admissions Officer |
| Record_Source |
The code for the admission system that is the source of this record.
Values:
AY - Apply Yourself
ASP - Annenberg PhD admissions
BMP - Biomedical PhD program admissions (historical data only - BMP programs now use AY)
CGS - Liberal and Professional Studies (historical data only - CGS programs now use AY)
DEN - School of Dental Medicine
EDC - Gradudate Education certificate programs (historical data only - EDC programs now use AY)
ENG - Graduate School of Engineering (historical data only - ENG programs now use AY)
GAS - Graduate Arts and Sciences (historical data only - GAS programs now use AY)
GSE - Graduate School of Eduction masters and PhD programs (historical data only - GSE now uses AY)
LAW - Law School JD programs
LLM - Law School Master of Laws
LWT - Law School transfer applicants
MDM - School of Medicine
MED - School of Medicine MD programs
NU - School of Nursing (historical data only - Nursing now uses AY)
SPP - School of Social and Public Policy (historical data only - SPP now uses AY)
VM - School of Veterinary Medicine
WH - Wharton School MBA and PHD programs (historical data only - WH now uses AY) |
| Test_Date |
Test Date in Text format as provided by ETS or Applicant. |
| Test_Type |
Test Type distinguishes between various tests in the table. Values include LSAT, GMAT, MCAT, DAT |
