Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Student Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AS_COURSE_OFFERING

Description Source composite view contains all sections or schedule offerings for a specific academic period.

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

SSBSECT

SSBSECT_TERM_CODE

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(30)

STVTERM

STVTERM_DESC

ACADEMIC_PERIOD_WEEKS Number of weeks associated with this academic period. For example, 16 week semester, 10 week quarter, etc. NUMBER(3)

SSBSECT

SSBSECT_PTRM_WEEKS

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

STVTERM

STVTERM_ACYR_CODE

ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(30)

STVACYR

STVACYR_DESC

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

SSBSECT

SSBSECT_ACCT_CODE

ACCOUNTING_METHOD_DESC Accounting method description for this course. VARCHAR2(30)

STVACCT

STVACCT_DESC

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

FUNCTION

F_ACTIVE_SECTION_IND

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

SSBSECT

SSBSECT_ENRL

CAMPUS Campus the schedule offering or section instruction occurs. VARCHAR2(3)

SSBSECT

SSBSECT_CAMP_CODE

CAMPUS_DESC Institution campus name. VARCHAR2(30)

STVCAMP

STVCAMP_DESC

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

SSBSECT

SSBSECT_CENSUS_ENRL

CENSUS_ENROLLMENT2 Total of students registered and counted in enrollment for the section or schedule offering through the second defined census date. NUMBER(4)

SSBSECT

SSBSECT_CENSUS_2_ENRL

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

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

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

SSBOVRR

SSBOVRR_COLL_CODE

COLLEGE_DESC College, faculty or school name. VARCHAR2(30)

STVCOLL

STVCOLL_DESC

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

NA

NA

COURSE_CLASS_LEVEL_DESC Class level code description. VARCHAR2(0)

NA

NA

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

CALCULATION

SSBSECT_SUBJ_CODE||SSBSECT_CRSE_NUMB

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

SSBSECT

SSBSECT_CRSE_NUMB

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

SSBSECT

SSBSECT_CRN

COURSE_TEXT_NARRATIVE Course offering descriptive text. VARCHAR2(4000)    
COURSE_VERSION_NO Course version number. VARCHAR2(0)

NA

NA

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

DEPARTMENT Department responsible the academic instruction. VARCHAR2(4)

SSBOVRR

SSBOVRR_DEPT_CODE

DEPARTMENT_DESC Department name. VARCHAR2(30)

STVDEPT

STVDEPT_DESC

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

SSBOVRR

SSBOVRR_DIVS_CODE

DIVISION_DESC Name of the division. VARCHAR2(30)

STVDIVS

STVDIVS_DESC

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

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

SSBSECT

SSBSECT_DUNT_CODE

DURATION_UNITS Indicates whether the course duration is in days, weeks, months, etc. NUMBER(7, 2)

SSBSECT

SSBSECT_DUNT_CODE

END_DATE End date for the section record. DATE

SSBSECT

SSBSECT_PTRM_END_DATE

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

SSBSECT

SSBSECT_TUIW_IND

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

NA

NA

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

SSBSECT

SSBSECT_NUMBER_OF_EXTENSIONS

GENERATED_CREDITS This field is the number of enrolled students times the number of credits the offering is worth. NUMBER(9, 3)

NA

NA

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

SSBSECT

SSBSECT_GRADABLE_IND

GRADE_TYPE Grade type for the course. VARCHAR2(1)

SSBSECT

SSBSECT_GMOD_CODE

GRADE_TYPE_DESC Grade type description. VARCHAR2(30)

STVGMOD

STVGMOD_DESC

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

SSBSECT

SSBSECT_LINK_IDENT

MAXIMUM_ENROLLMENT Sets the maximum enrollment for an offering. NUMBER(4)

SSBSECT

SSBSECT_MAX_ENRL

MAX_BILLING Second valid billing hour value or the high billing hour value within a range. NUMBER(7, 3)

SSBSECT

SSBSECT_BILL_HRS

MAX_CONTACT_HOURS Second valid contact hour value or the high contact hour value within a range. NUMBER(9, 3)

SSBSECT

SSBSECT_CONT_HR

MAX_CREDITS Second valid credit hour value or the high credit hour value within a range. NUMBER(7, 3)

SSBSECT

