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

Written by Sam Trendall on 18 April 2019 in News
News

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.

 

 

About the author

Sam Trendall is editor of PublicTechnology

Share this page

Tags

Categories

CONTRIBUTIONS FROM READERS

Please login to post a comment or register for a free account.

Related Articles

Related Sponsored Articles

Digital Transformation: Connecting and protecting with perfect predictability
10 September 2019

How can you stay ahead in the fast-paced world of digital technology? BT describes how it's a matter of focus... 

How to stay ahead of a changing threat landscape
3 September 2019

The security threat landscape is confusing and changing rapidly – there’s so much out there, how do you understand where the true risks are? BT offers insight from their own experience

The cyber security skills challenge: Hiring for tomorrow
27 August 2019

Organisations must alter their approach to cyber security recruitment in order to combat the global shortage of security professionals, writes BT 

Augmented Intelligence: digital transformation with humans in the loop
20 August 2019

BT reviews an event looking at how man and machine are working together to drive digital transformation