Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	Academic period or time frame associated with this meeting time record.	VARCHAR2(6)	SSRMEET	SSRMEET_TERM_CODE
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(30)	STVTERM	STVTERM_DESC
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
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
BUILDING	Building code for the room assignment.	VARCHAR2(6)	SSRMEET	SSRMEET_BLDG_CODE
BUILDING_DESC	Name of the building.	VARCHAR2(30)	STVBLDG	STVBLDG_DESC
CATEGORY	Meeting time/instructional session associated with this section.	VARCHAR2(2)	SSRMEET	SSRMEET_CATAGORY
CLASS_TYPE	Intended to specify the student year in school or class level of instruction for this course.	VARCHAR2(0)	NA	NA
CLASS_TYPE_DESC	Class type description.	VARCHAR2(0)	NA	NA
COMMITTEE	Committee associated with the section.	VARCHAR2(6)	SSRMEET	SSRMEET_COMT_CODE
COMMITTEE_DESC	Committee description.	VARCHAR2(30)	STVCOMT	STVCOMT_DESC
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)	SSRMEET	SSRMEET_CRN
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
END_DATE	End date for the section meeting time record.	DATE	SSRMEET	SSRMEET_END_DATE
END_TIME	Time the offering meeting ends.	VARCHAR2(4)	SSRMEET	SSRMEET_END_TIME
EVENT_FUNCTION	Specifies whether the meeting is an event function.	VARCHAR2(12)	SSRMEET	SSRMEET_FUNC_CODE
EVENT_FUNCTION_DESC	Function code description.	VARCHAR2(60)	GTVFUNC	GTVFUNC_DESC
FRIDAY_IND	Indicates whether the section meets on Friday.	VARCHAR2(1)	SSRMEET	SSRMEET_FRI_DAY
INSTRUCTION_DELIVERY_MODE	Instructional delivery mode of the course.	VARCHAR2(5)	SSBSECT	SSBSECT_INSM_CODE
INSTRUCTION_DELIVERY_MODE_DESC	Instructional delivery mode description for the course schedule type code.	VARCHAR2(30)	GTVINSM	GTVINSM_DESC
MEETING_HOURS	Hours per week that the section is scheduled to meet.	NUMBER(5, 2)	SSRMEET	SSRMEET_HRS_WEEK
MEETING_TYPE	Meeting type of the section.	VARCHAR2(4)	SSRMEET	SSRMEET_MTYP_CODE
MEETING_TYPE_DESC	Meeting type description.	VARCHAR2(30)	GTVMTYP	GTVMTYP_DESC
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
MONDAY_IND	Indicates whether the section meets on Monday.	VARCHAR2(1)	SSRMEET	SSRMEET_MON_DAY
ROOM	Classroom meeting location where this course section is scheduled. It is not required when scheduling course section meeting times.	VARCHAR2(10)	SSRMEET	SSRMEET_ROOM_CODE
SATURDAY_IND	Indicates whether the section meets on Saturday.	VARCHAR2(1)	SSRMEET	SSRMEET_SAT_DAY
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)	SSRMEET	SSRMEET_SCHD_CODE
SCHEDULE_DESC	Schedule or instructional type description for this section.	VARCHAR2(30)	STVSCHD	STVSCHD_DESC
SCHEDULE_STATUS	Identifies the current status of the section.	VARCHAR2(3)	SSRMEET	SSRMEET_SCHS_CODE
SCHEDULE_STATUS_DESC	Section status description. For example, is registration permitted.	VARCHAR2(30)	GTVSCHS	GTVSCHS_DESC
SECTION	Section sequence number for this offering of the course.	VARCHAR2(3)	SSBSECT	SSBSECT_SEQ_NUMB
SECTION_DESC	Course section description.	VARCHAR2(0)	NA	NA
START_DATE	Date the course offering instruction began for this section.	DATE	SSRMEET	SSRMEET_START_DATE
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
SUNDAY_IND	Indicates whether the section meets on Sunday.	VARCHAR2(1)	SSRMEET	SSRMEET_SUN_DAY
THURSDAY_IND	Indicates whether the section meets on Thursday.	VARCHAR2(1)	SSRMEET	SSRMEET_THU_DAY
TITLE_LONG_DESC	Long title of the course.	VARCHAR2(100)	FUNCTION	SOKODSF.F_GET_CRSE_LONG_TITLE
TITLE_SHORT_DESC	Displays the course or section short title.	VARCHAR2(30)	SSBSECT	SSBSECT_CRSE_TITLE
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_WED_DAY
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: 8.1