SSBSECT_CREDIT_HRS

MAX_LAB_HOURS Second valid lab hour value or the high lab hour value within a range. NUMBER(9, 3)

SSBSECT

SSBSECT_LAB_HR

MAX_LECTURE_HOURS Second valid lecture hour value or the high lecture hour value within a range. NUMBER(9, 3)

SSBSECT

SSBSECT_LEC_HR

MAX_OTHER_HOURS Second valid other hour value or the high other hour value within a range. NUMBER(9, 3)

SSBSECT

SSBSECT_OTH_HR

MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

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

NA

NA

MIN_BILLING Minimum number of billing hours for which a course may be offered. NUMBER(7, 3)

SSBSECT

SSBSECT_BILL_HRS

MIN_CONTACT_HOURS Minimum number of contact hours for which a course may be offered. NUMBER(9, 3)

SSBSECT

SSBSECT_CONT_HR

MIN_CREDITS Minimum number of credit hours for which a course may be offered. NUMBER(7, 3)

SSBSECT

SSBSECT_CREDIT_HRS

MIN_LAB_HOURS Minimum number of lab hours for which a course may be offered. NUMBER(9, 3)

SSBSECT

SSBSECT_LAB_HR

MIN_LECTURE_HOURS Minimum number of lecture hours for which a course may be offered. NUMBER(9, 3)

SSBSECT

SSBSECT_LEC_HR

MIN_OTHER_HOURS Minimum number of other hours for which a course may be offered. NUMBER(9, 3)

SSBSECT

SSBSECT_OTH_HR

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

NA

NA

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

SSBSECT

SSBSECT_SEQ_NUMB

PART_OF_TERM Session or part of the academic period associated with the information in the record. VARCHAR2(3)

SSBSECT

SSBSECT_PTRM_CODE

PART_OF_TERM_DESC Session, part of term, or academic period description. VARCHAR2(30)

STVPTRM

STVPTRM_DESC

PART_OF_TERM_END_DATE Date the course offering instruction ends. DATE

SSBSECT

SSBSECT_PTRM_END_DATE

PART_OF_TERM_START_DATE Date the course offering instruction begins. DATE

SSBSECT

SSBSECT_PTRM_START_DATE

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

SSBSECT

SSBSECT_PRIOR_ENRL

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

SSBSECT

SSBSECT_REG_TO_DATE

REGISTRATION_PERMIT_IND Indicates whether registration for the offering is available. VARCHAR2(1)

NA

NA

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

SSBSECT

SSBSECT_REG_FROM_DATE

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

SSBSECT

SSBSECT_SCHD_CODE

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

STVSCHD

STVSCHD_DESC

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

SSBSECT

SSBSECT_SEATS_AVAIL

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

SSBSECT

SSBSECT_SAPR_CODE

SPECIAL_APPROVAL_DESC Special approval type description. VARCHAR2(30)

STVSAPR

STVSAPR_DESC

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

SSBSECT

SSBSECT_PTRM_START_DATE

STATUS Identifies the current section status. May be used to identify whether registration is permitted for this section. VARCHAR2(1)

SSBSECT

SSBSECT_SSTS_CODE

STATUS_DESC Section or offering status description. VARCHAR2(30)

STVSSTS

STVSSTS_DESC

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

SSBSECT

SSBSECT_SESS_CODE

STUDENT_MEETING_TIME_DESC Student's meeting session description. VARCHAR2(30)

STVSESS

STVSESS_DESC

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

SSBSECT

SSBSECT_SUBJ_CODE

SUBJECT_DESC Subject code description. VARCHAR2(30)

STVSUBJ

STVSUBJ_DESC

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

SSBSECT

SSBSECT_PTRM_CODE

SUB_ACADEMIC_PERIOD_DESC Sub academic period description. VARCHAR2(30)

STVPTRM

STVPTRM_DESC

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

SSBSECT

SSBSECT_PROJ_ENRL

TITLE_LONG_DESC Long title of the course. VARCHAR2(100)

NA

NA

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

SSBSECT

SSBSECT_CRSE_TITLE

VOICE_WEB_AVAILABLE_IND The indicator that reflects if the section if offered on the Web or not. VARCHAR2(1)    
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA



Ver: 8.0