Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
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_RESERVE_CAP_ORDER_NP 

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 

Expand
titleQueries we currently do not run

UW_RS_CEM_EVENING_BUT_BLOCK_KW – If not using student demand this query is not required 

UW_RS_CEM_EVENING_BUT_FT_NP – If not using student demand this query is not required 

UW_RS_CEM_ZERO_PRIORITY_BAD_KW – If not using student demand this query is not required 

UW_RS_CEM_CAMP_NE_PCS_CAMP_NP – If not using student demand this query is not required 

UW_RS_CEM_MODE_NE_PCS_MODE_NP – If not using student demand this query is not required 

...

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 - Doesn’t affect scheduling

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

...

_

...

UW_RS_SCH_BLANK_RSRV_CAP_NP 

...

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 

      image-20240125-192726.pngImage Added

      image-20240125-192848.pngImage Added

  • 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 

...