Quest - Query Names and what they are used for

Owned by Elysia Gallinaro
Last updated: Feb 01, 2024
4 min read

This is a list of the queries that we use in scheduling, and what process we are using them in.

Table of Contents:

After Prior Term Copy

Look for them in this procedure 

Before data is moved into the DCU 

Look for them in this procedure 

Before data uploaded back to Quest/SOC updates

Look for them in this procedure

Before Sectioner is run

Look for them in this procedure

PCS reconciliation (Course Build)

Look for them in this procedure 

Mass Reserve Inactivation

Look for them in this procedure

Audit Table Queries

  • The audit table that’s looking at the Class TBL table behind the scenes in Quest to see what changes are made to the Class number, session, section number, component, class type, class associations, campus, location, course admin code, instruction mode, topic number, dates, Class status, consent, auto enrol, caps. It’s prompted on either term, or subject. (UW_SCH_AUDIT_CLASS_TBL)

  • The audit table that’s looking at the class associations table (found in Adjust Class Associations) to see what changes are made to the units, billing factor, grading basis, graded & primary component, requisites, and if they are using the catalog req as well (UW_SCH_AUDIT_CLASS_ASSOC)

  • The audit table that’s looking at the class component table (within the class associations) behind the scenes in Quest to see what changes are made to the session, associated class, and the component (UW_SCH_AUDIT_CLASS_COMPONENT)

  • The audit table that’s looking at the Instructors for Meeting Pattern table behind the scenes in Quest (which is found in Maintain Schedule of Classes under Meetings) to see what changes are made to the instructor ID, and the subsequent instructor information, and the instructor role (UW_SCH_AUDIT_CLASS_INSTR)

  • The audit table that’s looking at the meeting pattern table behind the scenes in Quest to see what changes are made to the Class number, session, section number, meeting pattern number, facility id, day, start and end times, start and end dates (UW_SCH_AUDIT_CLASS_MTG_PAT)

  • The audit table that’s looking at the reserve cap table behind the scenes in Quest to see what changes are made to the reserve cap sequence number, start date, enrollment capacity, and requirement group (UW_SCH_AUDIT_RESERVE_CAP)

When we update the scheduling pages from a process, it will not update the audit tables. 

Only when you click the "save" button will it update and create a snapshot of what the information looked like before the change. If we want a report we would need to have that snapshot and the new information added to it. 

Below is what the audit table will look for, any changes on all these pages will be reported on. 

A = added 

C = Changed 

D = Delete 

Specification – Audit Fields for Schedule of Classes Tables

Jira Epic – ROQRD-4457

Project Number – UWSA315_14

Audit Fields

CLASS_TBL

  • CRSE_ID

  • CRSE_OFFER_NBR

  • STRM

  • SESSION_CODE

  • CLASS_SECTION

  • CLASS_NBR

  • SSR_COMPONENT

  • CLASS_STAT

  • CLASS_TYPE

  • ASSOCIATED_CLASS

  • AUTO_ENROLL_SECT_1

  • AUTO_ENROLL_SECT_2

  • CONSENT

  • ENRL_CAP

  • CRS_TOPIC_ID

  • EMPLID

  • CAMPUS

  • LOCATION

  • INSTRUCTION_MODE

  • START_DT

  • END_DT

  • SSR_DROP_CONSENT 

CLASS_MTG_PAT

  • CRSE_ID

  • CRSE_OFFER_NBR

  • STRM

  • SESSION_CODE

  • CLASS_SECTION

  • CLASS_MTG_NBR

  • FACILITY_ID

  • MEETING_TIME_START

  • MEETING_TIME_END

  • MON

  • TUES

  • WED

  • THURS

  • FRI

  • SAT

  • SUN

  • START_DT

  • END_DT

  • STND_MTG_PAT 

CLASS_INSTR

  • CRSE_ID

  • CRSE_OFFER_NBR

  • STRM

  • SESSION_CODE

  • CLASS_SECTION

  • CLASS_MTG_NBR

  • INSTR_ASSIGN_SEQ

  • EMPLID

  • INSTR_ROLE

CLASS_ASSOC

  • CRSE_ID

  • CRSE_OFFER_NBR

  • STRM

  • SESSION_CODE

  • ASSOCIATED_CLASS

  • UNITS_MINIMUM

  • UNITS_MAXIMUM

  • UNITS_ACAD_PROG

  • UNITS_FINAID_PROG

  • GRADING_BASIS

  • SSR_COMPONENT

  • BILLING FACTOR

  • RQRMNT_GROUP

  • USE_CATLG_RQS

  • RQMNT_DESIGNTN

  • COMPONENT_PRIMARY

CLASS_COMPONENT

  • CRSE_ID

  • CRSE_OFFER_NBR

  • STRM

  • SESSION_CODE

  • ASSOCIATED_CLASS

  • SSR_COMPONENT

CLASS_RSRV_CAP

  • CRSE_ID

  • CRSE_OFFER_NBR

  • STRM

  • SESSION_CODE

  • CLASS_SECTION

  • RSRV_CAP_NBR

  • START_DT

  • ENRL_CAP

  • RQRMNT_GROUP

 SCTN_CMBND_TBL

  • INSTITUTION

  • STRM

  • SESSION_CODE

  • SCTN_COMBINED_ID

  • ENRL_CAP

  • ROOM_CAP_REQUEST

  • PERM_COMBINATION

  • COMBINATION_TYPE

  • SKIP_MTGPAT_EDIT

