vUserActiveRoles view: consolidate userRoles+vLookupOptions JOIN repeated at users-actions.ts:164/169/230 + data-health-actions.ts:58 + self-service-assignment.ts:51 — return userId, roleValues[], roleLabels[] (filtered deletedAt IS NULL)

Sub-tickets

Questions

Activity

• system created · 2026-05-03
  wi cli; parent=#174
• system note · 2026-05-03
  Audit-3414: auth.ts repeat-JOIN sites (113-118, 157-162) are inside React-cached getSession, effectively free. View benefit narrows to non-cached admin paths (users-actions, data-health, self-service-assignment).
• system completed · 2026-05-18
  vUserActiveRoles view consolidation + roleId→roleOptionId latent-bug fix (v1.100.1 689cbcb PASS)