Queries that must be be run before importing the courses, they can be run by anyone with query access. The queries can be run throughout the entering of prior term copies to save you from having to a monster clean up, but they all must be run after the prior term copies have been entered and checked.
...
Run scheduling queries related to course cleanup:
UW_RS_SOC_ORGS_GROUPS_NP – If you get results you must do a course roll (Curriculum Management -> Roll Curriculum Data Forward -> Course Roll) that should fix them!
Run query to look for missing RC weights (UW_RS_MISS_RC_IN_RCWGHT_TBL_NP) if there were some that needed to be added re-run: UW_RS_RESERVE_CAP_ORDER_NP to catch any changes.
| Note |
|---|
Ensure Scheduling has updated all course changes |
...
Waterloo Student Admin > CEM > Process > Course Scheduling Anomaly Report
Enter in the term you about to run – run it twice once for GRD and once for UG, and the server name is SISP1
Once it’s finished running and the status is “Success” and “Posted” in the Process monitor click “Details” then “View/Log Trace” then the “.out” file
fix in Timetabler Quest if required (most fixes will be within Quest as there’s no courses imported yet in Timetabler) , so there’s nothing to fix there)
...
To “fix” them check in Quest to see if the associated class number can all be 1 for UW courses, and 81 for the CEL sections. Currently most cannot be corrected unless a new way to code has been created to resolve the issue that sectioner is having.
Navigate to:
Waterloo Student Admin > Scheduling >Processes > Timetabler Extract
...