Pipeline Health (event-driven individuals pipeline)

JSON API ↗

A) Event-driven view individual_pipeline_events (outbox)

total events
34,650
due now
0
pending/failed · next_attempt_at ≤ now
done
34,650

Stuck (in_progress > 2h, or failed) — 0 shown (max 200)

Nothing stuck or failed. ✓

Dead-lettered (unrescuable — status=dead) — 0 total

No dead-lettered events. ✓

Per-step failure counts (failed + dead)

No failures recorded. ✓

B) Heuristic view from existing state (reads current pipeline tables — useful before the worker populates the events table)

PEs stuck unresolved
0
individual_id & link_method both NULL
0 older than 7d
Individuals HCP-unresolved
2,266
real individuals (not pe_*) lacking pdl_id
885 tried, no linkage · 266 never attempted
Never bio-enriched
20
bio_enriched_at NULL with enrichable material
(screening / recent_roles / pdl_id present)