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

Query Name: UCCS_R_SCHD_TOPICS
Report Title: Class Schedule: Topics Only
Purpose: Reporting on Schedule of Classes, for classes having a free-form topic defined, for user-entered term and other optional prompts.  Limited set of core data elements, including meeting patterns and instructors.
Description:

Rows: Classes with free-form topics defined only.  One row per class, per meeting pattern, per instructor, for specified term, filtered by optional user-entered prompts.  Class data repeats for each meeting pattern and instructor.

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

Required Prompts: Term

Optional Prompts: General Assignment (Y/N), Career, Group, Org, Cluster, Subject, Catalog Number (accepts % wildcard), Enrollment Status

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, SR Registrar Sched of Classes

Process: Create and Manage Curriculum
Usage Notes:  ​Use to pull lists of classes that have free-form topics defined as part of their meeting pattern. Meeting patterns without free-form topics defined do not appear.​
Report Elements:

For description of elements visit the Custom Fields Table