Worked example: AI-assisted public statutory assurance source map

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: Which public assurance artefacts contain RDY rows, what is each useful for, what are the gaps (FFT org-level, CQC non-statistical context), and how should a Business & Performance Partner use this as a conversation starter?

Dataset: KO41a, ERIC, DSPT, FFT and CQC public sources (assurance index)

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

Data used

demo_assurance_profile.csv
KO41a, ERIC, DSPT processed extracts
CQC context note (regulatory background only)

Period covered: KO41a 2024-25; ERIC 2024/25; DSPT public history; FFT/CQC as noted.
RDY filter: ODS code RDY; Dorset HealthCare trust name variants (see filter notes)
Historic trend data: Descriptive DSPT history only — not numeric performance trend

What this report can and cannot tell us

This report can:

Confirm which public assurance sources contain RDY rows and what each is useful for.
Document gaps such as missing org-level FFT rows or non-statistical CQC context.

This report cannot:

Combine assurance sources into a performance score or league table.
Draw operational IG, complaints or patient experience conclusions without local owner validation.

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

Headline reading

KO41a 2024-25: 403 new written complaints, 98 upheld — complaints team should confirm themes and local position.
ERIC 2024/25: 177 sites with exemplar estate metrics extracted — estates owner should confirm amendments.
DSPT latest public assessment: 2024-25 (version 7) - Standards met — but 2025-26 v8 deadline is 30 June 2026; confirm current-year submission with IG.
FFT org-level rows absent — setting-specific files may hold relevant rows; patient experience lead follow-up needed.
CQC overall Outstanding (main report 2019) — regulatory context only, not a performance score.

Main metric table

Public statutory assurance source map — not a composite performance score.

Period: KO41a 2024-25; ERIC 2024/25; DSPT public history; FFT/CQC as noted

Assurance sources are mostly annual snapshots or descriptive history — not numeric performance trends.

Figure / measure	Latest value	Peer position / comparator	Validation status	Judgement	Human check
KO41a — Written complaints (annual)	403 new; 98 upheld (2024-25)	Upheld rate ~24.3%. From rdy_ko41a_*Org Level.csv — Complaints_Total_New, Complaints_Number_Upheld.	Local owner confirmation needed	Participation confirmed — volume and themes need complaints team, not this brief alone.	Complaints team to confirm 2024-25 figures, PALS themes and whether public row matches internal reporting.
ERIC — Estates returns (annual)	177 sites; lifecycle capital maintenance £664,356 (2024/25)	From rdy_eric_annual_trust_data.csv — Total number of sites, Capital investment for maintaining (lifecycle) existing buildings.	Local owner confirmation needed	ERIC supports facilities benchmarking — confirm amendments file and board reporting year.	Estates/facilities owner to confirm amendments file and whether board reporting uses the same year.
DSPT — Data Security and Protection Toolkit	2024-25 (version 7) - Standards met	Latest: 2024-25 (version 7) - Standards met (30 June 2025). 2025-26 v8 deadline: 30 June 2026.	Local owner confirmation needed	Latest public status is 2024-25 Standards met, but confirm 2025-26 submission readiness with IG before assurance use.	IG/calendar owner to confirm 2025-26 DSPT v8 submission status and internal IG audit programme.
FFT — Friends and Family Test (org-level gap)	No org-level RDY rows in downloaded FFT summary XLSX	FFT split by setting — org-level workflow gap; see metadata/fft_manual_download_needed.md.	Local owner confirmation needed	Missing org-level row is a workflow/design issue — not evidence of poor patient experience.	Patient experience lead to confirm setting-level FFT files and whether service-category rows are more appropriate.
CQC — Regulatory context	Overall Outstanding — main provider report July 2019	Overall: Outstanding; Safe/Effective Good; Caring/Well-led Outstanding; Responsive Good. Manually curated from public CQC page — regulatory context only. <cite class="nhs-standard-cite"><a href="https://www.cqc.org.uk/provider/RDY" rel="noopener">CQC provider page — Dorset Healthcare University NHS Foundation Trust; published Main report July 2019; focused inspections to Mar 2026; accessed 2026-06-21; confidence: confirmed</a></cite>	Local owner confirmation needed	Use as regulatory context only — confirm latest internal action plans with quality/governance lead.	Quality/governance lead to confirm latest inspection status and internal action plans.

Why this is useful

The agent mapped which public assurance sources contain RDY rows and what each can safely support.
It extracted traceable values where possible, flagged currentness risks, and named who to speak to next.

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.
Who is the named owner for each return this cycle? — KO41a, ERIC, DSPT and FFT each have accountable teams — confirm before citing in assurance packs.

Bottom line

This is an assurance source map, not a performance report. Public data confirms RDY participation in key statutory returns and shows DSPT Standards met on the latest published assessment, but FFT needs setting-level follow-up and all sources need owner confirmation before any meeting use.

