Issue
When querying the Attendance History (AHS) table after running the Update Attendance History process for a specific date range, the days enrolled column (AHS.EN) displays results that are higher than the number of days expected from the processed date range set.
Environment
- Attendance History Config Table
- Query
LIST STU AHS STU.SC STU.ID STU.GR STU.NM AHS.EN AHS.PR AHS.AB AHS.AU AHS.TD AHS.YR IF AHS.YR = "2024-2025" AND AHS.EN > 0
Cause
Attendance History re-calculates automatically as soon as a teacher enters attendance. If a query is run for a specific data set, whilst attendance is being added, the query will show the most recent data.
Resolution
Best practice would be to run these type of queries for specific date ranges when attendance is not being changed.