Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Student Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: MEETING_TIME_SLOT

Description Uses data from the MEETING TIME reporting view. Displays up to 10 sets of values when more than one meeting time exists for a course reference number. Details include the meeting dates, days, times, building and room number. Currently there are no associated display rules.
Key & Frequency One row per course reference number per academic period.
Recommended Search Columns ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER
ACTIVITY_DATE

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(63)

SSRMEET

SSRMEET_TERM_CODE

ACTIVITY_DATE Date record was inserted or updated DATE

NA

SYSDATE

ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

BEGIN_TIME1 Begin time of the section or schedule offering. It is in the format HHMM using military time. VARCHAR2(4)

SSRMEET

SSRMEET_BEGIN_TIME

BEGIN_TIME10 Begin time of the section or schedule offering. It is in the format HHMM using military time. VARCHAR2(4)

SSRMEET

SSRMEET_BEGIN_TIME

BEGIN_TIME2 Begin time of the section or schedule offering. It is in the format HHMM using military time. VARCHAR2(4)

SSRMEET

SSRMEET_BEGIN_TIME

BEGIN_TIME3 Begin time of the section or schedule offering. It is in the format HHMM using military time. VARCHAR2(4)

SSRMEET

SSRMEET_BEGIN_TIME

BEGIN_TIME4 Begin time of the section or schedule offering. It is in the format HHMM using military time. VARCHAR2(4)

SSRMEET

SSRMEET_BEGIN_TIME

BEGIN_TIME5 Begin time of the section or schedule offering. It is in the format HHMM using military time. VARCHAR2(4)

SSRMEET

SSRMEET_BEGIN_TIME

BEGIN_TIME6 Begin time of the section or schedule offering. It is in the format HHMM using military time. VARCHAR2(4)

SSRMEET

SSRMEET_BEGIN_TIME

BEGIN_TIME7 Begin time of the section or schedule offering. It is in the format HHMM using military time. VARCHAR2(4)

SSRMEET

SSRMEET_BEGIN_TIME

BEGIN_TIME8 Begin time of the section or schedule offering. It is in the format HHMM using military time. VARCHAR2(4)

SSRMEET

SSRMEET_BEGIN_TIME

BEGIN_TIME9 Begin time of the section or schedule offering. It is in the format HHMM using military time. VARCHAR2(4)

SSRMEET

SSRMEET_BEGIN_TIME

BUILDING1 Building code for the room assignment. VARCHAR2(63)

SSRMEET

SSRMEET_BLDG_CODE

BUILDING10 Building code for the room assignment. VARCHAR2(63)

SSRMEET

SSRMEET_BLDG_CODE

BUILDING2 Building code for the room assignment. VARCHAR2(63)

SSRMEET

SSRMEET_BLDG_CODE

BUILDING3 Building code for the room assignment. VARCHAR2(63)

SSRMEET

SSRMEET_BLDG_CODE

BUILDING4 Building code for the room assignment. VARCHAR2(63)

SSRMEET

SSRMEET_BLDG_CODE

BUILDING5 Building code for the room assignment. VARCHAR2(63)

SSRMEET

SSRMEET_BLDG_CODE

BUILDING6 Building code for the room assignment. VARCHAR2(63)

SSRMEET

SSRMEET_BLDG_CODE

BUILDING7 Building code for the room assignment. VARCHAR2(63)

SSRMEET

SSRMEET_BLDG_CODE

BUILDING8 Building code for the room assignment. VARCHAR2(63)

SSRMEET

SSRMEET_BLDG_CODE

BUILDING9 Building code for the room assignment. VARCHAR2(63)

SSRMEET

SSRMEET_BLDG_CODE

BUILDING_DESC1 Name of the building. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

BUILDING_DESC10 Name of the building. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

BUILDING_DESC2 Name of the building. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

BUILDING_DESC3 Name of the building. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

BUILDING_DESC4 Name of the building. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

BUILDING_DESC5 Name of the building. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

BUILDING_DESC6 Name of the building. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

BUILDING_DESC7 Name of the building. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

BUILDING_DESC8 Name of the building. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

BUILDING_DESC9 Name of the building. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

COURSE_REFERENCE_NUMBER Computer assigned internal unique number for the schedule offering. VARCHAR2(5)

SSRMEET

SSRMEET_CRN

