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

SGHE Banner Operational Data Store
Reporting View Target: SCHEDULE_OFFERING

Description Contains detail data for a section (schedule offering) of a subject or course within a specific time period like an academic period.
Key & Frequency One row per course reference number per academic period and sub academic period.
Recommended Search Columns ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER
SUBJECT, COURSE_NUMBER, ACADEMIC_PERIOD
COURSE_IDENTIFICATION

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ACADEMIC_PERIOD Academic Period Academic period or time frame this section or schedule offering was taught. VARCHAR2(63)  

SSBSECT

SSBSECT_TERM_CODE

ACADEMIC_PERIOD_DESC Academic Period Description Academic period description. VARCHAR2(255)  

STVTERM

STVTERM_DESC

ACADEMIC_PERIOD_WEEKS Academic Period Weeks Number of weeks associated with this academic period. For example, 16 week semester, 10 week quarter, etc. NUMBER  

SSBSECT

SSBSECT_PTRM_WEEKS

ACADEMIC_YEAR Academic Year Academic year associated with the academic period on this record. VARCHAR2(63)  

STVTERM

STVTERM_ACYR_CODE

ACADEMIC_YEAR_DESC Academic Year Description Academic year description. VARCHAR2(255)  

STVACYR

STVACYR_DESC

ACCOUNTING_METHOD Accounting Method Accounting method used for tracking attendance either weekly or daily. VARCHAR2(63)  

SSBSECT

SSBSECT_ACCT_CODE

ACCOUNTING_METHOD_DESC Accounting Method Description Accounting method description for this course. VARCHAR2(255)  

STVACCT

STVACCT_DESC

ACTIVE_OFFERING_IND Active Offering Indicator Indicates whether the section or schedule offering is active and may have students registered. VARCHAR2(1)  

FUNCTION

F_ACTIVE_SECTION_IND

ACTUAL_ENROLLMENT Actual Enrollment Total number of students enrolled in this schedule offering. The students counting in the actual enrollment have a course status defined to count as enrolled. NUMBER  

SSBSECT

SSBSECT_ENRL

ADMINISTRATIVE_GROUP Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)  

NA

NA

ATTRIBUTE_COUNT Attribute Count Count of course degree attributes recorded for the section or schedule offering. NUMBER  

FUNCTION

MSKFUNC.F_COUNT_COURSE_ATTRIBUTES

CAMPUS Campus Campus the student attended this schedule offering or section. VARCHAR2(63)  

SSBSECT

SSBSECT_CAMP_CODE

CAMPUS_DESC Campus Description Institution campus name. VARCHAR2(255)  

STVCAMP

STVCAMP_DESC

CATEGORY Category The session indicator associated with the assignment. VARCHAR2(2)  

SIRASGN

SIRASGN_CATEGORY

CENSUS_ENROLLMENT1 Census Enrollment 1 Total of students registered and counted in enrollment for the section or schedule offering through the defined census date. NUMBER  

SSBSECT

SSBSECT_CENSUS_ENRL

CENSUS_ENROLLMENT2 Census Enrollment 2 Total of students registered and counted in enrollment for the section or schedule offering through the second defined census date. NUMBER  

SSBSECT

SSBSECT_CENSUS_2_ENRL

CENSUS_ENROLLMENT_DATE1 Census Enrollment Date 1 First date used for official enrollment reporting in a time frame. All student registration through this date is counted in the census one enrollment count. DATE  

SSBSECT

SSBSECT_CENSUS_ENRL_DATE

CENSUS_ENROLLMENT_DATE2 Census Enrollment Date 2 Second date used for official enrollment reporting in a time frame. All student registration through this date is counted in the census two enrollment count. DATE  

SSBSECT

SSBSECT_CENSUS_2_DATE

COLLEGE College College, faculty or school to which the course instructional responsibility is associated. VARCHAR2(63)  

SSBOVRR

SSBOVRR_COLL_CODE

COLLEGE_DESC College Description College, faculty or school name. VARCHAR2(255)  

STVCOLL

STVCOLL_DESC

COURSE_CLASS_LEVEL Course Class Level Expected class (first year, second year, etc.) the enrollee is in when taking the course. VARCHAR2(63)  

NA

NA

COURSE_CLASS_LEVEL_DESC Course Class Level Description Class level code description. VARCHAR2(255)  

NA

NA

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

CALCULATION

SSBSECT_SUBJ_CODE||SSBSECT_CRSE_NUMB

COURSE_NUMBER Course Number Course number associated with the subject for the course. VARCHAR2(63)  

SCBCRSE

SSBSECT

SCBCRSE_CRSE_NUMB

SSBSECT_CRSE_NUMB

