Orphan/missing-data audit — find students w/o teacher, teachers w/o students, and other missing-relation gaps. Inventory existing views/code; build report query if missing.

Sub-tickets

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
  starting orphan/missing-data audit
• system noted · 2026-05-02
  audit complete; report sent to PM
• system completed · 2026-05-02
  inventory complete (mars-db-cc-w-1951). 11 categories checked; mostly clean. Real findings: 12 NULL-jtp assignments, 1 orphan JTP, 1 ayudante w/o membership, 1 stale-jtp practica, 2 primaryRoleId mismatches. No vDataHealth view exists yet. 7 follow-up actions A-G surfaced for Elazar decision.