Background to the project
Like many healthcare organisations, Kingston Hospital was using an outdated data management and reporting system that could not meet their requirements for real time reporting from Electronic Patient Records (EPRs).
Historically, Kingston Hospital has used overnight extracts from its core clinical system to populate its data warehouse for management information reporting. Bulk processing can cause issues such as extraction errors, delays, data quality and timeliness of data.
At the same time, there is increasing pressure for NHS Trusts to provide high quality real time or near real time information to a range of stakeholders and partners as well as the desire to utilise data for their own operational efficiency.
“We had years and years of relying on overnight feeds. When they fail it can all go wrong because you have to load data manually and in the right order. We were keen to move to a new environment ASAP as data extraction was very painful for everyone involved,” explains Ursula Kingsley, Deputy Head of Information Services, Kingston Hospital.
The initial goal for the project was to achieve real time data access, but Kingston Hospital also has ambitions to use analytics for performance-based predictions.
Why Trustmarque was selected as partner
Trustmarque is well-versed in the issues NHS Trusts are facing in pulling data from EPR systems. We were able to demonstrate to Kingston Hospital our unique position; offering a consultative approach based on unrivalled market knowledge to identify the right value-based solution.
As part of the consultation, Trustmarque introduced Kingston Hospital to a similar data migration project at Royal Berkshire Hospital where they were using Bedrock data extraction tool. According to Ursula, when they saw the effectiveness of Bedrock in operation they were “bowled over”.
Zoe Dronfield, Trustmarque Client Manager, said: “Trustmarque have strong competencies around prediction which is an area the NHS is moving into. Being proactive and understanding the ‘what if’ scenarios is crucial to understanding your service and working in the most efficient manner to deliver better care. We have an impartial view of the market, so we can really look across the vendor landscape to find the right solution, whatever your data challenge.”
Bedrock Real Time Connector is a data extraction tool that moves data from Cerner to a local SQL Server database within just a few seconds. Bedrock is highly specialised to the healthcare market and works very efficiently with Cerner data platforms, however it can also be used to support any EPR system.
It is designed to simplify data warehouse management, making processes and reporting faster and more reliable. Large updates can run in minutes and the data is always available 24/7.
The extracted data can be used for a range of operational needs; monitoring patients in A&E, daily finance reporting and other operational notifications via mobile apps. Discover more