Quest & Email - Mass reserve inactivation query

Mass reserve inactivation query (we should post it out about 1 week before the start of term) to the teams channel and email all the scheduling reps that it’s been posted.

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

• all the ones that have already inactivated their reserves this term

• closed or cancelled courses.

• Remove WLU Double degree reserves from WLU courses, but they should remain on the list for non-WLU courses

• OPTOM, MSE, PD, BASE should be removed.

Lock the rest of the sheet so that only the last column can be edited.

Here’s how to lock the sheet so only the last column can be edited

under Review in Excel select “Allow Edit Ranges”.

Open

Select New…

Open

Then select Apply once the range has been set. Then “Protect Sheet…”

 

The query results should be saved to the UW scheduling reps team channel, Mass Reserve Inactivation also a copy can be saved to the Scheduling and Exams teams channel: Data Analysis → Mass Reserve Inactivation (Mass Reserve Inactivation) we can use the one from the scheduling and exams team channel as the original master. Systems should be pulling it from the UW scheduling reps team channel. Once the reserves have been inactivated we can move the file out and over to the scheduling and exams page.

Send from regstep.

The email: