GA Scheduling Compliance Dashboard GA Scheduling Compliance Dashboard PS Query Query Create and Manage Curriculum Schedule of Classes
 

Query Name: GA Scheduling Compliance Dashboard
Report Title: GA Scheduling Compliance Dashboard
Purpose: Reporting related to compliance with OR rules for scheduling classes into General Assignment classroom space.  Intended to be run via a WorkCenter page within Campus Solutions, but may also be run via Query Viewer.
Description: 18 individual queries (9 summary and 9 detail) are included in this Work Center, as follows:

GA Hours Limit:
UCCS_R_SCDB_GA_HOURS
UCCS_R_SCDB_GA_HOURS_DRILL
Prime-time 70/30 Split:
UCCS_R_SCDB_PRIMETIME
UCCS_R_SCDB_PRIMETIME_DRILL
50/50 Weekday Split:
UCCS_R_SCDB_WKDAY_SPLIT
UCCS_R_SCDB_WKDAY_SPLIT_DRILL
Capacity Limits:
UCCS_R_SCDB_CAPACITY
UCCS_R_SCDB_CAPACITY_DRILL
Standard Meeting Patterns:
UCCS_R_SCDB_STD_MTG_PAT
UCCS_R_SCDB_STD_MTG_PAT_DRILL
Primary/Secondary Meeting Conflicts:
UCCS_R_SCDB_CONFLICT1
UCCS_R_SCDB_CONFLICT1_DRILL
Internal Meeting Conflicts:
UCCS_R_SCDB_CONFLICT2
UCCS_R_SCDB_CONFLICT2_DRILL
Non-15-week classes:
UCCS_R_SCDB_15WK
UCCS_R_SCDB_15WK_DRILL
Colloquium classes:
UCCS_R_SCDB_COLLOQ
UCCS_R_SCDB_COLLOQ_DRILL

Functional documentation on the workcenter is available here:
https://drive.google.com/a/berkeley.edu/file/d/0Bx4jbMU1dnRRVm13SS0ybTkz...
w?usp=sharing

And more technical documentation on the queries themselves is here:
https://drive.google.com/a/berkeley.edu/file/d/0Bx4jbMU1dnRRUndMQUsxRzRr...
w?usp=sharing

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