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

Query Name: UCCS_R_SCHD_COMBINED_SECTIONS
Report Title: Class Schedule: Combined Sections
Purpose: Reporting on classes that are part of a Combined Section, for user-entered term and other optional prompts.  Includes combined section, meeting pattern, and instructor data.
Description:

Rows: Classes that are part of combined sections only. One row per combined section ID, per class, per meeting pattern, per instructor, for specified term, filtered by optional user-entered prompts. Combined section data repeats for each combined section ID. Class data repeats for each meeting pattern and instructor for the class.

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

Required Prompts: Term

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

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:  If a combined-section class meets the entered criteria, all classes that are part of the combined section appear (not just those that meeting the criteria). Combined section data repeats for each class included in the combined section.​
Report Elements:

For description of elements visit the Custom Fields Table