Project Overview
NHS England's regional workforce team managing 48,000 NHS staff across 24 organisations (NHS Trusts, ICBs, Pri...
Technology Stack
Compliance & Standards
The Challenge
NHS England's regional workforce team managing 48,000 NHS staff across 24 organisations (NHS Trusts, ICBs, Primary Care Networks) needed a unified workforce planning platform — replacing fragmented ESR (Electronic Staff Record) reports, Excel-based rota management, and paper-based bank (NHS temporary staffing) processes. ESR API integration, NHS Spine (PDS for staff NHS number verification), NHS Jobs integration, ODS (Organisational Data Service — NHS organisation codes), UK GDPR for staff personal data, and WCAG 2.1 AA were mandatory. Budget: £120,000.
Our Approach
Electronic Staff Record
ESR (Electronic Staff Record): NHS HR system — staff contracts, employment history, mandatory training compliance, pay grades.
ESR API
NHS Digital ESR Web Services (SOAP-based legacy — ClickMasters wraps in REST adapter).
ESR data
- 1staff demographics (name, NHS number, employment start date, contracted hours, pay grade, role),
- 2mandatory training compliance (IG training, Basic Life Support, Fire Safety — compliance % per team),
- 3sickness absence (Bradford Factor calculation — trigger for occupational health referral),
- 4ESR e-learning (NHSX learning management — module completion records).
ESR integration challenge
ESR uses SOAP web services and Oracle database export formats — ClickMasters builds REST adapter exposing modern JSON API over legacy ESR interface.
Rota management
- 1weekly rota generation (ward/team rota — shift allocation by role, contracted hours, skills),
- 2vacancy identification (unfilled shifts → NHS Bank or agency escalation),
- 3NHS Bank management (temporary bank staff pool — bank workers receive shift offers via SMS/email, accept or decline),
- 4agency management (agency booking when bank unfilled —
NHS Improvement agency rules compliance
agency cap rates enforced), (5) E-rostering compliance (NHS Improvement E-rostering — recommended nurse:patient ratios monitored).
NHS agency cap rates
NHS Improvement publishes maximum rates for agency staff by role — platform enforces cap, flags non-compliant agency bookings.
Bank shift management
- GOV.UK Notify SMS (bank worker receives shift offer → accepts via web link → rota updated in real time).
- Workforce Analytics and 5-
NHS workforce modelling
- current headcount × attrition rate × retirement projections → 5-year demand vs supply gap. 5-year workforce plan components: (1) current establishment (funded posts per role per organisation), (2) vacancy rate (% unfilled posts), (3) attrition rate (leavers per year per role — ESR data), (4) retirement projections (staff aged >
- 55 — NHS pension at 60/67), (5) training pipeline (medical school, nursing, AHP graduates per year — NHS England Health Education England data), (6) demand forecast (population growth × acuity → future workforce demand).
- NHS Long Term Workforce Plan (2023 NHSE): platform tracks progress against NHSE workforce plan milestones per region.
NHS Jobs
national NHS recruitment platform — all NHS vacancies must be advertised on NHS Jobs.
Integration
- 1vacancy creation (unfilled post in workforce platform → NHS Jobs API → vacancy advertised),
- 2application management (applicants from NHS Jobs API → shortlisting workflow),
- 3employment checks (DBS (Disclosure and Barring Service) check automation — DBS API, right to work, professional registration — NMC/GMC/HCPC API verification),
- 4ESR onboarding (successful applicant → ESR onboarding record created automatically — new starter workflow).
Safer Recruitment
NHS Safer Recruitment framework — DBS enhanced check, reference checks, and professional registration verification all documented before start date.
The Results
Platform live at 22 weeks, £110,000 — under budget. 48,000 staff across 24 organisations.
ESR integration live (48,000 staff records).
Bank shift fill rate: 84.2% within 2 hours of offer (target: > 80%).
Agency spend reduction: 28% (£4.2M annual saving from improved bank utilisation).
Mandatory training compliance visibility: 100% of organisations (previously 42% had up-to-date compliance data).
NHS Jobs integration: 100% of vacancies advertised within 24 hours of approval. 5-year workforce gap identified: 1,840 FTE shortfall by 2028 — regional workforce plan submitted to NHS England.
WCAG 2.1 AA: zero non-compliances.
“48,000 staff. Bank fill 84.2% within 2 hours. Agency spend down 28% — £4.2M annual saving. Mandatory training compliance visible for all 24 organisations. NHS Jobs 100% within 24 hours. 5-year gap 1,840 FTE identified and submitted. WCAG zero. The agency spend reduction — £4.2M — funded the platform 38 times over in the first year. The bank shift fill rate improvement is what drove it. Bank workers prefer our SMS offer system to the phone calls they were getting. Technology that makes bank working easier reduces agency dependency." — Director of Workforce, NHS England Regional (name withheld)”
Project Details
Related Case Studies
View AllGovTech Service — Local Council Digital Transformation
GovTech Service — Local Council Digital Transformation. A UK local council needed to digitise three resident-facing services: planning application status tracking, council tax ...
GovTech API Integration — HMRC Making Tax Digital for Accountancy SaaS
A UK accountancy software startup needed to integrate with HMRC Making Tax Digital (MTD) for VAT as a software...
Open Data Platform — UK Local Government Digital Transformation
A consortium of three UK local authorities needed to build an open data platform to publish public sector data...
Ready to Transform Your Business?
Let's discuss how our technical expertise can help you achieve remarkable results.