Reporting View Target: Z_NEU_CENSUS_CLASS_VW

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_CENSUS_CLASS_VW - Class Census

Description Provides snapshot of detailed class/course related information offered within each Academic Period. Examples: College, Course Number, Section Status Course Department, Instructor NUID(a link to employee attributes for faculty in HRM system). Data snapshots are taken at Census time(stat time) and End of Term starting from Fall 2009 going forward.

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

ACADEMIC_PERIOD Academic_Period_Enroll Period or time frame/Academic term when classes are offered VARCHAR2 (63 CHAR)

ACADEMIC_PERIOD_DESC Academic_Period_Enroll_Desc A description for the Academic Period VARCHAR2 (255 CHAR)

ACADEMIC_PERIOD_NUFREEZE Academic_Period_NUFreeze Academic term describes when course/class data was frozen corresponding to event in academic calendar (defined by student level). VARCHAR2 (63 CHAR)

ACADEMIC_PERIOD_NUFREEZE_DESC Academic_Period_NUFreeze_Desc Description for Academic Period NUFreeze VARCHAR2 (63 CHAR)

ACADEMIC_PERIOD_WEEKS Number of weeks the section is meeting. NUMBER (3)

ACADEMIC_RANK Primary_Instructor_Acad_Rank A code representing faculty designation-rank in a college or university. VARCHAR2 (4 CHAR)

ACADEMIC_RANK_DESC Primary_Instructor_Acad_Rank_Desc Description for Academic Rank VARCHAR2 (63 CHAR)

ACTUAL_ENROLLMENT Actual_Enrollment Total number of students enrolled in course section. The students counting in the actual enrollment have a course status defined to count as enrolled. NUMBER (5)

BUILDING1 Building Building code used to schedule and track locations of courses VARCHAR2 (63 CHAR)

BUILDING2 Building code used to schedule and track locations of courses VARCHAR2 (63 CHAR)

BUILDING3 Building code used to schedule and track locations of courses VARCHAR2 (63 CHAR)

BUILDING4 Building code used to schedule and track locations of courses VARCHAR2 (63 CHAR)

BUILDING5 Building code used to schedule and track locations of courses VARCHAR2 (63 CHAR)

BUILDING6 Building code used to schedule and track locations of courses VARCHAR2 (63 CHAR)

BUILDING_DESC1 Building_Description Building Description translation for Building Codes used in the scheduling of courses for the term VARCHAR2 (255 CHAR)

BUILDING_DESC2 Building Description translation for Building Codes used in the scheduling of courses for the term VARCHAR2 (255 CHAR)

BUILDING_DESC3 Building Description translation for Building Codes used in the scheduling of courses for the term VARCHAR2 (255 CHAR)

BUILDING_DESC4 Building Description translation for Building Codes used in the scheduling of courses for the term VARCHAR2 (255 CHAR)

BUILDING_DESC5 Building Description translation for Building Codes used in the scheduling of courses for the term VARCHAR2 (255 CHAR)

BUILDING_DESC6 Building Description translation for Building Codes used in the scheduling of courses for the term VARCHAR2 (255 CHAR)

CAMPUS Course_Campus_Code Code defines campus at which a class is being offered. Can either be a physical location or virtual for online classes. VARCHAR2 (63 CHAR) STVCAMP

CAMPUS_DESC Course_Campus_Desc Description for campus code. VARCHAR2 (255 CHAR)

COLLEGE Course_College_Code College or school which is offering the class VARCHAR2 (63 CHAR) STVCOLL

COLLEGE_DESC Course_College_Desc A description for College VARCHAR2 (255 CHAR)

CONTINUING_EDUCATION_IND Continuing_Ed_Ind Indicates whether or not the class is offered for continuing education credit. VARCHAR2 (1 CHAR)

COOPERATIVE_EDUCATION_IND Cooperative_Ed_Ind Indicates that the class is a coop placement VARCHAR2 (1 CHAR)

CORE_CAPSTONE_IND CORE_CAPSTONE_IND Records if class fulfills Capstone requirement

COURSE_CLASSIFICATION_GROUPING Course_Classification_Group Grouping by course classification by Lower(freshman, sophomore), Upper (junior, senior), graduate courses VARCHAR2 (63 CHAR)

COURSE_IDENTIFICATION Course_Identification Combined subject code and course number that identifies the instructional content of this course. VARCHAR2 (255 CHAR)

COURSE_LEVEL1 Code for a Course Level restriction placed on a class

COURSE_LEVEL2 Code for a Course Level restriction placed on a class

COURSE_LEVEL3 Code for a Course Level restriction placed on a class

COURSE_LEVEL4 Code for a Course Level restriction placed on a class

COURSE_LEVEL_DESC1 Description for COURSE_LEVEL1

COURSE_LEVEL_DESC2 Description for COURSE_LEVEL2