Audit trail and source checks

Assurance index figures trace to demo and processed extracts — no derived ranks or peer medians.

See linked demo CSV and filter notes.

Demo CSV(s):

demo_assurance_profile.csv

Filter / inspection notes:

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

Assurance index (demo extract — full columns)

source	label	rdy_rows	columns	_demo_source	_synthetic
ko41a_annual	Written complaints (KO41a)	12	Year; NHS_England_Region_Code; NHS_England_Region_Name; ICS_Code; ICS_Name; Organisation_Code; Organisation_Name; Site_Code	assurance_combined	FALSE
eric_annual	ERIC estates	1	Trust Code; Trust Name; Commissioning Region; Trust Type; Number of sites - General acute hospital (No.); Number of sites - Specialist hospital (acute only) (No.); Number of sites - Mixed service hospital (No.); Number of sites - Mental Health (including Specialist services) (No.)	assurance_combined	FALSE
dspt_rdy	DSPT assessment history	16	Status; Date Published	assurance_combined	FALSE

CQC regulatory context note

CQC Dorset HealthCare provider page — CONTEXT ONLY
================================================

DISCLAIMER: This is a public-data demonstration note. It is NOT an official Dorset HealthCare report.
Outputs require human review and local owner confirmation before operational use.

URL: https://www.cqc.org.uk/provider/RDY
Page title: Dorset Healthcare University NHS Foundation Trust
Captured: 2026-06-21

This source provides regulatory context (ratings, regulated activities, inspection links).
It is not a statistical aggregate dataset and was not bulk-downloaded.

Key findings by review area (detail)

Key findings by review area

Statutory participation confirmed

KO41a — Written complaints (annual)

RDY org-level row present in 2024-25 extract. Presence confirms participation — volume and themes need the complaints team.

Human check: Complaints team to confirm 2024-25 figures and whether public row matches internal reporting.

ERIC — Estates returns (annual)

RDY trust row in 2024/25 ERIC extract. Supports facilities benchmarking — not a simple good/bad score.

Human check: Estates/facilities owner to confirm amendments file and board reporting year.

IG and patient experience

DSPT — Data Security and Protection Toolkit

Latest public assessment: 2024-25 (version 7) - Standards met. Descriptive history across 16 published assessment rows — earliest: 2018-19 (version 1) - Baseline (11 October 2018); latest: 2024-25 (version 7) - Standards met (30 June 2025). Status labels are annual assurance signals, not operational IG detail.

Human check: IG/calendar owner to confirm current-year submission status.

FFT — Friends and Family Test (org-level gap)

No org-level RDY rows in downloaded FFT summary XLSX — workflow gap for analysts, not evidence of poor experience.

Human check: Patient experience lead to confirm whether setting-level XLSX download fills the gap.

Regulatory context

CQC — Regulatory context

Care Quality Commission provider page captured as context note — inspection and regulatory background only.

Human check: Quality/governance lead to confirm latest inspection status and internal action plans.

Draft interpretation (detail)

Draft interpretation

Public data confirms RDY participation in KO41a complaints and ERIC estates returns.
Latest DSPT public assessment: 2024-25 (version 7) - Standards met — annual assurance label, not operational IG detail.
FFT org-level rows were absent in the downloaded summary file — patient experience lead follow-up needed.
CQC provides regulatory context only — not a performance score or league table.

Prompt excerpt

Index public assurance sources for RDY: KO41a, ERIC, DSPT, FFT, CQC.
Appropriate-use language only — no operational IG or complaints performance conclusions.

Assurance source tables and DSPT history

3Assurance sources indexed

16DSPT history rows

2024-25KO41a period

ContextCQC / FFT gaps

Period: KO41a 2024-25; ERIC 2024/25; DSPT public history; FFT/CQC as noted

Assurance source map

Source	Latest_value	Currentness_risk	Who_to_speak_to
KO41a	403 new complaints; 98 upheld (24.3%)	Annual; may lag operational position	Complaints / PALS team
ERIC	177 sites; lifecycle capital maint £664,356	Annual; may be amended	Estates / facilities owner
DSPT	Latest public: 2024-25 (version 7) - Standards met	Latest public assessment may not reflect 2025-26 submission (v8 deadline 30 Jun 2026)	IG / calendar owner
FFT	No org-level RDY rows in downloaded FFT summary XLSX	Monthly but setting-specific; org-level row may be absent	Patient experience lead
CQC	Overall Outstanding (main report 2019) — see CQC context	Ratings may be old; focused inspections may be newer	Quality / governance lead

DSPT public assessment history (RDY-specific page)

