To update the Next Residence (STU.NRS) field to match the current Residence School (STU.RS) field:

1. Navigate to the Query Page

2. Run the following queries to update the Next Residence (STU.NRS) field to match the current Residence School (STU.RS) field 

• First run this List Query to find the number of records where the fields do not match 
  • LIST STU ID NM RS NRS IF RS # NRS
• Then run the following Change Query to change the Next Residence field to the same value in the Residence School field
  
  • CHANGE STU NRS TO RS 

It is important that all of your Residence School (STU.RS) data are accurate before running these queries

It is highly recommended that these queries are run in a Sandbox/Test environment prior to running them in the live database environment.  It is also highly recommended that a back up is made of the STU table prior to running the Change Query.