If Scheduling Tables are not being utilized, the Student Demographics Teacher (STU.CU) must match the Class Schedule Teacher for the designated Attendance Period. The following query can be used to verify that the Class Schedule Teacher and Student Demographics Teacher match for students:
LIST STU SEC MST STU.ID STU.LN STU.FN STU.GR STU.CU MST.TN IF MST.PD = 0 AND MST.TN # STU.CU
To verify the Attendance Enrollment Teacher matches the Student Demographic Teacher run the following Query:
LIST STU ATT STU.ID STU.LN STU.FN STU.GR STU.CU ATT.TN IF ATT.TN # STU.CU
If there are discrepancies, queries can be run to make the corrections. It is very important to note that these queries should only be run prior to Initializing ATT and CAR records.
To change the Student Demographic Teacher to match the Class Schedule Teacher for AttendancePeriod 0
CHANGE STU SEC MST STU.CU TO MST.TN IF MST.PD = 0
To change the Attendance Enrollment Teacher to match the Student Demographic Teacher:
CHANGE STU ATT ATT.TN TO STU.CU IF ATT.CD > “ “
NOTE: Caution should be used when running Query CHANGE commands.
Once you are sure that your settings for your school and students are correct, you are ready to start Attendance at your school.