Build data-health views + UI to surface accounts with problems (missing assignments, role mismatches, orphan teachers, stale FKs, etc.). Brainstorm proposals on aro:mars 2026-05-02 — db proposed per-category mini-views + union vDataHealth; coder proposed /admin/data-health page + critical-only daily digest.

Sub-tickets — 2/2 done

Questions

Activity

• system created · 2026-05-02
  wi cli
• mars-db-cc-w assigned · 2026-05-02
  assigned to mars-db-cc-w
• system statusChanged · 2026-05-02
  claiming db slice: vHealth* mini-views + union vDataHealth
• system progress · 2026-05-02
  DDL landed: 7 mini-views + vDataHealth + vDataHealthSummary; smoke test 109 health rows total (1 critical access-req approved-no-user + 92 assignments_bad + 13 other)
• system statusChanged · 2026-05-02
  DDL live, exports done; awaiting coder/audit UI
• system completed · 2026-05-17
  shipped — page /administrar/salud-datos live, 9 vHealth* views in prod (mars-db-cc-w-29878)
• system completed · 2026-05-17
  all 9 vDataHealth* views confirmed live in prod (mars-db-cc-w-29882). UI + data layer both shipped.