END_TIME1 Time the offering meeting ends. VARCHAR2(4)

SSRMEET

SSRMEET_END_TIME

END_TIME10 Time the offering meeting ends. VARCHAR2(4)

SSRMEET

SSRMEET_END_TIME

END_TIME2 Time the offering meeting ends. VARCHAR2(4)

SSRMEET

SSRMEET_END_TIME

END_TIME3 Time the offering meeting ends. VARCHAR2(4)

SSRMEET

SSRMEET_END_TIME

END_TIME4 Time the offering meeting ends. VARCHAR2(4)

SSRMEET

SSRMEET_END_TIME

END_TIME5 Time the offering meeting ends. VARCHAR2(4)

SSRMEET

SSRMEET_END_TIME

END_TIME6 Time the offering meeting ends. VARCHAR2(4)

SSRMEET

SSRMEET_END_TIME

END_TIME7 Time the offering meeting ends. VARCHAR2(4)

SSRMEET

SSRMEET_END_TIME

END_TIME8 Time the offering meeting ends. VARCHAR2(4)

SSRMEET

SSRMEET_END_TIME

END_TIME9 Time the offering meeting ends. VARCHAR2(4)

SSRMEET

SSRMEET_END_TIME

FRIDAY_IND1 Indicates whether the section meets on Friday. VARCHAR2(1)

SSRMEET

SSRMEET_FRI_DAY

FRIDAY_IND10 Indicates whether the section meets on Friday. VARCHAR2(1)

SSRMEET

SSRMEET_FRI_DAY

FRIDAY_IND2 Indicates whether the section meets on Friday. VARCHAR2(1)

SSRMEET

SSRMEET_FRI_DAY

FRIDAY_IND3 Indicates whether the section meets on Friday. VARCHAR2(1)

SSRMEET

SSRMEET_FRI_DAY

FRIDAY_IND4 Indicates whether the section meets on Friday. VARCHAR2(1)

SSRMEET

SSRMEET_FRI_DAY

FRIDAY_IND5 Indicates whether the section meets on Friday. VARCHAR2(1)

SSRMEET

SSRMEET_FRI_DAY

FRIDAY_IND6 Indicates whether the section meets on Friday. VARCHAR2(1)

SSRMEET

SSRMEET_FRI_DAY

FRIDAY_IND7 Indicates whether the section meets on Friday. VARCHAR2(1)

SSRMEET

SSRMEET_FRI_DAY

FRIDAY_IND8 Indicates whether the section meets on Friday. VARCHAR2(1)

SSRMEET

SSRMEET_FRI_DAY

FRIDAY_IND9 Indicates whether the section meets on Friday. VARCHAR2(1)

SSRMEET

SSRMEET_FRI_DAY

MONDAY_IND1 Indicates whether the section meets on Monday. VARCHAR2(1)

SSRMEET

SSRMEET_MON_DAY

MONDAY_IND10 Indicates whether the section meets on Monday. VARCHAR2(1)

SSRMEET

SSRMEET_MON_DAY

MONDAY_IND2 Indicates whether the section meets on Monday. VARCHAR2(1)

SSRMEET

SSRMEET_MON_DAY

MONDAY_IND3 Indicates whether the section meets on Monday. VARCHAR2(1)

SSRMEET

SSRMEET_MON_DAY

MONDAY_IND4 Indicates whether the section meets on Monday. VARCHAR2(1)

SSRMEET

SSRMEET_MON_DAY

MONDAY_IND5 Indicates whether the section meets on Monday. VARCHAR2(1)

SSRMEET

SSRMEET_MON_DAY

MONDAY_IND6 Indicates whether the section meets on Monday. VARCHAR2(1)

SSRMEET

SSRMEET_MON_DAY

MONDAY_IND7 Indicates whether the section meets on Monday. VARCHAR2(1)

SSRMEET

SSRMEET_MON_DAY

MONDAY_IND8 Indicates whether the section meets on Monday. VARCHAR2(1)

SSRMEET

SSRMEET_MON_DAY

MONDAY_IND9 Indicates whether the section meets on Monday. VARCHAR2(1)

SSRMEET

SSRMEET_MON_DAY

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

ROOM1 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

ROOM10 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

ROOM2 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

ROOM3 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

ROOM4 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

ROOM5 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

ROOM6 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

ROOM7 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

