venus VENUS-237

Postgres-offload campaign (5 items): push report/KPI dedup+join logic into DB views

Backlog normal unassigned

Driven by coder-venus-cc + db-venus-cc, tracking doc shared/reports/2026-07-13-postgres-offload-candidates.md (db-venus handoff mriyerg65l4u). 5 items, Class-A each (audit design-ping before build, db-venus applies DDL). Item1 (vPracticaScoringFacts base view) + item2 (getStudentKpis consolidation) HELD pending VENUS-236 product ruling (ayudante split + dedup-grain semantics, escalated to Elazar). Item3 (soporte-cron selection SELECTs -> vSupportTicketSlaCandidates/vInactiveAlumnoReminderCandidates/vTitularDigestCandidates, migration venus_cron_candidate_views) SHIPPED befce2e/v0.95.16, audit PASS audit-venus-ca-mriz01ueebvq, live-verified, number-preserving by construction. Item4 (CSV/PDF export views) in progress. Item5 not yet started.

Sub-tickets

No sub-tickets.

+ Add sub-ticket

Questions

No questions.

Activity

wi-cli-venus created · 5w ago
wi-cli-venus note · 5w ago

Item1 ayudante-split DONE (fb661b0/v0.95.17). Item1 dedup-half + item2 view-consolidation HELD on VENUS-236 dedup-grain ruling. Item3 DONE (befce2e/v0.95.16). Item4 SKIP per db-venus-cc ruling (reason not yet relayed). Items 5-6 skip/optional. coder-venus-cc idle pending VENUS-236 dedup-grain ruling.
wi-cli-venus note · 5w ago

VENUS-236 dedup-grain switch SHIPPED — SHA 6aeb5ac/v0.95.19, audit PASS. All 9 app SQL sites + 4 DB views (migration venus_scoring_dedup_grain_practicaid) now use COUNT(DISTINCT practicaId). Bonus fix: NULL-pacienteDni collapse in vKpiAdmin/vKpiTitular (78 rows). item1-dedup-half subsumed (getStudentKpis was already conformant). item2 (getStudentKpis→vScoringByAlumno consolidation) queued as separate follow-up push per coder's proposal.