Status	Date Published
2024-25 (version 7) - Standards met	30 June 2025
2023-24 (version 6) - Standards met	26 June 2024
2023-24 (version 6) - Baseline	29 February 2024
2022-23 (version 5) - Standards met	30 June 2023
2022-23 (version 5) - Baseline	03 March 2023
2021-22 (version 4) - Standards met	30 June 2022
2021-22 (version 4) - Baseline	04 March 2022
2020-21 (version 3) - Approaching standards	28 July 2021

Additional source commentary

KO41a — Written complaints (annual) Review locally

Plain-English meaning: Annual statutory return confirming RDY submitted written complaints data for 2024-25.
Latest value / position: RDY org-level row present in downloaded 2024-25 extract
Comparator / trend: Single annual snapshot in current extract — complaints trends need multiple years or local data.
Agent flag: Review locally
Cautious interpretation: Presence in KO41a confirms participation — volume, themes and small numbers need the complaints team, not this brief.
Human check required: Complaints team to confirm 2024-25 figures, PALS themes and whether public row matches internal reporting.

ERIC — Estates returns (annual) Review locally

Plain-English meaning: Annual estates and facilities cost/activity return — benchmarking and assurance context.
Latest value / position: RDY trust row in 2024/25 ERIC extract
Comparator / trend: Annual cadence — trend requires multiple ERIC years or local estates dashboards.
Agent flag: Review locally
Cautious interpretation: ERIC supports facilities benchmarking conversations — not a simple 'good/bad' performance score.
Human check required: Estates/facilities owner to confirm amendments file and whether board reporting uses the same year.

DSPT — Data Security and Protection Toolkit Potential strength

Plain-English meaning: Annual IG assurance assessment status published on the DSPT organisation page.
Latest value / position: 2024-25 (version 7) - Standards met
Comparator / trend: Descriptive history across 16 published assessment rows — earliest: 2018-19 (version 1) - Baseline (11 October 2018); latest: 2024-25 (version 7) - Standards met (30 June 2025). Status labels are annual assurance signals, not operational IG detail.
Agent flag: Potential strength
Cautious interpretation: 'Standards met' is an annual assurance label — it does not prove day-to-day operational IG compliance. Historical rows show movement from 'Approaching standards' (2018-19, 2020-21) to 'Standards met' in recent years — descriptive history only.
Human check required: IG/calendar owner to confirm current-year submission status and internal IG audit programme.

FFT — Friends and Family Test (org-level gap) Watch / clarify

Plain-English meaning: Patient experience survey aggregate — org-level FFT rows expected in summary downloads.
Latest value / position: No org-level RDY rows in downloaded FFT summary XLSX
Comparator / trend: Org-level trend not available — see metadata/fft_manual_download_needed.md for manual download steps.
Agent flag: Watch / clarify
Cautious interpretation: Missing org-level FFT is a workflow gap for analysts — not evidence of poor experience.
Human check required: Patient experience lead to confirm whether setting-level XLSX download fills the gap.

CQC — Regulatory context (not statistical data) Source validation only

Plain-English meaning: Care Quality Commission provider page captured as context note — inspection and regulatory background.
Latest value / position: Context note in metadata — not a performance metric
Comparator / trend: Not applicable — qualitative regulatory context only.
Agent flag: Source validation only
Cautious interpretation: CQC information supports assurance conversations — it must not be treated as a league table or performance proxy.
Human check required: Quality/governance lead to confirm latest inspection status and internal action plans.

DSPT assessment history (descriptive)

Multiple published assessment rows exist for RDY — summarised descriptively, not as a numeric performance trend.

Status	Date Published
2024-25 (version 7) - Standards met	30 June 2025
2023-24 (version 6) - Standards met	26 June 2024
2023-24 (version 6) - Baseline	29 February 2024
2022-23 (version 5) - Standards met	30 June 2023
2022-23 (version 5) - Baseline	03 March 2023
2021-22 (version 4) - Standards met	30 June 2022
2021-22 (version 4) - Baseline	04 March 2022
2020-21 (version 3) - Approaching standards	28 July 2021
2020-21 (version 3) - Approaching standards	30 June 2021
2020-21 (version 3) - Baseline	25 February 2021
2019-20 (version 2) - Standards met	28 September 2020
2019-20 (version 2) - Baseline	30 October 2019
2019-20 (version 2) - Baseline	30 October 2019
2018-19 (version 1) - Approaching standards	05 April 2019
2018-19 (version 1) - Standards not met	29 March 2019
2018-19 (version 1) - Baseline	11 October 2018

Annual IG assurance labels only — confirm current submission with the IG owner.

FFT trend detail

FFT trend not available from current extract

Public FFT summary XLSX files did not yield org-level RDY rows suitable for trend analysis.

See site/public-data/metadata/fft_manual_download_needed.md for URLs tried and recommended manual steps.

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

← Back to draft reports