RoundsCorrowmere Clinics · Estmark synthetic data · seed 23

Acknowledged result

A result a clinician has marked as seen. The inbox counts any acknowledgement; clinical governance counts only abnormal results acknowledged within the rule's hours.

Unit: results · parameters: abnormal hours 24, critical hours 4 · also said as: acknowledged, acknowledged result, acknowledged results, results seen, results signed off

Inbox

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

Any result resulted in the period with an acknowledgement recorded by now.

First version.

SELECT r.id AS result_id, r.flag, r.resulted_at, r.acknowledged_at
FROM results r
WHERE r.acknowledged_at <= {now} AND r.resulted_at >= {period_start} AND r.resulted_at < {period_end}

Tests: count_between

Governance

Medical director (clinical governance) · version 1, changed 2026-11-02

Abnormal or critical results acknowledged within the rule's hours (critical 4, abnormal 24).

First version.

SELECT r.id AS result_id, r.flag, r.resulted_at, r.acknowledged_at
FROM results r
WHERE r.flag IN ('abnormal', 'critical') AND r.acknowledged_at <= {now}
  AND r.acknowledged_at <= r.resulted_at + to_hours(CASE WHEN r.flag = 'critical' THEN {critical_hours}
                                                      ELSE {abnormal_hours} END)
  AND r.resulted_at >= {period_start} AND r.resulted_at < {period_end}

Tests: count_between