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 |
...
In the Course characteristics file (crschar.txt) in the DCU folder remove all the reserves that are brought in and DE, DIST, EVE, NEVE, OC, RESALL, SPACE , UAE – this will save you from manually removing them within Timetabler later (O:\Timetabler\Import\DCU)
In Infosilem Timetabler navigate to Import. File -> Import. Make sure the "Select File Type(s)” are Space-delimited (TXT).
...
any deliveries associated with a TST slot
any deliveries with no time or no room request (Status red top/bottom)
any deliveries with a room request and no time (white top/red bottom)
Getting rid of any deliveries that have forced times and/or rooms.
any deliveries with a forced room and no time (Status has a green top red bottom)
any deliveries with forced room and no time request (green top red white bottom)
any deliveries with a forced room and time request (Status has a 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)
...
, if they weren’t already removed by the white top/red bottom roll over delete)
In the new term (Secondary Files → Terms) change the start and end dates to the actual first and last day of the term.
...