SCTN_CMBND

  • INSTITUTION

  • STRM

  • SESSION_CODE

  • SCTN_COMBINED_ID

  • CLASS_NBR

Miscellaneous Queries

 

  • Using the instructor ID as a prompt to find courses and terms an instructor has been attached to  (UW_RS_CRSES_BY_INSTRUCTOR_JV)

  • There’s no prompt, it outputs a full list of all active people in the instructor/advisor table with their Quest ID number, Names, Academic Organization, their Instructor Type and the effective date - (UW_RS_SPECIAL_0893)

  • Searches for instructors that have been made “Inactive” but were left on as “Available” and have been attached to a course after they have been inactivated. (UW_SCH_INSTR_INAC_W_CRSE_TG)

  • Searches for a list of instructors that have been set to “Inactive” and are still “Available”. This causes troubles when the instructor has been inactivated but scheduling can add the instructor and doesn’t know that they have been inactivated – it can be fixed by extending the inactivation date.   (UW_SCH_CHK_INSTR_INAC_AVAILABL)

  • To find instructors that were added to only one side of the held with, manually scroll through the list and ensure that each of the held-with courses have the same instructors attached. (UW_SCH_MISMATCH_DELIV)

  • The results of this query are the days/dates and times that students have enrolled in a course, you can filter on the class number or section to narrow down the results, prompt on term, subject and catalog number (UW_RS_CLASS_ENRL_DATES_JV)

  • Closed class for enrollment but it is still an “active” course. The troll in Quest sometimes makes enrollment closed, but there is lots of spaces. (UW_RS_SCH_ENRL_STATUS_JV)

  • Looking for Notes that are on the wrong section and not appearing on SOC (it is manual):  (UW_RS_SCH_CLASS_NOTES_SB)

  • For students in a specific class that need to be moved to another timeslot.  When inputting the catalog number in the prompt field that it must have percent signs on either side of it, e.g., for PSCI 342 you would input %342% for the catalog number (UW_RS_SCH_STDNT_TIMETABLE_JV)

  • Exam Turnaround Document (UW_RS_SCH_EXAM_TAD_LW)

  • Looks for sections where the secondary component has been cancelled, but the associated class is still active (UW_RS_SCH_CANC_SEC_CLS_ASSOC)

  • Reserve Cap List (listing of all reserve cap numbers and their descriptions)  (UW_RS_SCH_RESERVE_CAP_LIST_LW)

  • Find all the terms that a particular course was offered and what component was offered (UW_RS_SCH_SOC_ANY_TERM_NP)

  • Find any rooms that have “Check for Facility Conflict” unchecked in error (should always be on) in the Facility Table. The Online room should have “Check for Facility Conflict” checked off.  (UW_RS_SCH_FAC_NO_CNFL_SB)

  • Tell you the number (and catalog course code) of all the active courses in the calendar for a particular term: (UW_RS_SCH_ACTIVE_COURSES_SB)

  • Give you a list of sections in a combined section (UW_RS_SCH_SCTN_CMBND_SB)

  • A list of courses that have no instructor attached for a term (prompt) (UW_RS_SCH_CLASS_NO_INSTR_TG) 

  • Looks for all the instructors that have the specified subject as a teachable subject (prompt on the subject and effective date [YYYYMMDD]) this is useful when a subject has changed (say from WS to GSJ, or AHS to HEALTH) (UW_RS_SCH_INSTR_SUBJ_SB ) 

  • This query is looking for an ASSOCIATED_CLASS value in CLASS_COMPONENT that does not exist in CLASS_ASSOC. Good for finding Buffer errors and helping to identify the issues  (UW_RS_SCH_CLS_COMP_CHECK_JV)

Queries no longer used

 (previously done before room assignment in Ad Astra) may consider using some of these again at different points in the cycle so do not delete from this document: 

  • Sections Combined courses with no facility (UW_RS_SCH_SCTN_CMB_NO_FAC_LW) 

  • Odd/Even meets with no facility (UW_RS_SCH_ST_END_DATES_LW) 

  • LAB meets with no facility (UW_RS_SCH_LAB_NO_FAC_LW) 

  • Campus = CGC, REN, STJ, STP and no facility (UW_RS_SCH_COLLEGES_LW) 

  • Campus = OFF and a meet vector (component) not = TBA (UW_RS_SCH_OFF_CAMPUS_LW) 

  • Campus = WLU (UW_RS_SCH_WLU_LW) 

  • Classes with meet begin before 8:30 a.m. (UW_RS_SCH_START_TIME_JV)  

  • Classes with meet begin after 8:30 p.m. (UW_RS_SCH_CLASSES_AFTER_LW) 

  • Class hours (UW_RS_SCH_COMPARE_TIME_LW) 

  • ONLN and CO don’t match (UW_RS_MISMATCHED_INSTR_MODE_SB) 

  • Checking the list we get from CEL was entered correctly (a list of Face to face CEL/remote exams)  (UW_RS_SCH_CLASS_ATTR_IPEX_JV)

  • Determining if the rooms are over capacity for a term (Fall 2020, and Winter 2021 highly important) we are only concerned with the negative valued rooms (UW_RS_ON_CAMPUS_CLASSES_JV)

Standard Data Exclusions

remove cancelled courses, exclude:

  • WLU 

  • ONLNL 

  • GUE 

  • COOP 

  • WKRPT 

  • PD 

  • PDARCH 

  • PDPHRM 

  • OFF Exchange 

When dealing with heldwith courses and rooms, make sure to make note of the ones where the other room is an online room if the rooms are different.