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_CATLG_ORGS_GROUPS_NP – Manually scroll through list and ensure that for the subject the Acad Org and Group are the same through the list – if different contact catalog person in either Grad or UG to have them fix it
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 |
...
Click on Next and Browse and point to DCU folder on desktop. Click on Set All and Same Folder as Selected then select Next.
...
| Expand | ||
|---|---|---|
| ||
The “open Rejected Records Report” will have some errors these are courses with time/days on their deliveries and it’s telling you the “dates” are incorrect – but we delete anything in the database with days/times/rooms on it. We clean it up later and is okay to ignore.   |
| Note |
|---|
You will get rejects here. Open up the “source”.txt file on the O drive and see if you can plainly see what's missing (say a start date) if it's a forced pattern move on. otherwise dig further and check that the files were pointing to the correct ones. Timereq was pointing to Delivtimes - but I think I clicked it incorrectly - so pay attention and don't do that! |
...
| Expand | ||
|---|---|---|
| ||
Timereq errors - these are forced times and dates that no longer are in the system
LocSpec errors - the building either has changed or didn’t get attached correctly - this is again fine as we delete everything with a room attached anyways CompChar - these are the course characteristics - we deleted them above, so it makes sense that we have errors for it!  |
| Info |
|---|
delivtimes = delivery times that are forced Timereq = delivery pattern requests those two combined make the timetable |
...
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.
Ensure Deactivate all scheduling groups are activated, then reactivate them all to catch any deliveries that are missing: Tools → Scheduling Groups 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
...