Report Title Report Name or Query Name Report Type Data
Source
Business Process Reporting Area
Class Schedule: Classes by Timeslot UCCS_R_SCHD_BY_TIMESLOT PS Query   Create and Manage Curriculum Schedule of Classes
 

Query Name: UCCS_R_SCHD_BY_TIMESLOT
Report Title: Class Schedule: Classes by Timeslot
Purpose: Reporting on class schedule based on characteristics of meeting times and locations.
Description: Rows: One row per class, per meeting pattern, per instructor, for specified term,
filtered by optional user-entered prompts. 

Columns: Core Schedule of Classes data elements, including meeting patterns and
instructors

Required Prompts:

  • Term
  • Day: Note that the report can be run for only one day at a time. For example, specifying ‘M’ returns all classes that meet on a Monday, regardless of other days on its meeting pattern (M, MW, MWF, etc.)  To run for multiple days, run each day separately and combine the results.
  • From Start Time (default 00:00)
  • To Start Time (default 23:59)
  • From End Time (default 00:00)
  • To End Time (default 23:59)
  • Start and end time ranges default to wide open times; specify narrower time ranges if desired.

Optional Prompts: General Assignment (Y/N), Building, Facility ID

Records used: CLASS_TBL, CLASS_CHRSTC, CLASS_ASSOC, CLASS_MTG_PAT,
CLASS_INSTR, SCC_PRI_NAME_VW, FACILITY_TBL, SUBJECT_TBL

User Access Group: SR Registrar Course Catalog
Process: Create and Manage Curriculum
Usage Notes:   
Report Elements: For description of elements visit the Custom Fields Table