| Target Column |
Business Name |
Business Definition |
Database Data Type |
Domain Value |
Source Name |
Source Column |
|
ACAD_PROGRAM_1
|
ACAD_PROGRAM_1
|
Most recent academic program of student applicant.
|
VARCHAR2(50)
|
|
|
|
|
ACAD_PROGRAM_1_DESC
|
ACAD_PROGRAM_1_DESC
|
Academic program 1 description.
|
VARCHAR2(100)
|
|
|
|
|
ACAD_PROGRAM_2
|
ACAD_PROGRAM_2
|
Currently not used. Students only allowed to apply to one college and major.
|
VARCHAR2(50)
|
|
|
|
|
ACAD_PROGRAM_2_DESC
|
ACAD_PROGRAM_2_DESC
|
Academic program 2 description.
|
VARCHAR2(100)
|
|
|
|
|
ACCEPTANCE_COUNT_DESC
|
ACCEPTANCE_COUNT_DESC
|
Description for codes identifying whether an applicant was admitted
|
VARCHAR2(50)
|
|
|
|
|
ACPTCNT
|
ACPTCNT
|
Indicates whether an applicant was admitted.
Values: 1,0
|
NUMBER(1)
|
|
|
|
|
ACPTDATE
|
ACPTDATE
|
This field identifies the date on which a student was admitted
|
DATE
|
|
|
|
|
ACTACPCT
|
ACTACPCT
|
Indicates whether an applicant is an active admit (did not withdraw application)Values: 1, 0
|
NUMBER(1)
|
|
|
|
|
ACTCS
|
ACTCS
|
Highest composite score of the ACT exam
|
VARCHAR2(50)
|
|
|
|
|
ACTIVE_ACCEPTANCE_COUNT_DESC
|
ACTIVE_ACCEPTANCE_COUNT_DESC
|
Description for codes identifying whether an applicant is an active admit.
|
VARCHAR2(50)
|
|
|
|
|
ACTIVE_MARTICULANT_COUNT_DESC
|
ACTIVE_MARTICULANT_COUNT_DESC
|
Description for codes identifying whether an applicant submitted a tuition or housing deposit that is still active.
|
VARCHAR2(50)
|
|
|
|
|
ACT_ENGLISH
|
ACT_ENGLISH
|
Highest score from the English section of the ACT test
|
VARCHAR2(50)
|
|
|
|
|
ACT_MATH
|
ACT_MATH
|
Highest score from the Math section of the ACT test
|
VARCHAR2(50)
|
|
|
|
|
ACT_READING
|
ACT_READING
|
Highest score from the Reading section of the ACT test
|
VARCHAR2(50)
|
|
|
|
|
ACT_SCIENCE
|
ACT_SCIENCE
|
Highest score from the Science section of the ACT test
|
VARCHAR2(50)
|
|
|
|
|
ADDRESS_TYPE_CODE
|
ADDRESS_TYPE_CODE
|
Address type (permanent or mailing)Values: P, M
|
VARCHAR2(50)
|
|
|
|
|
ADMDECCT
|
|
Currently Under Review
|
NUMBER(1)
|
|
|
|
|
ADMIT_DECLINE_COUNT_DESC
|
|
Currently Under Review
|
VARCHAR2(50)
|
|
|
|
|
ADVGRDYR
|
ADVGRDYR
|
Advanced Standing NU Graduation Year
|
VARCHAR2(50)
|
|
|
|
|
ADVHRS
|
ADVHRS
|
NU Qtr Hrs of Advanced Standing Credit
|
VARCHAR2(50)
|
|
|
|
|
ADVQPA
|
ADVQPA
|
Advanced Standing QPA (Rounded)
|
VARCHAR2(50)
|
|
|
|
|
ADVTOTHRS
|
ADVTOTHRS
|
Sum of AP Hours and Advanced Standing Credit
|
NUMBER(11,3)
|
|
|
|
|
APHRS
|
APHRS
|
Advanced Placement Credit Hours
|
VARCHAR2(50)
|
|
|
|
|
APPCNT
|
APPCNT
|
Indicates whether an applicant applied for admission. Values: 1, 0
|
NUMBER(1)
|
|
|
|
|
APPDATE
|
APPDATE
|
This field identifies the date associated with the most current status of the application.
|
DATE
|
|
|
|
|
APPDEC
|
|
Applicant decision code.
|
VARCHAR2(50)
|
|
|
|
|
APPDEC_DESC
|
|
Description for application decision code.
|
VARCHAR2(100)
|
|
|
|
|
APPDROP
|
Student whose application is no longer active due to application withdrawal, drop, or no response to admission
|
|
|
|
|
|
|
APPFNAID
|
APPFNAID
|
Yes/No Indicator on whether the student is applying for financial aid
|
VARCHAR2(50)
|
|
|
|
|
APPLICANT_CATEGORY_DESC
|
APPLICANT_CATEGORY_DESC
|
Description of applicant's entry into the admissions system, including pipeline programs.
|
VARCHAR2(300)
|
|
|
|
|
APPLICATION_NUMBER
|
|
Common App assigned application number.
|
VARCHAR2(50)
|
|
|
|
|
APPLICATION_STATUS_DESC
|
|
Description of student's application status.
|
VARCHAR2(100)
|
|
|
|
|
APPLICATION_TYPE_DESC
|
APPLICATION_TYPE_DESC
|
Description of the type of student the applicant will become if admitted, (new or transfer).
|
VARCHAR2(100)
|
|
|
|
|
APPSTAT
|
|
Status of application for admissions review.
|
VARCHAR2(50)
|
|
|
|
|
APTSTIND
|
APTSTIND
|
An indicator which defines if advanced placement test was taken.
|
VARCHAR2(50)
|
|
|
|
|
AREACD
|
AREACD
|
Area code of the phone number associated with permanent address of applicant.
|
VARCHAR2(50)
|
|
|
|
|
ATHLETE
|
ATHLETE
|
Indicates whether a student is a recruited athlete. Values: 1, 0
|
VARCHAR2(50)
|
|
|
|
|
ATHLETE_DESC
|
ATHLETE_DESC
|
Description for codes identifying whether a student is a recruited athlete. Values: Recruited, Not a Recruited Athlete
|
VARCHAR2(100)
|
|
|
|
|
BCOUNTRY
|
BCOUNTRY
|
This field identifies the applicant's birth country
|
VARCHAR2(50)
|
|
|
|
|
BOSRES
|
BOSRES
|
This field identifies residents of Boston
|
VARCHAR2(100)
|
|
|
|
|
CANDIDATE1
|
CANDIDATE1
|
Candidate for Special Program/Scholarship
|
VARCHAR2(10)
|
|
|
|
|
CANDIDATE1_DESC
|
CANDIDATE1_DESC
|
Description of Candidate for Special Program/Scholarship code
|
VARCHAR2(100)
|
|
|
|
|
CANDIDATE2
|
CANDIDATE2
|
Candidate for Special Program/Scholarship
|
VARCHAR2(10)
|
|
|
|
|
CANDIDATE2_DESC
|
CANDIDATE2_DESC
|
Description of Candidate 2
|
VARCHAR2(100)
|
|
|
|
|
CANDIDATE3
|
CANDIDATE3
|
Candidate for Special Program/Scholarship
|
VARCHAR2(10)
|
|
|
|
|
CANDIDATE3_DESC
|
CANDIDATE3_DESC
|
Description of Candidate 3
|
VARCHAR2(100)
|
|
|
|
|
CANDIDATE4
|
CANDIDATE4
|
Candidate for Special Program/Scholarship
|
VARCHAR2(10)
|
|
|
|
|
CANDIDATE4_DESC
|
CANDIDATE4_DESC
|
Description of Candidate 4
|
VARCHAR2(50)
|
|
|
|
|
CANDIDATE5
|
CANDIDATE5
|
Candidate for Special Program/Scholarship
|
VARCHAR2(10)
|
|
|
|
|
CANDIDATE5_DESC
|
CANDIDATE5_DESC
|
Description of Candidate 5
|
VARCHAR2(100)
|
|
|
|
|
CANDIDATE6
|
CANDIDATE6
|
Candidate for Special Program/Scholarship
|
VARCHAR2(10)
|
|
|
|
|
CANDIDATE6_DESC
|
CANDIDATE6_DESC
|
Description of Candidate 6
|
VARCHAR2(100)
|
|
|
|
|
CANDIDATE7
|
CANDIDATE7
|
Candidate for Special Program/Scholarship
|
VARCHAR2(10)
|
|
|
|
|
CANDIDATE7_DESC
|
CANDIDATE7_DESC
|
Description of Candidate for 7
|
VARCHAR2(100)
|
|
|
|
|
CANDIDATE8
|
CANDIDATE8
|
Candidate for Special Program/Scholarship
|
VARCHAR2(10)
|
|
|
|
|
CANDIDATE8_DESC
|
CANDIDATE8_DESC
|
Description of Candidate 8
|
VARCHAR2(50)
|
|
|
|
|
CATEGORY
|
CATEGORY
|
Code indicating applicant's entry into the admissions system, including pipeline programs.
|
VARCHAR2(50)
|
|
|
|
|
CD1
|
CD1
|
The prior college code of the applicant
|
VARCHAR2(30)
|
|
|
|
|
CIT
|
CIT
|
Prior to Global Campus System updates: Citizenship Type Values: Y: US Citizen, P: Legal Permanent Resident of US, N: Non-United States Citizen
After 2022 Freeze and Global Campus System updates: Indicates whether the person is a citizen or permanent resident of their home campus country.
|
VARCHAR2(50)
|
|
|
|
|
CITCNT
|
CITCNT
|
Prior to Global Campus System updates: Nation/country of applicant's citizenship.
After 2022 Freeze and Global Campus System updates:: Country code of the nation where the person maintains citizenship. Note: In the case of dual citizens, it is the citizenship under which they applied to the university.
|
VARCHAR2(50)
|
|
|
|
|
CITIZENSHIP_STATUS_DESC
|
CITIZENSHIP_STATUS_DESC
|
Description of Citizenship Status
|
VARCHAR2(100)
|
|
|
|
|
CITY
|
CITY
|
This field maintains the municipality associated with the address of person.
|
VARCHAR2(100)
|
|
|
|
|
CLGAPP1
|
|
College applied to as well as the original College a student was admitted to.
|
|
|
|
|
|
COLLEGE_APPLIED_1_DESC
|
|
Description for CLGAPP1
|
|
|
|
|
|
COMB
|
COMB
|
Highest composite score of the SAT exam (Math and Critical Reading only)
|
VARCHAR2(50)
|
|
|
|
|
CONCENTRATION
|
|
Concentration to which the applicant applied
|
|
|
|
|
|
CONCENTRATION_DESC
|
|
Description for CONCENTRATION
|
|
|
|
|
|
COUNRY_CITIZENSHIP_DESC
|
COUNTRY_CITIZENSHIP_DESC
|
Description of the nation/country of applicant's citizenship
|
VARCHAR2(100)
|
|
|
|
|
COUNTRY
|
COUNTRY
|
This field maintains the nation/country associated with the address of person.
|
VARCHAR2(50)
|
|
|
|
|
COUNTRY_DESC
|
COUNTRY_DESC
|
Name of the country associated with the address of applicant.
|
VARCHAR2(100)
|
|
|
|
|
CURRENT_COLLEGE_DESC
|
CURRENT_COLLEGE_DESC
|
Description of applicant's college.
|
VARCHAR2(200)
|
|
|
|
|
CURRENT_MAJOR_DESC
|
CURRENT_MAJOR_DESC
|
Applicant's current major name/description
|
VARCHAR2(200)
|
|
|
|
|
CYEAR
|
|
Currently Under Review
|
VARCHAR2(4)
|
|
|
|
|
DECISION
|
|
Applicant's admit decision
|
VARCHAR2(50)
|
|
|
|
|
DECISION_DESC
|
|
Description of applicant's admit decision.
|
VARCHAR2(100)
|
|
|
|
|
DEPCNT
|
DEPCNT
|
Indicates whether an applicant submitted a tuition or housing deposit. Values: 1, 0
|
NUMBER(1)
|
|
|
|
|
DEPDUEDATE
|
|
Deposit due date.
|
DATE
|
|
|
|
|
DEPOSIT_COUNT_DESC
|
DEPOSIT_COUNT_DESC
|
Description for codes identifying whether an applicant submitted a tuition or housing deposit.
|
VARCHAR2(50)
|
|
|
|
|
DORM
|
DORM
|
Indicates whether an applicant applied for housing. Values: Y, N
|
VARCHAR2(50)
|
|
|
|
|
DROPDATE
|
|
Date that an application became inactive
|
|
|
|
|
|
EAADMIT
|
EAADMIT
|
Indicates whether an applicant was admitted through Early Admission. Values: 1, 0
|
VARCHAR2(1)
|
|
|
|
|
EARLY_ADDMIT_CODE_DESC
|
EARLY_ADMIT_CODE_DESC
|
Description of early admission admit code.
|
VARCHAR2(50)
|
|
|
|
|
EDADMIT
|
|
Student admitted at ED1 or ED2 release
|
|
|
|
|
|
ESSAY
|
ESSAY
|
Highest score from the Writing section of the SAT
|
VARCHAR2(50)
|
|
|
|
|
ETHNIC
|
ETHNIC
|
Note: No longer populated beginning with the Fall 2024 academic terms.
Individual self-identified as Hispanic or Latino.
|
VARCHAR2(50)
|
|
|
|
|
ETHNICITY_DESC
|
ETHNICITY_DESC
|
Note: No longer populated beginning with the Fall 2024 academic terms.
Description of applicant's primary ethnicity
|
VARCHAR2(300)
|
|
|
|
|
EXP_MATRIC_TERM
|
|
Expected Academic Term of matriculation - last used in 2016
|
|
|
|
|
|
EXP_MATRIC_YR
|
|
Expected Academic Year of matriculation - last used in 2016
|
|
|
|
|
|
FNAME
|
FNAME
|
The first name given to a person at birth, baptism, another naming ceremony or through legal change.
|
VARCHAR2(50)
|
|
|
|
|
FOREIGN_LANGUGE_COURSE_DESC
|
FOREIGN_LANGUGE_COURSE_DESC
|
Description of Foreign Language Course(EX: French, Spanish, Latin, etc.)
|
VARCHAR2(100)
|
|
|
|
|
FORNIND
|
FORNIND
|
International address indicator. Values: Y, N
|
VARCHAR2(50)
|
|
|
|
|
FREEZE_DATE
|
FREEZE_DATE
|
Date on which data were frozen
|
DATE
|
|
|
|
|
GENDER_DESC
|
GENDER_DESC
|
The gender of a person, e.g. Male, Female.
|
VARCHAR2(300)
|
|
|
|
|
HIGHMATH
|
HIGHMATH
|
Highest Math Class taken by applicant
|
VARCHAR2(50)
|
|
|
|
|
HIGHMATH_DESC
|
HIGHMATH_DESC
|
Description of Highest Math Class taken by applicant.
|
VARCHAR2(100)
|
|
|
|
|
HIGHSCIENCE
|
HIGHSCIENCE
|
Highest Science taken by applicant
|
VARCHAR2(50)
|
|
|
|
|
HIGHSCIENCE_DESC
|
HIGHSCIENCE_DESC
|
Description of Highest Science taken by applicant
|
VARCHAR2(100)
|
|
|
|
|
HOME_CAMPUS_CD
|
HOME CAMPUS CD
|
The approved campus location assigned to a student or employee upon application, enrollment or hiring
|
VARCHAR2(63)
|
|
|
|
|
HOME_CAMPUS_COUNTRY_CD
|
|
The nation of a student's Home Campus
|
|
|
|
|
|
HOME_CAMPUS_COUNTRY_DESC
|
HOME CAMPUS COUNTRY DESC
|
Description of HOME CAMPUS COUNTRY
|
VARCHAR2(255)
|
|
|
|
|
HOME_CAMPUS_DESC
|
HOME CAMPUS DESC
|
Description of HOME CAMPUS CD
|
VARCHAR2(255)
|
|
|
|
|
HONORMAT
|
|
Indicates an admitted student enrolling in the honors program. Values: 1, 0
|
VARCHAR2(2)
|
|
|
|
|
HONORS
|
HONORS
|
Indicates whether a student was admitted into the Honors program. Values: 1, 0
|
VARCHAR2(50)
|
|
|
|
|
HONOR_DESC
|
HONOR_DESC
|
Description for codes identifying whether a student was admitted into the Honors program
|
VARCHAR2(100)
|
|
|
|
|
HSADDRESS1
|
HSADDRESS1
|
Address line 1 of applicant's High School
|
VARCHAR2(300)
|
|
|
|
|
HSADDRESS2
|
HSADDRESS2
|
Address line 2 of applicant's High School
|
VARCHAR2(300)
|
|
|
|
|
HSCITY
|
HSCITY
|
City of applicant's High School
|
VARCHAR2(50)
|
|
|
|
|
HSCODE
|
HSCODE
|
This field identifies the high school code of the prospect/applicant.
|
VARCHAR2(50)
|
|
|
|
|
HSCOUNTRY
|
HSCOUNTRY
|
Country of the applicants High School
|
VARCHAR2(50)
|
|
|
|
|
HSGPA
|
HSGPA
|
Applicant's weighted High School GPA
|
VARCHAR2(50)
|
|
|
|
|
HSNAME
|
HSNAME
|
Name of applicant's High School
|
VARCHAR2(300)
|
|
|
|
|
HSRNKRNG
|
|
High school rank percentile of applicant
|
NUMBER(3)
|
|
|
|
|
HSSTATE
|
HSSTATE
|
State of applicant's High School
|
VARCHAR2(50)
|
|
|
|
|
HSZIP
|
HSZIP
|
Zip code of applicant's High School
|
VARCHAR2(50)
|
|
|
|
|
IB
|
IB
|
Highest score from the IB test (often replaces SAT for international students)
|
VARCHAR2(50)
|
|
|
|
|
IBTOEFL
|
IBTOEFL
|
Highest score from the Internet Based TOEFL test
|
VARCHAR2(50)
|
|
|
|
|
ID
|
ID
|
Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent.
|
VARCHAR2(50)
|
|
|
|
|
IELTS
|
IELTS
|
Highest score from the IELTS (English proficiency) test
|
VARCHAR2(50)
|
|
|
|
|
INTGRADUATE
|
INTGRADUATE
|
Indicator of applicant's interest in Graduate school as indicated on Common Application. Values: Y, N
|
VARCHAR2(10)
|
|
|
|
|
INTPRELAW
|
INTPRELAW
|
Indicator of applicant's interest in Pre-Law as indicated on Common Application. Values: Y, N
|
VARCHAR2(10)
|
|
|
|
|
INTPREMED
|
INTPREMED
|
Indicator of applicant's interest in Pre-Med as indicated on Common Application. Values: Y, N
|
VARCHAR2(10)
|
|
|
|
|
KAPLAN
|
KAPLAN
|
Highest score from the KAPLAN (English proficiency) test
|
VARCHAR2(50)
|
|
|
|
|
LANGUAGE
|
LANGUAGE
|
Foreign language taken in high school.
|
VARCHAR2(50)
|
|
|
|
|
LANGUAGEYRS
|
LANGUAGEYRS
|
Number of years of foreign language taken
|
VARCHAR2(2)
|
|
|
|
|
LINE2
|
LINE2
|
Second line of the address associated with applicant.
|
VARCHAR2(100)
|
|
|
|
|
LINE4
|
LINE4
|
Third line of the address associated with applicant.
|
VARCHAR2(100)
|
|
|
|
|
LNAME
|
LNAME
|
The last name by which a person is known.
|
VARCHAR2(60)
|
|
|
|
|
MAJAPP1
|
|
Major applied to as well as the original Major a student was admitted to.
|
|
|
|
|
|
MAJOR
|
MAJOR
|
Current major
|
VARCHAR2(50)
|
|
|
|
|
MAJOR_APPLIED_1_DESC
|
|
Description for MAPAPP1
|
|
|
|
|
|
MATH
|
MATH
|
Highest score from the Math section of the SAT
|
VARCHAR2(50)
|
|
|
|
|
MATRICNT
|
MATRICNT
|
Indicates whether an applicant submitted a tuition or housing deposit that is still active. Values: 1, 0
|
NUMBER(1)
|
|
|
|
|
MERIT
|
MERIT
|
Merit scholarship offered to student. Values: 0, 3, 5, 6
|
VARCHAR2(50)
|
|
|
|
|
MERIT_DESC
|
MERIT_DESC
|
Description for Merit scholarship codes offered to student. Values: None (0), National Merit (3), National Achievement (5), Trustee Scholars (6)
|
VARCHAR2(100)
|
|
|
|
|
MI
|
MI
|
This field identifies the middle initial of person.
|
VARCHAR2(50)
|
|
|
|
|
MICHIGAN
|
MICHIGAN
|
Highest score from the MICHIGAN (English proficiency) test
|
VARCHAR2(50)
|
|
|
|
|
NATION_BIRTH_DESC
|
NATION_BIRTH_DESC
|
This field maintains the nation/country associated with the address of person.
|
VARCHAR2(300)
|
|
|
|
|
NM1
|
NM1
|
The prior college name of the applicant
|
VARCHAR2(50)
|
|
|
|
|
NU_FIRSTGEN
|
|
Yes/No flag indicating if applicant is a first generation student.
|
VARCHAR2(10)
|
|
|
|
|
ORIATND
|
ORIATND
|
Indicate whether the students has attended an orientation session. Values: Y, N
|
VARCHAR2(50)
|
|
|
|
|
ORIENT_SESSION_ATTENDED_DESC
|
ORIENT_SESSION_ATTENDED_DESC
|
Description of orientation session applicant attended.
|
VARCHAR2(200)
|
|
|
|
|
ORISESS
|
ORISESS
|
Indicates which orientation session applicant attended
|
VARCHAR2(50)
|
|
|
|
|
PBTOEFL
|
PBTOEFL
|
Highest score from the Paper Based TOEFL test
|
VARCHAR2(50)
|
|
|
|
|
PGMINT
|
|
Intended Program of Study
|
|
|
|
|
|
PGMINT_DESC
|
|
Description for PGMINT
|
|
|
|
|
|
PHONE
|
PHONE
|
Indicates telephone number.
|
VARCHAR2(50)
|
|
|
|
|
POP1
|
POP1
|
The first admissions attribute for the applicant
|
VARCHAR2(10)
|
|
|
|
|
POP2
|
POP2
|
The second admissions attribute for the applicant
|
VARCHAR2(10)
|
|
|
|
|
POP3
|
POP3
|
The third admissions attribute for the applicant
|
VARCHAR2(10)
|
|
|
|
|
POP4
|
POP4
|
The fourth admissions attribute for the applicant
|
VARCHAR2(10)
|
|
|
|
|
POP5
|
POP5
|
The fifth admissions attribute for the applicant
|
VARCHAR2(10)
|
|
|
|
|
POP6
|
POP6
|
The sixth admissions attribute for the applicant
|
VARCHAR2(10)
|
|
|
|
|
POP7
|
POP7
|
The seventh admissions attribute for the applicant
|
VARCHAR2(10)
|
|
|
|
|
POP8
|
POP8
|
The eighth admissions attribute for the applicant
|
VARCHAR2(10)
|
|
|
|
|
POPULATION_DESC_1
|
POPULATION_DESC_1
|
Description of the first admissions attribute for the applicant
|
VARCHAR2(50)
|
|
|
|
|
POPULATION_DESC_2
|
POPULATION_DESC_2
|
Description of the second admissions attribute for the applicant
|
VARCHAR2(50)
|
|
|
|
|
POPULATION_DESC_3
|
POPULATION_DESC_3
|
Description of the third admissions attribute for the applicant
|
VARCHAR2(50)
|
|
|
|
|
POPULATION_DESC_4
|
POPULATION_DESC_4
|
Description of the fourth admissions attribute for the applicant
|
VARCHAR2(50)
|
|
|
|
|
POPULATION_DESC_5
|
POPULATION_DESC_5
|
Description of the fifth admissions attribute for the applicant
|
VARCHAR2(50)
|
|
|
|
|
POPULATION_DESC_6
|
POPULATION_DESC_6
|
Description of the sixth admissions attribute for the applicant
|
VARCHAR2(50)
|
|
|
|
|
POPULATION_DESC_7
|
POPULATION_DESC_7
|
Description of the seventh admissions attribute for the applicant
|
VARCHAR2(50)
|
|
|
|
|
POPULATION_DESC_8
|
POPULATION_DESC_8
|
Description of the eighth admissions attribute for the applicant
|
VARCHAR2(50)
|
|
|
|
|
PREFIX
|
PREFIX
|
An appellation used to connote rank, placement or status. A title that precedes person name.
|
VARCHAR2(50)
|
|
|
|
|
PROGRAM1
|
PROGRAM1
|
Special Program 1 (e.g. Living Learning)
|
VARCHAR2(50)
|
|
|
|
|
PROGRAM1_DESC
|
|
Currently Under Review
|
VARCHAR2(100)
|
|
|
|
|
PROGRAM2
|
|
Currently Under Review
|
VARCHAR2(50)
|
|
|
|
|
PROGRAM2_DESC
|
|
Currently Under Review
|
VARCHAR2(100)
|
|
|
|
|
PROGRAM3
|
|
Currently Under Review
|
VARCHAR2(50)
|
|
|
|
|
PROGRAM3_DESC
|
|
Currently Under Review
|
VARCHAR2(100)
|
|
|
|
|
QTR
|
QTR
|
Term of entry associated with the information on applicant record.
|
VARCHAR2(2)
|
|
|
|
|
RACE_AFAM
|
RACE_AFAM
|
Note: No longer populated beginning with the Fall 2024 academic terms.
Applicant's African-American race status. Values: Y, N.
|
VARCHAR2(1)
|
|
|
|
|
RACE_AMIND
|
RACE_AMIND
|
Note: No longer populated beginning with the Fall 2024 academic terms.
Applicant's American Indian race status
|
VARCHAR2(1)
|
|
|
|
|
RACE_API
|
RACE_API
|
Note: No longer populated beginning with the Fall 2024 academic terms.
Applicant's Asian/Pacific Islander race status. Values: Y, N
|
VARCHAR2(1)
|
|
|
|
|
RACE_HISP
|
RACE_HISP
|
Note: No longer populated beginning with the Fall 2024 academic terms.
Applicant's Hispanic ethnicity status. Values: Y, N
|
VARCHAR2(1)
|
|
|
|
|
RACE_NOTIND
|
RACE_NOTIND
|
Note: No longer populated beginning with the Fall 2024 academic terms.
Applicant's race/ethnicity not identified. Values: Y, N
|
VARCHAR2(1)
|
|
|
|
|
RACE_WHITE
|
RACE_WHITE
|
Note: No longer populated beginning with the Fall 2024 academic terms.
Applicant's White/Caucasian race status. Values: Y, N
|
VARCHAR2(1)
|
|
|
|
|
RANKCLSZ
|
RANKCLSZ
|
Size of the applicant's high school graduating class size.
|
VARCHAR2(50)
|
|
|
|
|
RANKINCL
|
RANKINCL
|
Applicant's high school class rank.
|
VARCHAR2(50)
|
|
|
|
|
RANKPCT
|
RANKPCT
|
Applicant's rank percentile in their high school class
|
NUMBER(5,2)
|
|
|
|
|
REGIONGOAL
|
|
Geographic region of applicant.Values:1 New England 2 Middle Atlantic 3 Southeast 4 Southwest 5 Midwest 6 West 7 U.S. Territories 8 Other Country 9 International Student
|
VARCHAR2(2)
|
|
|
|
|
REGION_DESC
|
|
Description of geographic region of applicant.
|
VARCHAR2(50)
|
|
|
|
|
RELSDATE
|
RELSDATE
|
Date on which applicant's admission decision was released
|
DATE
|
|
|
|
|
R_ADV_MATH
|
R_Adv_Math
|
Business Definition
Passport to Advanced Math, subscore of Math Section of the new SAT.
Scale:1-15
Note: This field only impacts terms beginning 201810 (Fall 2017); new fields only apply to students who have taken the new test.
|
VARCHAR2(50)
|
|
|
|
|
R_ALGEBRA
|
R_Algebra
|
Business Definition
Heart of Algebra, subscore of Math Section of the new SAT.
Scale:1-15
Note: This field only impacts terms beginning 201810 (Fall 2017); new fields only apply to students who have taken the new test.
|
VARCHAR2(50)
|
|
|
|
|
R_CONVENTIONS
|
R_Conventions
|
Business Definition
Standard English Conventions, subscore of Writing and Language Sections of the new SAT.
Scale:1-15
Note: This field only impacts terms beginning 201810 (Fall 2017); new fields only apply to students who have taken the new test.
|
VARCHAR2(50)
|
|
|
|
|
R_ERW
|
R_ERW
|
Business Definition
Highest score from the Evidence-Based Reading & Writing Section of the new SAT.
What had been the separate “Verbal” and “Essay” sections are now one section – “Evidence-Based Reading and Writing”. Highest score from the Evidence-Based Reading and Writing section of the new SAT.
Scale: 200-800
Note: This field only impacts terms beginning 201810 (Fall 2017); new fields only apply to students who have taken the new test.
|
VARCHAR2(50)
|
|
|
|
|
R_EVIDENCE
|
R_Evidence
|
Business Definition
Command of Evidence, subscore of Reading and Writing and Language Sections of the new SAT.
Scale:1-15
Note: This field only impacts terms beginning 201810 (Fall 2017); new fields only apply to students who have taken the new test.
|
VARCHAR2(50)
|
|
|
|
|
R_HISTORY_SS
|
R_History_SS
|
Business Definition
Analysis in History/Social Studies, Cross-test Score, of the new SAT.
Score is based on select questions in SAT Reading, Writing & Language, and Math Tests. These scores show how well students use their skills to analyze texts and solve problems in this subject area.
Scale:10-40
Note: This field only impacts terms beginning 201810 (Fall 2017); new fields only apply to students who have taken the new test.
|
VARCHAR2(50)
|
|
|
|
|
R_IDEAS
|
R_Ideas
|
Business Definition
Expression of Ideas, subscore of Writing and Language Sections of the new SAT.
Scale:1-15
Note: This field only impacts terms beginning 201810 (Fall 2017); new fields only apply to students who have taken the new test.
|
VARCHAR2(50)
|
|
|
|
|
R_MATH
|
R_Math
|
Business Definition
Highest score from the Math section of the new SAT.
Scale: 200-800
Note: This field only impacts terms beginning 201810 (Fall 2017); new fields only apply to students who have taken the new test.
|
VARCHAR2(50)
|
|
|
|
|
R_MATH_TEST
|
R_Math_Test
|
Business Definition
Test scores of the new SAT.
Scale:10-40
Note: This field only impacts terms beginning 201810 (Fall 2017); new fields only apply to students who have taken the new test.
|
VARCHAR2(50)
|
|
|
|
|
R_PROB_SOLVE_DATA_ANALYZE
|
|
Business Definition
Problem Solving and Data Analysis, subscore of Math Section of the new SAT.
Scale:1-15
Note: This field only impacts terms beginning 201810 (Fall 2017); new fields only apply to students who have taken the new test.
|
|
|
|
|
|
R_READING_TEST
|
R_Reading_Test
|
Business Definition
Test scores of the new SAT.
Scale:10-40
Note: This field only impacts terms beginning 201810 (Fall 2017); new fields only apply to students who have taken the new test.
|
VARCHAR2(50)
|
|
|
|
|
R_SATCOMP
|
R_SATCOMP
|
Business Definition
Highest composite test score of Old SAT, New SAT, or ACT.
|
VARCHAR2(50)
|
|
|
|
|
R_SCIENCE
|
R_Science
|
Business Definition
Analysis in Science, Cross-test Score, of the new SAT.
Score is based on select questions in SAT Reading, Writing & Language, and Math Tests. These scores show how well students use their skills to analyze texts and solve problems in this subject area.
Scale:10-40
Note: This field only impacts terms beginning 201810 (Fall 2017); new fields only apply to students who have taken the new test.
|
VARCHAR2(50)
|
|
|
|
|
R_TOTAL_SCORE
|
R_Total_Score
|
Business Definition
Highest total score from the new SAT.
Business Logic
R_Total_Score = R_ERW + R_Math
Scale: 400-1600
Note: This field only impacts terms beginning 201810 (Fall 2017); new fields only apply to students who have taken the new test. Tri-Score is eliminated going forward.
|
VARCHAR2(50)
|
|
|
|
|
R_WORDS_IN_CONTEXT
|
R_Words_in_Context
|
Business Definition
Words in Context, subscore of Reading and Writing and Language Sections of the new SAT.
Scale:1-15
Note: This field only impacts terms beginning 201810 (Fall 2017); new fields only apply to students who have taken the new test.
|
VARCHAR2(50)
|
|
|
|
|
R_WRITING_LANGUAGE_TEST
|
R_Writing_Language_Test
|
Business Definition
Test scores of the new SAT.
Scale:10-40
Note: This field only impacts terms beginning 201810 (Fall 2017); new fields only apply to students who have taken the new test.
|
VARCHAR2(50)
|
|
|
|
|
SATCOMP
|
SATCOMP
|
Highest composite score of the SAT exam (Math and Critical Reading only). For students who submit an ACT score, the score is converted to an SAT score, and the highest score is reported.
|
VARCHAR2(50)
|
|
|
|
|
SCHOLAR1
|
SCHOLAR1
|
Scholarship received 1
|
VARCHAR2(10)
|
|
|
|
|
SCHOLAR1_DESC
|
SCHOLAR1_DESC
|
Scholarship received 1 description
|
VARCHAR2(100)
|
|
|
|
|
SCHOLAR2
|
SCHOLAR2
|
Scholarship received 2
|
VARCHAR2(10)
|
|
|
|
|
SCHOLAR2_DESC
|
SCHOLAR2_DESC
|
Scholarship received 2 description
|
VARCHAR2(100)
|
|
|
|
|
SCHOLAR3
|
SCHOLAR3
|
Scholarship received 3
|
VARCHAR2(10)
|
|
|
|
|
SCHOLAR3_DESC
|
SCHOLAR3_DESC
|
Scholarship received 3 description
|
VARCHAR2(100)
|
|
|
|
|
SECMATH
|
SECMATH
|
Second highest math taken by applicant
|
VARCHAR2(50)
|
|
|
|
|
SECMATH_DESC
|
SECMATH_DESC
|
Description of Second Highest Math taken by applicant
|
VARCHAR2(100)
|
|
|
|
|
SECOND_NATION_CITIZENSHIP
|
|
A country code for the nationality that a dual citizen maintains, but was not indicated as the primary nation of citizenship in relation to the individual's Home Campus. Added after 202210 Freeze as part of Global Campus System updates.
|
|
|
|
|
|
SECOND_NATION_CITIZENSHIP_DESC
|
SECOND NATION CITIZENSHIP DESC
|
Description of SECOND NATION CITIZENSHIP
|
VARCHAR2(255)
|
|
|
|
|
SECSCIENCE
|
SECSCIENCE
|
Second Highest Science taken by applicant
|
VARCHAR2(50)
|
|
|
|
|
SECSCIENCE_DESC
|
SECSCIENCE_DESC
|
Description of Second Highest Science taken by applicant
|
VARCHAR2(100)
|
|
|
|
|
SEX
|
SEX
|
Gender of applicant. Values: M - Male, F - Female, N - Unknown.
|
F - FEMALE
|
|
|
|
|
SOC
|
SOC
|
Identifies whether a student is a student of color (excludes international students and student with an unidentified race/ethnicity)Values: 1, 0
|
NUMBER(1)
|
|
|
|
|
SPORTCD1
|
|
Sport code of recruited athlete
|
VARCHAR2(10)
|
|
|
|
|
STATE
|
STATE
|
This field maintains the state, province or territory associated with the address of person.
|
VARCHAR2(50)
|
|
|
|
|
STREET
|
STREET
|
First line of the address associated with applicant.
|
VARCHAR2(256)
|
|
|
|
|
STUDENT_LEVEL
|
STUDENT_LEVEL
|
Student enrollment level. Values: UG
|
VARCHAR2(50)
|
|
|
|
|
STUDENT_OF_COLOR_DESC
|
STUDENT_OF_COLOR_DESC
|
Description for codes identifying whether a student is a student of color.
|
VARCHAR2(50)
|
|
|
|
|
SUFFIX
|
SUFFIX
|
A name suffix, in the western naming tradition, follows a person's full name and provides additional information about the person. There are academic, honorary, professional and inherited (social) name suffixes.
|
VARCHAR2(50)
|
|
|
|
|
TERM_ENTRY
|
TERM_ENTRY
|
Expected term of entry for the applicant
|
VARCHAR2(10)
|
|
|
|
|
TERM_ENTRY_DESC
|
TERM_ENTRY_DESC
|
Description of the expected term of entry for the applicant
|
VARCHAR2(100)
|
|
|
|
|
TOEFL
|
|
English proficiency test results.
|
VARCHAR2(50)
|
|
|
|
|
TRISCORE
|
TRISCORE
|
Highest composite score of the SAT exam (all three sections)
|
VARCHAR2(50)
|
|
|
|
|
TYPE
|
TYPE
|
Type of student the applicant will become if admitted (N, T).
|
VARCHAR2(50)
|
|
|
|
|
UNIQUEID
|
UNIQUEID
|
FolderWave ID
|
VARCHAR2(50)
|
|
|
|
|
VERBAL
|
VERBAL
|
Highest score from the Critical Reading section of the SAT
|
VARCHAR2(50)
|
|
|
|
|
WAITDATE
|
WAITDATE
|
Date waitlist was offered to applicant
|
DATE
|
|
|
|
|
WAIT_LIST_OFFER_DESC
|
WAIT_LIST_OFFER_DESC
|
Description of waitlist offer.
|
VARCHAR2(100)
|
|
|
|
|
WAIVE
|
WAIVE
|
Indicated whether an applicant had their test scores (ACT/SAT) waived. Values: 1, 0
|
VARCHAR2(2)
|
|
|
|
|
WAIVED_TEST_SCORE_DESC
|
WAIVED_TEST_SCORE_DESC
|
Description of test score waived code.
|
VARCHAR2(50)
|
|
|
|
|
WLOFFER
|
WLOFFER
|
Waitlist Offer-a term an applicant will be considered for acceptance. Values: F (Fall waitlist), FS (Spring admit)
|
VARCHAR2(50)
|
|
|
|
|
WLRESPONSE
|
WLRESPONSE
|
Applicant acceptance of waitlist offer Values: FO, FS
|
VARCHAR2(50)
|
|
|
|
|
YR
|
YR
|
Year of entry for applicant
|
VARCHAR2(4)
|
|
|
|
|
ZIPCODE
|
ZIPCODE
|
This field maintains the postal code associated with the address of person.
|
VARCHAR2(12)
|
|
|
|