ROOM8 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

ROOM9 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_IND1 Indicates whether the section meets on Saturday. VARCHAR2(1)

SSRMEET

SSRMEET_SAT_DAY

SATURDAY_IND10 Indicates whether the section meets on Saturday. VARCHAR2(1)

SSRMEET

SSRMEET_SAT_DAY

SATURDAY_IND2 Indicates whether the section meets on Saturday. VARCHAR2(1)

SSRMEET

SSRMEET_SAT_DAY

SATURDAY_IND3 Indicates whether the section meets on Saturday. VARCHAR2(1)

SSRMEET

SSRMEET_SAT_DAY

SATURDAY_IND4 Indicates whether the section meets on Saturday. VARCHAR2(1)

SSRMEET

SSRMEET_SAT_DAY

SATURDAY_IND5 Indicates whether the section meets on Saturday. VARCHAR2(1)

SSRMEET

SSRMEET_SAT_DAY

SATURDAY_IND6 Indicates whether the section meets on Saturday. VARCHAR2(1)

SSRMEET

SSRMEET_SAT_DAY

SATURDAY_IND7 Indicates whether the section meets on Saturday. VARCHAR2(1)

SSRMEET

SSRMEET_SAT_DAY

SATURDAY_IND8 Indicates whether the section meets on Saturday. VARCHAR2(1)

SSRMEET

SSRMEET_SAT_DAY

SATURDAY_IND9 Indicates whether the section meets on Saturday. VARCHAR2(1)

SSRMEET

SSRMEET_SAT_DAY

SCHEDULE1 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

SCHEDULE10 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

SCHEDULE2 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

SCHEDULE3 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

SCHEDULE4 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

SCHEDULE5 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

SCHEDULE6 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

SCHEDULE7 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

SCHEDULE8 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

SCHEDULE9 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_DESC1 Schedule or instructional type description for this section. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SCHEDULE_DESC10 Schedule or instructional type description for this section. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SCHEDULE_DESC2 Schedule or instructional type description for this section. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SCHEDULE_DESC3 Schedule or instructional type description for this section. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SCHEDULE_DESC4 Schedule or instructional type description for this section. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SCHEDULE_DESC5 Schedule or instructional type description for this section. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SCHEDULE_DESC6 Schedule or instructional type description for this section. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SCHEDULE_DESC7 Schedule or instructional type description for this section. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SCHEDULE_DESC8 Schedule or instructional type description for this section. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SCHEDULE_DESC9 Schedule or instructional type description for this section. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SUNDAY_IND1 Indicates whether the section meets on Sunday. VARCHAR2(1)

SSRMEET

SSRMEET_SUN_DAY

SUNDAY_IND10 Indicates whether the section meets on Sunday. VARCHAR2(1)

SSRMEET

SSRMEET_SUN_DAY

SUNDAY_IND2 Indicates whether the section meets on Sunday. VARCHAR2(1)

SSRMEET

SSRMEET_SUN_DAY

SUNDAY_IND3 Indicates whether the section meets on Sunday. VARCHAR2(1)

SSRMEET

SSRMEET_SUN_DAY

SUNDAY_IND4 Indicates whether the section meets on Sunday. VARCHAR2(1)

SSRMEET

SSRMEET_SUN_DAY

SUNDAY_IND5 Indicates whether the section meets on Sunday. VARCHAR2(1)

SSRMEET

SSRMEET_SUN_DAY

SUNDAY_IND6 Indicates whether the section meets on Sunday. VARCHAR2(1)

SSRMEET

SSRMEET_SUN_DAY

SUNDAY_IND7 Indicates whether the section meets on Sunday. VARCHAR2(1)

SSRMEET

SSRMEET_SUN_DAY

SUNDAY_IND8 Indicates whether the section meets on Sunday. VARCHAR2(1)

SSRMEET

SSRMEET_SUN_DAY

SUNDAY_IND9 Indicates whether the section meets on Sunday. VARCHAR2(1)

SSRMEET

SSRMEET_SUN_DAY

THURSDAY_IND1 Indicates whether the section meets on Thursday. VARCHAR2(1)

SSRMEET

SSRMEET_THU_DAY

THURSDAY_IND10 Indicates whether the section meets on Thursday. VARCHAR2(1)

SSRMEET

SSRMEET_THU_DAY

