Reporting View Target: Z_NEU_STUDENT_MIL_CENSUS

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_STUDENT_MIL_CENSUS_VW

Description Provides detailed military affiliated student bio demo and academic information for each Academic Period (Reg. term). Examples: Student level, college, veteran indicator, etc. Data snapshots are taken at Census time(stat time) starting from Fall 2018 going forward

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column

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(63 CHAR)

ACADEMIC_PERIOD_ADMITTED_DESC Description for Academic Period Admitted VARCHAR2(255 CHAR)

ACADEMIC_PERIOD_NUFREEZE Academic term when student data was frozen corresponding to event in the academic calendar (defined by student level) VARCHAR2(10 CHAR)

ACADEMIC_PERIOD_NUFREEZE_DESC Description for Academic Period VARCHAR2(255 CHAR)

COLLEGE This field identifies the college associated with the student's primary curriculum for the effective term. VARCHAR2(63 CHAR)

COLLEGE_DESC Description for College VARCHAR2(255 CHAR)

COURSE_CREDITS_FULL Course_Credits_Full Sum of academic credits for classes taken by a student that are held during a full semester (Sub Academic Period/Part of Term '1' or '1L') in the given academic term

COURSE_CREDITS_PT_A Course_Credits_PT_A Sum of academic credits for classes that are held during the first half (Sub Academic Period/Part of Term '2A') of the given academic term

COURSE_CREDITS_PT_B Course_Credits_PT_B Sum of academic credits for classes that are held during the second half (Sub Academic Period/Part of Term '2B') of the given academic term

DEGREE Degree or award code associated with the student's academic study. VARCHAR2(63 CHAR)

DEGREE_DESC Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc. VARCHAR2(63 CHAR)

ENROLLMENT_ATT_A Enrollment_Attribute_A Identifies if a student is on Clinical ('CL'), Co-op ('CO') or ('SA') in Sub Academic Period/Part of Term '2A' (meaning the first half of a semester) for the given academic term. VARCHAR2(2CHAR)

ENROLLMENT_ATT_A_DESC Enrollment_Attribute_A_Desc Descriptor for ENROLLMENT_ATT_A value VARCHAR2(2CHAR)

ENROLLMENT_ATT_B Enrollment_Attribute_B Identifies if a student is on Clinical ('CL'), Co-op ('CO') or ('SA') in Sub Academic Period/Part of Term '2B' (meaning the second half of a semester) for the given academic term. VARCHAR2(2CHAR)

ENROLLMENT_ATT_B_DESC Enrollment_Attribute_B_Desc Descriptor for ENROLLMENT_ATT_B value VARCHAR2(2CHAR)

ENROLLMENT_ATT_FULL Enrollment_Attribute_Full Identifies if a student is on Clinical ('CL'), Co-op ('CO') or ('SA') in Sub Academic Period/Part of Term '1' or '1L' (meaning a full term) in the given academic term. VARCHAR2(2CHAR)

ENROLLMENT_ATT_FULL_DESC Enrollment_Attribute_Full_Desc Descriptor for ENROLLMENT_ATT_FULL value VARCHAR2(2CHAR)

ENROLLMENT_STATUS Identifies student enrollment code for given term, such as: EL = Eligible to Register, LA = Leave of Absence, WD = Withdrawn After Stats, WX = Withdrawn Prior to Stats. HISTORICAL. Before Summer 2026 it also contained enrollment status codes for the term in Clinical = CL, Coop = CO, Study Abroad = SA. VARCHAR2(63 CHAR)

ENROLLMENT_STATUS_DESC Description for student enrollment status VARCHAR2(255 CHAR)

EVENT A description of the predefined freeze event as one of stat date freeze, degree data freeze, end of term freeze, etc. VARCHAR2(63 CHAR)

