← All reportsAgent operating modelReport method

Agent-assisted analytical brief · Public aggregate data · RDY · Demonstration only

Worked example: AI-assisted CSDS community activity briefing

CSDS community activity profile — RDY, Mar 2026 with descriptive trend

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: Using public CSDS for Mar 2026 , explain community activity measures, show descriptive six-month trends where the historic stack supports them, and what a business partner should validate locally.

Dataset: CSDS Monthly Statistics (RDY provider rows)

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

Scope: Provider / RDY rows only — not Dorset population or ICB-resident views.

Data used

What this report can and cannot tell us

This report can:

This report cannot:

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

Headline reading

  • Both Assessment and Clinical Intervention increased in Mar 2026 compared with the previous month, but both remain lower than the start of the six-month window (Assessment -29%, Clinical Intervention -8.2%). Local validation needed.
  • 'Other' is the largest activity category (9,995, 42% of total) — limits interpretability.
  • Community waiting-time performance requires CHS SitRep / NHS waiting-list data — not CSDS activity counts. <cite class="nhs-standard-cite"><a href="https://www.england.nhs.uk/statistics/statistical-work-areas/community-health-services-waiting-lists/" rel="noopener">NHS England community health services waiting lists; published 2025/26 planning guidance; accessed 2026-06-21; confidence: confirmed</a></cite>
  • Public aggregate CSDS activity counts cannot prove referral demand, waiting times or team performance.

Priority review flags

Main metric table

CSDS community activity profile for RDY — activity counts only, not access or waiting performance. Six-month summary: Oct 2025 – Mar 2026.

Period: Six-month summary: Oct 2025 – Mar 2026; full extract: 8 months

Figure / measureLatest valuePrevious period / comparatorTrendValidation statusJudgementHuman check
Care activities — Assessment4,270 (Mar 2026)Previous period: 3,880 (Feb 2026). No official standard in public CSDS extract.VolatileLocal owner confirmation neededUp month-on-month but lower than start of trend window — may reflect seasonality, coding or service mix.Community services/BI owner to confirm activity coding and whether this matches local community dashboards.
Care activities — Clinical Intervention5,955 (Mar 2026)Previous period: 5,700 (Feb 2026). Historic stack: trend_csds_activity_rdy.csv.FallingLocal owner confirmation neededUp month-on-month but lower than start of trend window — confirm service scope locally.Directorate lead to confirm which services feed this measure and coding QA for Mar 2026 .
Care activities — Other (ActivityType)9,995 (Mar 2026)42% of ActivityType total — data-quality/interpretability flag.Not availableLocal owner confirmation neededLargest category is 'Other' — local CSDS owners should confirm legitimate coding vs mapping limitations.CSDS return owner to confirm whether 'Other' reflects legitimate coding or inconsistent activity-type recording.
Total care activities (ActivityType slice)23,970 (Mar 2026)Aggregate sum for one month — not trended as a single total in historic stack.Not availableLocal owner confirmation neededPublic CSDS aggregates cannot support team-level or pathway conclusions without local drill-down.Confirm full RDY processed extract contains all measures needed — demo slice may not surface every row.
Community waiting-time performanceNot in this CSDS activity sliceCommunity waiting lists require CHS SitRep / NHS waiting-list data. National planning ambition: 80% under 18 weeks by 2028/29. <cite class="nhs-standard-cite"><a href="https://www.england.nhs.uk/statistics/statistical-work-areas/community-health-services-waiting-lists/" rel="noopener">NHS England community health services waiting lists; published 2025/26 planning guidance; accessed 2026-06-21; confidence: confirmed</a></cite>Not availableLocal owner confirmation neededUse NHS community health services waiting-list publication for access performance — not this activity report.Community services lead to confirm local waiting-list reporting source.

Why this is useful

Human validation checklist

Bottom line

This is an activity profile, not a community services performance report. March activity rose for key types but six-month movement is down for Assessment and Clinical Intervention. Waiting-time performance needs separate CHS waiting-list data. A community services lead should validate coding, especially the large 'Other' category, before any operational use.

Audit trail and source checks

Latest values from trend file where available; demo CSV period 2026-03-01 to 2026-03-31. Trend deltas from trend_csds_activity_rdy.csv.

See linked demo CSV and filter notes.

Key findings by review area (detail)

Key findings by review area

Activity with trend support

Care activities — Assessment

Assessment-type care activities for Mar 2026: 4,270. Latest vs previous month: 4,270 (Mar 2026) vs 3,880 (Feb 2026)

Human check: Community services/BI owner to confirm activity coding.

Care activities — Clinical Intervention

Direct clinical intervention activities: 5,955. Latest vs previous month: 5,955 (Mar 2026) vs 5,700 (Feb 2026)

Human check: Directorate lead to confirm which services feed this measure.

Aggregate limits

Total care activities and age bands

Total ActivityType slice sums to 23,970. Age-band splits vary by activity type and are not trended in the current stack.

Human check: Validate CYP vs adult splits with the CSDS return owner before directorate use.

Draft interpretation (detail)

Draft interpretation

  • For 2026-03-01 to 2026-03-31, care activity totals sum to 23,970 in the ActivityType slice.
  • Historic CSDS stack (Oct 2025 – Mar 2026) supports six-month descriptive comparison for Assessment and Clinical Intervention — not causal conclusions.
  • Public aggregate CSDS cannot prove referral demand, waiting times or team performance.
  • Sparse or zero activity in the demo slice needs local coding confirmation.
