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
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
ATTRIBUTE_COUNT	Count of course degree attributes recorded for the section or schedule offering.			FUNCTION	MSKFUNC.F_COUNT_COURSE_ATTRIBUTES
CAMPUS	Campus the student attended this schedule offering or section.			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 the 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.			SCBCRSE SSBSECT	SCBCRSE_CRSE_NUMB SSBSECT_CRSE_NUMB
COURSE_REFERENCE_NUMBER	Computer assigned internal unique number for the schedule offering.			SSBSECT	SSBSECT_CRN
COURSE_TEXT_NARRATIVE	Text developed at the institution to describe the course and course content.			SSBDESC	SSBDESC_TEXT_NARRATIVE
COURSE_VERSION	Course version number.			NA	NA
CROSS_LIST_ACTIVITY_DATE	Date record was inserted or updated.			SSBXLST	SSBXLST_ACTIVITY_DATE
CROSS_LIST_ENROLLMENT	Cross list section enrollment.			SSBXLST	SSBXLST_ENRL
CROSS_LIST_MAXIMUM_ENROLLMENT	Maximum cross list enrollment.			SSBXLST	SSBXLST_MAX_ENRL
CROSS_LIST_SEATS_AVAILABLE	Cross list section seats available.			SSBXLST	SSBXLST_SEATS_AVAIL
DEPARTMENT	Department responsible for the instructional delivery of this offering.			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
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	Number of enrolled students multiplied by the number of credits the offering is worth.			NA SSBSECT	NA SSBSECT_TOT_CREDIT_HRS
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_COUNT	Count the number of grading types or modes for this section or schedule offering.			FUNCTION	MSKFUNC.F_COUNT_GRADE_TYPE
GRADE_TYPE_DESC	Grade type description.			STVGMOD	STVGMOD_DESC
INSTRUCTOR_COUNT	Count of instructors or academic staff members assigned to this section or schedule offering.			FUNCTION	MSKFUNC.F_COUNT_INSTRUCTOR
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
MEETING_TIME_COUNT	Count of meeting times assigned to the course but not reflected in this row.			FUNCTION	MSKFUNC.F_COUNT_MEETING_TIME
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
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.			NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.			NA	NA
NON_TRADITIONAL_IND	Indicates whether the course is a non-traditional course.			NA	NA
OFFERING_COREQ_COUNT	Count of offering corequisites.			FUNCTION	MSKFUNC.F_COUNT_OFFERING_COREQ
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
OFFERING_PREREQ_COUNT	Count of offering prerequisites.			FUNCTION	MSKFUNC.F_COUNT_OFFERING_PREREQ
PERCENTAGE_OF_RESPONSIBILITY	Faculty member's percentage of responsibility to the assignment.			SIRASGN	SIRASGN_PERCENT_RESPONSE
PRIMARY_INSTRUCTOR_FIRST_NAME	Primary instructor's current first name.			SPRIDEN	SPRIDEN_FIRST_NAME
PRIMARY_INSTRUCTOR_ID	Current identification number of the primary instructor.			SPRIDEN	SPRIDEN_ID
PRIMARY_INSTRUCTOR_LAST_NAME	Primary instructor's current last name.			CALCULATION	NVL(SPRIDEN_LAST_NAME,'STAFF')
PRIOR_ENROLLMENT	Enrollment in the prior like academic period when available for the section or schedule offering.			SSBSECT	SSBSECT_PRIOR_ENRL
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
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 is permitted by students for this section or schedule offering.			STVSSTS	STVSSTS_DESC
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_COUNT	Count of the instruction or delivery methods for this section.			FUNCTION	MSKFUNC.F_COUNT_COURSE_SCHEDULE
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
SECTION_CROSS_LIST	Course cross list group identifier.			SSRXLST	SSRXLST_XLST_GROUP
SECTION_CROSS_LIST_DESC	Cross list enrollment description.			SSBXLST	SSBXLST_DESC
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	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.			STVCSTA	STVCSTA_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.			SCBCRSE SSBSECT	SCBCRSE_SUBJ_CODE 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
TITLE_LONG_DESC	Long title of the course.			SSRSYLN	SSRSYLN_LONG_COURSE_TITLE
TITLE_SHORT_DESC	Displays the course or section short title.			SSBSECT	SSBSECT_TITLE
VOICE_WEB_AVAILABLE_IND	Indicates that this schedule offering is available for web or voice based registration.			SSBSECT	SSBSECT_VOICE_AVAIL

Ver: 8.3