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

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 SUBJECT, COURSE_NUMBER
ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
ACADEMIC_PERIOD Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year. VARCHAR2(63)

SSBSECT

SSBSECT_TERM_CODE

NO

NO
ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

NO

NO
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

NO

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

STVTERM

STVTERM_ACYR_CODE

NO

NO
ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(255)

STVACYR

STVACYR_DESC

NO

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

SSBSECT

SSBSECT_ACCT_CODE

NO

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

STVACCT

STVACCT_DESC

NO

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

FUNCTION

F_ACTIVE_SECTION_IND

NO

NO
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

NO

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

NA

NA

NO

NO
ASSIGNMENT_TYPE Faculty Assignment Type Code VARCHAR2(63)

SIRASGN

SIRASGN_ASTY_CODE

NO

NO
ASSIGNMENT_TYPE_DESC Faculty Assignment Type Code Description VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

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

FUNCTION

MSKFUNC.F_COUNT_COURSE_ATTRIBUTES

NO

NO
CAMPUS Campus associated with this record. Campus for the course section, student course, student, applied for on the admission application, etc. VARCHAR2(63)

SSBSECT

SSBSECT_CAMP_CODE

NO

NO
CAMPUS_DESC Institution campus name. VARCHAR2(255)

STVCAMP

STVCAMP_DESC

NO

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

SIRASGN

SIRASGN_CATEGORY

NO

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

SSBSECT

SSBSECT_CENSUS_ENRL

NO

NO
CENSUS_ENROLLMENT2 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

NO

NO
CENSUS_ENROLLMENT_DATE1 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

NO

NO
CENSUS_ENROLLMENT_DATE2 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

NO

NO
COLLEGE First level of the institution organization structure that owns the student or the academic instruction for a student course. VARCHAR2(63)

SSBOVRR

SSBOVRR_COLL_CODE

NO

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

STVCOLL

STVCOLL_DESC

NO

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

NA

NA

NO

NO
COURSE_CLASS_LEVEL_DESC Class level code description. VARCHAR2(255)

NA

NA

NO

NO
COURSE_IDENTIFICATION Course subject and course number combined. VARCHAR2(255)

CALCULATION

SSBSECT_SUBJ_CODE||SSBSECT_CRSE_NUMB

NO

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

SCBCRSE

SSBSECT

SCBCRSE_CRSE_NUMB

SSBSECT_CRSE_NUMB

NO

NO

NO
COURSE_REFERENCE_NUMBER Computer assigned internal unique number for the schedule offering. VARCHAR2(5)

SSBSECT

SSBSECT_CRN

NO

NO
COURSE_TEXT_NARRATIVE Text developed at the institution to describe the course and course content. VARCHAR2(4000)

SSBDESC

SSBDESC_TEXT_NARRATIVE

NO

NO
COURSE_VERSION Course version number. VARCHAR2(255)

NA

NA

NO

NO
CROSS_LIST_ACTIVITY_DATE Date record was inserted or updated. DATE

SSBXLST

SSBXLST_ACTIVITY_DATE

NO

NO
CROSS_LIST_ENROLLMENT Cross list section enrollment. NUMBER

SSBXLST

SSBXLST_ENRL

NO

NO
CROSS_LIST_MAXIMUM_ENROLLMENT Maximum seats available within any of the sections within a cross list code. NUMBER

SSBXLST

SSBXLST_MAX_ENRL

NO

NO
CROSS_LIST_SEATS_AVAILABLE Seats available for the sections within the cross list code. NUMBER

SSBXLST

SSBXLST_SEATS_AVAIL

NO

NO
DEPARTMENT Department responsible for the major subject area of a student course or associated with the major within the student academic study. VARCHAR2(63)

SSBOVRR

SSBOVRR_DEPT_CODE

NO

NO
DEPARTMENT_DESC Department name. VARCHAR2(255)

STVDEPT

STVDEPT_DESC

NO

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

SSBOVRR

SSBOVRR_DIVS_CODE

NO

NO
DIVISION_DESC Name of the division. VARCHAR2(255)

STVDIVS

STVDIVS_DESC

NO

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

