Soft-delete active-view audit: inventory pulldown-source tables vs vActive<Table> policy

Sub-tickets

Questions

Activity

• system created · 2026-05-18
  wi cli
• researcher-pluto-cc assigned · 2026-05-18
  assigned to researcher-pluto-cc
• system finding · 2026-05-18
  Researcher audit complete. D1 missing views: comisionJtps, comisionAdjuntos, jtpAyudantes, studentAssignments (no active view), vActiveLookupOptions (only per-grupo views exist). D2 naming drift: vPeriodos/vComisiones/vUsers/vUsersWithRoles/vAcademicHierarchy filter deletedAt IS NULL but named v<Table> not vActive<Table>; vUserRolesActive uses suffix. D3 raw pulldown calls: lookup-actions.ts:26,44,97,113,136,155 + admin-actions.ts:922,2447. Flag: vStudentAssignmentsWithComision + vLookupRoles absent from schema.md. PM decision: grandfather existing v<Table> views (functionally correct, heavily used, renaming = high churn across all 3 projects); create missing views using vActive<Table> naming; fix raw call sites.
• system completed · 2026-05-18
  Audit complete. Findings logged. WI#428 unblocked for implementation.