Reporting View Target: Z_NEU_CLASS_DAILY_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_CLASS_DAILY_VW - Class Daily

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) 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)

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

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)

ACADEMIC_PERIOD_NUFREEZE_DESC Academic_Period_NUFreeze_Desc Description for Academic Period NUFreeze VARCHAR2(255)

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

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

ACADEMIC_RANK_DESC Description for Academic Rank VARCHAR2(63)

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 Building1 Building code used to schedule and track locations of courses VARCHAR2(63)

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

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

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

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

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

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

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

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

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

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

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

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

CAMPUS_DESC Description for campus code. VARCHAR2(255)

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

COLLEGE_DESC A description for College VARCHAR2(255)

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

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

CORE_CAPSTONE_IND CORE_CAPSTONE_IND Records if class fulfills Capstone requirement.

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

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

COURSE_LEVEL Currently Under Review VARCHAR2(63)

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_DESC Currently Under Review VARCHAR2(255)

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 Number identifying the course within the subject. VARCHAR2(63)

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 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)

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 Academic department responsible for the instructional delivery of this offering. VARCHAR2(63) STVDEPT

DEPARTMENT_DESC Description for Department VARCHAR2(255)

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

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

FACULTY_MEMBER_CATEGORY_DESC Description for faculty member category VARCHAR2(255)

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

FREEZE_DATE Actual date the data was frozen DATE

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

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

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 Method of content delivery for this class. VARCHAR2(5) GTVINSM

INSTRUCTIONAL_METHOD_DESC Description for Instructional Method VARCHAR2(255)

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

INSTRUCTOR_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)

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

INSTRUCTOR_HR_DIV_DESC Description of INSTRUCTOR_HR_DIV VARCHAR2(63)

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

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

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

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

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

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

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

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

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

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

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

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

PERSON_UID System generated Banner unique ID which gets assigned to all person and non-person records within Banner. 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 This field identifies first name of the primary instructor. VARCHAR2(63)

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

PRIMARY_INSTRUCTOR_NUID Currently Under Review VARCHAR2(63)

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

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

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

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

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

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

SCHEDULE Identifies the type of the class (lab, lecture, off-campus, internet, etc.) VARCHAR2(63) 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)

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)

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)

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)

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)

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)

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(255)

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)

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)

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)

SCHEDULE_DESC Description for Schedule. VARCHAR2(255)

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 First date of classes for a specific section. DATE

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

STATUS_DESC Description for Status VARCHAR2(255)

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

SUBJECT_DESC Description for Subject VARCHAR2(63)

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

