...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
| Note |
|---|
Please note the Timetabler - Determining reserve cap order procedure should be done first. |
Quest work in SCHDPROC:
Run queries that are course clean-up related. This is just to ensure that we have good information.
UW_RS_SCH_AUTO_NO_AUTO_ENRL_NP
UW_RS_CEM_TOPICS_W_SEC_COMP_KW
UW_RS_SCH_CAMP_NO_SEC_CAMP_SB (ie FR 192B has one STJ section but ORL have only UW)
UW_RS_MISMATCH_UNIT_SESSION_SB
UW_RS_MISSMATCH_PCS_VCB
UW_RS_PCS_BUT_NO_REAL_SB
UW_RS_PCS_BUT_CANCEL_REAL_SB
Run queries that are students and reserve cap related:
...
UW_RS_CEM_MODE_NE_PCS_MODE_NP – If not using student demand this query is not required
UW_RS_RESERVE_CAP_ORDER_NP
UW_RS_RSRV_CAP_COND_PROB_JV
UW_RS_MISSING_PARENTH_NP
UW_RS_MISSMATCH_PARENTH_NP – Tells you how many parenthesis are not matched
UW_RS_MISSMATCH_PARENTH_NEW_JV – Tells you which RQ’s are missing parenthesis
UW_RS_MISS_RC_IN_RCWGHT_TBL_NP
UW_RS_BLANK_WHERE_CLAUSE_NP
UW_RS_SCH_BLANK_RSRV_CAP_NP
UW_RS_SCH_MULTI_RSRV_CAP_NP
UW_RS_CLASS_LIST_IN_RC_NP
UW_RS_RSRV_CAP_USING_NE_SB -- Looks for RC's with NE condition operator
UW_RS_RSRV_CAP_USING_NI_EG - Looks for RC's with NI condition operator
...
Ensure that scheduling has updated all reserve cap changes.
Run Course Anomaly Report:
Run it for GRD and UG
Waterloo Student Admin
→ CEM
→ Process
→ Course Scheduling Anomaly Report
PCS Populate Demand process:
Waterloo Student Admin
→ CEM
→ Process
→ Populate Demand Tables
Reserve Capacity Assignment process:
Run it from GRD and UG (UG process takes a bit of time – 30 minutes)
Waterloo Student Admin
→ CEM
→ Process
→ Reserve Cap Assignment
Navigate to:
Waterloo Student Admin
→ Scheduling → Processes → Timetabler Extract (takes about 15 minutes)
run control: timetabler_extract
Enter in upcoming term and previous like term
Evening start time should be 16:00
File path is: /software/sa.sisp-1.0_prod/spool/outgoing/DCU/
Run the PS Job (UWTPINTT)
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
When the Timetabler Extract process has completed, navigate to:
Q: > k2 > PROD > outgoing and move DCU folder onto desktop of virtual machine. Put another copy on the R:Drive (R:\Records and Systems\Sectioning formerly TPHI\TERM)
Take a backup in current PROD version in Infosilem (Timetabler/Scheduling)
Once logged into Academic Suite select File -> → Import:
...
Select File Types: Space-delimited text file (TXT)
Keep in Infosilem Academic Suite records that do not exist in the source files (Do Not Delete) = Y
click next
Select the following files:
Components - Course Characteristics
Course Characteristics
Alternate Course CharacteristicsAssigned Component RequestsCategoriesComponent RequestsProgramsStudent TypesStudents(*If not using student demand, then files with strikethrough are not required*)
...
Click on Next and Browse and point to DCU folder on desktop. Click on Set All and Same Folder as Selected then click Next.
Check the Report for any problems. If everything is ok, click on Next.
Check the reports
If there are errors on the report – take a screen shot then abort the download and fix the errors – these are usually coding errors (course numbers are mis-typed, or sections need to be created)
When everything is ok click Import.