How to use a Change Query to mass populate the Counselor field (STU.CNS) for a Secondary school using Staff ID Based Counselor Tracking


If the counselor breakdown is based on student's last name, here are sample queries:

  • CHANGE STU CNS TO 1234 IF LN <= KZ  (counselor 1234 has students with the last name of A up through Kz)
  • CHANGE STU CNS TO 4567 IF LN > KZ AND LN <= TZ (counselor 4567 has students with last name from L through Tz)
  • CHANGE STU CNS TO 8910 IF LN > TZ (counselor 8910 has students with last name U-Z)

If the counselor breakdown is based on the student's grade level, here are sample queries:

  • CHANGE STU CNS TO 1234 IF GR < 10  (counselor 1234 has students with Grade 9)
  • CHANGE STU CNS TO 4567 IF GR > 9 AND GR < 11 (counselor 4567 has students with Grade 10)
  • CHANGE STU CNS TO 8910 IF GR > 10 AND GR < 12 (counselor 8910 has students with Grade 11)
  • CHANGE STU CNS TO 9999 IF GR > 11 (counselor 9999 has students with Grade 12 or higher)