Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Neu Admissions Reporting Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: Z_NEU_ADM_COLLEGE_WEEKLY_VW

Description Closed (at weekly census date) Admissions data made available for the colleges. Contains data for admitted students only at the undergraduate level. Undergraduate population meets the following criteria: 1) Admitted 2) Student admission decisions have already been released to the students

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)      


Ver: 9.0