COURSE_REFERENCE_NUMBER Course Reference Number Computer assigned internal unique number for the schedule offering. VARCHAR2(5)  

SSBSECT

SSBSECT_CRN

COURSE_TEXT_NARRATIVE Narrative Course Text Text developed at the institution to describe the course and course content. CLOB  

SSBDESC

SSBDESC_TEXT_NARRATIVE

COURSE_VERSION Course Version Course version number. VARCHAR2(255)  

NA

NA

CROSS_LIST_ACTIVITY_DATE Cross List Activity Date Date record was inserted or updated. DATE  

SSBXLST

SSBXLST_ACTIVITY_DATE

CROSS_LIST_ENROLLMENT Cross List Enrollment Cross list section enrollment. NUMBER  

SSBXLST

SSBXLST_ENRL

CROSS_LIST_MAXIMUM_ENROLLMENT Cross List Maximum Enrollment Maximum seats available within any of the sections within a cross list code. NUMBER  

SSBXLST

SSBXLST_MAX_ENRL

CROSS_LIST_SEATS_AVAILABLE Cross List Seats Available Seats available for the sections within the cross list code. NUMBER  

SSBXLST

SSBXLST_SEATS_AVAIL

DEPARTMENT Department Department responsible for the instructional delivery of this offering. VARCHAR2(63)  

SSBOVRR

SSBOVRR_DEPT_CODE

DEPARTMENT_DESC Department Description Department name. VARCHAR2(255)  

STVDEPT

STVDEPT_DESC

DIVISION Division Division responsible for the instructional delivery of this course or section. VARCHAR2(63)  

SSBOVRR

SSBOVRR_DIVS_CODE

DIVISION_DESC Division Description Name of the division. VARCHAR2(255)  

STVDIVS

STVDIVS_DESC

DURATION Duration Indicates whether the course duration is in days, weeks, months, etc. VARCHAR2(255)  

SSBSECT

SSBSECT_DUNT_CODE

DURATION_UNITS Duration Units Indicates whether the course duration is in days, weeks, months, etc. NUMBER  

SSBSECT

SSBSECT_DUNT_CODE

END_DATE End Date End date for the section record. DATE  

SSBSECT

SSBSECT_PTRM_END_DATE

EXEMPT_TUITION_SECTION Exempt Tuition Section Specifies this section is exempt from the assessment of tuition and fee rules and only incurs any section fee charges. VARCHAR2(63)  

SSBSECT

SSBSECT_TUIW_IND

EXTENSIONS_MAX_DATE Extensions Maximum Date Latest date for instruction as calculated by an extension granted to a student. DATE  

NA

NA

EXTENSIONS_PERMITTED Extensions Permitted Number of extensions permitted to a student beyond the normal end date for the instruction. NUMBER  

SSBSECT

SSBSECT_NUMBER_OF_EXTENSIONS

GENERATED_CREDITS Generated Credits Number of enrolled students multiplied by the number of credits the offering is worth. NUMBER  

NA

SSBSECT

NA

SSBSECT_TOT_CREDIT_HRS

GRADABLE_IND Gradable Indicator Indicates whether the course can be graded. VARCHAR2(1)  

SSBSECT

SSBSECT_GRADABLE_IND

GRADE_TYPE Grade Type Grade type for the course. VARCHAR2(63)  

SSBSECT

SSBSECT_GMOD_CODE

GRADE_TYPE_COUNT Grade Type Count Count the number of grading types or modes for this section or schedule offering. NUMBER  

FUNCTION

MSKFUNC.F_COUNT_GRADE_TYPE

GRADE_TYPE_DESC Grade Type Description Grade type description. VARCHAR2(255)  

STVGMOD

STVGMOD_DESC

INSTRUCTION_METHOD Instruction Method Instructional method either assigned by the schedule type or manually assigned to the schedule offering when it was created that describes how instruction will be delivered. VARCHAR2(63)  

SSBSECT

SSBSECT_INSM_CODE

INSTRUCTION_METHOD_DESC Instruction Method Description Instruction method description. VARCHAR2(255)  

GTVINSM

GTVINSM_DESC

INSTRUCTOR_COUNT Instructor Count Count of instructors or academic staff members assigned to this section or schedule offering. NUMBER  

FUNCTION

MSKFUNC.F_COUNT_INSTRUCTOR

INTEGRATION_PARTNER Integration Partner Institution defined integration code that identifies an external partner used for instruction of this schedule offering. VARCHAR2(63)  

SSBSECT

SSBSECT_INTG_CDE

INTEGRATION_PARTNER_DESC Integration Partner Description Instruction integration partner description. VARCHAR2(255)  

GORINTG

GORINTG_DESC