EXPECTED GRADUATION DATE A student's estimated date of graduation based on admitted date and Pattern of Attendance for undergraduate (Student Level = UG) or entry term and length of program for graduate and Law (Student Level = GR/LAW). Valid Values Sample 5/20/2000 0:00 1/7/2011 0:00 8/29/2013 0:00 4/13/2017 0:00 5/7/2020 0:00 DATE

FIRST_CONCENTRATION_1 First concentration attached to the primary major. VARCHAR2(63 CHAR)

FIRST_CONCENTRATION_DESC_1 Description for First Concentration Nu1. VARCHAR2(255 CHAR)

FIRST_MINOR_1 First Minor attached to a primary program. VARCHAR2(63 CHAR)

FIRST_MINOR_DESC_1 Description for First Minor. VARCHAR2(255 CHAR)

FIRST_NAME The first name given to a person at birth, baptism, another naming ceremony or through legal change. VARCHAR2(63 CHAR)

GPA GPA for the student level. Calculated by dividing quality points by GPA credit hours for the level of student. NUMBER(11,3)

HOME_CITY Student permanent (home) address city. VARCHAR2(100 CHAR)

HOME_COUNTRY Student permanent home address country. VARCHAR2(100 CHAR)

HOME_STATE Student permanent (home) address state. VARCHAR2(100 CHAR)

HOME_STREET Student permanent (home) street1 address. VARCHAR2(255 CHAR)

HOME_ZIP Student permanent (home) address zip code. VARCHAR2(50 CHAR)

LAST_NAME The last name (surname) by which a person is known. VARCHAR2(63 CHAR)

MAJOR This field identifies the primary major within the primary curriculum for the effective term. VARCHAR2(63 CHAR)

MAJOR_DESC Description for Major Nu1 VARCHAR2(255 CHAR)

NUID Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent. VARCHAR2(10 CHAR)

PERSON_UID System generated Banner unique ID which gets assigned to all person and non-person records within Banner. NUMBER (8)

PRIMARY_PROGRAM The combination of student level, course level, college and degree. Tied to (via curriculum rules) majors, minors, and concentrations. VARCHAR2(63 CHAR)

PRIMARY_PROGRAM_DESC Description for Program Classification VARCHAR2(255 CHAR)

SECOND_CONCENTRATION_1 Second Concentration attached to the primary major. VARCHAR2(63 CHAR)

SECOND_CONCENTRATION_DESC_1 Description for Second Concentration Nu1. VARCHAR2(255 CHAR)

SECOND_MINOR_1 Second Minor attached to a primary program. VARCHAR2(63 CHAR)

SECOND_MINOR_DESC_1 Description for Second Minor. VARCHAR2(255 CHAR)

SERT_HOURS_CONCAT This field identifies the number of credit hours NUMBER (9)

SGRVETN_ACTIVITY_DATE_CONCAT This field contains a concatenation the date(s) record was created or changed. This field does not display on this form. DATE

SGRVETN_SERT_DATE_CONCAT This field contains a concatenation of the date(s) record was certified or changed. This field does not display on this form. VARCHAR2(63 CHAR)

STUDENT_ATTRIBUTE A concatenation of the student attributes. Attribute concatenation begins with 201425 academic term freeze. VARCHAR2(63 CHAR)

STUDENT_ATTRIBUTE_DESC A concatenation of the student attributes. Attribute concatenation begins with 201425 academic term freeze. VARCHAR2(255 CHAR)

STUDENT_LEVEL This field identifies the level of the student for the effective term as one of CP(Continuing Education CPS), UP(CPS - Undergraduate), GP(CPS - Graduate), UG(Undergraduate Day), GR(Graduate Day), LW(Law), US(Undergraduate Specialty Programs), GS(Graduate Specialty Programs) VARCHAR2(63 CHAR)

STUDENT_LEVEL_DESC Description for Student Level VARCHAR2(255 CHAR)

STUDENT_POPULATION This field identifies the student type for the effective term, such as: N = New, C = Continuing, S = Special, X = Exchange VARCHAR2(63 CHAR)

