Attendance Letters Based on Age (Compliance) - Six year old students and older receive truancy letters
The truancy 1, 2, and 3 letters are generated at the school sites. In previous years, we have kept only students grades 1-12 to receive the truancy letters. To stay compliant, we must include students who are 6 years old and older to receive these letters.
Since this would be based on a student's 6th birthday and accounting for absences to generate letters AFTER their 6th birthday.
What would be the best approach or query(ies) to do this since we cannot send a letter to a student who just turned six who is qualified to receive letters... when the student was five. That is, five year olds cannot receive letters even if they qualify. We need to account for the absence codes that they receive after they turn six years old.

-
Anonymous commented
The truancy 1, 2, and 3 letters are generated at the school sites. In previous years, we have kept only students grades 1-12 to receive the truancy letters. To stay compliant, we must include students who are 6 years old and older to receive these letters.
Since this would be based on a student's 6th birthday and accounting for absences to generate letters AFTER their 6th birthday.
What would be the best approach or query(ies) to do this since we cannot send a letter to a student who just turned six who is qualified to receive letters... when the student was five. That is, five year olds cannot receive letters even if they qualify. We need to account for the absence codes that they receive after they turn six years old. This is due to CDE compliance where students ages six years and older are to receive the letter.