Shrewsbury and Telford NHS trust to create £800k data warehouse

Hospital wishes to enable a ‘transparent view of patient care’

Credit: Pexels from Pixabay

Shrewsbury and Telford Hospital NHS Trust is to build a “data warehouse” to bring together information currently housed in a range of disparate systems. 

The project will enable clinicians and other staff to access “a transparent view of parent care”, the trust hopes. Clinical and care information is currently stored in an outdated way, it said.

“The trust currently has what would be widely known in the industry as a ‘reporting database’ that has evolved organically from former MS Excel and MS Access data repositories and eventually became reported from MS SQL Server, the industry-standard product,” the trust added. “While the product is modern, the data architecture – how the data is stored, structured and designed – is not. Therefore, there is a requirement to move to a fully modelled data warehouse where the data structures underlying reporting, are designed based on the trust’s business requirements.”


Related content


Shrewsbury and Telford are seeking to appoint a supplier to 30-month contract to help design and build a “stable, consolidated, structured data-warehousing model”. This model must allow the trust to produce and store its “nationally mandated submission datasets”, as well as enabling automated reporting of certain information.

The warehouse will be used by “staff from all disciplines” across the trust, as well as by external organisations that form part of the local NHS sustainability and transformation partnership.

“The data warehouse design must move to a fully modelled data warehouse, adopting industry standard methodologies, where data feeds are independent of the upper layers in the data warehouse and onward reporting, and can be plugged in or out as trust systems change and develop,” the trust added.

Bids for the project are open until midnight on Monday April 29, with a contract due to commence on 3 June. The trust has allocated a budget of up to £813,000 for the work.

 

 

Sam Trendall

Learn More →

Leave a Reply

Your email address will not be published. Required fields are marked *

Processing...
Thank you! Your subscription has been confirmed. You'll hear from us soon.
Newsletter Signup
Receive the top stories from the UK’s leading public sector digital and data publication direct to your inbox every lunchtime.
ErrorHere