Definitions / abnormal_result
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