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

Ver: 9.2