Worked example: AI-assisted urgent care, diagnostics and beds source check

Public-data demonstration report: This is not an official Dorset HealthCare report. It uses public aggregate data only and requires human review and local owner confirmation before operational use.

What the agent was asked to do

Business question: Check whether RDY appears in public A&E, DM01 and KH03 files; explain what each source can safely support for a trust without an emergency department; and where trend analysis is or is not available.

Dataset: A&E, DM01 and KH03 public provider files (RDY)

This is a first-draft analytical brief for human review — not an approved performance report.

Data used

A&E monthly provider CSV (rdy_ae_monthly_ae_monthly__May-2026-CSV-F4flrg.csv)
DM01 (demo_dm01_diagnostics.csv + full RDY extract)
KH03 (demo_kh03_beds.csv + trend file where used)
trend_ae_rdy.csv
trend_dm01_rdy.csv

Period covered: A&E Dec 2025 – May 2026; DM01 Nov 2025 – Apr 2026; KH03 quarterly snapshots (Mar 2024 to Jun 2024).
RDY filter: ODS code RDY; Dorset HealthCare trust name variants (see filter notes)
Historic trend data: Yes — six-month A&E/DM01 stacks where available; KH03 quarterly snapshots (KH03 supporting extract: 6 quarterly snapshots from 2023-03-31 to Jun 2024 (may lag monthly A&E/DM01 dates).)

What this report can and cannot tell us

This report can:

Confirm RDY row presence in public A&E, DM01 and KH03 files.
Show descriptive trends where stacked historic files support them.
Explain what each source can safely support for a trust without a Type 1/2 emergency department.

This report cannot:

Prove urgent care or diagnostic performance standing from source validation alone.
Make ED performance claims — RDY shows zero Type 1/2 A&E attendances by service model.

For that reason, this should be treated as a first-draft prompt for review, not a final performance judgement.

Headline reading

These sources are grouped because they were checked together, not because they form a single performance pathway.
RDY appears in public A&E, DM01 and KH03 files — A&E confirms zero Type 1/2 ED attendances (source validation only, not ED performance).
DM01 (Apr 2026): audiology accounts for most waiting-list volume (2,306 of 2,361; 6 waits over 13 weeks in extract.
KH03 supporting extract: 6 quarterly snapshots from 2023-03-31 to Jun 2024 (may lag monthly A&E/DM01 dates).
Trend extracts: A&E 12 periods; DM01 17 periods — headline uses latest period per source.

Main metric table

These sources are grouped because they were checked together, not because they form a single performance pathway. Main summary uses latest period per source; supporting extracts may contain longer histories.

Period: A&E headline: May 2026 (extract: 12 periods); DM01 headline: Apr 2026 (extract: 17 periods); KH03: 6 quarterly snapshots

Figure / measure	Latest value	Peer position / comparator	Trend	Validation status	Judgement	Human check
A&E — RDY row and Type 1/2 attendances	RDY present; Type 1/2 A&E attendances = 0 (May 2026 extract)	Source validation — RDY does not operate a Type 1/2 emergency department.	Source validation only	Source validation only	Zero Type 1/2 ED attendances — no ED performance conclusion for RDY; treat as source-presence check only.	Urgent/emergency care lead to confirm service model and what is coded in A&E returns.
A&E — Other emergency admissions	3 (May 2026)	Previous period: 0 (Apr 2026). Historic stack: trend_ae_rdy.csv (12 periods).	Source validation only	Local owner confirmation needed	Small counts should be treated as coding/service-model-specific until confirmed — not ED activity.	Confirm what 'other emergency admissions' represents for RDY in the national return.
DM01 — AUDIOLOGY_ASSESSMENTS (activity and waiting list)	Activity 1,436 (Apr 2026)	Audiology WL 2,306 of 2,361 total; 6 waits 13+ weeks.	Falling	Local owner confirmation needed	DM01 for RDY is mainly an audiology/community diagnostics picture — audiology accounts for most waiting-list volume in the extract.	Diagnostics service owner to confirm DM01 mapping to local community diagnostic pathways.
KH03 — Mental illness overnight beds	176.8462 beds (Jun 2024 — KH03 — Mental illness overnight beds (recent snapshots))	Previous snapshot: 178.2418 (Mar 2024). KH03 supporting extract: 6 quarterly snapshots from 2023-03-31 to Jun 2024 (may lag monthly A&E/DM01 dates).	Stable	Local owner confirmation needed	KH03 is a quarterly bed-stock source — label metric name (available vs occupied) before interpreting values.	Bed management/estates lead to confirm latest KH03 quarter, metric definition and alignment with internal bed state.

Why this is useful

The agent checked RDY presence across heterogeneous urgent-care, diagnostics and bed-stock sources.
It explained which sources are meaningful for a mental health/community trust and where local owners must confirm definitions.

Human validation checklist

Is this the same definition used locally? — Public datasets may use national definitions. Local dashboards may use different filters, denominators or reporting dates.
Is this still the latest position? — Public data may be delayed. Local operational data may have moved on since the reporting period shown.
Is the figure affected by data quality, suppression, coding or service model? — A public figure can be affected by small numbers, exclusions, coding rules or how services are configured.
Who owns the local narrative? — The accountable service, finance, workforce, quality or BI owner should confirm the explanation before use.
Is this suitable for board/service reporting, or only a prompt for further review? — These briefs are first drafts — confirm whether the figure is ready for formal reporting or needs more local work.
Which urgent care metrics apply locally without an ED? — Many national urgent care indicators assume Type 1/2 ED activity — confirm which apply to RDY.

Bottom line

This is a source applicability check, not a unified performance report. A&E rows validate RDY's service model rather than ED performance. DM01 mainly describes audiology/community diagnostics waiting lists for RDY. KH03 provides quarterly mental health bed-stock context. Local owners should confirm all figures before operational use.

Audit trail and source checks

Figures trace to processed RDY extracts and trend_*.csv files — filter to Organisation_Code or Org Code = RDY.

See linked demo CSV and filter notes.

Demo CSV(s):

Filter / inspection notes:

Method documentation: PUBLIC_REPORTS_METHOD.md · DATA_SOURCE_REGISTER.csv · Governance and benefits

A&E RDY row — full public data columns

Period	Org Code	Parent Org	Org name	A&E attendances Type 1	A&E attendances Type 2	A&E attendances Other A&E Department	A&E attendances Booked Appointments Type 1	A&E attendances Booked Appointments Type 2	A&E attendances Booked Appointments Other Department	Attendances over 4hrs Type 1	Attendances over 4hrs Type 2	Attendances over 4hrs Other Department	Attendances over 4hrs Booked Appointments Type 1	Attendances over 4hrs Booked Appointments Type 2	Attendances over 4hrs Booked Appointments Other Department	Patients who have waited 4-12 hs from DTA to admission	Patients who have waited 12+ hrs from DTA to admission	Emergency admissions via A&E - Type 1	Emergency admissions via A&E - Type 2	Emergency admissions via A&E - Other A&E department	Other emergency admissions
MSitAE-MAY-2026	RDY	NHS ENGLAND SOUTH WEST	DORSET HEALTHCARE UNIVERSITY NHS FOUNDATION TRUST	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	3	3

KH03 mental illness beds (snapshots in extract)

reporting_period_start	measure_id	measure_name	metric_value
30/06/2024	Mental Illness	Mental Illness beds	176.8462
30/06/2024	Mental Illness	Mental Illness beds	203.0000
30/06/2024	Mental Illness	Mental Illness beds	203.0000
30/06/2024	Mental Illness	Mental Illness beds	176.8462
30/06/2024	Mental Illness	Mental Illness beds	203.0000
30/06/2024	Mental Illness	Mental Illness beds	203.0000

Key findings by review area (detail)

Key findings by review area

A&E source validation

A&E — RDY row and zero Type 1/2 attendances

RDY row present in May 2026 A&E extract. Type 1/2 attendances = 0 — expected for RDY service model. Other emergency admissions: 3.

Human check: Urgent/emergency care lead to confirm service model and A&E return coding.

DM01 diagnostics

DM01 — AUDIOLOGY_ASSESSMENTS

16 diagnostic test rows for Apr 2026. Top test activity: 1,436. Audiology/community diagnostics may dominate — local validation required.

Human check: Diagnostics service owner to confirm DM01 mapping to local pathways.

KH03 bed snapshots

KH03 — Mental illness overnight beds

Latest snapshot: 176.8462 beds (Jun 2024). Quarterly stack only — verify latest quarter on NHS England site.

Human check: Bed management/estates lead to confirm alignment with internal bed state.

Draft interpretation (detail)

Draft interpretation

RDY appears in public A&E, DM01 and KH03 files — interpretation needs service-owner confirmation. A&E shows zero Type 1/2 ED attendances (expected for RDY service model).
DM01: 16 test rows for Apr 2026 — AUDIOLOGY_ASSESSMENTS has highest activity; six-month window Nov 2025 – Apr 2026.
KH03: KH03 supporting extract: 6 quarterly snapshots from 2023-03-31 to Jun 2024 (may lag monthly A&E/DM01 dates).
This brief validates source presence — it does not prove urgent care or diagnostic performance standing.

Prompt excerpt

Confirm RDY row presence per source. Report zero ED attendances explicitly.
No ED performance claims. No causal language.

Source presence tables and charts

YesRDY in A&E file

16DM01 RDY rows

24KH03 RDY rows

Apr 2026DM01 latest period

Period: A&E: May 2026; DM01: Apr 2026

Source presence check

Source	RDY_present	Notes
A&E monthly provider	Yes	Other emergency admissions: 3; 0 Type 1/2 A&E attendances
DM01 diagnostics	Yes	16 diagnostic test rows for RDY (Apr 2026)
KH03 overnight beds	Yes	24 bed rows — latest snapshot from historic pipeline

A&E RDY row — interpretive columns only (May 2026)

Period	Org Code	Org name	A&E attendances Type 1	Other emergency admissions
MSitAE-MAY-2026	RDY	DORSET HEALTHCARE UNIVERSITY NHS FOUNDATION TRUST	0	3

DM01 diagnostics summary — Apr 2026

Diagnostic Tests	Total WL	Total Activity	13+ Weeks
TOTAL	2361	1876	6
AUDIOLOGY_ASSESSMENTS	2306	1451	6
NON_OBSTETRIC_ULTRASOUND	55	425	0
MRI	0	0	0
CT	0	0	0
BARIUM_ENEMA	0	0	0
DEXA_SCAN	0	0	0
ECHOCARDIOGRAPHY	0	0	0
ELECTROPHYSIOLOGY	0	0	0
PERIPHERAL_NEUROPHYS	0	0	0
SLEEP_STUDIES	0	0	0
URODYNAMICS	0	0	0
COLONOSCOPY	0	0	0
FLEXI_SIGMOIDOSCOPY	0	0	0
CYSTOSCOPY	0	0	0

DM01 total activity by test (RDY, Apr 2026)

Period: Apr 2026

TOTAL

AUDIOLOGY_ASSESSMENTS

NON_OBSTETRIC_ULTRASOUND

MRI

BARIUM_ENEMA

DEXA_SCAN

ECHOCARDIOGRAPHY

ELECTROPHYSIOLOGY

PERIPHERAL_NEUROPHYS

Additional source commentary

A&E monthly — RDY presence and zero ED attendances Source validation only

Plain-English meaning: Monthly A&E provider statistics — attendance and emergency admission columns.
Latest value / position: RDY row present; Type 1/2 A&E attendances = 0; other emergency admissions = 3
Comparator / trend: Historic A&E stack (12 months) — Type 1/2 attendances remain zero; source validation only.
Agent flag: Source validation only
Cautious interpretation: Zero ED attendances are consistent with RDY not operating a Type 1/2 emergency department — this row confirms source presence and coding, not urgent care performance. Small other emergency admission count (3) needs service-owner confirmation of what is included.
Human check required: Urgent/emergency care lead to confirm service model and what 'other emergency admissions' represents for RDY.

DM01 — Diagnostic tests (Apr 2026) Review locally

Plain-English meaning: Monthly diagnostic waiting list and activity by test type for RDY as provider.
Latest value / position: 16 test rows; highest activity: AUDIOLOGY_ASSESSMENTS
Comparator / trend: Historic DM01 stack: latest vs previous month for AUDIOLOGY_ASSESSMENTS — 1,436 vs 1,451.
Agent flag: Review locally
Cautious interpretation: Audiology and community diagnostics may dominate activity — do not infer national waiting position without local validation.
Human check required: Diagnostics service owner to confirm DM01 mapping to local community diagnostic pathways.

KH03 — Overnight mental illness beds (snapshot dates) Watch / clarify

Plain-English meaning: Quarterly overnight bed stock by sector — mental illness rows relevant to RDY as mental health provider.
Latest value / position: 176.8462 beds (Jun 2024 snapshot)
Comparator / trend: Historical snapshots span 6 dates — latest vs previous: 176.8462 vs 178.2418. Irregular snapshot intervals — descriptive only.
Agent flag: Watch / clarify
Cautious interpretation: KH03 supporting extract: 6 quarterly snapshots from 2023-03-31 to Jun 2024 (may lag monthly A&E/DM01 dates).
Human check required: Bed management/ estates lead to confirm latest KH03 quarter and alignment with internal bed state.

A&E and DM01 six-month window summary

Six-month trend summary

Six-month descriptive trends from trend_ae_rdy.csv (Dec 2025 – May 2026) and trend_dm01_rdy.csv (Nov 2025 – Apr 2026).

Measure	Latest	Previous period	Period-on-period change	Six-month change	Six-month avg	Six-month high	Six-month low	Trend reading	Note
A&E — other emergency admissions (source validation)	3 (May 2026)	0 (Apr 2026)	+3	-1 (-25%)	2.3	4	0	Volatile	Source validation only — small counts need service-owner confirmation.
DM01 — AUDIOLOGY_ASSESSMENTS total activity	1,436 (Apr 2026)	1,451 (Mar 2026)	-15 (-1%)	+133 (+10.2%)	1,345.3	1,455	1,167	Volatile	Provisional DM01 monthly diagnostics; audiology may dominate activity counts.

A&E — other emergency admissions (source validation) (Dec 2025 – May 2026)

DM01 — AUDIOLOGY_ASSESSMENTS total activity (Nov 2025 – Apr 2026)

A&E trends are source validation only — zero Type 1/2 ED attendances expected at RDY.
DM01 provisional monthly data — validate with diagnostics service owner.

A&E trend detail

Trend analysis (from downloaded public time series)

Descriptive period-on-period change only — not causal. Figures may be provisional; suppression, rounding and definition changes may apply between months.

Source: trend_ae_rdy.csv / trend_dm01_rdy.csv (historic stack from script 05)

Measure	Latest	Previous	Absolute_change	Percent_change	Periods_in_extract
A&E — other emergency admissions (source validation)	3 (May 2026)	0 (Apr 2026)	+3	—	12
DM01 — Audiology total activity	1,436 (Apr 2026)	1,451 (Mar 2026)	-15	-1%	17

A&E — other emergency admissions (source validation) — monthly trend (descriptive)

Jun 25

Jul 25

Aug 25

Sep 25

Oct 25

Nov 25

Dec 25

Jan 26

Feb 26

Mar 26

DM01 — Audiology total activity — monthly trend (descriptive)

Oct 24

Nov 24

Dec 24

Jan 25

Feb 25

Mar 25

Jun 25

Jul 25

Aug 25

Sep 25

A&E — other emergency admissions (source validation): rolling mean across 12 months = 1.7 (descriptive only — not a performance target).

DM01 — Audiology total activity: rolling mean across 17 months = 1,261.5 (descriptive only — not a performance target).

A&E trends are source validation only — zero Type 1/2 ED attendances expected at RDY.
Descriptive period-on-period change only — not operational cause.

KH03 bed trend detail

Trend analysis (from downloaded public time series)

Descriptive period-on-period change only — not causal. Figures may be provisional; suppression, rounding and definition changes may apply between months.

Source: trend_kh03_beds_rdy.csv — Mental Illness sector, recent snapshots only

Measure	Latest	Previous	Absolute_change	Percent_change	Periods_in_extract
KH03 — Mental illness overnight beds (recent snapshots)	176.8462 (Jun 2024)	178.2418 (Mar 2024)	-1.395604	-0.8%	6

KH03 — Mental illness overnight beds (recent snapshots) — monthly trend (descriptive)

Mar 23

Jun 23

Sep 23

Dec 23

Mar 24

Jun 24

KH03 — Mental illness overnight beds (recent snapshots): rolling mean across 6 months = 174.9 (descriptive only — not a performance target).

Snapshot dates are irregular (quarterly, not monthly) — descriptive only.
Latest snapshot may lag NHS England publication — verify on source site.

Human review required: Confirm definitions, publication status and local owner sign-off before any operational use.

← Back to draft reports