Attendance management is incorrectly displaying verified absences when the "Unverified Only" setting is enabled 


Cause

More than one Unverified Absence code in Absence Code Setup (ABS) table

Resolution

Ensure only one ABS code is tagged as an unverified absence 


Identify schools with more than 1 unverified absence code:

SELECT SC, COUNT(*)
FROM ABS 
WHERE DEL = 0 AND TY = 1 
GROUP BY SC 
HAVING COUNT(*) > 1