pacientes archive coverage + cross-práctica demographic propagation

Sub-tickets

Activity

• wi-cli-venus created · 2026-06-30
• wi-cli-venus note · 2026-06-30
  pacientes registry has NO archive trigger (pg_trigger NOT internal = 0). P2 (creator edits edad/sexo, e622d65-era) shipped A2 práctica-scoped to avoid an un-ledgered shared-table write. DEFER + bundle with future porSexo/porEdad epi-KPI build: (1) add archive trigger + archive table to pacientes matching practicas pattern; (2) on demographic edit propagate corrected pacienteDob/pacienteSexo to registry + all prácticas of same DNI (A1 design), wrapped in setArchiveContext. No present consumer until epi stats exist. Reversible.
• wi-cli-venus note · 2026-06-30
  pacientes registry has NO archive trigger (non-internal pg_trigger count=0). P2 (creator edits edad/sexo) shipped A2 práctica-scoped to avoid an un-ledgered shared-table write. DEFER + bundle with the future porSexo/porEdad epi-KPI build: (1) add archive trigger + archive table to pacientes matching the practicas pattern; (2) on demographic edit, propagate corrected pacienteDob/pacienteSexo to the registry + all prácticas of same DNI (A1 design) wrapped in setArchiveContext. No present consumer until epi stats exist. Reversible.
• pmmaster-evolutiva-cc assigned · 1w ago
  db-venus-cc
• db-venus-cc note · 1w ago
  Grepped src for porSexo/porEdad/epi-kpi consumer (route/query/dashboard): zero matches across .ts/.tsx/.sql. No consumer exists. Scoping (1) only - archive trigger+table on pacientes, same shape as VENUS-469/applied practicas pattern. (2) cross-práctica demographic propagation stays DEFERRED per the row's own stated precondition (no epi-KPI consumer). pmmaster-confirmed scope narrowing, 2026-10-06.
• coder-venus-cc note · 1w ago
  Pushed 2c7bf72 (coder-venus-cc, PASS:2c7bf727 audit-general-ca, 5-round review cycle). version 1.17.42 (no bump, Class-A DDL-only). deploymentId tail-match confirmed: dpl_BXV7u8sr5XuyxAyDehF842XGb1yy == live /api/health deploymentId. Vercel build/runtime log read UNAVAILABLE for this seat (VENUS-462) - Class-A PTD gap stated not skipped. db-venus-cc: apply GO is yours; close citing this SHA when applied.
• db-venus-cc completed · 1w ago
  completed
• coder-venus-cc note · 1w ago
  db handoff a3bd9dc (pending->applied + schema.md regen) pushed to main by coder-venus-cc in 7536dae push, 1.17.43.