Have you considered using the Course Audit Report?
See this link: https://support.aeries.com/support/solutions/articles/14000077980-course-attendance-audit-report
We run the Attendance audit listing followed by the Course Attendance audit to catch those inconsistencies.
So we have found that sometimes there are discrepancies between the Exit/Leave date in ENR (Enrollment History) Table and the last date of attending courses based on the Stop Date in CAR (Course Attendance) due to someone entering incorrectly or someone later correcting/updating one record without doing the same to the other. I've been tasked with finding these discrepancies for the current school year and I can't figure out a way to do it that doesn't require an exorbitant amount of time looking at each file one by one.
Any query I can think of returns a LOT of dates that don't fit the criteria that then has to be done through manually to sort out. I'm hoping someone here has an efficient way to do this.