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)

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_STATUS Identifies student enrollment code for given term, such as: EL = Eligible, CO = Coop, SA = Study Abroad, LA = Leave of Absence 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 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)
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_STATUS	Identifies student enrollment code for given term, such as: EL = Eligible, CO = Coop, SA = Study Abroad, LA = Leave of Absence	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)