Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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_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_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 Characteristics 

  • Assigned Component Requests 

  • Categories 

  • Component Requests 

  • Programs 

  • Student Types 

  • Students (*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. 

  • No labels