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
|