Prompt excerpt
Filter CSDS monthly CSV to RDY. Inspect CareActivities by ActivityType.
Use trend_csds_activity_rdy.csv for month-on-month trends where ≥2 periods exist.
No causal language.
Supporting tables and charts
23,970Care activity total (Mar 2026)
10Activity type rows
200Total RDY rows in extract
Mar 2026Latest publication month

Period: Latest month: Mar 2026 (Full extract: 8 months in trend_csds_activity_rdy.csv)

Care activities by type (Mar 2026)

MEASURE_DESCMEASURE_VALUEMEASURE_VALUE_0_18MEASURE_VALUE_19_64MEASURE_VALUE_65_PLUS
Other9995112034455430
Clinical Intervention5955191016452400
Assessment4270139510001875
Counselling, Advice, Support1590 905 225 460
Patient Specific Health Promotion 620 300 205 110
Health Visitor New Birth Visit 400 400 0 0
Health Visitor Health Review (6-8 weeks) 385 385 0 0
Health Visitor Health Review (2-2.5 years) 375 375 0 0
Health Visitor Health Review (1 year) 360 360 0 0
Multidisciplinary Team Review 20 5 10 5

Care activities by type (RDY, Mar 2026)

Period: Mar 2026

Other
Clinical Intervention
Assessment
Counselling, Advice, Support
Patient Specific Health Promotion
Health Visitor New Birth Visit
Health Visitor Health Review (6-8 weeks)
Health Visitor Health Review (2-2.5 years)
Health Visitor Health Review (1 year)
Multidisciplinary Team Review
Additional measure commentary

Care activities — Assessment Review locally

Plain-English meaning
Count of assessment-type care activities recorded in CSDS for the month.
Latest value
4,270
Comparator / trend
Latest vs previous month: 4,270 (Mar 2026) vs 3,880 (Feb 2026)
Agent flag
Review locally
Cautious interpretation
Activity counts reflect coded CSDS submissions — not unique patients.
Human check required
Community services/BI owner to confirm activity coding.

Care activities — Clinical Intervention Review locally

Plain-English meaning
Direct clinical intervention activities in community services for the month.
Latest value
5,955
Comparator / trend
Latest vs previous month: 5,955 (Mar 2026) vs 5,700 (Feb 2026)
Agent flag
Review locally
Cautious interpretation
Largest activity type where numeric — confirm service scope locally.
Human check required
Directorate lead to confirm which services feed this measure.
CSDS six-month trend summary

CSDS six-month trend summary

Descriptive six-month statistics from trend_csds_activity_rdy.csv (Oct 2025 – Mar 2026).

MeasureLatestPrevious periodPeriod-on-period changeCSDS six-month changeCSDS six-month avgCSDS six-month highCSDS six-month lowTrend readingNote
CSDS — Assessment (CareActivities)4,270 (Mar 2026)3,880 (Feb 2026)+390 (+10.1%)-1,740 (-29%)4,453.36,0103,845VolatileActivity counts reflect coded CSDS submissions — not unique patients.
CSDS — Clinical Intervention (CareActivities)5,955 (Mar 2026)5,700 (Feb 2026)+255 (+4.5%)-530 (-8.2%)6,0056,4855,415FallingLargest activity type where numeric — confirm service scope locally.

CSDS — Assessment (CareActivities) (Oct 2025 – Mar 2026)

Oct 25Nov 25Dec 25Jan 26Feb 26Mar 26

CSDS — Clinical Intervention (CareActivities) (Oct 2025 – Mar 2026)

Oct 25Nov 25Dec 25Jan 26Feb 26Mar 26
  • Full trend extract contains 8 months — table above uses six-month window only.
  • Provisional CSDS monthly data; ActivityType/CareActivities slice only.
  • Trend describes direction of change only — not operational cause.
CSDS Assessment and Clinical Intervention 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_csds_activity_rdy.csv (Oct 2025 – Mar 2026)

MeasureLatestPreviousAbsolute_changePercent_changePeriods_in_extract
CSDS — Assessment (CareActivities)4,270 (Mar 2026)3,880 (Feb 2026)+390+10.1%8
CSDS — Clinical Intervention (CareActivities)5,955 (Mar 2026)5,700 (Feb 2026)+255+4.5%8

CSDS — Assessment (CareActivities) — monthly trend (descriptive)

Aug 25
Sep 25
Oct 25
Nov 25
Dec 25
Jan 26
Feb 26
Mar 26

CSDS — Clinical Intervention (CareActivities) — monthly trend (descriptive)

Aug 25
Sep 25
Oct 25
Nov 25
Dec 25
Jan 26
Feb 26
Mar 26

CSDS — Assessment (CareActivities): rolling mean across 8 months = 4,658.8 (descriptive only — not a performance target).

CSDS — Clinical Intervention (CareActivities): rolling mean across 8 months = 5,831.9 (descriptive only — not a performance target).

  • Provisional CSDS monthly data; ActivityType/CareActivities slice only.
  • Trend describes direction of change only — not operational cause.
Human review required: Confirm definitions, publication status and local owner sign-off before any operational use.

← Back to draft reports