Reporting Memo: December 29 - January 2, 2026
Short week spanning New Year’s holiday.
Attendance Recovery Dashboard Expansion
Restructured Romoland’s “Attendance Hours Recovered” dashboard to show all AR-eligible students rather than just those who have attended AR programs. The previous version displayed roughly 1,000 students—only those with recorded AR attendance. APs requested visibility into students who have absences but haven’t recovered any hours yet, so they can conduct targeted outreach.
The new query starts from eligible students (anyone with qualifying absence codes since July 1, capped at 10 recoverable days) and LEFT JOINs AR attendance data. This surfaces all 4,649 students with absences, making it clear which students haven’t participated in attendance recovery and need outreach. Grade-specific minute thresholds preserved: TK/K requires 180 minutes per day, grades 1-3 require 230 minutes, and grades 4-12 require 240 minutes.
ATT-2087
Admin Reporting Interface Security Audit
Conducted a comprehensive security review of the internal admin tool used for managing program tags, user locations, and attendance codes across tenant databases. Identified and fixed a critical issue: an unprotected test endpoint that exposed database credentials.
Additional hardening included UUID validation on all ID parameters to prevent injection attacks, sanitized error messages with correlation IDs (preventing information leakage while maintaining debuggability), and verification that all database queries use parameterized inputs. The tool serves seven tenants (SAUSD, Winters, SJCA, Romoland, Oakland, Fruitvale, Beaumont) and handles sensitive operations, so this audit was overdue.
ASSIST Program Tagging Audits
Completed program tagging audits for both Oakland USD and Woodland JUSD ahead of the January 31 ASSIST reporting deadline. These audits verify that all programs have correct funding tags (ASES, ELOP, 21st CCLC) so state compliance reports pull accurate data. Both districts are now ready for Surya to schedule review meetings with district staff before submission.
ATT-1962, ATT-1964
Other Items
Configured Education Record codes for Monroe Elementary programs at Romoland via the admin interface, enabling proper state reporting compliance for those programs. Also updated Lilly’s AR data sheet with current figures following the dashboard expansion work. Earlier in the week, completed documentation for the Explo new tenant setup process—a standardized onboarding guide covering database connections, frontend constants, customer hierarchy, attributes, and domain allowlisting.
ATT-2139, ATT-2179, ATT-2104
Tickets Completed
| ID | Title | District | Type |
|---|---|---|---|
| ATT-2087 | AR Hours Recovered Dashboard - Show All Eligible Students | Romoland | Reporting |
| ATT-2104 | Memo for Adding New Tenants and Setting Up in Explo | — | Documentation |
| ATT-2139 | Input ER Codes for Monroe Elementary Programs | Romoland | Configuration |
| ATT-1962 | Audit OUSD Programs for Jan 31 ASSIST Reporting | Oakland | Compliance |
| ATT-1964 | Audit WJUSD Programs for Jan 31 ASSIST Reporting | Woodland | Compliance |
| ATT-2179 | Update Lilly’s Sheet | Romoland | Reporting |