Quest & Email - Mass reserve inactivation query

Owned by Elysia Gallinaro
Last updated: May 08, 2024
2 min read

Mass reserve inactivation query (we should send it out about 1 week before the start of term) to UTC members

Log into Quest, run this query to excel in Query viewer: UW_RS_SCH_RSRV_FOR_INACTV_SB

Add a column at the end in excel that says “Mark with an “X” = do not inactivate). Remove all courses that do not have a reserve, and all the ones that have already inactivated their reserves this term, also closed or cancelled courses. Exclude WLU Double degree reserves from WLU courses, but they should remain on the list for non-WLU courses, OPTOM, MSCI, PD, BASE.

 

The query results should also be saved to the Scheduling and Exams teams channel: Data Analysis → Mass Reserve Inactivation (Mass Reserve Inactivation) This is where the Systems will pull it from directly and is the master list that we update

Also include current rep list with email and send from regstep.

The email:

From: UW Regstep 

To: Undergrad Scheduling Reps ONLY

Cc: Jennifer Coghlin; Annette Ertel; Jennifer Crane; Tanya Pompilio; Elysia Gallinaro; Libby Askin; Alice Law 

Subject: Mass Reserve Inactivation for the Winter 2023 - Please confirm receipt of this email 

Date: Tuesday, January 03, 2023 9:12:21 AM 

Attachments: 1231 - Reserves for Inactivation.xlsx 

 

Good morning Undergrad Scheduling reps, 

Attached is a list of all reserves currently in place for the Winter term (2023). Could you please indicate on the spreadsheet in the column provided, which reserves you do not want inactivated for the Winter term. Please keep in mind that all reserves will be inactivated by noon on Jan 16 unless otherwise indicated.  

Please return this information to the Scheduling Office no later than Jan 12 at 4:00 p.m. to give us enough time to prepare the information for reserve inactivation on Jan 16. If your course does not appear on the list it could mean that: 

  • Section is already inactive 

  • Section is closed or cancelled

  • Course does not have any reserves 

  • Department specified reason

  • It’s a graduate course (those are not included in this process)

Thank you, 

The Scheduling Office