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
|
|
Highest score from the science section of the ACT test
|
|
|
|
|
ADDRESS_TYPE_CODE
|
Address_Type_Code
|
Address type (permanent or mailing) Values: P, M
|
VARCHAR2(50)
|
|
|
|
ADMDECCT
|
Admdecct
|
Currently Under Review
|
NUMBER(1)
|
|
|
|
ADMIT_DECLINE_COUNT_DESC
|
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
|
Appdec
|
Applicant decision code.
|
VARCHAR2(50)
|
|
|
|
APPDEC_DESC
|
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
|
Application_Number
|
Common App assigned application number.
|
VARCHAR2(50)
|
|
|
|
APPLICATION_STATUS_DESC
|
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
|
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
|
An indicator which defines if advanced placement test was taken.
|
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
|
Cadnidate1
|
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(10)
|
|
|
|
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
|
CANDIDATE FOR SPECIAL PROGRAM/
|
|
|
|
CANDIDATE8_DESC
|
Candidate8_Desc
|
Description of Candidate 8
|
VARCHAR2(100)
|
|
|
|
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
|
Citizenship Type Values: Y: US Citizen P: Legal Permanent Resident of US N: Non-United States Citizen
|
VARCHAR2(50)
|
|
|
|
CITCNT
|
Citcnt
|
Nation/country of applicant's citizenship.
|
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)
|
|
|
|
CLG
|
Clg
|
Current college of applicant
|
VARCHAR2(50)
|
|
|
|
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
|
Country associated with the address of applicant.
|
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
|
Cyear
|
Currently Under Review
|
VARCHAR2(4)
|
|
|
|
DECISION
|
Decision
|
Applicant's admit decision
|
VARCHAR2(50)
|
|
|
|
DECISION_DESC
|
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
|
Depuedate
|
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
|
Individual self-identified as Hispanic or Latino.
|
VARCHAR2(50)
|
|
|
|
ETHNICITY_DESC
|
Ethnicity_Desc
|
Description of applicant's primary ethnicity
|
VARCHAR2(300)
|
|
|
|
EVENT
|
Event
|
Census term and year for close data.
|
VARCHAR2(50)
|
|
|
|
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_Language_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
|
|
The approved campus location assigned to a student or employee upon application, enrollment or hiring
|
|
|
|
|
HOME_CAMPUS_COUNTRY_CD
|
|
The nation of a student's Home Campus
|
|
|
|
|
HOME_CAMPUS_COUNTRY_DESC
|
|
Description for HOME_CAMPUS_COUNTRY_CD
|
|
|
|
|
HOME_CAMPUS_DESC
|
|
Description for HOME_CAMPUS_CD
|
|
|
|
|
HONORMAT
|
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
|
Honors_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
|
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
|
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
|
Program1_Desc
|
Currently Under Review
|
VARCHAR2(100)
|
|
|
|
PROGRAM2
|
Program2
|
Currently Under Review
|
VARCHAR2(50)
|
|
|
|
PROGRAM2_DESC
|
Program2_Desc
|
Currently Under Review
|
VARCHAR2(100)
|
|
|
|
PROGRAM3
|
Program3
|
Currently Under Review
|
VARCHAR2(50)
|
|
|
|
PROGRAM3_DESC
|
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
|
Applicant's African-American race status Values: Y, N
|
VARCHAR2(1)
|
|
|
|
RACE_AMIND
|
Race_Amind
|
Applicant's American Indian race status
|
VARCHAR2(1)
|
|
|
|
RACE_API
|
Race_Api
|
Applicant's Asian/Pacific Islander race status Values: Y, N
|
VARCHAR2(1)
|
|
|
|
RACE_HISP
|
Race_Hisp
|
Applicant's Hispanic ethnicity status Values: Y, N
|
VARCHAR2(1)
|
|
|
|
RACE_NOTIND
|
Race_Notind
|
Applicant's race/ethnicity not identified Values: Y, N
|
VARCHAR2(1)
|
|
|
|
RACE_WHITE
|
Race_White
|
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
|
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
|
Region_Desc
|
Description of geographic region of applicant.
|
VARCHAR2(50)
|
|
|
|
RELSDATE
|
Relsdate
|
Date on which applicant's admission decision was released
|
DATE
|
|
|
|
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
|
|
Description for SECOND_NATION_CITIZENSHIP
|
|
|
|
|
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.
|
VARCHAR2(50)
|
|
|
|
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
|
Sprotcd1
|
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
|
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)
|
|
|
|