|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:-
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.