STUDENT_POPULATION_DESC Description for Student Population. VARCHAR2(255 CHAR)

STUDENT_RESIDENCY Residency of the student as one of: F, I, J, P VARCHAR2(63 CHAR)

STUDENT_RESIDENCY_DESC Description for Student Residency Values: F: full-time I: full-time international P: part-time J: part-time international. VARCHAR2(255 CHAR)

SURROGATE_ID_CONCAT A concatenation of the veteran or military affiliated ID codes. VARCHAR2(63 CHAR)

THIRD_CONCENTRATION_1 Third Concentration attached to the primary major. VARCHAR2(63 CHAR)

THIRD_CONCENTRATION_DESC_1 Third Concentration Description. VARCHAR2(255 CHAR)

THIRD_MINOR_1 Third minor for the primary program. VARCHAR2(63 CHAR)

THIRD_MINOR_DESC_1 Description of third minor. VARCHAR2(255 CHAR)

VETERAN_CODE_CONCAT A concatenation of the veteran or military affiliated financial assistance codes. Valid values Sample A N E M 2 4 D R V C W 0 1 3 5 7 Valid values Sample A N E M 2 4 D R V C W 0 1 3 5 7 VARCHAR2 (1)

VETERAN_CODE_DESC_CONCAT A concatenation of the veteran or military affiliated financial assistance definitions. Valid values Sample Active Duty Non Active Duty Military Tuition Assistance Post 911 Dependent Post 911 Veteran Chapter 35 (DEA) REAP VEAP Chapter 1601 VRAP Vocational Rehabilitation Post 911 Montgomery GI Bill Dependent Yellow Ribbon VARCHAR2(63 CHAR)

VETERAN_IND Indicates that the student is a military veteran. VARCHAR2(10 CHAR)

VETERAN_IND_DESC Description for Veteran IND VARCHAR2(63 CHAR)

VETERAN_SERT_DATE_CONCAT This field contains a concatenation the date(s) student was certified to be eligible. VARCHAR2(63 CHAR)

Ver: 9.0

