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 | ||
---|---|---|
| ||
|
...
|
...
|
...
|
...
|
...
UW_RS_CLASS_LIST_IN_RC_NP
...
|
...
Looks for RC's with NE condition operator - Sectioner query
|
...
- 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
Expand | ||
---|---|---|
| ||
The Reserve Cap Assignment looks at all reserves on a course and assigns any reserves they meet as a characteristic to students. If a student meets a reserve they get that characteristic assigned, if they meet more than one they get one assigned and the other is an alternate. The component characteristics are assigned by looking at the individual component reserves/space but the students are assigned by looking at the entire course reserves/space. There are 3 options that the component of a course falls into:
Each scenario is handled differently for assigning characteristics to a component.
Each scenario is handled differently for assigning the characteristics to a student as well
Another significant point to keep in mind is that in the assigning process does NOT look at the capacity of the course or of the reserves. This means that if a course has a reserve with a capacity of 75 and 100 students meet that reserve, ALL of the students will be assigned to that section. Also, if a course has a capacity of 15 with no reserves and 50 request it all of the students will be assigned. The reason for this is because we want ALL students to influence the placement of the section because we don’t know which students will get it and which ones won’t. |
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)
...