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 |
Run Course Anomaly Report
Quest work:
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 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 if required (most fixes will be within Quest as there’s no courses imported yet in Timetabler)
Navigate to:
Waterloo Student Admin > Scheduling >Processes > Timetabler Extract
...
Change terms as appropriate.
run control: timetabler_extract
Upcoming term gets entered and previous like term
Evening start time is 4:00PM (16:00)
...
run control: timetabler_extract
filepath: /software/sa.sisp-1.0_prod/spool/outgoing/DCU/
When running in a test environment “/software/sa.sisp-1.0_dev/spool/outgoing/DCU/”
Run the PS Job (UWTPINTT)
The order isthe processes run are:
UWTPINEX = Timetabler Course Extract
UWTPINSE = timetabler extract setup - set up files
UWTPINST = Timetabler Extract Student - we don't use students - but it might contain programs
UWTPINCP - Timetabler extract conversion
...
Q: > k2 > PROD > outgoing and move DCU folder onto desktop
Test would be “Q:\ozark\dev\outgoing”
Should save a copy of the DCU folder on the R O drive "RO:\Records and SystemsTimetabler\TimetablerImport" (it should have todays date and replace the last DCU folder)
Timetabler work:
In Infosilem Timetabler navigate to Import. File -> Import on the database that you are creating. Make sure the "Select File Type(s) are Space-delimited (TXT)
...