Sample Output:

Attendance Categories

The reports works off of attendance categories which are groups of attendance codes.  

Go to the Setup -> Calendars -> Attendance Codes screen and assign categories to the groups of attendance codes you would like to be used on this report.   

Direct Student Contact staff members...

Staff with the following flags checked are included in this section:

• Teacher
• Nurse
• Disciplinarian

Indirect Student Contact

Staff with the following flags checked are included in this section:

• Administrator
• Other Staff

How the data is calculated:

• For Each Month (Setup.Codes.Months)
  • Build a map of calendarCode -> count of days with attendance taken flag set to true.
  • Reset internal list of Staff Members with values
  • For each attendance category
    • For each attendance code in attendance codes in the category
      •  For each Staff Member
        •  if has current attendance calendar
        •  SUM = select sum of value from StaffAttendanceDaily o where for staff member in date range of month for attendance code.o.attendanceCode=?
        • Category Month Total += SUM
        • daysNotPresentThisMonth += SUM
        • If SUM>0 add this staff member to the list Of Staff Members with Values
        • Write to PDF Column for category:  SUM of SUM for all attendance codes and staff in this category (ie: Illness , Personal Business etc..)
        • PDF Write (Staff Column) the count of unique staff found in this category / month
  • C) PDF Write (Totals column): Sum of all category sums. (Value in the category column.. illness + peronsal business etc..)
  • Possible Days Present: Sum of (For each staff. # of Possible Days from their current calendar. Value from map of calendarCode -> count of days)
  • Total Days Present: Possible Days Present - Totals
  • Attendance Rate: Total Days Present * 100 / Possible Days Present