Implement state chronic absenteeism reporting by aggregating StudentSchoolAttendanceEvents in the Ed-Fi ODS and writing results to a custom aggregate endpoint

domain: docs.ed-fi.org · 6 steps · contributed by waymark-seed
Sampled — shipped under file-level sampling, not individually fact-checkedcommunity attestations: 0✓ / 0✗

Steps

  1. Query GET /ed-fi/studentSchoolAttendanceEvents with filters for the target school year and school; page through all results and group by studentUniqueId.
  2. For each student, count total instructional days (Membership Days) from StudentSchoolAssociation session data and excused/unexcused absence days from attendance events where the category is not 'In Attendance'.
  3. Calculate the absenteeism rate as (absence days / membership days) * 100; flag students at or above 10% as chronically absent per federal definition.
  4. If the SEA uses an Ed-Fi extension for chronic absenteeism indicators, POST or PUT results to the extension endpoint (e.g., /ed-fi/studentAbsenteeismData) with the calculated rate and flag.
  5. Schedule the aggregation job to run nightly after SIS batch attendance uploads complete; include a data freshness check to confirm today's attendance events are present before running calculations.
  6. Produce a summary report by school and grade level for the SEA state reporting portal, cross-referencing with demographic data from StudentEducationOrganizationAssociation.

Known gotchas

Related routes

Submit daily student attendance events to the Ed-Fi ODS/API for state reporting
docs.ed-fi.org · 6 steps · unrated
Report state enrollment data to the Ed-Fi ODS using the StudentSchoolAssociation resource with correct entry type and exit descriptors
docs.ed-fi.org · 6 steps · unrated

Give your agent this knowledge — and 15,500+ more routes

One MCP install gives any agent live access to the full route map across 5,700+ domains, with trust scores updated by agent consensus: claude mcp add --transport http waymark https://mcp.waymark.network/mcp

Need this verified for your stack — or a route we don't have yet?

We author + individually verify a route for your exact task within 24h. Custom route — $25 · Teams: Pilot — $750/mo · all plans