INTEGRATION_PARTNER_SYSTEM Integration Partner System Institution defined integration system code that identifies an external partner systen used for instruction of this schedule offering. VARCHAR2(63)  

GORINTG

GORINTG_INTP_CODE

INTEGRATION_PARTNER_SYS_DESC Integration Partner System Description Instruction integration partner system description. VARCHAR2(255)  

GORINTG

GTVINTP_DESC

LINK_IDENTIFIER Link Identifier Links other sections of the same course which must be taken concurrently. VARCHAR2(2)  

SSBSECT

SSBSECT_LINK_IDENT

MAXIMUM_ENROLLMENT Maximum Enrollment Sets the maximum enrollment for an offering. NUMBER  

SSBSECT

SSBSECT_MAX_ENRL

MAX_BILLING Maximum Billing Second valid billing hour value or the high billing hour value within a range. NUMBER  

SSBSECT

SSBSECT_BILL_HRS

MAX_CONTACT_HOURS Maximum Contact Hours Second valid contact hour value or the high contact hour value within a range. NUMBER  

SSBSECT

SSBSECT_CONT_HR

MAX_CREDITS Maximum Credits Second valid credit hour value or the high credit hour value within a range. NUMBER  

SSBSECT

SSBSECT_CREDIT_HRS

MAX_LAB_HOURS Maximum Lab Hours Second valid lab hour value or the high lab hour value within a range. NUMBER  

SSBSECT

SSBSECT_LAB_HR

MAX_LECTURE_HOURS Maximum Lecture Hours Second valid lecture hour value or the high lecture hour value within a range. NUMBER  

SSBSECT

SSBSECT_LEC_HR

MAX_OTHER_HOURS Maximum Other Hours Second valid other hour value or the high other hour value within a range. NUMBER  

SSBSECT

SSBSECT_OTH_HR

MEETING_TIME_COUNT Meeting Time Count Count of meeting times assigned to the course but not reflected in this row. NUMBER  

FUNCTION

MSKFUNC.F_COUNT_MEETING_TIME

MINIMUM_ENROLLMENT Minimum Enrollment Sets the minimum enrollment allowed for an offering. VARCHAR2(255)  

NA

NA

MIN_BILLING Minimum Billing Minimum number of billing hours for which a course may be offered. NUMBER  

SSBSECT

SSBSECT_BILL_HRS

MIN_CONTACT_HOURS Minimum Contact Hours Minimum number of contact hours for which a course may be offered. NUMBER  

SSBSECT

SSBSECT_CONT_HR

MIN_CREDITS Minimum Credits Minimum number of credit hours for which a course may be offered. NUMBER  

SSBSECT

SSBSECT_CREDIT_HRS

MIN_LAB_HOURS Minimum Lab Hours Minimum number of lab hours for which a course may be offered. NUMBER  

SSBSECT

SSBSECT_LAB_HR

MIN_LECTURE_HOURS Minimum Lecture Hours Minimum number of lecture hours for which a course may be offered. NUMBER  

SSBSECT

SSBSECT_LEC_HR

MIN_OTHER_HOURS Minimum Other Hours Minimum number of other hours for which a course may be offered. NUMBER  

SSBSECT

SSBSECT_OTH_HR

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)  

NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)  

NA

NA

NON_TRADITIONAL_IND Non Traditional Indicator Indicates whether the course is a non-traditional course. VARCHAR2(1)  

NA

NA

OFFERING_COREQ_COUNT Offering Coreq Count Count of offering corequisites. NUMBER  

FUNCTION

MSKFUNC.F_COUNT_OFFERING_COREQ

OFFERING_NUMBER Offering Number Offering number of a course. An offering number can only be used once to identify a subject/course number combination in a term; however, multiple offerings of a course can share a zero offering number. VARCHAR2(63)  

SSBSECT

SSBSECT_SEQ_NUMB

OFFERING_PREREQ_COUNT Offering Prereq Count Count of offering prerequisites. NUMBER  

FUNCTION

MSKFUNC.F_COUNT_OFFERING_PREREQ

PERCENTAGE_OF_RESPONSIBILITY Percentage Of Responsibility Faculty member's percentage of responsibility to the assignment. NUMBER  

SIRASGN

SIRASGN_PERCENT_RESPONSE

PRIMARY_INSTRUCTOR_FIRST_NAME Primary Instructor First Name Primary instructor's current first name. VARCHAR2(60)  

SPRIDEN

SPRIDEN_FIRST_NAME

PRIMARY_INSTRUCTOR_ID Primary Instructor ID Current identification number of the primary instructor. VARCHAR2(63)  

SPRIDEN

SPRIDEN_ID

PRIMARY_INSTRUCTOR_LAST_NAME Primary Instructor Last Name Primary instructor's current last name. VARCHAR2(60)  

