Anyone have any good queries in Aeries or SQL for calculating truancy rates?
I thought I had found a way to do this, but in looking again I think the best I came up with was to run a series of reports (absence totals and enrollment totals) and then crunch the data together using spreadsheets or Report Tags, which is nowhere near as elegant as the Query you suggest. If anyone has a clean suggestion, I'd love it!
I use this query for my truancy rates and for my afterschool program reports:
LIST STU TCH AHS STU.SC STU.NM TCH.TE AHS.ID AHS.YR AHS.EN AHS.PR AHS.AB AHS.AE AHS.AU AHS.TD AHS.TRU AHS.SU AHS.ISS AHS.ISC AHS.ISI IF AHS.EN # 0 AND AHS.YR = "2018-2019"
I will just run this and do a little formula to calculate the attendance rate. Not sure if this is what you're looking for but it's what I use because I don't have anything better!