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(6)	SSRMEET	SSRMEET_TERM_CODE	NO	NO
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(30)	STVTERM	STVTERM_DESC	NO	NO
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(4)	STVTERM	STVTERM_ACYR_CODE	NO	NO
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(30)	STVACYR	STVACYR_DESC	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
BUILDING	Building code for the room assignment.	VARCHAR2(6)	SSRMEET	SSRMEET_BLDG_CODE	NO	NO
BUILDING_DESC	Name of the building.	VARCHAR2(30)	STVBLDG	STVBLDG_DESC	NO	NO
BUILDING_SITE		VARCHAR2(3)				NO
BUILDING_SITE_DESC		VARCHAR2(30)				NO
CATEGORY	Meeting time/instructional session associated with this section.	VARCHAR2(2)	SSRMEET	SSRMEET_CATAGORY	NO	NO
CLASS_TYPE	Intended to specify the student year in school or class level of instruction for this course.	VARCHAR2(0)	NA	NA	NO	NO
CLASS_TYPE_DESC	Class type description.	VARCHAR2(0)	NA	NA	NO	NO
COMMITTEE	Committee associated with the section.	VARCHAR2(6)	SSRMEET	SSRMEET_COMT_CODE	NO	NO
COMMITTEE_DESC	Committee description.	VARCHAR2(30)	STVCOMT	STVCOMT_DESC	NO	NO
COURSE_CAMPUS		VARCHAR2(3)				NO
COURSE_CAMPUS_DESC		VARCHAR2(30)				NO
COURSE_IDENTIFICATION	Course subject and course number combined.	VARCHAR2(9)	CALCULATION	SSBSECT_SUBJ_CODE||SSBSECT_CRSE_NUMB	NO	NO
COURSE_NUMBER	Course number associated with the subject for the course.	VARCHAR2(5)	SSBSECT	SSBSECT_CRSE_NUMB	NO	NO
COURSE_REFERENCE_NUMBER	Computer assigned internal unique number for the schedule offering.	VARCHAR2(5)	SSRMEET	SSRMEET_CRN	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
END_DATE	End date for the section meeting time record.	DATE	SSRMEET	SSRMEET_END_DATE	NO	NO
END_TIME	Time the offering meeting ends.	VARCHAR2(4)	SSRMEET	SSRMEET_END_TIME	NO	NO
EVENT_FUNCTION	Specifies whether the meeting is an event function.	VARCHAR2(12)	SSRMEET	SSRMEET_FUNC_CODE	NO	NO
EVENT_FUNCTION_DESC	Function code description.	VARCHAR2(60)	GTVFUNC	GTVFUNC_DESC	NO	NO
FRIDAY_IND	Indicates whether the section meets on Friday.	VARCHAR2(1)	SSRMEET	SSRMEET_FRI_DAY	NO	NO
INSTRUCTION_DELIVERY_MODE	Instructional delivery mode of the course.	VARCHAR2(5)	SSBSECT	SSBSECT_INSM_CODE	NO	NO
INSTRUCTION_DELIVERY_MODE_DESC	Instructional delivery mode description for the course schedule type code.	VARCHAR2(30)	GTVINSM	GTVINSM_DESC	NO	NO
MEETING_ACTIVITY_DATE		DATE				NO
MEETING_HOURS	Hours per week that the section is scheduled to meet.	NUMBER	SSRMEET	SSRMEET_HRS_WEEK	NO	NO
MEETING_TYPE	Meeting type of the section.	VARCHAR2(4)	SSRMEET	SSRMEET_MTYP_CODE	NO	NO
MEETING_TYPE_DESC	Meeting type description.	VARCHAR2(30)	GTVMTYP	GTVMTYP_DESC	NO	NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
MONDAY_IND	Indicates whether the section meets on Monday.	VARCHAR2(1)	SSRMEET	SSRMEET_MON_DAY	NO	NO
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	NO	NO
SATURDAY_IND	Indicates whether the section meets on Saturday.	VARCHAR2(1)	SSRMEET	SSRMEET_SAT_DAY	NO	NO
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	NO	NO
SCHEDULE_CONFLICT_OVERRIDE		VARCHAR2(1)				NO
SCHEDULE_DESC	Schedule or instructional type description for this section.	VARCHAR2(30)	STVSCHD	STVSCHD_DESC	NO	NO
SCHEDULE_STATUS	Identifies the current status of the section.	VARCHAR2(3)	SSRMEET	SSRMEET_SCHS_CODE	NO	NO
SCHEDULE_STATUS_DESC	Section status description. For example, is registration permitted.	VARCHAR2(30)	GTVSCHS	GTVSCHS_DESC	NO	NO
SCHED_CONFLICT_OVERRIDE_DESC		VARCHAR2(255)				NO
SECTION	Section sequence number for this offering of the course.	VARCHAR2(3)	SSBSECT	SSBSECT_SEQ_NUMB	NO	NO
SECTION_DESC	Course section description.	VARCHAR2(0)	NA	NA	NO	NO
START_DATE	Date the course offering instruction began for this section.	DATE	SSRMEET	SSRMEET_START_DATE	NO	NO
SUBJECT	Main instructional subject area for this course.	VARCHAR2(4)	SSBSECT	SSBSECT_SUBJ_CODE	NO	NO
SUBJECT_DESC	Subject code description.	VARCHAR2(30)	STVSUBJ	STVSUBJ_DESC	NO	NO
SUB_ACADEMIC_PERIOD	A session, portion or part of the academic period.	VARCHAR2(3)	SSBSECT	SSBSECT_PTRM_CODE	NO	NO
SUB_ACADEMIC_PERIOD_DESC	Sub academic period description.	VARCHAR2(30)	STVPTRM	STVPTRM_DESC	NO	NO
SUNDAY_IND	Indicates whether the section meets on Sunday.	VARCHAR2(1)	SSRMEET	SSRMEET_SUN_DAY	NO	NO
THURSDAY_IND	Indicates whether the section meets on Thursday.	VARCHAR2(1)	SSRMEET	SSRMEET_THU_DAY	NO	NO
TITLE_LONG_DESC	Long title of the course.	VARCHAR2(100)	FUNCTION	SOKODSF.F_GET_CRSE_LONG_TITLE	NO	NO
TITLE_SHORT_DESC	Displays the course or section short title.	VARCHAR2(30)	SSBSECT	SSBSECT_CRSE_TITLE	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_WED_DAY	NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: