2025-12-30 - AR Hours Recovered Dashboard Update

2025-12-30: AR Hours Recovered Dashboard - Show All Eligible Students

For: Lilly Ellefsen / APs (Romoland) Impact: Dashboard now shows all 4,649 AR-eligible students (vs previous ~1,000 who attended AR programs), enabling APs to identify and target students who haven’t participated yet Context: APs requested visibility into students who have absences but haven’t recovered any hours, so they can conduct targeted outreach

Problem: The “Attendance Hours Recovered” report only showed students who had attended AR programs. APs couldn’t see the full picture of eligible students to target for outreach.

Solution: Restructured query to start from eligible students (those with absences) rather than AR attendees:

1. Changed query foundation: Instead of starting with all_students_ar (students who attended AR programs), now starts with eligible_students (all students with qualifying absence codes)

2. Key CTEs in new structure:

   • eligible_students: All students with absence codes (‘2’,‘6’,‘7’,‘A’,‘E’,‘P’,‘Q’,‘S’,‘U’,‘W’,‘X’) since July 1, capped at 10 recoverable days
   • ar_attendance: Session-based AR program attendance minutes
   • summer_minutes: Summer 2025 minutes from dependent metadata
   • student_info: Student demographics from dependent table with site from location

3. LEFT JOIN pattern: AR attendance and summer minutes are LEFT JOINed to eligible students, so students with 0 hours still appear

Data Impact:

• Previous: ~1,004 students (only AR attendees)
• New: 4,649 students (all with absences)

Technical Notes:

• Removed enrolled_students filter (was limiting to students with complete enrollment in Attendly)
• Student info pulled from dependent table via mainLocationId for site assignment
• Grade-specific minute thresholds preserved: TK/K=180min, 1-3=230min, 4-12=240min per day

Related: 2025-12-15 - AR Data Sheet Update, 2025-12-22 - P-1 PADC ADA Reporting System