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

Query Name: UCCS_R_SCHD_CUSTODIAL
Report Title: Class Schedule: Custodial Schedule
Purpose: Reporting on schedule of classes based on characteristics of their meeting patterns; limited by default to classes ending after 5pm. Intended to be used for custodial scheduling.
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

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 17:00)
  • To End Time (default 23:59)
  • Start and end time ranges default to return only classes ending after 5pm. Specify other 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