Target Column	Business Name	Business Definition	Database Data Type	Domain Value	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
BUILDING_SITE	Building Site		VARCHAR2(3)
BUILDING_SITE_DESC	Building Site Description		VARCHAR2(30)
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_CAMPUS	Course Campus		VARCHAR2(3)
COURSE_CAMPUS_DESC	Course Campus Description		VARCHAR2(30)
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	Event Function Description	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_ACTIVITY_DATE	Meeting Activity Date		DATE
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_CONFLICT_OVERRIDE	Schedule Conflict Override		VARCHAR2(1)
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
SCHED_CONFLICT_OVERRIDE_DESC	Sched Conflict Override Description		VARCHAR2(255)
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: