Norfolk and Waveney STP Bed Flow Management Tracker DISCOVERY

Project details:

Organisation Norfolk County Council
Department Information Management Service, Information Management and Technology
Collaboration Level Share Ideas
Budget £0K > £50K
Key Contact Mark Crannage
Phase start 25 June 2018
Phase Estimated end 31 December 2018



Building on an initial trial deployment last winter of an Adult Service, Care Home Bed Tracker which has:-

  • enabled quick identification of a vacancy ensuring improved turnaround times enabling social worker staff to quickly place service users
  • significantly helps winter pressures and speeds up hospital discharges
  • enabled NCC to use less experienced staff to identify vacancies enabling the more experienced staff to focus on arranging contracts which means we are paying providers earlier and saving around 450 phone calls a week.
  • by putting contracts on early this reduces potential loss of income (i.e. service users are more likely to receive an invoice earlier, meaning advice and information is given earlier to reduce customer complaints.

Norfolk County Council are leading the development of a full system wide Bed Management Tracker primarily designed to aid in the demands on the system during winter pressures, for the Norfolk and Waveney STP footprint. The types of organisations within the footprint include 3 Acute Hospitals, 1 Mental Health Trust, 1 Community Health provider and a local authority care home provision viewpoint.

The Bed Management Tracker prototype (using Microsoft PowerBI) has the functionality to show a full system wide view of the bed capacity and demand across the Norfolk and Waveney STP footprint through one dashboard that can be available to all the key STP stakeholders to aid in managing bed pressures, especially winter pressures. There is also a provider specific dashboard available to each organisation that identifies the number of occupied beds, number of empty beds and the demand of patients currently not in beds at ward level, and at organisation wide level. There are also filters available to view the information by quinary age bands, gender, ward type, ward classification and bed group.

The Bed Management Tracker prototype has been designed to take a generic bed state dataset from the NHS provider organisations on a 15-minute cycle 24 hours, 7 days a week, 52 weeks of the year. The dataset is sent and received via a secure file transfer process and is digested into Norfolk County Council’s award-winning Data Warehouse analytical solution - GRID which has been developed to enable better business insights being key to delivering better decisions.




Status Updates