CALCULATION

NVL(SPRIDEN_LAST_NAME,'STAFF')

PRIOR_ENROLLMENT Prior Enrollment Enrollment in the prior like academic period when available for the section or schedule offering. NUMBER  

SSBSECT

SSBSECT_PRIOR_ENRL

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)  

NA

NA

REGISTRATION_END_DATE Registration End Date Latest date a student may register and start this academic instruction. DATE  

SSBSECT

SSBSECT_REG_TO_DATE

REGISTRATION_PERMIT_IND Registration Permit Indicator Indicates whether registration is permitted by students for this section or schedule offering. VARCHAR2(255)  

STVSSTS

STVSSTS_DESC

REGISTRATION_START_DATE Registration Start Date Earliest date a student may register and start this academic instruction. DATE  

SSBSECT

SSBSECT_REG_FROM_DATE

SCHEDULE Schedule Instructional delivery methods authorized for a course. Each course must be authorized to be offered for at least one schedule type. An unlimited number of schedule types can be authorized for a course (i.e., lecture, lab, internet, correspondence, etc.). VARCHAR2(63)  

SSBSECT

SSBSECT_SCHD_CODE

SCHEDULE_COUNT Schedule Count Count of the instruction or delivery methods for this section. NUMBER  

FUNCTION

MSKFUNC.F_COUNT_COURSE_SCHEDULE

SCHEDULE_DESC Schedule Description Schedule or instructional type description for this section. VARCHAR2(255)  

STVSCHD

STVSCHD_DESC

SEATS_AVAILABLE Seats Available Remaining or available seats in this section or offering. System maintained by subtracting the actual number enrolled from the maximum number permitted to enroll in the section. NUMBER  

SSBSECT

SSBSECT_SEATS_AVAIL

SECTION_CROSS_LIST Section Cross List Course cross list group identifier. VARCHAR2(63)  

SSRXLST

SSRXLST_XLST_GROUP

SECTION_CROSS_LIST_DESC Section Cross List Description Cross list enrollment description. VARCHAR2(255)  

SSBXLST

SSBXLST_DESC

SPECIAL_APPROVAL Special Approval Type of special approval a student must have to register for this course or section. VARCHAR2(63)  

SSBSECT

SSBSECT_SAPR_CODE

SPECIAL_APPROVAL_DESC Special Approval Description Special approval type description. VARCHAR2(255)  

STVSAPR

STVSAPR_DESC

START_DATE Start Date Date the course offering instruction began for this sub academic period. DATE  

SSBSECT

SSBSECT_PTRM_START_DATE

STATUS Status Current section status. May be used to identify whether registration is permitted for this section. VARCHAR2(63)  

SSBSECT

SSBSECT_SSTS_CODE

STATUS_DESC Status Description Section or offering status description. VARCHAR2(255)  

STVCSTA

STVCSTA_DESC

STUDENT_MEETING_TIME Student Meeting Time Student's normal attendance time. May be either day, evening, weekend, etc. VARCHAR2(63)  

SSBSECT

SSBSECT_SESS_CODE

STUDENT_MEETING_TIME_DESC Student Meeting Time Description Student's meeting session description. VARCHAR2(255)  

STVSESS

STVSESS_DESC

SUBJECT Subject Main instructional subject area for this course. VARCHAR2(63)  

SCBCRSE

SSBSECT

SCBCRSE_SUBJ_CODE

SSBSECT_SUBJ_CODE

SUBJECT_DESC Subject Description Subject code description. VARCHAR2(255)  

STVSUBJ

STVSUBJ_DESC

SUB_ACADEMIC_PERIOD Sub Academic Period A session, portion or part of the academic period. VARCHAR2(63)  

SSBSECT

SSBSECT_PTRM_CODE

SUB_ACADEMIC_PERIOD_DESC Sub Academic Period Description Sub academic period description. VARCHAR2(255)  

STVPTRM

STVPTRM_DESC

TARGET_ENROLLMENT Target Enrollment Anticipated or desired enrollment for this section or offering. Optional field defaults to zero when an offering is created. NUMBER  

SSBSECT

SSBSECT_PROJ_ENRL

TITLE_LONG_DESC Title Long Description Long title of the course. VARCHAR2(255)  

SSRSYLN

SSRSYLN_LONG_COURSE_TITLE

TITLE_SHORT_DESC Title Short Description Displays the course or section short title. VARCHAR2(255)  

SSBSECT

SSBSECT_TITLE

VOICE_WEB_AVAILABLE_IND Voice Web Available Indicator Indicates that this schedule offering is available for web or voice based registration. VARCHAR2(1)  

SSBSECT

SSBSECT_VOICE_AVAIL



Ver: 9.0