HealthTech NHS Integrated Care Board Clinical Analytics Platform

ICB population health data sources

• 1SUS (Secondary Uses Service — admitted patient care, outpatient, A&E — from NHS Digital),
• 2GPES (General Practice Extraction Service — primary care activity data),
• 3CSDS (Community Services Data Set),
• 4IAPT (Improving Access to Psychological Therapies — mental health),
• 5MHSDS (Mental Health Services Data Set).

Data architecture

• all 5 sources → AWS Glue (ETL — NHS-standard fields mapped to ICB analytics schema) → Redshift Serverless (analytics data warehouse) → QuickSight (dashboards — ICB commissioners).
• NHS DTAC Domain 4 (Interoperability): data lineage documented via dbt DAG — every metric traceable to NHS source data set and NHS Digital specification.
• Population Health Stratification —

Population health management

identify high-risk patients before they deteriorate — proactive intervention vs reactive treatment.

Risk stratification

• 1King's Fund Combined Predictive Model (CPM) adapted for NHS data,
• 2QAdmissions score (likelihood of unplanned hospital admission — NHS-validated),
• 3frailty index (electronic Frailty Index — eFI — from primary care data),
• 4multimorbidity count (number of long-term conditions per patient).

Pseudonymised population

• NHS number pseudonymised (HMAC-SHA256 consistent pseudonym) — population-level analytics without direct NHS number exposure.
• GP practice-level stratification: GP practice sees only their own patients' risk scores (not ICB-wide data) — Row Level Security in QuickSight.

Waiting List Analytics and RTT Management

NHS RTT (Referral to Treatment): maximum 18 weeks from referral to treatment (NHS Constitution standard).

RTT breach prediction

• 1current waiting list by specialty (imported weekly from NHS trusts — NHSE Waiting List tracker API),
• 2breach prediction (current wait + expected additional wait by specialty → predicted breach date),
• 3capacity modelling (available outpatient slots vs demand — gap analysis).

ICB action

commissioner identifies at-risk RTT patients → accelerated pathway.

Elective recovery analytics

COVID-19 backlog — ICB tracks progress against NHS England elective recovery plan milestones.

NHSE Waiting List Minimum Data Set

automated weekly extract for NHS England reporting.

GP practice dashboards

each of 42 GP practices sees their own practice-level data (comparative against ICB average — anonymised benchmarking).

Metrics

• 1QOF (Quality and Outcomes Framework — GP achievement against clinical indicators),
• 2appointment utilisation (DNA rate, appointment type mix, clinical staff utilisation),
• 3prescribing analytics (high-cost prescribing, antibiotic stewardship, biosimilar switch rate),
• 4referral analytics (referral rate by specialty, conversion to first appointment, Did Not Attend rate). GPCOG (General Practice COVID Oversight Group) reporting: automated monthly GPCOG report from analytics platform — reduces GP admin burden.