Skip to content

Sprint history — Attendance

What shipped

Recording what actually happened versus what was planned.

  • Attendance & actuals (Sprint 10a) — attendance records and statuses, the Excel import (preview/commit), admin-edit + manager-revert, and the audit tables.
  • Reconciliation + variance (Sprint 10b) — the reconciliation exception queue, validation, and the variance report (JSON + xlsx + pdf).
  • Utilization / OT report (MIQ-051) — the utilization report (JSON-only, mirroring equalization's v1 deferral).

Key decisions

  • Times are Excel-sourced — there is no device/punch feed (sheet 13). Attendance comes from spreadsheet import, not turnstiles.
  • Cross-midnight Time_Out is rejected (C2) — a shift ending after midnight isn't handled by the simple import path.
  • Edits are reviewable — an admin edit creates a pending review a manager can revert; the change is audited.
  • Utilization shipped JSON-only — no xlsx/pdf export yet (PB-112); the variance report is the only export trio so far.

Build status

Available (records, import, edit/revert, reconciliation, variance report); Partial (utilization JSON-only, no charts). See Record attendance (task), View reports (task), and the Attendance API.

  • Fact sheets 13 (attendance & actuals), 17 (reports); reports Sprint 10a, Sprint 10b, MIQ-051.