THURSDAY_IND2 Indicates whether the section meets on Thursday. VARCHAR2(1)

SSRMEET

SSRMEET_THU_DAY

THURSDAY_IND3 Indicates whether the section meets on Thursday. VARCHAR2(1)

SSRMEET

SSRMEET_THU_DAY

THURSDAY_IND4 Indicates whether the section meets on Thursday. VARCHAR2(1)

SSRMEET

SSRMEET_THU_DAY

THURSDAY_IND5 Indicates whether the section meets on Thursday. VARCHAR2(1)

SSRMEET

SSRMEET_THU_DAY

THURSDAY_IND6 Indicates whether the section meets on Thursday. VARCHAR2(1)

SSRMEET

SSRMEET_THU_DAY

THURSDAY_IND7 Indicates whether the section meets on Thursday. VARCHAR2(1)

SSRMEET

SSRMEET_THU_DAY

THURSDAY_IND8 Indicates whether the section meets on Thursday. VARCHAR2(1)

SSRMEET

SSRMEET_THU_DAY

THURSDAY_IND9 Indicates whether the section meets on Thursday. VARCHAR2(1)

SSRMEET

SSRMEET_THU_DAY

TUESDAY_IND1 Indicates whether the section meets on Tuesday. VARCHAR2(1)

SSRMEET

SSRMEET_TUE_DAY

TUESDAY_IND10 Indicates whether the section meets on Tuesday. VARCHAR2(1)

SSRMEET

SSRMEET_TUE_DAY

TUESDAY_IND2 Indicates whether the section meets on Tuesday. VARCHAR2(1)

SSRMEET

SSRMEET_TUE_DAY

TUESDAY_IND3 Indicates whether the section meets on Tuesday. VARCHAR2(1)

SSRMEET

SSRMEET_TUE_DAY

TUESDAY_IND4 Indicates whether the section meets on Tuesday. VARCHAR2(1)

SSRMEET

SSRMEET_TUE_DAY

TUESDAY_IND5 Indicates whether the section meets on Tuesday. VARCHAR2(1)

SSRMEET

SSRMEET_TUE_DAY

TUESDAY_IND6 Indicates whether the section meets on Tuesday. VARCHAR2(1)

SSRMEET

SSRMEET_TUE_DAY

TUESDAY_IND7 Indicates whether the section meets on Tuesday. VARCHAR2(1)

SSRMEET

SSRMEET_TUE_DAY

TUESDAY_IND8 Indicates whether the section meets on Tuesday. VARCHAR2(1)

SSRMEET

SSRMEET_TUE_DAY

TUESDAY_IND9 Indicates whether the section meets on Tuesday. VARCHAR2(1)

SSRMEET

SSRMEET_TUE_DAY

WEDNESDAY_IND1 Indicates whether the section meets on Wednesday. VARCHAR2(1)

SSRMEET

SSRMEET_WED_DAY

WEDNESDAY_IND10 Indicates whether the section meets on Wednesday. VARCHAR2(1)

SSRMEET

SSRMEET_WED_DAY

WEDNESDAY_IND2 Indicates whether the section meets on Wednesday. VARCHAR2(1)

SSRMEET

SSRMEET_WED_DAY

WEDNESDAY_IND3 Indicates whether the section meets on Wednesday. VARCHAR2(1)

SSRMEET

SSRMEET_WED_DAY

WEDNESDAY_IND4 Indicates whether the section meets on Wednesday. VARCHAR2(1)

SSRMEET

SSRMEET_WED_DAY

WEDNESDAY_IND5 Indicates whether the section meets on Wednesday. VARCHAR2(1)

SSRMEET

SSRMEET_WED_DAY

WEDNESDAY_IND6 Indicates whether the section meets on Wednesday. VARCHAR2(1)

SSRMEET

SSRMEET_WED_DAY

WEDNESDAY_IND7 Indicates whether the section meets on Wednesday. VARCHAR2(1)

SSRMEET

SSRMEET_WED_DAY

WEDNESDAY_IND8 Indicates whether the section meets on Wednesday. VARCHAR2(1)

SSRMEET

SSRMEET_WED_DAY

WEDNESDAY_IND9 Indicates whether the section meets on Wednesday. VARCHAR2(1)

SSRMEET

SSRMEET_WED_DAY



Ver: 8.0