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_GRAD_DAILY_VW

Description Daily view of Graduate Admissions data that provides Grad colleges and OSER with reporting capability to define and improve the enrollment management strategy. Includes all current terms in the active admissions cycle (may be 1 or more terms). One freeze per term aligned with student freezes (stats date). Data released to Grad colleges, OSER, Admissions Grad Office, Financial Aid Office, Institutional Research Office, Provost Office, and Office of the Registrar.

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
AGENCYRECRUITED_IND   Indicates (through Y/N) whether or not an international applicant is working with an Agency.        
ACADEMIC_PERIOD_APPLY Apply_Term_Code Applied to term VARCHAR2(50 CHAR)      
ACADEMIC_PERIOD_APPLY_DESC Apply_Term_Desc Term description VARCHAR2(255 CHAR)      
ACADEMIC_PERIOD_ENTRY Entry_Term_Code Expected term of entry for the applicant at time of application submission VARCHAR2(50 CHAR)      
ACADEMIC_PERIOD_ENTRY_DESC Entry_Term_Desc Term description VARCHAR2(255 CHAR)      
ACPTCNT Admitted_Students Counter for accepted applications NUMBER(1)      
AFRICAN_AMERICAN_IND   Applicant's African-American race status VARCHAR2(1 CHAR)      
AGE Age Age (at the point of applying to NU) NUMBER(4,1)      
AGENCY_CD   Indicates the code of the International Recruitment Agency working with the applicant.        
AMERICAN_INDIAN_IND   Applicant's American Indian race status VARCHAR2(1 CHAR)      
APPCNT Submitted_Applications Counter for submitted applications. Defaults to 1 for all records NUMBER(1)      
APPDECISIONSTATUS Applicant_Status Applicant decision status        
APPINPROCESSSTATUS App_In_Process_Status Applicant in process stage        
APPLICANT_DECISION_DATE Enrollment_Decision_Date The date the applicant makes their decision on whether or not to enroll at the university. DATE      
APPLICANT_DECISION_IND Application_Decision_Ind Yes/No field, Y being students who have deposited for a certain academic term. VARCHAR2(1 CHAR)      
APPLICATION_COMPLETE_DATE App_Completed_Date Application Complete Date DATE      
APPLICATION_CREATE_DATE App_Create_Date The date graduate application are started. DATE      
APPLICATION_DATE App_Date The date associated with the most current status of the application. DATE      
APPLICATION_ID AYID Apply Yourself unique application ID VARCHAR2(50 CHAR)      
APPLICATION_NUMBER   The unique application reference ID for both Slate and AY applications        
APPLICATION_STATUS Application_Status_Code Key stages in an application that are useful to track for reporting purposes, e.g. Incomplete, Complete, Denied, Accepted, Withdrawn VARCHAR2(50 CHAR)      
APPLICATION_STATUS_DESC App_Status_Desc Description of Application Status VARCHAR2(255 CHAR)      
APPLICATION_SUBMIT_DATE App_Submit_Date Date of submission on the Application DATE      
APPLIED_COLLEGE College_Code College applied to at Northeastern VARCHAR2(50 CHAR)      
APPLIED_COLLEGE_2 College2_Code Secondary college applied to if the program is considered 'shared'. In particular, If the program is either a CS certificate or masters program, then the field is set to CS. VARCHAR2(50 CHAR)      
APPLIED_COLLEGE_2_DESC College2_Desc Description of secondary college applied to VARCHAR2(255 CHAR)      
APPLIED_COLLEGE_DESC College_Desc Description of college applied to VARCHAR2(255 CHAR)      
APPLIED_CONCENTRATION Concentration_Code Concentration applied to VARCHAR2(50 CHAR)      
APPLIED_CONCENTRATION_DESC Concentration_Desc Description of concentration applied to VARCHAR2(255 CHAR)      
APPLIED_DEGREE Degree_Code Degree applicant is applying to VARCHAR2(50 CHAR)      
APPLIED_DEGREE_DESC Degree_Desc Description of Degree applicant is applying to VARCHAR2(255 CHAR)      
APPLIED_DEPARTMENT Department_Code Banner department code VARCHAR2(50 CHAR)      
APPLIED_DEPARTMENT_DESC Department_Desc Banner department code description VARCHAR2(255 CHAR)      
APPLIED_MAJOR Major_Code Major applied to VARCHAR2(50 CHAR)      
APPLIED_MAJOR_DESC Major_Desc Description of major applied to VARCHAR2(255 CHAR)      
APPLIED_PROGRAM Program_Code Program applicant applied to VARCHAR2(50 CHAR)      
APPLIED_PROGRAM_DESC Program_Desc Description of Program applicant applied to VARCHAR2(255 CHAR)      
ASIAN_IND   Applicant's Asian race status VARCHAR2(1 CHAR)      
APPDECISIONSTATUS     VARCHAR2(50 CHAR)      
APPLNPROCESSSTATUS     VARCHAR2(255 CHAR)      
BIRTH_DATE Birth_Date Date of birth of person. DATE      
CAMPUS_PREFERENCE Campus_Preference Field is used to identify the campus to which students are enrolled. VARCHAR2(50 CHAR)      
CAMPUS_REGION_CD Campus_Code Campus Region (eg. MCHL for Charlotte) VARCHAR2(50 CHAR)      
CAMPUS_REGION_DESC Campus_Desc Campus Region Description VARCHAR2(255 CHAR)      
CELL_PHONE_NBR Cell_Phone This field maintains the cell phone number associated with address of person. VARCHAR2(50 CHAR)      
CITIZENSHIP_TYPE Citizenship_Type_Code Prior to Global Campus System updates: Indicates whether the person has been identified as a citizen of the United States. 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 CHAR)      
CITIZENSHIP_TYPE_DESC Citizenship_Type_Desc Description of citizenship status VARCHAR2(255 CHAR)      
COMP_APPCNT Completed_Applications Counter for completed applications NUMBER(1)      
COUNTRY_CITIZENSHIP_CODE Nation_Citizenship_Code The nation/country code of citizenship of the applicant VARCHAR2(50 CHAR)      
COUNTRY_CITIZENSHIP_DESC Nation_Citizenship_Desc The nation/country name/description of citizenship of the applicant VARCHAR2(255 CHAR)      
DCF_CD   Indicates if a Declaration and Certification of Finances (DCF) for an international student who needs to provide proof of funding for one academic year has been received, waived, etc.        
DECISION Decision_Code Admission decision VARCHAR2(50 CHAR)      
DECISION_DATE   The date on which the final admissions decision is posted internally. DATE      
DECISION_DESC Decision_Desc Description of admission decision VARCHAR2(255 CHAR)      
DECISION_PUBLISH_DATE   The date on which the applicants admissions decision was released to the applicant. DATE      
DEPCNT Total_Deposits Counter for applications with paid or waived deposits NUMBER(1,1)      
DOUBLE_HUSKY_SELF_REPORT_IND Double_Husky DoubleHusky Self Report VARCHAR2(1 CHAR)      
DUOLINGO_TOTAL   Overall Duolingo English Test Score        
EMAIL EMail Indicates email address for person. VARCHAR2(255 CHAR)      
ENROLLMENT_STATUS   Enrollment Status preference indicated on application (Full-time or Part-time)        
FIRST_NAME First_Name The first name given to a person at birth, baptism, another naming ceremony or through legal change. VARCHAR2(63 CHAR)      
FREEZE_DATE   Date of freeze data load DATE      
GENDER Gender_Code Gender code of applicant. VARCHAR2(50 CHAR)      
GENDER_DESC Gender_Desc Gender description of applicant VARCHAR2(255 CHAR)      
GMAT_MAX_QUANTITATIVE GMAT_Max_Quantitative Find the highest GMAT Total among GMAT Total 1-5 and enter the corresponding Quantitative here. VARCHAR2(50 CHAR)      
GMAT_MAX_QUANTITATIVE_PRCNTL GMAT_Max_Quant_Percent Find the highest GMAT Total among GMAT Total 1-5 and enter the corresponding Quantitative Percentile here. VARCHAR2(50 CHAR)      
GMAT_MAX_TOTAL GMAT_Max_Total Find the highest GMAT Total among GMAT Total 1-5 and enter it here. VARCHAR2(50 CHAR)      
GMAT_MAX_TOTAL_PRCNTL GMAT_Max_Total_Percent Find the highest GMAT Total among GMAT Total 1-5 and enter the corresponding Total Percentile here. VARCHAR2(50 CHAR)      
GMAT_MAX_VERBAL GMAT_Max_Verbal Find the highest GMAT Total among GMAT Total 1-5 and enter the corresponding Verbal here. VARCHAR2(50 CHAR)      
GMAT_MAX_VERBAL_PRCNTL GMAT_Max_Verbal_Percent Find the highest GMAT Total among GMAT Total 1-5 and enter the corresponding Verbal Percentile here. VARCHAR2(50 CHAR)      
GMAT_MAX_WRITING GMAT_Max_Writing Find the highest GMAT Total among GMAT Total 1-5 and enter the corresponding Writing here. VARCHAR2(50 CHAR)      
GMAT_MAX_WRITING_PRCNTL GMAT_Max_Writing_Percent Find the highest GMAT Total among GMAT Total 1-5 and enter the corresponding Writing Percentile here. VARCHAR2(50 CHAR)      
GRE_MAX_ANALYT_WRITING GRE_Max_Writing Find the highest AW Percentile among AW Percentile 1-5 and enter the corresponding AW score here. VARCHAR2(50 CHAR)      
GRE_MAX_ANALYT_WRITING_PRCNTL GRE_Max_Writing_Percent Find the highest AW Percentile among AW Percentile 1-5 and enter it here. VARCHAR2(50 CHAR)      
GRE_MAX_QUANTITATIVE GRE_Max_Quantitative Find the highest Quant Percentile among Quant Percentile 1-5 and enter the corresponding Quant score here. VARCHAR2(50 CHAR)      
GRE_MAX_QUANTITATIVE_PRCNTL GRE_Max_Quant_Percent Find the highest Quant Percentile among Quant Percentile 1-5 and enter it here. VARCHAR2(50 CHAR)      
GRE_MAX_VERBAL GRE_Max_Verbal Find the highest Verbal Percentile among Verbal Percentile 1-5 and enter the corresponding Verbal score here. VARCHAR2(50 CHAR)      
GRE_MAX_VERBAL_PERCENTILE GRE_Max_Verbal_Percent Find the highest Verbal Percentile among Verbal Percentile 1-5 and enter it here. VARCHAR2(50 CHAR)      
HISPANIC_LATINO_IND   Does applicant self-identify as Hispanic/Latino VARCHAR2(1 CHAR)      
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)      
ID NUID Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent. VARCHAR2(10 CHAR)      
IELTS_MAX_LISTENING IELTS_Max_Listening Find Maximum Total and enter the corresponding Listening here. VARCHAR2(50 CHAR)      
IELTS_MAX_READING IELTS_Max_Reading Find Maximum Total and enter the corresponding Reading here. VARCHAR2(50 CHAR)      
IELTS_MAX_SPEAKING IELTS_Max_Speaking Find Maximum Total and enter the corresponding Speaking here. VARCHAR2(50 CHAR)      
IELTS_MAX_TOTAL IELTS_Max_Total Find Maximum Total and enter it here. VARCHAR2(50 CHAR)      
IELTS_MAX_WRITING IELTS_Max_Writing Find Maximum Total and enter the corresponding Writing here. VARCHAR2(50 CHAR)      
INST1_ATTND_FINISH_DATE   First college end date from where the applicant is graduated.        
INST1_ATTND_START_DATE   First college start date from where the applicant is graduated.        
INST1_CITY Inst1_City First college city from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST1_CODE Inst1_Code First college code from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST1_COUNTRY Inst1_Country First college country name from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST1_COUNTRY_CD   The country code of the applicant's rank 1 institution (i.e. US = United States)        
INST1_DEGREE Inst1_Degree First college degree name from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST1_DEGREE_DATE Inst1_Degree_Date First college degree awarded date from where the applicant is graduated. DATE      
INST1_GPA Inst1_GPA First college GPA from where the applicant is graduated. NUMBER(11,3)      
INST1_MAJOR   The applicant's self-selected major at their rank 1 institution        
INST1_MAJOR_CD   The abbreviation/code for the applicant's self-selected major at their rank 1 institution        
INST1_NAME Inst1_Name First college name from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST1_STATE Inst1_State First college state from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST1_VERIFICATION Inst1_Verification First college degree verified from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST2_ATTND_FINISH_DATE   Second college end date from where the applicant is graduated.        
INST2_ATTND_START_DATE   Second college start date from where the applicant is graduated.        
INST2_CITY   Second college city from where the applicant is graduated.        
INST2_CODE Inst2_Code Second college code from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST2_COUNTRY   Second college country name from where the applicant is graduated.        
INST2_COUNTRY_CODE   The country code of the applicant's rank 2 institution (i.e. US = United States)        
INST2_DEGREE Inst2_Degree Second college degree name from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST2_DEGREE_DATE Inst2_Degree_Date Second college degree awarded date from where the applicant is graduated. DATE      
INST2_GPA Inst2_GPA Second college GPA from where the applicant is graduated. NUMBER(11,3)      
INST2_GPASCALE   Second college GPA scale from where the applicant is graduated.        
INST2_MAJOR   The applicant's self-selected major at their rank 2 institution        
INST2_MAJOR_CD   The abbreviation/code for the applicant's self-selected major at their rank 2 institution        
INST2_NAME Inst2_Name Second college name from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST2_STATE   The state of the applicant's rank 2 institution        
INST2_VERIFICATION   Second college degree verified from where the applicant is graduated.        
INST3_ATTND_FINISH_DATE   Third college end date from where the applicant is graduated.        
INST3_ATTND_START_DATE   Third college start date from where the applicant is graduated.        
INST3_CITY   Third college city from where the applicant is graduated.        
INST3_CODE Inst3_Code Third college code from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST3_COUNTRY   Third college country name from where the applicant is graduated.        
INST3_COUNTRY_CD   The country code of the applicant's rank 3 institution (i.e. US = United States)        
INST3_DEGREE Inst3_Degree Third college degree name from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST3_DEGREE_DATE Inst3_Degree_Date Third college degree awarded date from where the applicant is graduated. DATE      
INST3_GPA Inst3_GPA Third college GPA from where the applicant is graduated. NUMBER(11,3)      
INST3_GPASCALE   Third college GPA scale from where the applicant is graduated.        
INST3_MAJOR   The applicant's self-selected major at their rank 3 institution        
INST3_MAJOR_CD   The abbreviation/code for the applicant's self-selected major at their rank 3 institution        
INST3_NAME Inst3_Name Third college name from where the applicant is graduated. VARCHAR2(63 CHAR)      
INST3_STATE   The state of the applicant's rank 3 institution        
INST3_VERIFICATION   Third college degree verified from where the applicant is graduated.        
INTERNAL_DECISION_DATE Internal_Recommendation_Date The date the department or program makes a recommendation on an applicant's admittance. DATE      
INTL_ADDRESS_IND   International address indicator. If perm address country code is not US, then 'Y' else is unknown (NULL) VARCHAR2(50 CHAR)      
IPEDS_RACE_CD IPEDS_Ethnicity_Code Race/ethnicity based on requirements from the "Integrated Postsecondary Education Data System (IPEDS)" VARCHAR2(50 CHAR)      
IPEDS_RACE_NAME IPEDS_Ethnicity_Desc Description of IPEDS Ethnicity Race Code VARCHAR2(250 CHAR)      
LAST_NAME Last_Name The last name by which a person is known. VARCHAR2(63 CHAR)      
MAILING_STATE_CODE   Mailing Address Banner State Code VARCHAR2(255 CHAR)      
MATRICNT Active_Deposits Counter for matriculated applicants NUMBER(1,1)      
MIDDLE_NAME Middle_Name A secondary name given to an individual at birth, baptism, another naming ceremony, or through legal change. VARCHAR2(63 CHAR)      
NOT_INDICATED_IND   To be removed VARCHAR2(1 CHAR)      
NU_RACE_NAME   Used for internal reporting only. Uses the same logic as IPEDS_ETHNICTY_RACE_CD but with different descriptors.        
PACIFIC_ISLDR_IND   Applicant's Pacific Islander ethnicity status VARCHAR2(1 CHAR)      
PERM_CITY Perm_City The city associated with the permanent address of the applicant VARCHAR2(50 CHAR)      
PERM_COUNTRY Perm_Country_Code The country associated with the permanent address of the applicant VARCHAR2(50 CHAR)      
PERM_COUNTRY_DESC Perm_Country_Desc Name/description of the country associated with the permanent address of the applicant VARCHAR2(255 CHAR)      
PERM_STATE_CODE Perm_State The state associated with the permanent address of the applicant VARCHAR2(50 CHAR)      
PERM_STREET1 Perm_Street1 The first address line associated with the permanent address of the applicant VARCHAR2(255 CHAR)      
PERM_STREET2 Perm_Stree2 The second address line associated with the permanent address of the applicant VARCHAR2(255 CHAR)      
PERM_STREET3 Perm_Street3 The third address line associated with the permanent address of the applicant VARCHAR2(255 CHAR)      
PERM_ZIP Perm_Zip The postal code associated with the permanent address of the applicant VARCHAR2(50 CHAR)      
POPULATION_CD_1 Pop1_Code The first admissions attribute for the person and term. VARCHAR2(10 CHAR)      
POPULATION_CD_2 Pop2_Code The second admissions attribute for the person and term. The second admissions attribute for the person and term. VARCHAR2(10 CHAR)      
POPULATION_CD_3 Pop3_Code The third admissions attribute for the person and term. VARCHAR2(10 CHAR)      
POPULATION_CD_4 Pop4_Code The fourth admissions attribute for the application. VARCHAR2(10 CHAR)      
POPULATION_CD_5 Pop5_Code The fifth admissions attribute for the application. VARCHAR2(10 CHAR)      
POPULATION_DESC_1 Pop1_Desc Description for the first admissions attribute for the application VARCHAR2(50 CHAR)      
POPULATION_DESC_2 Pop2_Desc Description for the second admissions attribute for the application VARCHAR2(50 CHAR)      
POPULATION_DESC_3 Pop3_Desc Description for the third admissions attribute for the application VARCHAR2(50 CHAR)      
POPULATION_DESC_4 Pop4_Desc Description for the fourth admissions attribute for the application VARCHAR2(50 CHAR)      
POPULATION_DESC_5 Pop5_Desc Description for the fifth admissions attribute for the application VARCHAR2(50 CHAR)      
PREFIX Prefix An appellation used to connote rank, placement or status. A title that precedes person name. VARCHAR2(63 CHAR)      
REGION Region_Code US region of the applicant based on their permanent state code VARCHAR2(2 CHAR)      
REGION_DESC Region_Desc Description of US region of the applicant VARCHAR2(50 CHAR)      
SCHOLARSHIP_CD_1 Scholar1_Code Scholarship received 1 VARCHAR2(10 CHAR)      
SCHOLARSHIP_CD_2 Scholar2_Code Scholarship received 2 VARCHAR2(10 CHAR)      
SCHOLARSHIP_CD_3 Scholar3_Code Scholarship received 3 VARCHAR2(10 CHAR)      
SCHOLARSHIP_DESC_1 Scholar1_Desc Scholarship received 1 description VARCHAR2(50 CHAR)      
SCHOLARSHIP_DESC_2 Scholar2_Desc Scholarship received 2 description VARCHAR2(50 CHAR)      
SCHOLARSHIP_DESC_3 Scholar3_Desc Scholarship received 3 description VARCHAR2(50 CHAR)      
SECONDARY_EMAIL Second_EMail Applicant's secondary email address VARCHAR2(255 CHAR)      
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 CODE. VARCHAR2(255)      
STUDENT_LEVEL   Student level as graduate student VARCHAR2(50 CHAR)      
STUDENT_LEVEL_DESC   Student level as graduate student VARCHAR2(255 CHAR)      
STUDENT_OF_COLOR_DESC SOC_Desc Description for codes identifying whether a student is a student of color. Excludes international students VARCHAR2(255 CHAR)      
STUDENT_OF_COLOR_IND SOC_Ind This field identifies whether a student is a student of color (excludes international students and student with an unidentified race/ethnicity) VARCHAR2(1 CHAR)      
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(63 CHAR)      
TOEFL_MAX_LISTENING TOEFL_Max_Listening Find the highest TOEFL Total among TOEFL Total 1-5 (only if TOEFL Type =IBT) and enter the corresponding TOEFL Listening here. VARCHAR2(50 CHAR)      
TOEFL_MAX_READING TOEFL_Max_Reading Find the highest TOEFL Total among TOEFL Total 1-5 (only if TOEFL Type =IBT) and enter the corresponding TOEFL Reading here. VARCHAR2(50 CHAR)      
TOEFL_MAX_SPEAKING TOEFL_Max_Speaking Find the highest TOEFL Total among TOEFL Total 1-5 (only if TOEFL Type =IBT) and enter the corresponding TOEFL Speaking here. VARCHAR2(50 CHAR)      
TOEFL_MAX_TOTAL TOEFL_Max_Total Find the highest TOEFL Total among TOEFL Total 1-5 (only if TOEFL Type =IBT) and enter it here. VARCHAR2(50 CHAR)      
TOEFL_MAX_WRITING TOEFL_Max_Writing Find the highest TOEFL Total among TOEFL Total 1-5 (only if TOEFL Type =IBT) and enter the corresponding TOEFL Writing here. VARCHAR2(50 CHAR)      
VETERAN_IND   Indicates that the student is a military veteran.        
WHITE_IND   Applicant's White/Caucasian race status VARCHAR2(1 CHAR)      
WORK_PHONE_NBR Work_Phone This field maintains the work phone number associated with address of person. VARCHAR2(50 CHAR)      
YEARS_OF_WORK_EXPERIENCE   Years of Work Experience VARCHAR2(50 CHAR)      


Ver: 9.0