SSBSECT

SSBSECT_DUNT_CODE

NO

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

SSBSECT

SSBSECT_DUNT_CODE

NO

NO
END_DATE End date for the section record. DATE

SSBSECT

SSBSECT_PTRM_END_DATE

NO

NO
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

NO

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

NA

NA

NO

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

SSBSECT

SSBSECT_NUMBER_OF_EXTENSIONS

NO

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

NA

SSBSECT

NA

SSBSECT_TOT_CREDIT_HRS

NO

NO

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

SSBSECT

SSBSECT_GRADABLE_IND

NO

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

SSBSECT

SSBSECT_GMOD_CODE

NO

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

FUNCTION

MSKFUNC.F_COUNT_GRADE_TYPE

NO

NO
GRADE_TYPE_DESC Grade type description. VARCHAR2(255)

STVGMOD

STVGMOD_DESC

NO

NO
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

NO

NO
INSTRUCTION_METHOD_DESC Instruction method description. VARCHAR2(255)

GTVINSM

GTVINSM_DESC

NO

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

FUNCTION

MSKFUNC.F_COUNT_INSTRUCTOR

NO

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

SSBSECT

SSBSECT_INTG_CDE

NO

NO
INTEGRATION_PARTNER_DESC Instruction integration partner description. VARCHAR2(255)

GORINTG

GORINTG_DESC

NO

NO
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

NO

NO
INTEGRATION_PARTNER_SYS_DESC Instruction integration partner system description. VARCHAR2(255)

GORINTG

GTVINTP_DESC

NO

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

SSBSECT

SSBSECT_LINK_IDENT

NO

NO
MAXIMUM_ENROLLMENT Sets the maximum enrollment for an offering. NUMBER

SSBSECT

SSBSECT_MAX_ENRL

NO

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

SSBSECT

SSBSECT_BILL_HRS

NO

NO
MAX_CONTACT_HOURS Second valid contact hour value or the high contact hour value within a range. NUMBER

SSBSECT

SSBSECT_CONT_HR

NO

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

SSBSECT

SSBSECT_CREDIT_HRS

NO

NO
MAX_LAB_HOURS Second valid lab hour value or the high lab hour value within a range. NUMBER

SSBSECT

SSBSECT_LAB_HR

NO

NO
MAX_LECTURE_HOURS Second valid lecture hour value or the high lecture hour value within a range. NUMBER

SSBSECT

SSBSECT_LEC_HR

NO

NO
MAX_OTHER_HOURS Second valid other hour value or the high other hour value within a range. NUMBER

SSBSECT

SSBSECT_OTH_HR

NO

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

FUNCTION

MSKFUNC.F_COUNT_MEETING_TIME

NO

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

NA

NA

NO

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

SSBSECT

SSBSECT_BILL_HRS

NO

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

SSBSECT

SSBSECT_CONT_HR

NO

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

SSBSECT

SSBSECT_CREDIT_HRS

NO

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

SSBSECT

SSBSECT_LAB_HR

NO

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

SSBSECT

SSBSECT_LEC_HR

NO

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

SSBSECT

SSBSECT_OTH_HR

NO

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

NA

NA

NO

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

NA

NA

NO

NO
NON_TRADITIONAL_IND Indicates whether the course is a non-traditional course. VARCHAR2(1)

NA

NA

NO

NO
OFFERING_COREQ_COUNT Count of offering corequisites. NUMBER

FUNCTION

MSKFUNC.F_COUNT_OFFERING_COREQ

NO

NO
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

NO

NO
OFFERING_PREREQ_COUNT Count of offering prerequisites. NUMBER

FUNCTION

MSKFUNC.F_COUNT_OFFERING_PREREQ

NO

NO
PERCENTAGE_OF_RESPONSIBILITY Faculty member's percentage of responsibility to the assignment. NUMBER

SIRASGN

SIRASGN_PERCENT_RESPONSE

NO

NO
PRIMARY_INSTRUCTOR_FIRST_NAME Primary instructor's current first name. VARCHAR2(60)

SPRIDEN

SPRIDEN_FIRST_NAME

NO

