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 |
...
| Info |
|---|
delivtimes = delivery times that are forced Timereq = delivery pattern requests those two combined make the timetable |
In the Timetabler database use rollover delete and advanced to delete deliveries“Tools” then “RollOver” then “Delete…” and “Advanced” to “Select a data element:” then select “Deliveries”:
any deliveries associated with a TST slot
any deliveries with no time or no room request (Status red top/bottom)
Getting rid of any deliveries that have forced times and/or rooms.
any deliveries with a forced time (Status has a green bottom)
any deliveries with forced room and no time (green top red bottom)
any deliveries with forced room and time request (green top white bottom)
any deliveries with forced room and time (complete green)
Run the Data Consistency Check of “Deliveries having room requests without specified Pavilion“ and batch edit all deliveries to remove the room requests that are blank (these are mostly WLU room requests)
...
In the new term (Secondary Files → Terms) change the start and end dates to the actual first and last day of the term. Deactivate all scheduling groups, then reactivate them all to catch any deliveries that are missing: Tools → Scheduling Groups Deactivation/Activation → Component Groups. Select all and Save to deactivate, repeat to activate.
Must change blockoff dates and remove all instructors from any blockoffs that aren't their names only
Make sure Instructors do not have any constraints overridden (checkbox)
Deactivate all the held withs, then re-activate them all to catch any that aren’t aligned with the same delivery information. Tools → Scheduling Groups Deactivation→ Component Groups
...
Tools → Scheduling Groups Activation → Component Groups
...
After activating you will likely get this error message:
...
To fix them open the component group, select the components tab, select all courses and open them.
...
Select their Deliveries tabs. Sometimes one has a delivery and other other is missing the delivery. Since the DCU is still closed, you can either copy over the one delivery to the other course, or delete the one delivery. As long as they match. Once they do, head back to the Scheduling Groups Activation tool, and save that component group:
...
DCU Admin Setup
The procedure is called Academic Suite - Opening DCU and Message Board Examples
...