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

SGHE Banner Operational Data Store
Reporting View Target: Z_NEU_ACADEMIC_OUTCOME_FREEZE

Description Used for University reporting and official government degree reporting, such as IPEDS. Contains snapshot of frozen degrees awarded during the fiscal year of July to June.

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ACADEMIC_PERIOD   Academic period or time frame associated with this outcome or degree record. VARCHAR2(63 CHAR)      
ACADEMIC_PERIOD_ADMITTED Academic_Period_Admitted Academic period the student was admitted to the university. Student changing majors or levels that do not require a separate admission process do not get a new value (for example, a student moving to the graduate portion of a +1 program). Each separate admissions process a student goes through will generate a new date. VARCHAR2(50)      
ACADEMIC_PERIOD_ADMITTED_DESC Academic_Period_Admitted_Desc Description for Academic Period Admitted VARCHAR2(255 CHAR)      
ACADEMIC_PERIOD_DESC   Academic period description. VARCHAR2(255 CHAR)      
ACADEMIC_PERIOD_GRADUATION Academic_Period_Graduation Academic period when graduation requirements were or will be completed. VARCHAR2(63 CHAR)      
ACADEMIC_PERIOD_GRAD_DESC Academic_Period_Grad_Desc Academic period description. VARCHAR2(255 CHAR)      
ACADEMIC_YEAR_GRADUATION Academic_Grad_Year Academic year associated with this graduation date. This is the traditional academic year (fall-summer) and NOT the degree year (July-June). VARCHAR2(63 CHAR)      
ACADEMIC_YEAR_GRADUATION_DESC Academic_Grad_Year_Desc Academic year description. VARCHAR2(255 CHAR)      
AFRICAN_AMERICAN_IND   Indicates that the student has self-identified as being of a race categorized as Black or African-American VARCHAR2(1 CHAR)      
AMERICAN_INDIAN_IND   Indicates that the student has self-identified as being of a race categorized as American Indian or Alaska VARCHAR2(1 CHAR)      
APPLIED_FOR_OUTCOME_IND   Indicates whether the person has applied to officially receive this specific degree or award as an academic outcome. Should always be "N" in freeze view. VARCHAR2(1 CHAR)      
ASIAN_IND   Indicates that the student has self-identified as being of a race categorized as Asian. VARCHAR2(1 CHAR)      
AWARD_CATEGORY Award_Category Award category associated with the outcome, degree or award. Category used to group outcomes for reporting similar awards together. For example, less than two year, two year and four year awards. VARCHAR2(63 CHAR)      
AWARD_CATEGORY_DESC Award_Category_Desc Award category description. VARCHAR2(255 CHAR)      
CAMPUS   Campus associated to where the academic outcome requirements were completed. VARCHAR2(63 CHAR)      
CAMPUS_DESC   Institution campus name. VARCHAR2(255 CHAR)      
COHORT1 Cohort1 A specific group of students that have a common attribute(s). NU generally uses a start date as a common attribute. For IPEDS reporting, as well as management reports, a student cohort is commonly defined as a collective group of first-time entrants to our institution who enrolled at the census date in programs leading to a certificate, associate or baccalaureate, or other degree. This cohort is first-time full-time freshmen & first-time full-time transfers. Example: 201310FN (New student as of Fall 2013 term) VARCHAR2(50 CHAR)      
COHORT1_DESC Cohort1_Desc Description for Cohort 1 VARCHAR2(250 CHAR)      
COLLEGE Student_College College, faculty or school to which the academic study for the student is associated. VARCHAR2(63 CHAR)      
COLLEGE_DESC Student_College_Desc College, faculty or school name. VARCHAR2(255 CHAR)      
CURRICULUM_ORDER   Unique sequence number that identifies this academic study or program for the student. NUMBER(2)      
CURRICULUM_PRIORITY_NUMBER   Identifies the significant ranking for a curricula. NUMBER(2)      
DEGREE Degree Degree or award code associated with the academic study. VARCHAR2(63 CHAR)      
DEGREE_DESC Degree_Desc Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc. VARCHAR2(255 CHAR)      
DEPARTMENT Student_Department Department responsible to verify that the academic outcome requirements have been completed. VARCHAR2(63 CHAR)      
DEPARTMENTAL_HONORS_COUNT   UNDER REVIEW. Count of all honors recorded for the student. Indicates the honor was approved by the department. NUMBER(2)      
DEPARTMENT_DESC Student_Department_Desc Department name. VARCHAR2(255 CHAR)      
DOB   Date of birth of the person. DATE      
DUAL_MAJOR_FLAG Dual_Major_Ind Flag indicating that the student is pursuing two majors. VARCHAR2(1 CHAR)      
EVENT Event a description of the predefined freeze event as one of stat date freeze, degree data freeze, end of term freeze, etc. VARCHAR2(100 CHAR)      
FIRST_CONCENTRATION First_Concentration Concentration or study emphasis attached to the major for the student's academic study. VARCHAR2(63 CHAR)      
FIRST_CONCENTRATION_DESC First_Concentration_Desc Concentration or study emphasis description. VARCHAR2(255 CHAR)      
FIRST_MINOR First_Minor Minor subject area of the person's academic study. VARCHAR2(63 CHAR)      
FIRST_MINOR_DESC First_Minor_Desc Minor subject area of study description. VARCHAR2(255 CHAR)      
FIRST_NM First_Name The first name given to a person at birth, baptism, another naming ceremony or through legal change. VARCHAR2(100 CHAR)      
FOURTH_DEPARTMENT   Department responsible for this major subject area of academic instruction. VARCHAR2(63 CHAR)      
FOURTH_DEPARTMENT_DESC   Department name. VARCHAR2(255 CHAR)      
FOURTH_MAJOR   Subject area or major focus recorded for the student's academic study. This may be blank. VARCHAR2(63 CHAR)      
FOURTH_MAJOR_CONC_1   First concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis. VARCHAR2(63 CHAR)      
FOURTH_MAJOR_CONC_1_DESC   Student's concentration description. VARCHAR2(255 CHAR)      
FOURTH_MAJOR_CONC_2   Second concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis. VARCHAR2(63 CHAR)      
FOURTH_MAJOR_CONC_2_DESC   Student's concentration description. VARCHAR2(255 CHAR)      
FOURTH_MAJOR_CONC_3   Third concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis. VARCHAR2(63 CHAR)      
FOURTH_MAJOR_CONC_3_DESC   Student's concentration description. VARCHAR2(255 CHAR)      
FOURTH_MAJOR_DESC   Major or subject area of study description. VARCHAR2(255 CHAR)      
FOURTH_MINOR   Fourth minor for the student within this academic study. This may be blank when no minor has been specified. VARCHAR2(63 CHAR)      
FOURTH_MINOR_DESC   Minor area of study description. VARCHAR2(255 CHAR)      
FOURTH_PROGRAM_CLASSIFICATION   Program classification associated with the major subject area of study for this academic outcome. This may be Classification of Institutional Program (CIP) codes used for reporting outcomes to the federal government. VARCHAR2(63 CHAR)      
FOURTH_PROGRAM_CLASSIF_DESC   Program classification code description. VARCHAR2(255 CHAR)      
FREEZE_DATE Freeze_Date Actual date the data was frozen. Data in this Academic Outcome view is frozen on an annual basis in August. DATE      
GENDER Gender The gender of a person, e.g. Male, Female. VARCHAR2(5 CHAR)      
GENDER_DESC Gender_Desc Description for Gender VARCHAR2(100 CHAR)      
GRADUATED_IND   Indicates whether the person has earned this degree or other award from the institution. Should always be "Y" in freeze view. VARCHAR2(1 CHAR)      
GRADUATION_STATUS   Identifies that an academic outcome is completed or still being sought, etc. VARCHAR2(3 CHAR)      
GRADUATION_STATUS_DESC   Current graduation status description. VARCHAR2(255 CHAR)      
GRAD_AUTHORIZED_ADDS_CHGS   Identifies that the student is authorized to add or drop based on graduation requirements. VARCHAR2(63 CHAR)      
HISPANIC_LATINO_IND   Indicates that the student has self-identified as being of Hispanic or Latino origin VARCHAR2(1 CHAR)      
HONORS_COUNT   Count of all honors recorded for the student. NUMBER(2)      
ID Student_NUID Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent. VARCHAR2(9 CHAR)      
INSTITUTIONAL_HONORS_COUNT Institutional_Honors_Count Count of all honors recorded for the student. Indicate that the honor was approved at the institution level, including honors such as Cum Laude, Summa Cum Laude, First Class, etc. NUMBER(2)      
IPEDS_AWARD_LEVEL Degree_IPEDS_Code IPEDS Code associated with student degree Examples: 2 - Cert between 1 and 2 years 3 - Associate 4 - Postsecondary award, certificate, or diploma of (at least 2 but less than 4 academic years) 5 - Bachelors 6 - Post baccalaureate certificate 7 - Masters 8 - Post-master's certificate 9 - Doctorate (Retired as of Fall 2010) 17 -Doctor-Research/Scholarship 18 - Doctor - Professional Practice 19 - Doctor Other 99 - No Degree VARCHAR2(6 CHAR)      
IPEDS_ETHNICITY_RACE_CD   Race / Ethnicity based on requirements from the "Integrated Postsecondary Education Data System (IPEDS) Example: 1 - Hispanic of any race 2 - American Indian or Alaska Native 3 - Asian 4- Black or African American 5 - Native Hawaiian or Other Pacific Islander 6 - White 7 - Two or more races 8 - Nonresident Alien 9 - Race and Ethnicity unknown *This code is only valid beginning Fall 2010. Note: Corresponds to IPEDS_Ethnicity_Race_Cd for IPEDS reporting. This information is used for statistical purposes only and is aggregated and submitted to the federal government as may be required by law. The University also uses the aggregated data to develop government-mandated reports/plans. This means the information is reported in total numbers only, without any identifying information. Personally identifiable information will remain confidential. VARCHAR2(63 CHAR)      
IPEDS_ETHNICITY_RACE_NAME   Description of IPEDS_RACE_CD Note: Corresponds to IPEDS_Ethnicity_Race_Name for IPEDS reporting. VARCHAR2(255 CHAR)      
LAST_NM Last_Name The last name by which a person is known. VARCHAR2(100 CHAR)      
MAJOR Primary_Major First subject area or major focus recorded for the student's curriculum. This may not be blank. VARCHAR2(63 CHAR)      
MAJOR_DESC Primary_Major_Desc Name of the student's major subject area. VARCHAR2(255 CHAR)      
NEU_CREDITS_ATTEMPTED   Sum of hours for all classes in which a student has enrolled. NUMBER(11,2)      
NEU_CREDITS_EARNED   Credits earned as defined by the grading rules of the institution. This number must be calculated by the system after the final grade is recorded for the student. NUMBER(11,2)      
NEU_CREDITS_PASSED   Sum of hours for classes a student has enrolled in and passed. NUMBER(11,2)      
NEU_GPA   Calculated grade point average or average for the set of courses completed. NUMBER(11,2)      
NEU_GPA_CREDITS   Credits used to calculate the average or grade point average for the courses used to complete the outcome requirements. NUMBER(11,2)      
NEU_QUALITY_POINTS   Quality points used to calculate the grade point average for this academic outcome. NUMBER(11,2)      
OFFICIAL_DOCUMENT_NAME   Name of the person as it appears on the outcome document. VARCHAR2(500 CHAR)      
OUTCOME_APPLICATION_DATE Outcome_Application_Date Date that the student applied for graduation in this academic outcome. DATE      
OUTCOME_AWARDED_IND   Identifies whether the academic outcome, award or degree has been officially awarded to the person. Should always be "A" in freeze view. VARCHAR2(1 CHAR)      
OUTCOME_GRADUATION_DATE Outcome_Graduation_Date Date for the formal graduation for this academic outcome. This is the date that the completion of this degree or award is confirmed. DATE      
OUTCOME_NUMBER   Degree or award sequence number for this academic outcome for the student. NUMBER      
PACIFIC_ISLDR_IND   Indicates that the student has self-identified as being of a race categorized as Native Hawaiian or Pacific Islander VARCHAR2(1 CHAR)      
PERSON_UID Person_UID System generated Banner unique ID which gets assigned to all person and non-person records within Banner. NUMBER      
PRIMARY_ETHNICITY   This field identifies the ethnic code defined as one of defined by NU. This information is used for statistical purposes only and is aggregated and submitted to the federal government as may be required by law. The University also uses the aggregated data to develop government-mandated reports/plans. This means the information is reported in total numbers only, without any identifying information. Personally identifiable information will remain confidential. *This code is only valid prior to Fall 2010. VARCHAR2(63 CHAR)      
PRIMARY_ETHNICITY_DESC   Description for Primary Ethnicity VARCHAR2(255 CHAR)      
PROGRAM Program Program or course of study for the student. This may be blank when programs are not being used to manage a set of completion requirements. VARCHAR2(63 CHAR)      
PROGRAM_CLASSIFICATION Program_Classification Program classification associated with the major subject area of study for this outcome. This may be the Classification of Institutional Programs (CIP) codes used for reporting outcomes to the federal government. VARCHAR2(63 CHAR)      
PROGRAM_CLASSIFICATION_DESC Program_Classification_Desc Program classification description. VARCHAR2(255 CHAR)      
PROGRAM_DESC Program_Desc Program or course of study description. VARCHAR2(255 CHAR)      
SECOND_CONCENTRATION Second_Concentration Concentration or study emphasis attached to the major for the student's academic study. VARCHAR2(63 CHAR)      
SECOND_CONCENTRATION_DESC Second_Concentration_Desc Concentration or study emphasis description. VARCHAR2(255 CHAR)      
SECOND_DEPARTMENT Second_Department Department responsible for the second major or subject area of academic instruction. VARCHAR2(63 CHAR)      
SECOND_DEPARTMENT_DESC Second_Department_Desc Department name. VARCHAR2(255 CHAR)      
SECOND_MAJOR Second_Major Subject area or major focus recorded for the student's academic study. This may be blank. VARCHAR2(63 CHAR)      
SECOND_MAJOR_CONC_1 Second_Major_Conc_1 First concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis. VARCHAR2(63 CHAR)      
SECOND_MAJOR_CONC_1_DESC Second_Major_Conc_1_Desc Student's concentration description. VARCHAR2(255 CHAR)      
SECOND_MAJOR_CONC_2   Second concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis. VARCHAR2(63 CHAR)      
SECOND_MAJOR_CONC_2_DESC   Student's concentration description. VARCHAR2(255 CHAR)      
SECOND_MAJOR_CONC_3   Third concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis. VARCHAR2(63 CHAR)      
SECOND_MAJOR_CONC_3_DESC   Student's concentration description. VARCHAR2(255 CHAR)      
SECOND_MAJOR_DESC Second_Major_Desc Major or subject area of study description. VARCHAR2(255 CHAR)      
SECOND_MINOR Second_Minor Second minor for the student within this academic study. This may be blank when no minor has been specified. VARCHAR2(63 CHAR)      
SECOND_MINOR_DESC Second_Minor_Desc Minor subject area of study description. VARCHAR2(255 CHAR)      
SECOND_PROGRAM_CLASSIFICATION   Program classification associated with the major subject area of study for this outcome. This may be the Classification of Program (CIP) codes used for reporting outcomes to the federal government. VARCHAR2(63 CHAR)      
SECOND_PROGRAM_CLASSIF_DESC   Program classification code description. VARCHAR2(255 CHAR)      
STATUS Student_Status Current status of the academic outcome. For example, pending, awarded, etc. Should always be "AW" in freeze view. VARCHAR2(63 CHAR)      
STATUS_DESC Student_Status_Desc Outcome or award status description. VARCHAR2(255 CHAR)      
STUDENT_LEVEL Student_Level Student level associated with the coursework in the academic outcome. Examples, include undergraduate and graduate, etc. VARCHAR2(63 CHAR)      
STUDENT_LEVEL_DESC Student_Level_Desc Student level description. VARCHAR2(255 CHAR)      
THIRD_CONCENTRATION   Concentration or study emphasis attached to the major for the student's academic study. VARCHAR2(63 CHAR)      
THIRD_CONCENTRATION_DESC   Concentration or study emphasis description. VARCHAR2(255 CHAR)      
THIRD_DEPARTMENT   Department responsible for the major or subject area of academic instruction. VARCHAR2(63 CHAR)      
THIRD_DEPARTMENT_DESC   Department name. VARCHAR2(255 CHAR)      
THIRD_MAJOR   Subject area or major focus recorded for the student's academic study. This may be blank. VARCHAR2(63 CHAR)      
THIRD_MAJOR_CONC_1   First concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis. VARCHAR2(63 CHAR)      
THIRD_MAJOR_CONC_1_DESC   Student's concentration description. VARCHAR2(255 CHAR)      
THIRD_MAJOR_CONC_2   Second concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis. VARCHAR2(63 CHAR)      
THIRD_MAJOR_CONC_2_DESC   Student's concentration description. VARCHAR2(255 CHAR)      
THIRD_MAJOR_CONC_3   Third concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis. VARCHAR2(63 CHAR)      
THIRD_MAJOR_CONC_3_DESC   Student's concentration description. VARCHAR2(255 CHAR)      
THIRD_MAJOR_DESC   Major or subject area of study description. VARCHAR2(255 CHAR)      
THIRD_MINOR   Third minor for the student within this academic study. This may be blank when no minor has been specified. VARCHAR2(63 CHAR)      
THIRD_MINOR_DESC   Minor area of study description. VARCHAR2(255 CHAR)      
THIRD_PROGRAM_CLASSIFICATION   Program classification associated with the major subject area of study for this academic outcome. This may be the classification of Institutional Program (CIP) codes used for reporting outcomes to the federal government. VARCHAR2(63 CHAR)      
THIRD_PROGRAM_CLASSIF_DESC   Program classification code description. VARCHAR2(255 CHAR)      
TRANSFER_WORK_EXISTS_IND Transfer_Work_Exists_Ind Indicates whether any transfer credits are recorded for the student that apply to this academic outcome. VARCHAR2(1 CHAR)      
WHITE_IND   Indicates that the student has self-identified as being of a race categorized as White. VARCHAR2(1 CHAR)      


Ver: 9.0