How To Mass Add A Perm Lock On Course Requests For A Certain Course or Period

To Mass Add a Perm Lock to Course Requests (SSS.PL) a Change query may be used

NOTE: the change queries below do not honor "Records Being Skipped", include any additional condition statements in the Change queries

First identify the code/reason that will be added as a Perm Lock. These codes can be updated in the Update Code Table:

NOTE: It is recommended to run these change queries in a Sandbox first to ensure the desired results are achieved

Mass Add Perm Lock by Course:

1. View Students with this Course in Course Requests (SSS) and get a count of records: 
   LIST STU SSS CRS TCH STU.ID STU.NM STU.GR SSS.CN CRS.CN CRS.CO SSS.TN SSS.PL IF SSS.CN = 1234

   Make note of the number of records; this should match the number of records being changed with the query below.
   
   

2. Change the Perm Lock (SSS.PL) to the selected code for the course indicated (bold):
   CHANGE STU SSS PL TO A IF SSS.CN = 1234


3. To only change the Perm Locks for students that do not already have a tag, include the condition to make the change only if the Perm Lock is blank (bold): 
   CHANGE SSS PL TO A IF CN = 1234 AND PL = " "


Mass Add Perm Lock by Period:

1. View Students with the selected Period (bold) in Scheduling Master Schedule (SMS) and get a count of records: 
   LIST STU SSS SMS CRS TCH STU.ID STU.NM STU.GR TCH.TE SMS.RM SMS.SE CRS.CO SMS.PD SSS.PL IF SMS.PD = 1


2. Change the Perm Lock (SSS.PL) to the selected code for the period indicated (bold). Add Perm Lock Condition if needed: 
   CHANGE STU SSS SMS CRS TCH SSS.PL TO A IF SMS.PD = 1 AND PL = " "


Once the change query is run, the Perm Lock Code will be seen in the Students' Course Requests page.