Emailer - Daily Absentee Report

This SQL query duplicates the functionality of the Absentee report built into PowerSchool's System Reports. We use it with Phoenix Learning System's Emailer program to provide an automatic report to secretaries and principals at the end of each day so that they can ensure that attendance has been taken accurately (it is a check against substitutes not getting their attendance in or a teacher forgetting).