For an Elementary w/MST school using Daily Attendance: If a school does not use the SMS process when scheduling, and are working straight out of Master Schedule, there is no automatic process that assigns the STU.CU field to match the teacher in the Master Schedule.  A CHANGE query can be used to populate the STU.CU field.  


 This needs to be done prior to running the Initialize ATT/CAR process.



Step 1: Confirm the Attendance Period from School Options.

  • Open the School Options page, and confirm the Attendance Period. For this example, the Attendance Period is 0


Step 2: Run a List query first, to determine the number of records that need updating:

  • LIST STU SEC MST STU.ID STU.NM STU.CU MST.SE MST.PD MST.TN IF MST.PD = 0 AND STU.CU # MST.TN 
    • The number of record results in this query should match the number of proposed changes in the next query


Step 3: Run the Change query to populate the STU.CU field based on the Teacher Number listed in the Attendance Period class:

  • CHANGE STU SEC MST STU.CU TO MST.TN IF MST.PD = 0 AND STU.CU # MST.TN

    • The number of proposed changes in this query should match the number of results in the previous query