COURSE_LEVEL_DESC3 Description for COURSE_LEVEL3

COURSE_LEVEL_DESC4 Description for COURSE_LEVEL4

COURSE_NUMBER Course_Number Number identifying the course within the subject. VARCHAR2 (63 CHAR)

COURSE_NUMBER_COREQ COURSE_NUMBER_COREQ Course Number of class that must be co-registered with class in Course Number (e.g. class and lab that must be taken together).

COURSE_REFERENCE_NUMBER Course_Reference_Number Universally referred to as the 'CRN', this is a computer assigned internal unique 5 digit numeric identifier for the schedule offering for a specific section within a specific term. Please note: The course reference number for a given class will be different from term to term. VARCHAR2 (5 CHAR)

CP_ENROLLMENT CP_Enrollment Number of continuing education students in the class. NUMBER (5)

CROSS_LIST_MAXIMUM_ENROLLMENT Cross_List_Maximum_Enrollment
Business Definition
The total number of seats available for the jointly run class. The total enrollment for all sections of the jointly run class cannot exceed the Cross List Maximum Enrollment.

Valid Values
Sample
14
37
54
99
180
VARCHAR2(63)

DEPARTMENT Course_Department_Code Academic department responsible for the instructional delivery of this offering. VARCHAR2 (63 CHAR) STVDEPT

DEPARTMENT_DESC Course_Department_Desc Description for Department VARCHAR2 (255 CHAR)

END_DATE Class_End_Date Last date of classes for a specific section. Please Note: The end state for the class's final exam will be after the end date for the last lecture. DATE

EVENT Event A description for the predefined freeze event as one of: stat date freeze, end of term freeze. VARCHAR2 (63 CHAR)

FACULTY_MEMBER_CATEGORY Faculty_Member_Category Category assigned to the faculty or academic staff member. VARCHAR2 (63 CHAR)

FACULTY_MEMBER_CATEGORY_DESC Faculty_Member_Category_Desc Description for faculty member category VARCHAR2 (255 CHAR)

FACULTY_TENURE Faculty_Tenure_Status Tenure is an employee status with respect to permanence of their position. VARCHAR2 (63 CHAR)

FREEZE_DATE Freeze_Date Actual date the data was frozen DATE

FULL_PART_TIME_IND Instructor_Full_Part_Time_Ind Indicates whether the instructor is full or part time faculty. VARCHAR2 (5 CHAR)

GP_ENROLLMENT GP_Enrollment The number of CPS graduate students enrolled in this class. NUMBER (5)

GR_ENROLLMENT GR_Enrollment Number of graduate students (excluding CPS and Law) enrolled in this class. NUMBER (5)

HONORS_TYPE Honors_Type Indicates whether a course is part of the Honors program, and if so, what type of Honors course it is. There are Honors Department courses which are offered centrally and are unique to the Honors program, and there are Honors Section courses, which carry the same course numbers and departmental prefix as non-honors sections offered through the colleges but have a range of different distinctive profiles relative to other departmental courses: sometimes they have fewer students, they may use different source materials, or cover the subject matter in a modified way. If a course is not one of these two options, it will be designated as Not Honors. VARCHAR2(63)

INSTRUCTIONAL_METHOD Instructional_Method Method of content delivery for this class. VARCHAR2 (5 CHAR) GTVINSM

INSTRUCTIONAL_METHOD_DESC Instructional_Method_Desc Description for Instructional Method VARCHAR2 (255 CHAR)

INSTRUCTOR_HR_DEPTID Primary_Instr_HR_Dept_ID HR department ID of the faculty member identified as the primary instructor of the class. VARCHAR2 (10 CHAR)

INSTRUCTOR_HR_DEPT_DESC Primary_Instr_HR_Dept_Desc Description for Instructor HR Dept ID. Department descriptions differ in Fall 2011/Spring 2012 due to PeopleSoft conversion. Use department code rather than description when pulling data during this crossover time. VARCHAR2 (63 CHAR)

INSTRUCTOR_HR_DIV INSTRUCTOR_HR_DIV Faculty member's primary Division Code, from Workday VARCHAR2 (10 CHAR)

INSTRUCTOR_HR_DIV_DESC INSTRUCTOR_HR_DIV_DESC Description of INSTRUCTOR_HR_DIV VARCHAR2 (63 CHAR)

INSTRUCTOR_JOB_GRADE Primary_Instructor_Job_Grades The employee identifier which indicates broad job function and hierarchy within that function. VARCHAR2 (3 CHAR)

INSTRUCTOR_ROLE Primary_Instructor_Role Instructor's Role as one of Staff, faculty, SGA VARCHAR2 (10 CHAR)

LW_ENROLLMENT LW_Enrollment Number of students enrolled from the School of Law NUMBER (5)

MAXIMUM_ENROLLMENT Maximum_Enrollment Sets the maximum enrollment allowed for a class section. NUMBER (5)

