RoundsCorrowmere Clinics · Estmark synthetic data · seed 23

Abnormal result

A result the lab flagged abnormal or critical against the test's reference range.

Unit: results · also said as: abnormal result, abnormal results, flagged result, out of range result, critical result

Lab

Lab manager (lab) · version 1, changed 2026-11-02

Flag abnormal or critical, resulted in the period.

First version.

SELECT r.id AS result_id, r.test_code, r.flag, r.clinic_id, r.resulted_at
FROM results r
WHERE r.flag IN ('abnormal', 'critical') AND r.resulted_at >= {period_start} AND r.resulted_at < {period_end}
  AND r.resulted_at <= {now}

Tests: count_between