Health Services

We provide a range of services to the Healthcare Market in both private and public NHS sectors - such as assistance in the National Program, data warehousing and system integration

Health Services Case Study

St Georges NHS Trust Case Study data warehouse

Customer

St Georges NHS Trust is based in Tooting, South London. St Georges recently went live with the NHS Connecting for Health PAS Solution (Cerner Millennium). St Georges has over 6,000 staff, 1,000 bed capacity, covering a Surrey and Sussex population of around 3.5 million people.

Customer Situation

As part of the PAS deployment, the trust also installed a new information data warehouse solution, provided by CACI. As part of the integration between the new Millennium PAS and the CACI data warehouse, the Trust needed assistance in data cleansing, set-up of standing reporting data, data testing and production of Business Intelligence reporting using Business Objects, for the production of reports including CDS and 18 week extracts.

Solution Provided

We provided consultation on-site services including database administration of the newly installed CACI Data Warehouse. We provided testing of the feeds provided from Millennium, integration and file distribution systems, testing of feeds into the data warehouse for quality control, as well as general data warehouse administration services.

Benefits of Service

The new data warehouse allowed the Trust to move away from reliance on distributed MS-Access databases, into a single SQL Server database with standardised Business Objects reports and the ability to produce custom reports based on hospital user requests. Processes developed and introduced by Touchstone provided automation of the database feeds, alerts on problems (incorrect files, data, check sums etc) and NHS standard extracts for mandatory and regulatory reporting.

Methods Utilised

Working with the Trust IT department, processes were designed and developed using the Trusts preferred technology. Microsoft SSIS packages were developed and documented, as well as Visual studio control systems. Technologies were selected to allow easy handover to existing Trust IT staff.

External Factors

As part of such a large PAS deployment, cooperation was required from BT, Connecting for Health and CACI. Touchstone worked as a go-between for all three organisations bringing them together whenever issues arose for rapid resolution as required.

Contact touchstone Systems about our NHS data warehouse consultancy services