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

One in six government service assessments ends in failure
4 May 2020

PublicTechnology research finds that failing to consider user needs is the most common stumbling block, with a lack of simplicity and intuitiveness also a frequent failing

‘We need your data’ – how the ONS is mobilising the power of information in the fight against coronavirus
20 May 2020

As the UK enters its ninth week of lockdown, interim deputy national statistician Frankie Kay calls for organisations to bring their data together to address the nation’s challenges

Scotland begins trials of contact-tracing platform
19 May 2020

NHS Scotland is testing its contact-tracing program ahead of a nationwide rollout due later this month

What next for GOV.UK Verify?
15 May 2020

The identity-assurance tool is being used more than ever just as its future grows more uncertain. PublicTechnology examines what might happen to the service in the longer term

Related Sponsored Articles