MAX_BILLING Maximum_Billing_Hours Maximum number of billing hours for this class section. NUMBER (11, 3)

MAX_CREDITS Maximum_Credits Maximum number of credit hours for which this class may be offered NUMBER (11,3)

MAX_LAB_HOURS Maximum_Lab_Hours Maximum number of lab hours for which this class is offered. NUMBER (11,3)

MEETING_TIME Meeting_Time Indicates the day(s) and time(s) this class meets. VARCHAR2 (255 CHAR)

MIN_BILLING Minimum_Billing_Hours Minimum number of billing hours for this class section. NUMBER (11, 3)

MIN_CREDITS Minimum_Credits Minimum number of academic credit hours for which this class may be offered. NUMBER (11, 3)

MIN_LAB_HOURS Minimum_Lab_Hours Minimum number of lab hours for which this class may be offered NUMBER (11,3)

OFFERING_NUMBER Course_Section_Number The two digit number identifying this particular section of the course. VARCHAR2 (63)

PERSON_UID Primary_Instructor_PIDM System generated, unique, internal identification number assigned to the person. NUMBER (8)

POSITION_EMPL_CLASS
Business Definition
Employee class code. Organizes position information consistent with employee groupings. At the employee level, it's used to help determine controls for benefits, leave, payroll and self-service rules.
VARCHAR2(63 CHAR)

POSITION_EMPL_CLASS_DESC
Business Definition
Employee class description.
VARCHAR2(255 CHAR)

PRIMARY_INSTRUCTOR_FIRST_NAME Primary_Instructor_First_Name This field identifies first name of the primary instructor. VARCHAR2 (63 CHAR)

PRIMARY_INSTRUCTOR_LAST_NAME Primary_Instructor_Last_Name This field identifies the last name of the primary instructor. VARCHAR2 (63 CHAR)

PRIMARY_INSTRUCTOR_NUID Primary_Instructor_NUID Northeastern Identification number assigned to the primary instructor. VARCHAR2 (63 CHAR)

ROOM1 Room_Number Room Number code in conjunction with Building code & Building Description. Provides exact location of courses offered for a given term. VARCHAR2 (63 CHAR)

ROOM2 Room Number code in conjunction with Building code & Building Description. Provides exact location of courses offered for a given term. VARCHAR2 (63 CHAR)

ROOM3 Room Number code in conjunction with Building code & Building Description. Provides exact location of courses offered for a given term. VARCHAR2 (63 CHAR)

ROOM4 Room Number code in conjunction with Building code & Building Description. Provides exact location of courses offered for a given term. VARCHAR2 (63 CHAR)

ROOM5 Room Number code in conjunction with Building code & Building Description. Provides exact location of courses offered for a given term. VARCHAR2 (63 CHAR)

ROOM6 Room Number code in conjunction with Building code & Building Description. Provides exact location of courses offered for a given term. VARCHAR2 (63 CHAR)

SCHEDULE Course_Schedule_Code Identifies the type of the class (lab, lecture, off-campus, internet, etc) VARCHAR2 (63 CHAR) STVSCHD

SCHEDULE_ATTRIBUTE1 Schedule_Attribute1 Identifies one of many possible Scheduling Attributes to be tracked for detailed information pertaining to course/section for requirements and used for reporting groups of courses for curriculum purposes in a timely correlated with course record . Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for Scheduling 1 and Attribute 2 for Scheduling 2 ETC. VARCHAR2 (63 CHAR)

SCHEDULE_ATTRIBUTE2 Schedule_Attribute2 Identifies one of many possible Scheduling Attributes to be tracked for detailed information pertaining to course/section for requirements and used for reporting groups of courses for curriculum purposes in a timely correlated with course record . Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for Scheduling 1 and Attribute 2 for Scheduling 2 ETC. VARCHAR2 (63 CHAR)

SCHEDULE_ATTRIBUTE3 Schedule_Attribute3 Identifies one of many possible Scheduling Attributes to be tracked for detailed information pertaining to course/section for requirements and used for reporting groups of courses for curriculum purposes in a timely correlated with course record . Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for Scheduling 1 and Attribute 2 for Scheduling 2 ETC. VARCHAR2 (63 CHAR)

SCHEDULE_ATTRIBUTE4 Schedule_Attribute4 Identifies one of many possible Scheduling Attributes to be tracked for detailed information pertaining to course/section for requirements and used for reporting groups of courses for curriculum purposes in a timely correlated with course record . Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for Scheduling 1 and Attribute 2 for Scheduling 2 ETC. VARCHAR2 (63 CHAR)

SCHEDULE_ATTRIBUTE5 Schedule_Attribute5 Identifies one of many possible Scheduling Attributes to be tracked for detailed information pertaining to course/section for requirements and used for reporting groups of courses for curriculum purposes in a timely correlated with course record . Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for Scheduling 1 and Attribute 2 for Scheduling 2 ETC. VARCHAR2 (63 CHAR)

SCHEDULE_ATTRIBUTE_DESC1 Schedule_Attribute_Desc1 Identifies one of many possible Scheduling Attributes to be tracked for detailed information pertaining to course/section for requirements and used for reporting groups of courses for curriculum purposes in a timely correlated with course record . Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for Scheduling 1 and Attribute 2 for Scheduling 2 ETC. VARCHAR2 (255 CHAR)

SCHEDULE_ATTRIBUTE_DESC2 Schedule_Attribute_Desc2 Identifies one of many possible Scheduling Attributes to be tracked for detailed information pertaining to course/section for requirements and used for reporting groups of courses for curriculum purposes in a timely correlated with course record . Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for Scheduling 1 and Attribute 2 for Scheduling 2 ETC. VARCHAR2 (255CHAR)

SCHEDULE_ATTRIBUTE_DESC3 Schedule_Attribute_Desc3 Identifies one of many possible Scheduling Attributes to be tracked for detailed information pertaining to course/section for requirements and used for reporting groups of courses for curriculum purposes in a timely correlated with course record . Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for Scheduling 1 and Attribute 2 for Scheduling 2 ETC. VARCHAR2 (255 CHAR)

SCHEDULE_ATTRIBUTE_DESC4 Schedule_Attribute_Desc4 Identifies one of many possible Scheduling Attributes to be tracked for detailed information pertaining to course/section for requirements and used for reporting groups of courses for curriculum purposes in a timely correlated with course record . Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for Scheduling 1 and Attribute 2 for Scheduling 2 ETC. VARCHAR2 (255 CHAR)

SCHEDULE_ATTRIBUTE_DESC5 Schedule_Attribute_Desc5 Identifies one of many possible Scheduling Attributes to be tracked for detailed information pertaining to course/section for requirements and used for reporting groups of courses for curriculum purposes in a timely correlated with course record . Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for Scheduling 1 and Attribute 2 for Scheduling 2 ETC. VARCHAR2 (255 CHAR)

SCHEDULE_DESC Course_Schedule_Desc Description for Schedule. VARCHAR2 (255, CHAR)

SECTION_CROSS_LIST Cross_Listed_Code
Business Definition
Two or more departments (can be within the same college or not) jointly offering the same class under the separate individual departments.

Please Note: Cross Listed courses are indicated by a Section Cross List code beginning with ‘X’, ‘Y’ or ‘Z’. Any other codes in this field should be ignored as they related to scheduling business processes and not to cross listed courses.

Valid Values
Sample
X0
XM
Y7
YA
Z1
VARCHAR2(63)

START_DATE Class_Start_Date First date of classes for a specific section. DATE

STATUS Section_Status_Code Current class status as one of A or C. VARCHAR2 (63 CHAR) STVSSTS

STATUS_DESC Section_Status_Desc Description for Status VARCHAR2 (255 CHAR)

SUBJECT Course_Subject_Code Instructional subject area for this class. VARCHAR2 (63 CHAR) STVSUBJ

SUBJECT_DESC Course_Subject_Desc Description for Subject VARCHAR2 (63 CHAR)

SUB_ACADEMIC_PERIOD Part_of_Term_Code Defines the part of the term in which the class is offered. VARCHAR2 (63 CHAR)

SUB_ACADEMIC_PERIOD_DESC Part_of_Term_Desc Description of Sub Academic Period VARCHAR2 (255 CHAR)

TITLE_LONG_DESC Course_Title_Long_Desc Unabbreviated class title, including some HTML coding so titles appear correctly on website. VARCHAR2 (255 CHAR)

TITLE_SHORT_DESC Title_Short_Desc Abbreviated class title, limited to 30 characters. VARCHAR2 (255 CHAR)

TOTAL_CREDIT_HOURS Generated_Credits Total credit hours for the class generated by actual enrollment. NUMBER (11, 3)

TOTAL_ENROLLMENT TOTAL_ENROLLMENT Total number of students enrolled in course section. The students counting in the actual enrollment have a course status defined to count as enrolled.

UC_ENROLLMENT Number of CPS Undergraduate Semester students enrolled in this class.
Note:
Beginning Fall 2016. NUMBER(5)

UG_ENROLLMENT UG_Enrollment Number of undergraduate day students enrolled in this class. NUMBER (5)

UP_ENROLLMENT UP_Enrollment Number of CPS undergraduate students enrolled in this class. CPS Undergrad term changed from Quarters to Semesters beginning Fall 2016. NUMBER (5)

US_ENROLLMENT US_Enrollment Number of undergraduate specialty program students enrolled in this class. NUMBER (5)

Ver: 9.0

Target Column	Business Name	Business Definition	Database Data Type	Domain Value
ACADEMIC_PERIOD	Academic_Period_Enroll	Period or time frame/Academic term when classes are offered	VARCHAR2 (63 CHAR)
ACADEMIC_PERIOD_DESC	Academic_Period_Enroll_Desc	A description for the Academic Period	VARCHAR2 (255 CHAR)
ACADEMIC_PERIOD_NUFREEZE	Academic_Period_NUFreeze	Academic term describes when course/class data was frozen corresponding to event in academic calendar (defined by student level).	VARCHAR2 (63 CHAR)
ACADEMIC_PERIOD_NUFREEZE_DESC	Academic_Period_NUFreeze_Desc	Description for Academic Period NUFreeze	VARCHAR2 (63 CHAR)
ACADEMIC_PERIOD_WEEKS		Number of weeks the section is meeting.	NUMBER (3)
ACADEMIC_RANK	Primary_Instructor_Acad_Rank	A code representing faculty designation-rank in a college or university.	VARCHAR2 (4 CHAR)
ACADEMIC_RANK_DESC	Primary_Instructor_Acad_Rank_Desc	Description for Academic Rank	VARCHAR2 (63 CHAR)
ACTUAL_ENROLLMENT	Actual_Enrollment	Total number of students enrolled in course section. The students counting in the actual enrollment have a course status defined to count as enrolled.	NUMBER (5)
BUILDING1	Building	Building code used to schedule and track locations of courses	VARCHAR2 (63 CHAR)
BUILDING2		Building code used to schedule and track locations of courses	VARCHAR2 (63 CHAR)
BUILDING3		Building code used to schedule and track locations of courses	VARCHAR2 (63 CHAR)
BUILDING4		Building code used to schedule and track locations of courses	VARCHAR2 (63 CHAR)
BUILDING5		Building code used to schedule and track locations of courses	VARCHAR2 (63 CHAR)
BUILDING6		Building code used to schedule and track locations of courses	VARCHAR2 (63 CHAR)
BUILDING_DESC1	Building_Description	Building Description translation for Building Codes used in the scheduling of courses for the term	VARCHAR2 (255 CHAR)
BUILDING_DESC2		Building Description translation for Building Codes used in the scheduling of courses for the term	VARCHAR2 (255 CHAR)
BUILDING_DESC3		Building Description translation for Building Codes used in the scheduling of courses for the term	VARCHAR2 (255 CHAR)
BUILDING_DESC4		Building Description translation for Building Codes used in the scheduling of courses for the term	VARCHAR2 (255 CHAR)
BUILDING_DESC5		Building Description translation for Building Codes used in the scheduling of courses for the term	VARCHAR2 (255 CHAR)
BUILDING_DESC6		Building Description translation for Building Codes used in the scheduling of courses for the term	VARCHAR2 (255 CHAR)
CAMPUS	Course_Campus_Code	Code defines campus at which a class is being offered. Can either be a physical location or virtual for online classes.	VARCHAR2 (63 CHAR)	STVCAMP
CAMPUS_DESC	Course_Campus_Desc	Description for campus code.	VARCHAR2 (255 CHAR)
COLLEGE	Course_College_Code	College or school which is offering the class	VARCHAR2 (63 CHAR)	STVCOLL
COLLEGE_DESC	Course_College_Desc	A description for College	VARCHAR2 (255 CHAR)
CONTINUING_EDUCATION_IND	Continuing_Ed_Ind	Indicates whether or not the class is offered for continuing education credit.	VARCHAR2 (1 CHAR)
COOPERATIVE_EDUCATION_IND	Cooperative_Ed_Ind	Indicates that the class is a coop placement	VARCHAR2 (1 CHAR)
CORE_CAPSTONE_IND	CORE_CAPSTONE_IND	Records if class fulfills Capstone requirement
COURSE_CLASSIFICATION_GROUPING	Course_Classification_Group	Grouping by course classification by Lower(freshman, sophomore), Upper (junior, senior), graduate courses	VARCHAR2 (63 CHAR)
COURSE_IDENTIFICATION	Course_Identification	Combined subject code and course number that identifies the instructional content of this course.	VARCHAR2 (255 CHAR)
COURSE_LEVEL1		Code for a Course Level restriction placed on a class
COURSE_LEVEL2		Code for a Course Level restriction placed on a class
COURSE_LEVEL3		Code for a Course Level restriction placed on a class
COURSE_LEVEL4		Code for a Course Level restriction placed on a class
COURSE_LEVEL_DESC1		Description for COURSE_LEVEL1
COURSE_LEVEL_DESC2		Description for COURSE_LEVEL2
COURSE_LEVEL_DESC3		Description for COURSE_LEVEL3
COURSE_LEVEL_DESC4		Description for COURSE_LEVEL4
COURSE_NUMBER	Course_Number	Number identifying the course within the subject.	VARCHAR2 (63 CHAR)
COURSE_NUMBER_COREQ	COURSE_NUMBER_COREQ	Course Number of class that must be co-registered with class in Course Number (e.g. class and lab that must be taken together).
COURSE_REFERENCE_NUMBER	Course_Reference_Number	Universally referred to as the 'CRN', this is a computer assigned internal unique 5 digit numeric identifier for the schedule offering for a specific section within a specific term. Please note: The course reference number for a given class will be different from term to term.	VARCHAR2 (5 CHAR)
CP_ENROLLMENT	CP_Enrollment	Number of continuing education students in the class.	NUMBER (5)
CROSS_LIST_MAXIMUM_ENROLLMENT	Cross_List_Maximum_Enrollment	Business Definition The total number of seats available for the jointly run class. The total enrollment for all sections of the jointly run class cannot exceed the Cross List Maximum Enrollment. Valid Values Sample 14 37 54 99 180	VARCHAR2(63)
DEPARTMENT	Course_Department_Code	Academic department responsible for the instructional delivery of this offering.	VARCHAR2 (63 CHAR)	STVDEPT
DEPARTMENT_DESC	Course_Department_Desc	Description for Department	VARCHAR2 (255 CHAR)
END_DATE	Class_End_Date	Last date of classes for a specific section. Please Note: The end state for the class's final exam will be after the end date for the last lecture.	DATE
EVENT	Event	A description for the predefined freeze event as one of: stat date freeze, end of term freeze.	VARCHAR2 (63 CHAR)
FACULTY_MEMBER_CATEGORY	Faculty_Member_Category	Category assigned to the faculty or academic staff member.	VARCHAR2 (63 CHAR)
FACULTY_MEMBER_CATEGORY_DESC	Faculty_Member_Category_Desc	Description for faculty member category	VARCHAR2 (255 CHAR)
FACULTY_TENURE	Faculty_Tenure_Status	Tenure is an employee status with respect to permanence of their position.	VARCHAR2 (63 CHAR)
FREEZE_DATE	Freeze_Date	Actual date the data was frozen	DATE
FULL_PART_TIME_IND	Instructor_Full_Part_Time_Ind	Indicates whether the instructor is full or part time faculty.	VARCHAR2 (5 CHAR)
GP_ENROLLMENT	GP_Enrollment	The number of CPS graduate students enrolled in this class.	NUMBER (5)
GR_ENROLLMENT	GR_Enrollment	Number of graduate students (excluding CPS and Law) enrolled in this class.	NUMBER (5)
HONORS_TYPE	Honors_Type	Indicates whether a course is part of the Honors program, and if so, what type of Honors course it is. There are Honors Department courses which are offered centrally and are unique to the Honors program, and there are Honors Section courses, which carry the same course numbers and departmental prefix as non-honors sections offered through the colleges but have a range of different distinctive profiles relative to other departmental courses: sometimes they have fewer students, they may use different source materials, or cover the subject matter in a modified way. If a course is not one of these two options, it will be designated as Not Honors.	VARCHAR2(63)
INSTRUCTIONAL_METHOD	Instructional_Method	Method of content delivery for this class.	VARCHAR2 (5 CHAR)	GTVINSM
INSTRUCTIONAL_METHOD_DESC	Instructional_Method_Desc	Description for Instructional Method	VARCHAR2 (255 CHAR)
INSTRUCTOR_HR_DEPTID	Primary_Instr_HR_Dept_ID	HR department ID of the faculty member identified as the primary instructor of the class.	VARCHAR2 (10 CHAR)
INSTRUCTOR_HR_DEPT_DESC	Primary_Instr_HR_Dept_Desc	Description for Instructor HR Dept ID. Department descriptions differ in Fall 2011/Spring 2012 due to PeopleSoft conversion. Use department code rather than description when pulling data during this crossover time.	VARCHAR2 (63 CHAR)
INSTRUCTOR_HR_DIV	INSTRUCTOR_HR_DIV	Faculty member's primary Division Code, from Workday	VARCHAR2 (10 CHAR)
INSTRUCTOR_HR_DIV_DESC	INSTRUCTOR_HR_DIV_DESC	Description of INSTRUCTOR_HR_DIV	VARCHAR2 (63 CHAR)
INSTRUCTOR_JOB_GRADE	Primary_Instructor_Job_Grades	The employee identifier which indicates broad job function and hierarchy within that function.	VARCHAR2 (3 CHAR)
INSTRUCTOR_ROLE	Primary_Instructor_Role	Instructor's Role as one of Staff, faculty, SGA	VARCHAR2 (10 CHAR)
LW_ENROLLMENT	LW_Enrollment	Number of students enrolled from the School of Law	NUMBER (5)
MAXIMUM_ENROLLMENT	Maximum_Enrollment	Sets the maximum enrollment allowed for a class section.	NUMBER (5)
MAX_BILLING	Maximum_Billing_Hours	Maximum number of billing hours for this class section.	NUMBER (11, 3)
MAX_CREDITS	Maximum_Credits	Maximum number of credit hours for which this class may be offered	NUMBER (11,3)
MAX_LAB_HOURS	Maximum_Lab_Hours	Maximum number of lab hours for which this class is offered.	NUMBER (11,3)
MEETING_TIME	Meeting_Time	Indicates the day(s) and time(s) this class meets.	VARCHAR2 (255 CHAR)
MIN_BILLING	Minimum_Billing_Hours	Minimum number of billing hours for this class section.	NUMBER (11, 3)
MIN_CREDITS	Minimum_Credits	Minimum number of academic credit hours for which this class may be offered.	NUMBER (11, 3)
MIN_LAB_HOURS	Minimum_Lab_Hours	Minimum number of lab hours for which this class may be offered	NUMBER (11,3)
OFFERING_NUMBER	Course_Section_Number	The two digit number identifying this particular section of the course.	VARCHAR2 (63)
PERSON_UID	Primary_Instructor_PIDM	System generated, unique, internal identification number assigned to the person.	NUMBER (8)
POSITION_EMPL_CLASS		Business Definition Employee class code. Organizes position information consistent with employee groupings. At the employee level, it's used to help determine controls for benefits, leave, payroll and self-service rules.	VARCHAR2(63 CHAR)
POSITION_EMPL_CLASS_DESC		Business Definition Employee class description.	VARCHAR2(255 CHAR)
PRIMARY_INSTRUCTOR_FIRST_NAME	Primary_Instructor_First_Name	This field identifies first name of the primary instructor.	VARCHAR2 (63 CHAR)
PRIMARY_INSTRUCTOR_LAST_NAME	Primary_Instructor_Last_Name	This field identifies the last name of the primary instructor.	VARCHAR2 (63 CHAR)
PRIMARY_INSTRUCTOR_NUID	Primary_Instructor_NUID	Northeastern Identification number assigned to the primary instructor.	VARCHAR2 (63 CHAR)
ROOM1	Room_Number	Room Number code in conjunction with Building code & Building Description. Provides exact location of courses offered for a given term.	VARCHAR2 (63 CHAR)
ROOM2		Room Number code in conjunction with Building code & Building Description. Provides exact location of courses offered for a given term.	VARCHAR2 (63 CHAR)
ROOM3		Room Number code in conjunction with Building code & Building Description. Provides exact location of courses offered for a given term.	VARCHAR2 (63 CHAR)
ROOM4		Room Number code in conjunction with Building code & Building Description. Provides exact location of courses offered for a given term.	VARCHAR2 (63 CHAR)
ROOM5		Room Number code in conjunction with Building code & Building Description. Provides exact location of courses offered for a given term.	VARCHAR2 (63 CHAR)
ROOM6		Room Number code in conjunction with Building code & Building Description. Provides exact location of courses offered for a given term.	VARCHAR2 (63 CHAR)
SCHEDULE	Course_Schedule_Code	Identifies the type of the class (lab, lecture, off-campus, internet, etc)	VARCHAR2 (63 CHAR)	STVSCHD
SCHEDULE_ATTRIBUTE1	Schedule_Attribute1	Identifies one of many possible Scheduling Attributes to be tracked for detailed information pertaining to course/section for requirements and used for reporting groups of courses for curriculum purposes in a timely correlated with course record . Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for Scheduling 1 and Attribute 2 for Scheduling 2 ETC.	VARCHAR2 (63 CHAR)
SCHEDULE_ATTRIBUTE2	Schedule_Attribute2	Identifies one of many possible Scheduling Attributes to be tracked for detailed information pertaining to course/section for requirements and used for reporting groups of courses for curriculum purposes in a timely correlated with course record . Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for Scheduling 1 and Attribute 2 for Scheduling 2 ETC.	VARCHAR2 (63 CHAR)
SCHEDULE_ATTRIBUTE3	Schedule_Attribute3	Identifies one of many possible Scheduling Attributes to be tracked for detailed information pertaining to course/section for requirements and used for reporting groups of courses for curriculum purposes in a timely correlated with course record . Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for Scheduling 1 and Attribute 2 for Scheduling 2 ETC.	VARCHAR2 (63 CHAR)
SCHEDULE_ATTRIBUTE4	Schedule_Attribute4	Identifies one of many possible Scheduling Attributes to be tracked for detailed information pertaining to course/section for requirements and used for reporting groups of courses for curriculum purposes in a timely correlated with course record . Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for Scheduling 1 and Attribute 2 for Scheduling 2 ETC.	VARCHAR2 (63 CHAR)
SCHEDULE_ATTRIBUTE5	Schedule_Attribute5	Identifies one of many possible Scheduling Attributes to be tracked for detailed information pertaining to course/section for requirements and used for reporting groups of courses for curriculum purposes in a timely correlated with course record . Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for Scheduling 1 and Attribute 2 for Scheduling 2 ETC.	VARCHAR2 (63 CHAR)
SCHEDULE_ATTRIBUTE_DESC1	Schedule_Attribute_Desc1	Identifies one of many possible Scheduling Attributes to be tracked for detailed information pertaining to course/section for requirements and used for reporting groups of courses for curriculum purposes in a timely correlated with course record . Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for Scheduling 1 and Attribute 2 for Scheduling 2 ETC.	VARCHAR2 (255 CHAR)
SCHEDULE_ATTRIBUTE_DESC2	Schedule_Attribute_Desc2	Identifies one of many possible Scheduling Attributes to be tracked for detailed information pertaining to course/section for requirements and used for reporting groups of courses for curriculum purposes in a timely correlated with course record . Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for Scheduling 1 and Attribute 2 for Scheduling 2 ETC.	VARCHAR2 (255CHAR)
SCHEDULE_ATTRIBUTE_DESC3	Schedule_Attribute_Desc3	Identifies one of many possible Scheduling Attributes to be tracked for detailed information pertaining to course/section for requirements and used for reporting groups of courses for curriculum purposes in a timely correlated with course record . Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for Scheduling 1 and Attribute 2 for Scheduling 2 ETC.	VARCHAR2 (255 CHAR)
SCHEDULE_ATTRIBUTE_DESC4	Schedule_Attribute_Desc4	Identifies one of many possible Scheduling Attributes to be tracked for detailed information pertaining to course/section for requirements and used for reporting groups of courses for curriculum purposes in a timely correlated with course record . Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for Scheduling 1 and Attribute 2 for Scheduling 2 ETC.	VARCHAR2 (255 CHAR)
SCHEDULE_ATTRIBUTE_DESC5	Schedule_Attribute_Desc5	Identifies one of many possible Scheduling Attributes to be tracked for detailed information pertaining to course/section for requirements and used for reporting groups of courses for curriculum purposes in a timely correlated with course record . Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for Scheduling 1 and Attribute 2 for Scheduling 2 ETC.	VARCHAR2 (255 CHAR)
SCHEDULE_DESC	Course_Schedule_Desc	Description for Schedule.	VARCHAR2 (255, CHAR)
SECTION_CROSS_LIST	Cross_Listed_Code	Business Definition Two or more departments (can be within the same college or not) jointly offering the same class under the separate individual departments. Please Note: Cross Listed courses are indicated by a Section Cross List code beginning with ‘X’, ‘Y’ or ‘Z’. Any other codes in this field should be ignored as they related to scheduling business processes and not to cross listed courses. Valid Values Sample X0 XM Y7 YA Z1	VARCHAR2(63)
START_DATE	Class_Start_Date	First date of classes for a specific section.	DATE
STATUS	Section_Status_Code	Current class status as one of A or C.	VARCHAR2 (63 CHAR)	STVSSTS
STATUS_DESC	Section_Status_Desc	Description for Status	VARCHAR2 (255 CHAR)
SUBJECT	Course_Subject_Code	Instructional subject area for this class.	VARCHAR2 (63 CHAR)	STVSUBJ
SUBJECT_DESC	Course_Subject_Desc	Description for Subject	VARCHAR2 (63 CHAR)
SUB_ACADEMIC_PERIOD	Part_of_Term_Code	Defines the part of the term in which the class is offered.	VARCHAR2 (63 CHAR)
SUB_ACADEMIC_PERIOD_DESC	Part_of_Term_Desc	Description of Sub Academic Period	VARCHAR2 (255 CHAR)
TITLE_LONG_DESC	Course_Title_Long_Desc	Unabbreviated class title, including some HTML coding so titles appear correctly on website.	VARCHAR2 (255 CHAR)
TITLE_SHORT_DESC	Title_Short_Desc	Abbreviated class title, limited to 30 characters.	VARCHAR2 (255 CHAR)
TOTAL_CREDIT_HOURS	Generated_Credits	Total credit hours for the class generated by actual enrollment.	NUMBER (11, 3)
TOTAL_ENROLLMENT	TOTAL_ENROLLMENT	Total number of students enrolled in course section. The students counting in the actual enrollment have a course status defined to count as enrolled.
UC_ENROLLMENT		Number of CPS Undergraduate Semester students enrolled in this class. Note: Beginning Fall 2016.	NUMBER(5)
UG_ENROLLMENT	UG_Enrollment	Number of undergraduate day students enrolled in this class.	NUMBER (5)
UP_ENROLLMENT	UP_Enrollment	Number of CPS undergraduate students enrolled in this class. CPS Undergrad term changed from Quarters to Semesters beginning Fall 2016.	NUMBER (5)
US_ENROLLMENT	US_Enrollment	Number of undergraduate specialty program students enrolled in this class.	NUMBER (5)