Versions Compared

Old Version 3

changes.mady.by.user Elysia Gallinaro

Saved on

compared with

New Version 4

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

...

Expand
titleReserve cap assignment explained

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: 

  1. No reserves 

  2. Fully reserved 

  3. Partially reserved 

Each scenario is handled differently for assigning characteristics to a component. 

  1. No Reserves  – the component gets the characteristic of SPACE  

  2. Fully Reserved – the component gets the appropriate characteristic of the reserve (ECON10101004418). (significance of the numbers)The ECON1010 is the course code, the “1” is where it sits in the list of reserves and the 004418 is the requirement group number, which is what the reserve number is coded like.  

  3. Partially Reserved – the component gets the characteristic of each reserve as well as the SPACE characteristic.  

Each scenario is handled differently for assigning the characteristics to a student as well 

  1. No Reserves – if there are NO reserves on any section the students all get a characteristic of SPACE. The result is that the students can be assigned to any section.  

  2. Fully Reserved - if the student meets ANY of the reserves on any section they get the characteristic (ECON10101004418) assigned and if they don’t meet ANY reserve they get no characteristic. If they meet more than one reserve they get one assigned and the other as assigned as an alternate. The result is that only the students that meet the reserves will be assigned to the appropriate components. All other students will be rejected.  

  3. Partially Reserved – if a student meets one or more reserve they are assigned the reserve (and the others as alternates). If they do not meet any of the reserves they are assigned SPACE. They are NOT assigned the alternate of SPACE, however. The result is that students that meet a reserve will ONLY be assigned to the components that have the reserve. Students that don’t meet the reserve can go to any section that has SPACE. This way we are ensuring that students that meet the reserves are going into the appropriate section. Example ECON 101 for the 1159 – we want all ARTBUS students to go into LEC 001. If there was an alternate to SPACE they could go into LEC 005. 

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. 

...