This is the list of queries that should be run before course build opens for the undergrad scheduling reps. Once the queries have been run we send out this email to those that have course build access.

Expand
title What is Course build?
Course build is the scheduling reps side of Quest that they use to add/remove the PCS (or 701) sections from Quest. The Quest Navigation is: Waterloo Student Admin → CEM → Use → Course Build We create all the PCS sections (except the ones on the exceptions list) for courses offered for a term, we do all the necessary clean up using the rest of the queries in this procedure. Once we have done all that it’s up to the reps to log in and change, add, or remove any sections that were either missed, or intentionally left off by off our team that this term they want added, or that they don’t want a PCS section for. This is also where they can clean up any notes that on the PCS sections that were carried over from last year that need to be updated. We in Scheduling have told the reps it’s not our responsibility to change or check the notes that have been added to PCS sections, as we already maintain the ones on the real sections. If you’re feeling kind here’s the notes query: UW_RS_SCH_CLASS_NOTES_SB The reps and students can see all the PCS sections that are being offered here: https://classes.uwaterloo.ca/uwpcshtm.html There’s also this procedure that walks you through creating PCS sections: PCS reconciliation using Course Build page

Log into Quest and under query viewer run the following queries:

• Find all sections that have a real section but no PCS section, to add those

...

• use the maintain schedule of classes pages within Quest (refer to PCS Exceptions list

...

• )

...

• • UW_RS_REAL_NO_PCS_SB

...

And

...

• • - run to excel and filter the headings to remove those that shouldn’t get a PCS section

  • PCS Exceptions list: The following subjects/courses do not get PCS sections added:

    • Courses with caps of 1

    • Location of OFF with a location of OTHER/CHINA/ABROAD/ITALY, etc.

    • ARTS 130/140

    • BASE

    • COMMST 193

    • COOP

    • EFAS

    • ELPE

    • OPTOM

    • PDARCH

    • PDPHARM

    • PHARM

    • SEQ

    • SWREN

    • WHMIS

    • WKRPT – single digit course numbers – no PCS needed. All 3- or 4-digit course numbers do get PCS

• Query of PCS section information – things to check – capacity, consent, and section numbers.

  •  UW_RS_SCH_PCS_SYNCHRO_CHK_SB - run to excel

    • Add/Drop Consent stays on with department consent for COMMST 193 and ENGL 193. Drop consent stays on for Engineering courses (SYDE all courses)

...

• • • things to check – capacity (should always be 9999), and section numbers should match associated class numbers (701 and 701, for example)

• Find secondary/tertiary etc. components attached to PCS to clean them on the Class Associations panel in Quest:

  • UW_RS_PCS_COMP_NOT_REMOV_JV

• Run after above query to re-add any that were accidentally removed:

  • UW_RS_SCH_COMP_NOT_ASS_CLS_JV

PCS Exceptions list:

Exceptions: The following subjects/courses do not get PCS added:

• ARTS 130/140

• BASE

• COOP

• EFAS

• ELPE

• OFF OTHER/CHINA/ETC

• Courses with caps of 1

• OPTOM

• PDARCH

• PDPHARM

• PHARM

• SEQ

• COMMST 193

• SWREN

• WHMIS

• WKRPT – single digit course numbers – no PCS needed. All 3- or 4-digit courses numbers do get PCS