Target Column	Business Definition	Database Data Type	Source Name	Source Column
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)	SFRSTCR	SFRSTCR_TERM_CODE
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(63)	STVTERM	STVTERM_ACYR_CODE
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ACCOUNTING_METHOD	Accounting method used for tracking attendance either weekly or daily.	VARCHAR2(63)	SSBSECT	SSBSECT_ACCT_CODE
ACCOUNTING_METHOD_DESC	Accounting method description for this course.	VARCHAR2(255)	STVACCT	STVACCT_DESC
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-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
BEGIN_TIME	Begin time of the section or schedule offering. It is in the format HHMM using military time.	VARCHAR2(4)	SSRMEET	SSRMEET_BEGIN_TIME
BILLING_UNITS	Specifies the billing units associated with this course.	NUMBER	SFRSTCR	SFRSTCR_BILL_HR
BUILDING	Building code for the room assignment.	VARCHAR2(63)	SSRMEET	SSRMEET_BLDG_CODE
CENSUS_ENROLLMENT1	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	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	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
COURSE_BILLING_HOLD	Identifies the number of billing units that are being held for potential reinstatement.	NUMBER	SFRSTCR	SFRSTCR_BILL_HR_HOLD
COURSE_CAMPUS	Campus the student attended this schedule offering or section.	VARCHAR2(63)	SFRSTCR	SFRSTCR_CAMP_CODE
COURSE_CAMPUS_DESC	Institution campus description.	VARCHAR2(255)	STVCAMP	STVCAMP_DESC
COURSE_COLLEGE	College, faculty or school provide this section instruction.	VARCHAR2(63)	SCBCRSE SSBOVRR	SCBCRSE_COLL_CODE SSBOVRR_COLL_CODE
COURSE_COLLEGE_DESC	College description.	VARCHAR2(255)	STVCOLL	STVCOLL_DESC
COURSE_CREDITS	Credits associated with this course.	NUMBER	SFRSTCR	SFRSTCR_CREDIT_HR
COURSE_CREDITS_HOLD	Identifies the number of credits that are being held for potential reinstatement.	NUMBER	SFRSTCR	SFRSTCR_CREDIT_HR_HOLD
COURSE_DEPARTMENT	Department providing this instruction.	VARCHAR2(63)	SCBCRSE SSBOVRR	SCBCRSE_DEPT_CODE SSBOVRR_DEPT_CODE
COURSE_DEPARTMENT_DESC	Department providing this instruction.	VARCHAR2(255)	STVDEPT	STVDEPT_DESC
COURSE_DIVISION	Division providing this instruction.	VARCHAR2(63)	SCBCRSE SSBOVRR	SCBCRSE_DIVS_CODE SSBOVRR_DIVS_CODE
COURSE_DIVISION_DESC	Division description.	VARCHAR2(255)	STVDIVS	STVDIVS_DESC
COURSE_IDENTIFICATION	Course subject and course number combined.	VARCHAR2(63)	CALCULATION CALCULATION	SHRTCKN_SUBJ_CODE||SHRTCKN_CRSE_NUMB SSBSECT_SUBJ_CODE||SSBSECT_CRSE_NUMB
COURSE_LEVEL	Level of academic study satisfied by this course. For example, undergraduate, graduate, credit, etc.	VARCHAR2(63)	NA SFRSTCR	NA SFRSTCR_LEVL_CODE
COURSE_LEVEL_DESC	Course level description.	VARCHAR2(255)	FUNCTION NA	GOKODSF.F_GET_DESC NA
COURSE_NUMBER	Course number associated with the subject for the course.	VARCHAR2(63)	SCBCRSE	SCBCRSE_CRSE_NUMB
COURSE_REFERENCE_NUMBER	Computer assigned internal unique number for the schedule offering.	VARCHAR2(63)	SFRSTCR	SFRSTCR_CRN
COURSE_REPORTING_CODE_1	Course institutional reporting element 1 code.	VARCHAR2(63)	SCBSUPP	SCBSUPP_CUDA_CODE
COURSE_REPORTING_CODE_2	Course institutional reporting element 2 code.	VARCHAR2(63)	SCBSUPP	SCBSUPP_CUDB_CODE
COURSE_REPORTING_CODE_3	Course institutional reporting element 3 code.	VARCHAR2(63)	SCBSUPP	SCBSUPP_CUDC_CODE
COURSE_REPORTING_CODE_4	Course institutional reporting element 4 code.	VARCHAR2(63)	SCBSUPP	SCBSUPP_CUDD_CODE
COURSE_REPORTING_CODE_5	Course institutional reporting element 5 code.	VARCHAR2(63)	SCBSUPP	SCBSUPP_CUDE_CODE
COURSE_REPORTING_CODE_6	Course institutional reporting element 6 code.	VARCHAR2(63)	SCBSUPP	SCBSUPP_CUDF_CODE
COURSE_TITLE_SHORT	Short title for the course.	VARCHAR2(63)	CALCULATION	NVL(SSBSECT_CRSE_TITLE,SCBCRSE_TITLE)
END_DATE	Date on which the instruction ended. It is either stored specifically for the open learning student or taken from the end date on the offering.	DATE	SFRAREG	SFRAREG_COMPLETION_DATE
END_TIME	Time the offering meeting ends.	VARCHAR2(4)	SSRMEET	SSRMEET_END_TIME
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
FACULTY_MEMBER_STAFF_TYPE	Staff type assigned to the faculty or academic staff member. Included type may be full time, part time, continuing education, etc.	VARCHAR2(63)	SIBINST	SIBINST_FSTP_CODE
FACULTY_MEMBER_STAFF_TYPE_DESC	Faculty member staff type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
FINAL_GRADE	Final grade earned by the student for this course.	VARCHAR2(63)	SHRTCKG	SHRTCKG_GRDE_CODE_FINAL
FIRST_NAME	Person's first or given name.	VARCHAR2(63)	SPRIDEN	SPRIDEN_FIRST_NAME
FRIDAY_IND	Indicates whether the section meets on Friday.	VARCHAR2(1)	SSRMEET	SSRMEET_FRI_DAY
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID
INSTRUCTION_METHOD	Method of instruction. Traditional classroom, internet, correspondence, etc.	VARCHAR2(63)	SSBSECT	SSBSECT_INSM_CODE
INSTRUCTION_METHOD_DESC	Instructional method description.	VARCHAR2(255)	GTVINSM	GTVINSM_DESC
INSTRUCTOR_COUNT	Count of instructors assigned to the course.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_INSTRUCTOR
INSTRUCTOR_FIRST_NAME	Primary instructor first name.	VARCHAR2(60)	SPRIDEN	SPRIDEN_FIRST_NAME
INSTRUCTOR_ID	Instructor ID for the academic staff assigned as the primary instructor.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID
INSTRUCTOR_LAST_NAME	Primary instructor last name.	VARCHAR2(60)	CALCULATION	NVL(SPRIDEN_LAST_NAME,'STAFF')
INSTRUCTOR_MIDDLE_NAME	Primary instructor middle name.	VARCHAR2(63)	SPRIDEN	SPRIDEN_MI
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	Instruction integration partner description.	VARCHAR2(255)	GORINTG	GORINTG_DESC
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	Instruction integration partner system description.	VARCHAR2(255)	GORINTG	GTVINTP_DESC
LAB_CONTACT_HOURS	Maximum lab contact hours for schedule offering.	NUMBER	CALCULATION	NVL(SSBSECT_LAB_HR,SCBCRSE_LAB_HR_HIGH)
LAST_NAME	Last name.	VARCHAR2(63)	SPRIDEN	SPRIDEN_LAST_NAME
LECTURE_CONTACT_HOURS	Maximum lecture contact hours for schedule offering.	NUMBER	CALCULATION	NVL(SSBSECT_LEC_HR,SCBCRSE_LEC_HR_HIGH)
MAXIMUM_ENROLLMENT	Sets the maximum enrollment for this offering.	NUMBER	SSBSECT	SSBSECT_MAX_ENRL
MEETING_TIME_COUNT	Count of meeting times assigned to the course but not reflected in this row.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_MEETING_TIME
MIDDLE_NAME	Middle name.	VARCHAR2(63)	SPRIDEN	SPRIDEN_MI
MONDAY_IND	Indicates whether the section meets on Monday.	VARCHAR2(1)	SSRMEET	SSRMEET_MON_DAY
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NON_TRADITIONAL_COURSE	Non-traditional course as indicated by the institution.	VARCHAR2(1)	NA	NA
OCCUPATIONAL_COURSE	Indicates whether this course is an occupational or vocational course for reporting purposes.	VARCHAR2(63)	SCBSUPP	SCBSUPP_OCCS_CODE
OCCUPATIONAL_COURSE_DESC	Vocational or occupational indicator description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
OFFERING_NUMBER	Identifies a particular offering within the course identification.	VARCHAR2(63)	SSBSECT	SSBSECT_SEQ_NUMB
OTHER_CONTACT_HOURS	Maximum other contact hours for schedule offering.	NUMBER	CALCULATION	NVL(SSBSECT_OTH_HR,SCBCRSE_OTH_HR_HIGH)
PERCENT_RESPONSIBILITY	Schedule offering session percent of responsibility for the faculty member's instructional assignment.	NUMBER	SIRASGN	SIRASGN_PERCENT_SESS
PERSON_UID	Internally generated by the system to uniquely identify the person or entity.	NUMBER	SFRSTCR	SFRSTCR_PIDM
PRIMARY_IND	Indicates Y if the instructor is the primary or N if not.	VARCHAR2(1)	SIRASGN	SIRASGN_PRIMARY_IND
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
PROGRAM_CLASSIFICATION	Classification of Instructional Program (CIP) codes assigned to an area of study and used for governmental reporting.	VARCHAR2(63)	NA	NA
PROGRAM_CLASSIFICATION_DESC	Program classification description.	VARCHAR2(255)	STVCIPC	STVCIPC_DESC
REGISTER_CENSUS_DATE1_IND	Indicates a registration course status that identifies the person counts in the course section headcount was recorded prior to the census date.	VARCHAR2(1)	SSBSECT	SSBSECT_CENSUS_ENRL
REGISTER_CENSUS_DATE2_IND	Indicates a registration course status that identifies the person counts in the course section headcount was recorded prior to the census date 2.	VARCHAR2(1)	SSBSECT	SSBSECT_CENSUS_2_DATE
REGISTRATION_ERROR_FLAG	Identifies an error associated with the registration of this course section or offering. Values include F=Fatal, D=Do not count in enrollment, L=Waitlisted, O=Override.	VARCHAR2(1)	SFRSTCR	SFRSTCR_ERROR_FLAG
REGISTRATION_SEQUENCE_NUMBER	Sequence in which this registrant enrolled in this course.	NUMBER	SFRSTCR	SFRSTCR_REG_SEQ
REGISTRATION_STATUS	Identifies the course registration status associated for this course.	VARCHAR2(63)	SFRSTCR	SFRSTCR_RSTS_CODE
REGISTRATION_STATUS_DATE	Latest change registration date for this course.	DATE	SFRSTCR	SFRSTCR_RSTS_DATE
REGISTRATION_STATUS_DESC	Course registration status description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
REGISTRATION_USER_ID	User who entered the course registration.	VARCHAR2(63)	SFRSTCR	SFRSTCR_USER
REPEAT_COURSE_IND	Identifies this course is being taken again by this student.	VARCHAR2(1)	SFRSTCR	SFRSTCR_REPT_OVER
ROOM	Room where the offering meeting is scheduled.	VARCHAR2(10)	SSRMEET	SSRMEET_ROOM_CODE
SATURDAY_IND	Indicates whether the section meets on Saturday.	VARCHAR2(1)	SSRMEET	SSRMEET_SAT_DAY
SCHEDULE	Instructional delivery for this course. This could be lecture, lab, internet, etc.	VARCHAR2(63)	SSBSECT	SSBSECT_SCHD_CODE
SCHEDULE_TYPE_DESC	Description for the method in which the course content is delivered. For example, lecture, lab, internet, etc.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
SEATS_AVAILABLE	System maintained running total of remaining available seats in the section by subtracting the Actual enrollment field from the Maximum enrollment field defined for this section.	NUMBER	SSBSECT	SSBSECT_ENRL
SECTION_ADD_DATE	Original registration date for this course regardless of the last change in registration status date.	DATE	SFRSTCR	SFRSTCR_ADD_DATE
SPECIAL_APPROVAL_IND	Indicates special approval was required for this registration.	VARCHAR2(1)	SFRSTCR	SFRSTCR_APPR_RECEIVED_IND
START_DATE	Date the instruction for this course began for this student.	DATE	SFRAREG	SFRAREG_START_DATE
STUDENT_MEETING_TIME	Student's normal attendance time. May be either day, evening, weekend, etc.	VARCHAR2(63)	NA	NA
STUDENT_MEETING_TIME_DESC	Student's normal attendance time. May be either day, evening, weekend, etc.	VARCHAR2(255)	NA	NA
SUBJECT	Main instructional subject area for this course.	VARCHAR2(63)	SCBCRSE	SCBCRSE_SUBJ_CODE
SUBJECT_DESC	Subject code description.	VARCHAR2(255)	STVSUBJ	STVSUBJ_DESC
SUB_ACADEMIC_PERIOD	A session, portion or part of the academic period.	VARCHAR2(63)	SFRSTCR	SFRSTCR_PTRM_CODE
SUB_ACADEMIC_PERIOD_DESC	Sub academic period description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
SUNDAY_IND	Indicates whether the section meets on Sunday.	VARCHAR2(1)	SSRMEET	SSRMEET_SUN_DAY
TAXONOMY_OF_PROGRAM	Government reporting code typically used for reporting of vocational technical courses or subjects.	VARCHAR2(63)	SCBSUPP SSBOVRR	SCBSUPP_TOPS_CODE SSBOVRR_TOPS_CODE
TAXONOMY_OF_PROGRAM_DESC	Government reporting code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
THURSDAY_IND	Indicates whether the section meets on Thursday.	VARCHAR2(1)	SSRMEET	SSRMEET_THU_DAY
TOTAL_CONTACT_HOURS	Maximum contact hours for schedule offering.	NUMBER	CALCULATION	NVL(SSBSECT_CONT_HR,SCBCRSE_CONT_HR_HIGH)
TUESDAY_IND	Indicates whether the section meets on Tuesday.	VARCHAR2(1)	SSRMEET	SSRMEET_TUE_DAY
WEDNESDAY_IND	Indicates whether the section meets on Wednesday.	VARCHAR2(1)	SSRMEET	SSRMEET_SUN_DAY
WORKLOAD_ADJUST	Adjusted workload recorded for the instructional assignments of this faculty member.	NUMBER	SIRASGN	SIRASGN_WORKLOAD_ADJUST

Ver: 9.1