Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	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
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	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
ASSIGNMENT_TYPE	Assignment Type	Faculty Assignment Type Code	VARCHAR2(63)	SIRASGN	SIRASGN_ASTY_CODE
ASSIGNMENT_TYPE_DESC	Assignment Type Desc	Faculty Assignment Type Code Description	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
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 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
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	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
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	Course subject and course number combined.	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.	VARCHAR2(4000)	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 major subject area of a student course or associated with the major within the student academic study.	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
RESERVED_IND	Reserved Indicator	This field indicates whether reserved seats are defined for the section.	VARCHAR2(1)	SSBSECT	SSBSECT_RESERVED_IND
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
SCHEDULE_PRINT_IND	Schedule Print Indicator	This field is used to specify whether the section should be printed in the Schedule Report.	VARCHAR2(1)	SSBSECT	SSBSECT_PRNT_IND
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
WAIT_AVAILABLE	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
WAIT_CAPACITY	Wait Capacity	This field is used to set the maximum waitlist enrollment for a section	NUMBER	SSBSECT	SSBSECT_WAIT_CAPACITY
WAIT_COUNT	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

Ver: 9.2