| Target Column | 
Business Name | 
Business Definition | 
Database Data Type | 
Domain Value | 
Source Name | 
Source Column | 
| 
ACADEMIC_PERIOD
 | 
Academic Period 
 | 
Academic period or time frame associated with this meeting time record.
 | 
VARCHAR2(63)
 | 
 
 | 
 SSRMEET
 
 | 
 SSRMEET_TERM_CODE
 
 | 
| 
ACADEMIC_PERIOD_DESC
 | 
Academic Period Description 
 | 
Academic period description.
 | 
VARCHAR2(255)
 | 
 
 | 
 STVTERM
 
 | 
 STVTERM_DESC
 
 | 
| 
ACADEMIC_YEAR
 | 
Academic Year 
 | 
Academic year associated with the academic period on this record.
 | 
VARCHAR2(63)
 | 
 
 | 
 STVTERM
 
 | 
 STVTERM_ACYR_CODE
 
 | 
| 
ACADEMIC_YEAR_DESC
 | 
Academic Year Description 
 | 
Academic year description.
 | 
VARCHAR2(255)
 | 
 
 | 
 STVACYR
 
 | 
 STVACYR_DESC
 
 | 
| 
ADMINISTRATIVE_GROUP
 | 
Administrative Group 
 | 
Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.
 | 
VARCHAR2(255)
 | 
 
 | 
 NA
 
 | 
 NA
 
 | 
| 
BEGIN_TIME
 | 
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 
 | 
Building code for the room assignment.
 | 
VARCHAR2(63)
 | 
 
 | 
 SSRMEET
 
 | 
 SSRMEET_BLDG_CODE
 
 | 
| 
BUILDING_DESC
 | 
Building Description 
 | 
Name of the building.
 | 
VARCHAR2(255)
 | 
 
 | 
 STVBLDG
 
 | 
 STVBLDG_DESC
 
 | 
| 
BUILDING_SITE
 | 
Building Site 
 | 
Site or location where the student is attending or obtaining instruction.
 | 
VARCHAR2(63)
 | 
 
 | 
 SLBBLDG
 
 | 
 SLBBLDG_SITE_CODE
 
 | 
| 
BUILDING_SITE_DESC
 | 
Building Site Description 
 | 
Site or location name.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 GOKODSF.F_GET_DESC
 
 | 
| 
CATEGORY
 | 
Category 
 | 
Meeting time/instructional session associated with this section.
 | 
VARCHAR2(2)
 | 
 
 | 
 SSRMEET
 
 | 
 SSRMEET_CATAGORY
 
 | 
| 
CLASS_TYPE
 | 
Class Type 
 | 
Intended to specify the student year in school or class level of instruction for this course.
 | 
VARCHAR2(63)
 | 
 
 | 
 NA
 
 | 
 NA
 
 | 
| 
CLASS_TYPE_DESC
 | 
Class Type Description 
 | 
Class type description.
 | 
VARCHAR2(255)
 | 
 
 | 
 NA
 
 | 
 NA
 
 | 
| 
COMMITTEE
 | 
Committee 
 | 
Committee associated with the section.
 | 
VARCHAR2(63)
 | 
 
 | 
 SSRMEET
 
 | 
 SSRMEET_COMT_CODE
 
 | 
| 
COMMITTEE_DESC
 | 
Committee Description 
 | 
Committee description.
 | 
VARCHAR2(255)
 | 
 
 | 
 STVCOMT
 
 | 
 STVCOMT_DESC
 
 | 
| 
COURSE_CAMPUS
 | 
Course Campus 
 | 
Campus scheduling the offering.
 | 
VARCHAR2(63)
 | 
 
 | 
 SLBBLDG
 
 | 
 SLBBLDG_CAMP_CODE
 
 | 
| 
COURSE_CAMPUS_DESC
 | 
Course Campus Description 
 | 
Course campus description.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 GOKODSF.F_GET_DESC
 
 | 
| 
COURSE_IDENTIFICATION
 | 
Course ID 
 | 
Combined subject code and course number that identifies the instructional content of this course.
 | 
VARCHAR2(255)
 | 
 
 | 
 CALCULATION SCBCRSE
 
 | 
 SSBSECT_SUBJ_CODE||SSBSECT_CRSE_NUMB SCBCRSE_SUBJ_CODE
 
 | 
| 
COURSE_NUMBER
 | 
Course Number 
 | 
Course number associated with the subject for the course.
 | 
VARCHAR2(63)
 | 
 
 | 
 SSBSECT
 
 | 
 SSBSECT_CRSE_NUMB
 
 | 
| 
COURSE_REFERENCE_NUMBER
 | 
