Timetabler - Determining Reserve Cap Order

This is not technically a timetabler procedure, in that most of the below work will be done within Quest, however it’s done for the preparation of work that is all done within Timetabler. This procedure is to determining the reserve order within Quest before the import of reserves for creating Academic blocks.

We can make some reserve changes in Quest so that when they are imported into Timetabler, the reserve number is the same for all the sections of a course (example Table 1), however for those we can’t correct within Quest (Table 2) we make the changes in Timetabler after the import.

Do the reserve cap clean up first:

UW_RS_SCH_BLANK_RSRV_CAP_NP – looks for reserves that are missing the reserve criteria cap weight, if you get results have sarecord@uwaterloo.ca assign it a weight if it’s an undergrad reserve, if it’s grad send it to gscheduling@uwaterloo.ca

UW_RS_SCH_MULTI_RSRV_CAP_NP – look for reserve cap duplicates

UW_RS_RESERVE_CAP_ORDER_NP

The reserve cap criteria table gives you an idea of what the order should be for the reserves if you are knowledgeable in how reserves are created, thankfully there’s a query that does all the work for you.

Then muddle with reserves:

UW_RS_SCH_RSRV_CHK_FOR_CC_SB

Manually scan through the list of reserves looking at the reserve number trying to keep different sections of the same course reserves in the same order.

Example of them working out well:

Subject	Catalog	Section	Class Stat	Course Cap	Reserve Cap	Rq Group	Reserve Number	Descr	case when (A.ENRL_CAP - sum(F
KIN	100L	001	A	35	30	001564	1	KIN students	Fully Reserved
KIN	100L	001	A	35	5	007910	2	SPHS -Undergrad Students Only	Fully Reserved
KIN	100L	002	A	35	30	001564	1	KIN students	Fully Reserved
KIN	100L	002	A	35	5	007910	2	SPHS -Undergrad Students Only	Fully Reserved
KIN	100L	003	A	35	30	001564	1	KIN students	Fully Reserved
KIN	100L	003	A	35	5	007910	2	SPHS -Undergrad Students Only	Fully Reserved

In the above, nothing needs to be changed as all the reserves will import with the same number this makes it easier to be attached to the courses while attaching reserves for the preparation of running block builder.

Example of them going poorly:

Subject	Catalog	Section	Class Stat	Course Cap	Reserve Cap	Rq Group	Reserve Number	Descr	case when (A.ENRL_CAP - sum(F
CHEM	123	001	A	446	420	007830	1	1A, 1B or 2A students	Open Spaces
CHEM	123	002	A	446	420	007830	1	1A, 1B or 2A students	Open Spaces
CHEM	123	003	A	446	30	007390	1	BASE students	Open Spaces
CHEM	123	003	A	446	390	007830	2	1A, 1B or 2A students	Open Spaces
CHEM	123L	001	A	110	30	007390	1	BASE students	Fully Reserved
CHEM	123L	001	A	110	80	007830	2	1A, 1B or 2A students	Fully Reserved
CHEM	123L	002	A	110	100	007830	1	1A, 1B or 2A students	Open Spaces
CHEM	123L	003	A	110	100	007830	1	1A, 1B or 2A students	Open Spaces
CHEM	123L	004	A	110	100	007830	1	1A, 1B or 2A students	Open Spaces

CHEM 123 and CHEM 123L the 1A, 1B or 2A students reserve will be imported as “CHEM12302007830” where as all the other 1A, 1B or 2A students reserve will be brought in as “CHEM12301007830”.

In the above table we have two options. We can change it Quest just before the import, then change it back, or we will have to make the change once it’s imported into Timetabler, since the reserves don’t go back into Quest from Timetabler. Manually changing them in Timetabler doesn’t impact the sectioner or enrollment processes (which is what the reserves are used for in Quest). Changing them in Quest, we would have to ensure they are fixed before sectioner runs.

In timetable the reserves or course characteristics, are used in the creation of the academic blocks so that the correct group of students gets placed in that section.

If you have changed the order of a reserve on a section re-run the UW_RS_RESERVE_CAP_ORDER_NP query to make sure that change will be okay for enrollment.