Target Column	Business Name	Business Definition	Database Data Type
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(63 CHAR)
ACADEMIC_PERIOD_ADMITTED_DESC		Description for Academic Period Admitted	VARCHAR2(255 CHAR)
ACADEMIC_PERIOD_NUFREEZE		Academic term when student data was frozen corresponding to event in the academic calendar (defined by student level)	VARCHAR2(10 CHAR)
ACADEMIC_PERIOD_NUFREEZE_DESC		Description for Academic Period	VARCHAR2(255 CHAR)
COLLEGE		This field identifies the college associated with the student's primary curriculum for the effective term.	VARCHAR2(63 CHAR)
COLLEGE_DESC		Description for College	VARCHAR2(255 CHAR)
COURSE_CREDITS_FULL	Course_Credits_Full	Sum of academic credits for classes taken by a student that are held during a full semester (Sub Academic Period/Part of Term '1' or '1L') in the given academic term
COURSE_CREDITS_PT_A	Course_Credits_PT_A	Sum of academic credits for classes that are held during the first half (Sub Academic Period/Part of Term '2A') of the given academic term
COURSE_CREDITS_PT_B	Course_Credits_PT_B	Sum of academic credits for classes that are held during the second half (Sub Academic Period/Part of Term '2B') of the given academic term
DEGREE		Degree or award code associated with the student's academic study.	VARCHAR2(63 CHAR)
DEGREE_DESC		Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.	VARCHAR2(63 CHAR)
ENROLLMENT_ATT_A	Enrollment_Attribute_A	Identifies if a student is on Clinical ('CL'), Co-op ('CO') or ('SA') in Sub Academic Period/Part of Term '2A' (meaning the first half of a semester) for the given academic term.	VARCHAR2(2CHAR)
ENROLLMENT_ATT_A_DESC	Enrollment_Attribute_A_Desc	Descriptor for ENROLLMENT_ATT_A value	VARCHAR2(2CHAR)
ENROLLMENT_ATT_B	Enrollment_Attribute_B	Identifies if a student is on Clinical ('CL'), Co-op ('CO') or ('SA') in Sub Academic Period/Part of Term '2B' (meaning the second half of a semester) for the given academic term.	VARCHAR2(2CHAR)
ENROLLMENT_ATT_B_DESC	Enrollment_Attribute_B_Desc	Descriptor for ENROLLMENT_ATT_B value	VARCHAR2(2CHAR)
ENROLLMENT_ATT_FULL	Enrollment_Attribute_Full	Identifies if a student is on Clinical ('CL'), Co-op ('CO') or ('SA') in Sub Academic Period/Part of Term '1' or '1L' (meaning a full term) in the given academic term.	VARCHAR2(2CHAR)
ENROLLMENT_ATT_FULL_DESC	Enrollment_Attribute_Full_Desc	Descriptor for ENROLLMENT_ATT_FULL value	VARCHAR2(2CHAR)
ENROLLMENT_STATUS		Identifies student enrollment code for given term, such as: EL = Eligible to Register, LA = Leave of Absence, WD = Withdrawn After Stats, WX = Withdrawn Prior to Stats. HISTORICAL. Before Summer 2026 it also contained enrollment status codes for the term in Clinical = CL, Coop = CO, Study Abroad = SA.	VARCHAR2(63 CHAR)
ENROLLMENT_STATUS_DESC		Description for student enrollment status	VARCHAR2(255 CHAR)
EVENT		A description of the predefined freeze event as one of stat date freeze, degree data freeze, end of term freeze, etc.	VARCHAR2(63 CHAR)
EXPECTED GRADUATION DATE		A student's estimated date of graduation based on admitted date and Pattern of Attendance for undergraduate (Student Level = UG) or entry term and length of program for graduate and Law (Student Level = GR/LAW). Valid Values Sample 5/20/2000 0:00 1/7/2011 0:00 8/29/2013 0:00 4/13/2017 0:00 5/7/2020 0:00	DATE
FIRST_CONCENTRATION_1		First concentration attached to the primary major.	VARCHAR2(63 CHAR)
FIRST_CONCENTRATION_DESC_1		Description for First Concentration Nu1.	VARCHAR2(255 CHAR)
FIRST_MINOR_1		First Minor attached to a primary program.	VARCHAR2(63 CHAR)
FIRST_MINOR_DESC_1		Description for First Minor.	VARCHAR2(255 CHAR)
FIRST_NAME		The first name given to a person at birth, baptism, another naming ceremony or through legal change.	VARCHAR2(63 CHAR)
GPA		GPA for the student level. Calculated by dividing quality points by GPA credit hours for the level of student.	NUMBER(11,3)
HOME_CITY		Student permanent (home) address city.	VARCHAR2(100 CHAR)
HOME_COUNTRY		Student permanent home address country.	VARCHAR2(100 CHAR)
HOME_STATE		Student permanent (home) address state.	VARCHAR2(100 CHAR)
HOME_STREET		Student permanent (home) street1 address.	VARCHAR2(255 CHAR)
HOME_ZIP		Student permanent (home) address zip code.	VARCHAR2(50 CHAR)
LAST_NAME		The last name (surname) by which a person is known.	VARCHAR2(63 CHAR)
MAJOR		This field identifies the primary major within the primary curriculum for the effective term.	VARCHAR2(63 CHAR)
MAJOR_DESC		Description for Major Nu1	VARCHAR2(255 CHAR)
NUID		Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent.	VARCHAR2(10 CHAR)
PERSON_UID		System generated Banner unique ID which gets assigned to all person and non-person records within Banner.	NUMBER (8)
PRIMARY_PROGRAM		The combination of student level, course level, college and degree. Tied to (via curriculum rules) majors, minors, and concentrations.	VARCHAR2(63 CHAR)
PRIMARY_PROGRAM_DESC		Description for Program Classification	VARCHAR2(255 CHAR)
SECOND_CONCENTRATION_1		Second Concentration attached to the primary major.	VARCHAR2(63 CHAR)
SECOND_CONCENTRATION_DESC_1		Description for Second Concentration Nu1.	VARCHAR2(255 CHAR)
SECOND_MINOR_1		Second Minor attached to a primary program.	VARCHAR2(63 CHAR)
SECOND_MINOR_DESC_1		Description for Second Minor.	VARCHAR2(255 CHAR)
SERT_HOURS_CONCAT		This field identifies the number of credit hours	NUMBER (9)
SGRVETN_ACTIVITY_DATE_CONCAT		This field contains a concatenation the date(s) record was created or changed. This field does not display on this form.	DATE
SGRVETN_SERT_DATE_CONCAT		This field contains a concatenation of the date(s) record was certified or changed. This field does not display on this form.	VARCHAR2(63 CHAR)
STUDENT_ATTRIBUTE		A concatenation of the student attributes. Attribute concatenation begins with 201425 academic term freeze.	VARCHAR2(63 CHAR)
STUDENT_ATTRIBUTE_DESC		A concatenation of the student attributes. Attribute concatenation begins with 201425 academic term freeze.	VARCHAR2(255 CHAR)
STUDENT_LEVEL		This field identifies the level of the student for the effective term as one of CP(Continuing Education CPS), UP(CPS - Undergraduate), GP(CPS - Graduate), UG(Undergraduate Day), GR(Graduate Day), LW(Law), US(Undergraduate Specialty Programs), GS(Graduate Specialty Programs)	VARCHAR2(63 CHAR)
STUDENT_LEVEL_DESC		Description for Student Level	VARCHAR2(255 CHAR)
STUDENT_POPULATION		This field identifies the student type for the effective term, such as: N = New, C = Continuing, S = Special, X = Exchange	VARCHAR2(63 CHAR)
STUDENT_POPULATION_DESC		Description for Student Population.	VARCHAR2(255 CHAR)
STUDENT_RESIDENCY		Residency of the student as one of: F, I, J, P	VARCHAR2(63 CHAR)
STUDENT_RESIDENCY_DESC		Description for Student Residency Values: F: full-time I: full-time international P: part-time J: part-time international.	VARCHAR2(255 CHAR)
SURROGATE_ID_CONCAT		A concatenation of the veteran or military affiliated ID codes.	VARCHAR2(63 CHAR)
THIRD_CONCENTRATION_1		Third Concentration attached to the primary major.	VARCHAR2(63 CHAR)
THIRD_CONCENTRATION_DESC_1		Third Concentration Description.	VARCHAR2(255 CHAR)
THIRD_MINOR_1		Third minor for the primary program.	VARCHAR2(63 CHAR)
THIRD_MINOR_DESC_1		Description of third minor.	VARCHAR2(255 CHAR)
VETERAN_CODE_CONCAT		A concatenation of the veteran or military affiliated financial assistance codes. Valid values Sample A N E M 2 4 D R V C W 0 1 3 5 7 Valid values Sample A N E M 2 4 D R V C W 0 1 3 5 7	VARCHAR2 (1)
VETERAN_CODE_DESC_CONCAT		A concatenation of the veteran or military affiliated financial assistance definitions. Valid values Sample Active Duty Non Active Duty Military Tuition Assistance Post 911 Dependent Post 911 Veteran Chapter 35 (DEA) REAP VEAP Chapter 1601 VRAP Vocational Rehabilitation Post 911 Montgomery GI Bill Dependent Yellow Ribbon	VARCHAR2(63 CHAR)
VETERAN_IND		Indicates that the student is a military veteran.	VARCHAR2(10 CHAR)
VETERAN_IND_DESC		Description for Veteran IND	VARCHAR2(63 CHAR)
VETERAN_SERT_DATE_CONCAT		This field contains a concatenation the date(s) student was certified to be eligible.	VARCHAR2(63 CHAR)