The Course Attendance Audit Report returns an error, preventing the user from running the report. The error indicates that there are multiple primary teachers assigned to a section.
Environment
- Flex Scheduling
- Secondary Scheduling with Section Staff enabled
Cause
The issue is caused by any Master Schedule Section having more than one teacher marked as Primary Teacher = Yes for the same date.
Resolution
To resolve the issue:
- Identify sections with more than one primary teacher using the following SQL query:
SELECT MST.SC, MST.SE, Count(*) FROM MST LEFT JOIN SSE ON MST.SE = SSE.SE AND MST.SC = SSE.SC AND SSE.PR = 1 AND SSE.DEL = 0 LEFT JOIN STF ON SSE.ID = STF.ID AND STF.DEL = 0 WHERE MST.DEL = 0 GROUP BY MST.SC, MST.SE HAVING COUNT(*) > 1
2. Ensure that the start/end dates do not overlap between the current primary teacher and past primary teachers. edit the records as applicable
Note: Aeries prevents multiple primary teachers from being added through the user interface. If there are multiple instances of this issue, this could mean the data was injected via SQL by a district user.