Course Reference Number 
 | 
Computer assigned internal unique number for the schedule offering.
 | 
VARCHAR2(5)
 | 
 
 | 
 SSRMEET
 
 | 
 SSRMEET_CRN
 
 | 
| 
END_DATE
 | 
End Date 
 | 
End date for the section meeting time record.
 | 
DATE
 | 
 
 | 
 SSRMEET
 
 | 
 SSRMEET_END_DATE
 
 | 
| 
END_TIME
 | 
End Time 
 | 
Time the offering meeting ends.
 | 
VARCHAR2(4)
 | 
 
 | 
 SSRMEET
 
 | 
 SSRMEET_END_TIME
 
 | 
| 
EVENT_FUNCTION
 | 
Event Function 
 | 
Specifies whether the meeting is an event function.
 | 
VARCHAR2(63)
 | 
 
 | 
 SSRMEET
 
 | 
 SSRMEET_FUNC_CODE
 
 | 
| 
EVENT_FUNCTION_DESC
 | 
Event Function Description 
 | 
Function code description.
 | 
VARCHAR2(255)
 | 
 
 | 
 GTVFUNC
 
 | 
 GTVFUNC_DESC
 
 | 
| 
FRIDAY_IND
 | 
Friday Indicator 
 | 
Indicates whether the section meets on Friday.
 | 
VARCHAR2(1)
 | 
 
 | 
 SSRMEET
 
 | 
 SSRMEET_FRI_DAY
 
 | 
| 
INSTRUCTION_DELIVERY_MODE
 | 
Instruction Delivery Method 
 | 
Instructional delivery method associated with the course.
 | 
VARCHAR2(255)
 | 
 
 | 
 SSBSECT
 
 | 
 SSBSECT_INSM_CODE
 
 | 
| 
INSTRUCTION_DELIVERY_MODE_DESC
 | 
Instruction Delivery Method Description 
 | 
Instructional delivery mode description for the course schedule type code.
 | 
VARCHAR2(255)
 | 
 
 | 
 GTVINSM
 
 | 
 GTVINSM_DESC
 
 | 
| 
MEETING_ACTIVITY_DATE
 | 
Meeting Activity Date 
 | 
Date record was inserted or updated.
 | 
DATE
 | 
 
 | 
 SSRMEET
 
 | 
 SSRMEET_ACTIVITY_DATE
 
 | 
| 
MEETING_HOURS
 | 
Meeting Hours 
 | 
Hours per week that the section is scheduled to meet.
 | 
NUMBER
 | 
 
 | 
 SSRMEET
 
 | 
 SSRMEET_HRS_WEEK
 
 | 
| 
MEETING_TYPE
 | 
Meeting Type 
 | 
Meeting type of the section.
 | 
VARCHAR2(63)
 | 
 
 | 
 SSRMEET
 
 | 
 SSRMEET_MTYP_CODE
 
 | 
| 
MEETING_TYPE_DESC
 | 
Meeting Type Description 
 | 
Meeting type description.
 | 
VARCHAR2(255)
 | 
 
 | 
 GTVMTYP
 
 | 
 GTVMTYP_DESC
 
 | 
| 
MONDAY_IND
 | 
Monday Indicator 
 | 
Indicates whether the section meets on Monday.
 | 
VARCHAR2(1)
 | 
 
 | 
 SSRMEET
 
 | 
 SSRMEET_MON_DAY
 
 | 
| 
MULTI_SOURCE
 | 
Multi Source 
 | 
Institution value for the record when the optional multi-institution facility feature has been applied.
 | 
VARCHAR2(63)
 | 
 
 | 
 NA
 
 | 
 NA
 
 | 
| 
MULTI_SOURCE_DESC
 | 
Multi Source Description 
 | 
Institution description when the optional multi-institution facility feature has been applied.
 | 
VARCHAR2(255)
 | 
 
 | 
 NA
 
 | 
 NA
 
 | 
| 
PROCESS_GROUP
 | 
Process Group 
 | 
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
 | 
VARCHAR2(255)
 | 
 
 | 
 NA
 
 | 
 NA
 
 | 
| 
ROOM
 | 
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
 | 
Saturday Indicator 
 | 
Indicates whether the section meets on Saturday.
 | 
VARCHAR2(1)
 | 
 
 | 
 SSRMEET
 
 | 
 SSRMEET_SAT_DAY
 
 | 
| 
SCHEDULE
 | 
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(63)
 | 
 
 | 
 SSRMEET
 
 | 
 SSRMEET_SCHD_CODE
 
 | 
| 
SCHEDULE_CONFLICT_OVERRIDE
 | 
