| 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
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
...
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)
...