Schedule-Related Queries

The queries listed below will assist in the identification of potential issues such as Class Association errors, Instructor Role Access errors and Meeting Date errors.

The queries names must be entered exactly as indicated below.

Queries are available by navigating to Reporting Tools>Query.

(The queries names must be entered exactly as indicated below.) 

• Class Association Errors:  UH_RAR_CLS_ASSC_ERROR
• Instructor Role Access:  UH_RAR_AUDIT_INSTR_ROLE_ACCESS
• Term Date Errors:  UH_RAR_TERM_DATES_QRY
• Courses Outside University Recognized Time Bands:  UH_TIMEBAND_CRSE1
• Courses in University Recognized Time Bands by Enrollment: UH_TIMEBAND_CRSE
• Course enrollment between the prompted terms for up to 3 catalog numbers of one subject: UHM_DE_COURSE_HISTORY
• Class Schedule by Course Level:   PM_CLASS_SCHEDULE_BY_LVL_DEPT
• Active Course Offerings in Cat: CATLG_CRSE_OFFR
• Hours Not Equal:  COURSE_DISCREPANCIES
• Courses by Term and Instructor:  COURSE_INST_TERMINFO or SHORTSCHED_TERMINFO
• Duplicate Section Numbers: DOUBLE_COURSE_SAME_SECTN_MODIF
• Inactive Instructors: INACTIVE_INSTRUCTORS
• Location Discrepancy: LOCATION_CODE_DOESNT_MATCH
• Section Number Not Used Yet:  SECTION_NUMBERS_ALL
• Primary Instructor Room Utiliz:  UHIR_CLASS_TABLE, UHIR_CLASS_DEPT
• GRD UGR Enroll Less Than 10:  UHIR_ENRL_ENROLLMENT
• Space Utilization by Seat Fill:  UHM_SPACE_UTLI_REPORT
• Check Meeting Patterns:  UH_CLASS_MTG_PAT
• Ck Summer No Friday Meeting:  UH_CLASS_NO_FRIDAY
• When Course Last Taught:  UH_SUBJECT, UH_SUBJECT_LAST, UH_COURSE_LAST_TAUGHT, or UH_SUBJECT_LAST_MV
• UH Hybrid Courses:  UH_RAR_HYBRID_COURSES
• Sections Not Having Cat Dates:  UH_RAR_TERM_DATES_QRY