Versions Compared

Old Version 4

changes.mady.by.user Elysia Gallinaro

Saved on

compared with

New Version Current

changes.mady.by.user Elysia Gallinaro

Saved on

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_MISS_RC_IN_RCWGHT_TBL_NP 

UW_RS_BLANK_WHERE_CLAUSE_NP 

UW_RS_SCH_BLANK_RSRV_CAP_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 

      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 

...

  • 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) to the O drive “O:\Timetabler\Import“ 

  • Take a backup in current PROD version in Infosilem (Timetabler/Scheduling) 

...