Go To View:  RETURN TO BANNER COMP META DATA 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.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACADEMIC_PERIOD Academic period or time frame this section or schedule offering was taught.    

SSBSECT

SSBSECT_TERM_CODE

 
ACADEMIC_PERIOD_DESC Academic period description.    

STVTERM

STVTERM_DESC

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

SSBSECT

SSBSECT_PTRM_WEEKS

 
ACADEMIC_YEAR Academic year associated with the academic period on this record.    

STVTERM

STVTERM_ACYR_CODE

 
ACADEMIC_YEAR_DESC Academic year description.    

STVACYR

STVACYR_DESC

 
ACCOUNTING_METHOD Accounting method used for tracking attendance either weekly or daily.    

SSBSECT

SSBSECT_ACCT_CODE

 
ACCOUNTING_METHOD_DESC Accounting method description for this course.    

STVACCT

STVACCT_DESC

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

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.    

SSBSECT

SSBSECT_ENRL

 
CAMPUS Campus the schedule offering or section instruction occurs.    

SSBSECT

SSBSECT_CAMP_CODE

 
CAMPUS_DESC Institution campus name.    

STVCAMP

STVCAMP_DESC

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

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.    

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.    

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.    

SSBSECT

SSBSECT_CENSUS_2_DATE

 
COLLEGE College, faculty or school to which the course instructional responsibility is associated.    

SSBOVRR

SSBOVRR_COLL_CODE

 
COLLEGE_DESC College, faculty or school name.    

STVCOLL

STVCOLL_DESC

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

NA

NA

 
COURSE_CLASS_LEVEL_DESC Class level code description.    

NA

NA

 
COURSE_IDENTIFICATION Combined subject code and course number that identifies the instructional content of this course.    

CALCULATION

SSBSECT_SUBJ_CODE||SSBSECT_CRSE_NUMB

 
COURSE_NUMBER Course number associated with the subject for the course.    

SSBSECT

SSBSECT_CRSE_NUMB

 
COURSE_REFERENCE_NUMBER Computer assigned internal unique number for the schedule offering.    

SSBSECT

SSBSECT_CRN

 
COURSE_TEXT_NARRATIVE Course offering descriptive text.    

SSBDESC

SSBDESC_TEXT_NARRATIVE

 
COURSE_VERSION_NO Course version number.    

NA

NA

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

NA

SYSDATE

 
DEPARTMENT Department responsible the academic instruction.    

SSBOVRR

SSBOVRR_DEPT_CODE

 
DEPARTMENT_DESC Department name.    

STVDEPT

STVDEPT_DESC

 
DIVISION Division responsible for the instructional delivery of this course or section.    

SSBOVRR

SSBOVRR_DIVS_CODE

 
DIVISION_DESC Name of the division.    

STVDIVS

STVDIVS_DESC

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

NA

NA

 
DURATION Indicates whether the course duration is in days, weeks, months, etc.    

SSBSECT

SSBSECT_DUNT_CODE

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

SSBSECT

SSBSECT_DUNT_CODE

 
END_DATE End date for the section record.    

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.    

SSBSECT

SSBSECT_TUIW_IND

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

NA

NA

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

SSBSECT

SSBSECT_NUMBER_OF_EXTENSIONS

 
GENERATED_CREDITS This field is the number of enrolled students times the number of credits the offering is worth.    

NA

NA

 
GRADABLE_IND Indicates whether the course can be graded.    

SSBSECT

SSBSECT_GRADABLE_IND

 
GRADE_TYPE Grade type for the course.    

SSBSECT

SSBSECT_GMOD_CODE

 
GRADE_TYPE_DESC Grade type description.    

STVGMOD

STVGMOD_DESC

 
LINK_IDENTIFIER Links other sections of the same course which must be taken concurrently.    

SSBSECT

SSBSECT_LINK_IDENT

 
MAXIMUM_ENROLLMENT Sets the maximum enrollment for an offering.    

SSBSECT

SSBSECT_MAX_ENRL

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

SSBSECT

SSBSECT_BILL_HRS

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

SSBSECT

SSBSECT_CONT_HR

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

SSBSECT

SSBSECT_CREDIT_HRS

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

SSBSECT

SSBSECT_LAB_HR

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

SSBSECT

SSBSECT_LEC_HR

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

SSBSECT

SSBSECT_OTH_HR

 
MIF_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

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

NA

NA

 
MINIMUM_ENROLLMENT Sets the minimum enrollment allowed for an offering.    

NA

NA

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

SSBSECT

SSBSECT_BILL_HRS

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

SSBSECT

SSBSECT_CONT_HR

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

SSBSECT

SSBSECT_CREDIT_HRS

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

SSBSECT

SSBSECT_LAB_HR

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

SSBSECT

SSBSECT_LEC_HR

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

SSBSECT

SSBSECT_OTH_HR

 
NON_TRADITIONAL_IND Indicates whether the course is a non-traditional course.    

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.    

SSBSECT

SSBSECT_SEQ_NUMB

 
PART_OF_TERM Session or part of the academic period associated with the information in the record.    

SSBSECT

SSBSECT_PTRM_CODE

 
PART_OF_TERM_DESC Session, part of term, or academic period description.    

STVPTRM

STVPTRM_DESC

 
PART_OF_TERM_END_DATE Date the course offering instruction ends.    

SSBSECT

SSBSECT_PTRM_END_DATE

 
PART_OF_TERM_START_DATE Date the course offering instruction begins.    

SSBSECT

SSBSECT_PTRM_START_DATE

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

SSBSECT

SSBSECT_PRIOR_ENRL

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

SSBSECT

SSBSECT_REG_TO_DATE

 
REGISTRATION_PERMIT_IND Indicates whether registration for the offering is available.    

NA

NA

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

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

SSBSECT

SSBSECT_SCHD_CODE

 
SCHEDULE_DESC Schedule or instructional type description for this section.    

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.    

SSBSECT

SSBSECT_SEATS_AVAIL

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

SSBSECT

SSBSECT_SAPR_CODE

 
SPECIAL_APPROVAL_DESC Special approval type description.    

STVSAPR

STVSAPR_DESC

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

SSBSECT

SSBSECT_PTRM_START_DATE

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

SSBSECT

SSBSECT_SSTS_CODE

 
STATUS_DESC Section or offering status description.    

STVSSTS

STVSSTS_DESC

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

SSBSECT

SSBSECT_SESS_CODE

 
STUDENT_MEETING_TIME_DESC Student's meeting session description.    

STVSESS

STVSESS_DESC

 
SUBJECT Main instructional subject area for this course.    

SSBSECT

SSBSECT_SUBJ_CODE

 
SUBJECT_DESC Subject code description.    

STVSUBJ

STVSUBJ_DESC

 
SUB_ACADEMIC_PERIOD A session, portion or part of the academic period.    

SSBSECT

SSBSECT_PTRM_CODE

 
SUB_ACADEMIC_PERIOD_DESC Sub academic period description.    

STVPTRM

STVPTRM_DESC

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

SSBSECT

SSBSECT_PROJ_ENRL

 
TAXONOMY_OF_PROGRAM Government reporting code typically used for reporting of vocational technical courses or subjects.    

SSBOVRR

SSBOVRR_TOPS_CODE

 
TAXONOMY_OF_PROGRAM_DESC Taxonomy of program code description.    

FUNCTION

GOKODSF.F_GET_DESC

 
TITLE_LONG_DESC Long title of the course.    

NA

NA

 
TITLE_SHORT_DESC Displays the course or section short title.    

SSBSECT

SSBSECT_CRSE_TITLE

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

NA

NA

 


Ver: 8.3