Schedule Conflict Override 
 | 
Indicates when an override was required to schedule this meeting record and if it was oerridden due to a room conflict, time conflict, or both.
 | 
VARCHAR2(63)
 | 
 
 | 
 FUNCTION
 
 | 
 CASE WHEN SSRMEET_OVER_RIDE
 
 | 
| 
SCHEDULE_DESC
 | 
Schedule Description 
 | 
Schedule or instructional type description for this section.
 | 
VARCHAR2(255)
 | 
 
 | 
 STVSCHD
 
 | 
 STVSCHD_DESC
 
 | 
| 
SCHEDULE_STATUS
 | 
Schedule Status 
 | 
Identifies the current status of the section.
 | 
VARCHAR2(63)
 | 
 
 | 
 SSRMEET
 
 | 
 SSRMEET_SCHS_CODE
 
 | 
| 
SCHEDULE_STATUS_DESC
 | 
Schedule Status Description 
 | 
Section status description. For example, is registration permitted.
 | 
VARCHAR2(255)
 | 
 
 | 
 GTVSCHS
 
 | 
 GTVSCHS_DESC
 
 | 
| 
SCHED_CONFLICT_OVERRIDE_DESC
 | 
Sched Conflict Override Description 
 | 
Schedule conflict override description.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 CASE WHEN SSRMEET_OVER_RIDE
 
 | 
| 
SECTION
 | 
Section 
 | 
Section sequence number for this offering of the course.
 | 
VARCHAR2(63)
 | 
 
 | 
 SSBSECT
 
 | 
 SSBSECT_SEQ_NUMB
 
 | 
| 
SECTION_DESC
 | 
Section Description 
 | 
Course section description.
 | 
VARCHAR2(255)
 | 
 
 | 
 NA
 
 | 
 NA
 
 | 
| 
START_DATE
 | 
Start Date 
 | 
Date the course offering instruction began for this section.
 | 
DATE
 | 
 
 | 
 SSRMEET
 
 | 
 SSRMEET_START_DATE
 
 | 
| 
SUBJECT
 | 
Subject 
 | 
Main instructional subject area for this course.
 | 
VARCHAR2(63)
 | 
 
 | 
 SSBSECT
 
 | 
 SSBSECT_SUBJ_CODE
 
 | 
| 
SUBJECT_DESC
 | 
Subject Description 
 | 
Subject code description.
 | 
VARCHAR2(255)
 | 
 
 | 
 STVSUBJ
 
 | 
 STVSUBJ_DESC
 
 | 
| 
SUB_ACADEMIC_PERIOD
 | 
Sub Academic Period 
 | 
A session, portion or part of the academic period.
 | 
VARCHAR2(63)
 | 
 
 | 
 SSBSECT
 
 | 
 SSBSECT_PTRM_CODE
 
 | 
| 
SUB_ACADEMIC_PERIOD_DESC
 | 
Sub Academic Period Description 
 | 
Sub academic period description.
 | 
VARCHAR2(255)
 | 
 
 | 
 STVPTRM
 
 | 
 STVPTRM_DESC
 
 | 
| 
SUNDAY_IND
 | 
Sunday Indicator 
 | 
Indicates whether the section meets on Sunday.
 | 
VARCHAR2(1)
 | 
 
 | 
 SSRMEET
 
 | 
 SSRMEET_SUN_DAY
 
 | 
| 
THURSDAY_IND
 | 
Thursday Indicator 
 | 
Indicates whether the section meets on Thursday.
 | 
VARCHAR2(1)
 | 
 
 | 
 SSRMEET
 
 | 
 SSRMEET_THU_DAY
 
 | 
| 
TITLE_LONG_DESC
 | 
Title Long Description 
 | 
Long title of the course.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 SOKODSF.F_GET_CRSE_LONG_TITLE
 
 | 
| 
TITLE_SHORT_DESC
 | 
Title Short Description 
 | 
Displays the course or section short title.
 | 
VARCHAR2(255)
 | 
 
 | 
 SSBSECT
 
 | 
 SSBSECT_CRSE_TITLE
 
 | 
| 
TUESDAY_IND
 | 
Tuesday Indicator 
 | 
Indicates whether the section meets on Tuesday.
 | 
VARCHAR2(1)
 | 
 
 | 
 SSRMEET
 
 | 
 SSRMEET_TUE_DAY
 
 | 
| 
WEDNESDAY_IND
 | 
Wednesday Indicator 
 | 
Indicates whether the section meets on Wednesday.
 | 
VARCHAR2(1)
 | 
 
 | 
 SSRMEET
 
 | 
 SSRMEET_WED_DAY
 
 |