SUB_ACADEMIC_PERIOD_DESC Description of Sub Academic Period VARCHAR2(255)

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

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

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 Number of undergraduate day students enrolled in this class. NUMBER(5)

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 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)
ACADEMIC_PERIOD_DESC	Academic_Period_Enroll_Desc	A description for the Academic Period	VARCHAR2(255)
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)
ACADEMIC_PERIOD_NUFREEZE_DESC	Academic_Period_NUFreeze_Desc	Description for Academic Period NUFreeze	VARCHAR2(255)
ACADEMIC_PERIOD_WEEKS		Number of weeks the section is meeting.	NUMBER(3)
ACADEMIC_RANK		A code representing faculty designation-rank in a college or university.	VARCHAR2(4)
ACADEMIC_RANK_DESC		Description for Academic Rank	VARCHAR2(63)
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	Building1	Building code used to schedule and track locations of courses	VARCHAR2(63)
BUILDING2	Building2	Building code used to schedule and track locations of courses	VARCHAR2(63)
BUILDING3	Building3	Building code used to schedule and track locations of courses	VARCHAR2(63)
BUILDING4	Building4	Building code used to schedule and track locations of courses	VARCHAR2(63)
BUILDING5	Building5	Building code used to schedule and track locations of courses	VARCHAR2(63)
BUILDING6	Building6	Building code used to schedule and track locations of courses	VARCHAR2(63)
BUILDING_DESC1	Building_Desc1	Building Description translation for Building Codes used in the scheduling of courses for the term	VARCHAR2(255)
BUILDING_DESC2	Building_Desc2	Building Description translation for Building Codes used in the scheduling of courses for the term	VARCHAR2(255)
BUILDING_DESC3	Building_Desc3	Building Description translation for Building Codes used in the scheduling of courses for the term	VARCHAR2(255)
BUILDING_DESC4	Building_Desc4	Building Description translation for Building Codes used in the scheduling of courses for the term	VARCHAR2(255)
BUILDING_DESC5	Building_Desc5	Building Description translation for Building Codes used in the scheduling of courses for the term	VARCHAR2(255)
BUILDING_DESC6	Building_Desc6	Building Description translation for Building Codes used in the scheduling of courses for the term	VARCHAR2(255)
CAMPUS		Code defines campus at which a class is being offered. Can either be a physical location or virtual for online classes.	VARCHAR2(63)	STVCAMP
CAMPUS_DESC		Description for campus code.	VARCHAR2(255)
COLLEGE		College or school which is offering the class	VARCHAR2(63)	STVCOLL
COLLEGE_DESC		A description for College	VARCHAR2(255)
CONTINUING_EDUCATION_IND		Indicates whether or not the class is offered for continuing education credit.	VARCHAR2(1)
COOPERATIVE_EDUCATION_IND		Indicates that the class is a coop placement	VARCHAR2(1)
CORE_CAPSTONE_IND	CORE_CAPSTONE_IND	Records if class fulfills Capstone requirement.
COURSE_CLASSIFICATION_GROUPING		Grouping by course classification by Lower(freshman, sophomore), Upper (junior, senior), graduate courses	VARCHAR2(63)
COURSE_IDENTIFICATION		Combined subject code and course number that identifies the instructional content of this course.	VARCHAR2(255)
COURSE_LEVEL		Currently Under Review	VARCHAR2(63)
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_DESC		Currently Under Review	VARCHAR2(255)
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		Number identifying the course within the subject.	VARCHAR2(63)
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		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)
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		Academic department responsible for the instructional delivery of this offering.	VARCHAR2(63)	STVDEPT
DEPARTMENT_DESC		Description for Department	VARCHAR2(255)
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
FACULTY_MEMBER_CATEGORY		Category assigned to the faculty or academic staff member.	VARCHAR2(63)
FACULTY_MEMBER_CATEGORY_DESC		Description for faculty member category	VARCHAR2(255)
FACULTY_TENURE		Tenure is an employee status with respect to permanence of their position.	VARCHAR2(63)
FREEZE_DATE		Actual date the data was frozen	DATE
FULL_PART_TIME_IND		Indicates whether the instructor is full or part time faculty.	VARCHAR2(5)
GP_ENROLLMENT		The number of CPS graduate students enrolled in this class.	NUMBER(5)
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		Method of content delivery for this class.	VARCHAR2(5)	GTVINSM
INSTRUCTIONAL_METHOD_DESC		Description for Instructional Method	VARCHAR2(255)
INSTRUCTOR_HR_DEPTID		HR department ID of the faculty member identified as the primary instructor of the class.	VARCHAR2(10)
INSTRUCTOR_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)
INSTRUCTOR_HR_DIV		Faculty member's primary Division Code, from Workday	VARCHAR2(10)
INSTRUCTOR_HR_DIV_DESC		Description of INSTRUCTOR_HR_DIV	VARCHAR2(63)
INSTRUCTOR_JOB_GRADE		The employee identifier which indicates broad job function and hierarchy within that function.	VARCHAR2(3)
INSTRUCTOR_ROLE		Instructor's Role as one of Staff, faculty, SGA	VARCHAR2(10)
LW_ENROLLMENT		Number of students enrolled from the School of Law	NUMBER(5)
MAXIMUM_ENROLLMENT		Sets the maximum enrollment allowed for a class section.	NUMBER(5)
MAX_BILLING		Maximum number of billing hours for this class section.	NUMBER(11,3)
MAX_CREDITS		Maximum number of credit hours for which this class may be offered	NUMBER(11,3)
MAX_LAB_HOURS		Maximum number of lab hours for which this class is offered.	NUMBER(11,3)
MEETING_TIME		Indicates the day(s) and time(s) this class meets.	VARCHAR2(255)
MIN_BILLING		Minimum number of billing hours for this class section.	NUMBER(11,3)
MIN_CREDITS		Minimum number of academic credit hours for which this class may be offered.	NUMBER(11,3)
MIN_LAB_HOURS		Minimum number of lab hours for which this class may be offered	NUMBER(11,3)
OFFERING_NUMBER		The two digit number identifying this particular section of the course.	VARCHAR2(63 BYTE)
PERSON_UID		System generated Banner unique ID which gets assigned to all person and non-person records within Banner.	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		This field identifies first name of the primary instructor.	VARCHAR2(63)
PRIMARY_INSTRUCTOR_LAST_NAME		This field identifies the last name of the primary instructor.	VARCHAR2(63)
PRIMARY_INSTRUCTOR_NUID		Currently Under Review	VARCHAR2(63)
ROOM1	Room1	Room Number code in conjunction with Building code & Building Description. Provides exact location of courses offered for a given term.	VARCHAR2(63)
ROOM2	Room2	Room Number code in conjunction with Building code & Building Description. Provides exact location of courses offered for a given term.	VARCHAR2(63)
ROOM3	Room3	Room Number code in conjunction with Building code & Building Description. Provides exact location of courses offered for a given term.	VARCHAR2(63)
ROOM4	Room4	Room Number code in conjunction with Building code & Building Description. Provides exact location of courses offered for a given term.	VARCHAR2(63)
ROOM5	Room5	Room Number code in conjunction with Building code & Building Description. Provides exact location of courses offered for a given term.	VARCHAR2(63)
ROOM6	Room6	Room Number code in conjunction with Building code & Building Description. Provides exact location of courses offered for a given term.	VARCHAR2(63)
SCHEDULE		Identifies the type of the class (lab, lecture, off-campus, internet, etc.)	VARCHAR2(63)	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)
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)
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)
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)
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)
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)
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(255)
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)
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)
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)
SCHEDULE_DESC		Description for Schedule.	VARCHAR2(255)
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		First date of classes for a specific section.	DATE
STATUS		Current class status as one of A or C.	VARCHAR2(63)	STVSSTS
STATUS_DESC		Description for Status	VARCHAR2(255)
SUBJECT		Instructional subject area for this class.	VARCHAR2(63)	STVSUBJ
SUBJECT_DESC		Description for Subject	VARCHAR2(63)
SUB_ACADEMIC_PERIOD		Defines the part of the term in which the class is offered.	VARCHAR2(63)
SUB_ACADEMIC_PERIOD_DESC		Description of Sub Academic Period	VARCHAR2(255)
TITLE_LONG_DESC		Unabbreviated class title, including some HTML coding so titles appear correctly on website.	VARCHAR2(255)
TITLE_SHORT_DESC		Abbreviated class title, limited to 30 characters.	VARCHAR2(255)
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		Number of undergraduate day students enrolled in this class.	NUMBER(5)
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		Number of undergraduate specialty program students enrolled in this class.	NUMBER(5)