| Note |
|---|
Please note the Timetabler - Determining reserve cap order procedure should be done first. |
...
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 - Used only for sectioner, I’m not sure if it’s still an issue
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 - Sectioner query
UW_RS_RSRV_CAP_USING_NI_EG- Looks for RC's with NI condition operator - Sectioner Query
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
...