NO
PRIMARY_INSTRUCTOR_ID Current identification number of the primary instructor. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

NO

NO
PRIMARY_INSTRUCTOR_LAST_NAME Primary instructor's current last name. VARCHAR2(60)

CALCULATION

NVL(SPRIDEN_LAST_NAME,'STAFF')

NO

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

SSBSECT

SSBSECT_PRIOR_ENRL

NO

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

NA

NA

NO

NO
REGISTRATION_END_DATE Latest date a student may register and start this academic instruction. DATE

SSBSECT

SSBSECT_REG_TO_DATE

NO

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

STVSSTS

STVSSTS_DESC

NO

NO
REGISTRATION_START_DATE Earliest date a student may register and start this academic instruction. DATE

SSBSECT

SSBSECT_REG_FROM_DATE

NO

NO
RESERVED_IND This field indicates whether reserved seats are defined for the section. VARCHAR2(1)

SSBSECT

SSBSECT_RESERVED_IND

NO

NO
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

NO

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

FUNCTION

MSKFUNC.F_COUNT_COURSE_SCHEDULE

NO

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

STVSCHD

STVSCHD_DESC

NO

NO
SCHEDULE_PRINT_IND This field is used to specify whether the section should be printed in the Schedule Report. VARCHAR2(1)

SSBSECT

SSBSECT_PRNT_IND

NO

NO
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

NO

NO
SECTION_CROSS_LIST Course cross list group identifier. VARCHAR2(63)

SSRXLST

SSRXLST_XLST_GROUP

NO

NO
SECTION_CROSS_LIST_DESC Cross list enrollment description. VARCHAR2(255)

SSBXLST

SSBXLST_DESC

NO

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

SSBSECT

SSBSECT_SAPR_CODE

NO

NO
SPECIAL_APPROVAL_DESC Special approval type description. VARCHAR2(255)

STVSAPR

STVSAPR_DESC

NO

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

SSBSECT

SSBSECT_PTRM_START_DATE

NO

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

SSBSECT

SSBSECT_SSTS_CODE

NO

NO
STATUS_DESC Section or offering status description. VARCHAR2(255)

STVCSTA

STVCSTA_DESC

NO

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

SSBSECT

SSBSECT_SESS_CODE

NO

NO
STUDENT_MEETING_TIME_DESC Student's meeting session description. VARCHAR2(255)

STVSESS

STVSESS_DESC

NO

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

SCBCRSE

SSBSECT

SCBCRSE_SUBJ_CODE

SSBSECT_SUBJ_CODE

NO

NO

NO
SUBJECT_DESC Subject code description. VARCHAR2(255)

STVSUBJ

STVSUBJ_DESC

NO

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

SSBSECT

SSBSECT_PTRM_CODE

NO

NO
SUB_ACADEMIC_PERIOD_DESC Sub academic period description. VARCHAR2(255)

STVPTRM

STVPTRM_DESC

NO

NO
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

NO

NO
TITLE_LONG_DESC Long title of the course. VARCHAR2(255)

SSRSYLN

SSRSYLN_LONG_COURSE_TITLE

NO

NO
TITLE_SHORT_DESC Displays the course or section short title. VARCHAR2(255)

SSBSECT

SSBSECT_TITLE

NO

NO
VOICE_WEB_AVAILABLE_IND Indicates that this schedule offering is available for web or voice based registration. VARCHAR2(1)

SSBSECT

SSBSECT_VOICE_AVAIL

NO

NO
WAIT_AVAILABLE This field displays a running total of remaining available waitlist seats by subtracting the waitlist actual enrollment from the maximum waitlist enrollment for the section NUMBER

SSBSECT

SSBSECT_WAIT_AVAIL

NO

NO
WAIT_CAPACITY This field is used to set the maximum waitlist enrollment for a section NUMBER

SSBSECT

SSBSECT_WAIT_CAPACITY

NO

NO
WAIT_COUNT This field displays a running total of enrollments in the section which have course status with a waitlist flag set to Y on the Registration Status Code Validation Form NUMBER

SSBSECT

SSBSECT_WAIT_COUNT

NO

NO


Ver: 9.2