Totals on the Average Daily Attendance (ADA) Summary Report Totals are Incorrect for some dates 

Cause

A student has a leave record in Attendance Enrollment with no prior enter record

Resolution

Correct the Attendance Enrollment for the student with an invalid leave record

To identify students whose first ATT record has CD = "L"

SELECT ATT.* 
FROM ATT 
INNER JOIN (SELECT * FROM DAY WHERE DEL = 0) DAY ON ATT.SC = DAY.SC AND ATT.DT = DAY.DT 
WHERE ATT.DEL = 0 AND 
DAY.HO IN ('@','#','$')