Target Column	Business Name	Business Definition	Database Data Type	Domain Value	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.	CLOB		SSBDESC	SSBDESC_TEXT_NARRATIVE
COURSE_VERSION_NO		Course version number.	VARCHAR2(0)		NA	NA
CROSS_LIST_ACTIVITY_DATE	Cross List Activity Date	Most recent date a record was created or updated.	DATE		SSBXLST	SSBXLST_ACTIVITY_DATE
CROSS_LIST_ENROLLMENT	Cross List Enrollment	Cross list section enrollment to date.	NUMBER		SSBXLST	SSBXLST_ENRL
CROSS_LIST_MAXIMUM_ENROLLMENT	Cross List Maximum Enrollment	Maximum cross listed section enrollment.	NUMBER		SSBXLST	SSBXLST_MAX_ENRL
CROSS_LIST_SEATS_AVAILABILE	Cross List Seats Available	Seats available in the sections within a cross List code.	NUMBER		SSBXLST	SSBXLST_SEATS_AVAIL
CROSS_LIST_SEATS_AVAILABLE	Cross List Seats Available		NUMBER
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
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(5)		SSBSECT	SSBSECT_INSM_CODE
INSTRUCTION_METHOD_DESC	Instruction Method Description	Instruction method description.	VARCHAR2(30)		GTVINSM	GTVINSM_DESC
INTEGRATION_PARTNER	Integration Partner	Institution defined integration code that identifies an external partner used for instruction of this schedule offering.	VARCHAR2(5)		SSBSECT	SSBSECT_INTG_CDE
INTEGRATION_PARTNER_DESC	Integration Partner Description	Instruction integration partner description.	VARCHAR2(30)		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(5)		GORINTG	GORINTG_INTP_CODE
INTEGRATION_PARTNER_SYS_DESC	Integration Partner System Description	Instruction integration partner system description.	VARCHAR2(30)		GORINTG	GTVINTP_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
SECTION_CROSS_LIST	Section Cross List		VARCHAR2(2)
SECTION_CROSS_LIST_DESC	Section Cross List Description		VARCHAR2(30)
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
TAXONOMY_OF_PROGRAM	Taxonomy of Program	Government reporting code typically used for reporting of vocational technical courses or subjects.	VARCHAR2(6)		SSBOVRR	SSBOVRR_TOPS_CODE
TAXONOMY_OF_PROGRAM_DESC		Taxonomy of program code description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
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: