No data management company has more experience with the Cerner Millennium product than Avoca. As the data migration partner for Fujitsu and BT we helped them implement the system at complex acute organisations (see below). The challenge of migrating business and patient critical data to Millennium should not be undertaken lightly. The cleaning and transforming required to make legacy PAS data compliant with Millennium can be very complex and if not managed properly will lead to many unplanned trial loads, multiple slipped go live dates, and additional cost.

Aligned to this challenge is the massive disruption and re-design of reporting methods. Avoca, as either the data migration supplier for the project or providing consultancy support, have experience in providing solutions to the reporting problems and supporting the re-design.

The sections below show our experience of projects moving to the Cerner system and Cerner report validation. From this experience, combined with our extensive healthcare knowledge, Avoca are very well placed to support any ICT project involving Cerner Millennium:

Cerner Migration Projects
The projects below which are now live with Millennium all used the Avoca Migration Service to produce the upload files needed by Millennium.

• Milton Keynes Hospital NHS Foundation Trust
• Newcastle Foundation Trust
• Barnet and Chase Farm NHS Trust
• Winchester and Eastleigh Healthcare NHS Trust
• Surrey and Sussex Healthcare NHS Trust
• Queen Mary’s Hospital, Sidcup
• Weston General Hospital

 

Cerner Support Projects
The projects below are where we provided expert consultancy to the implementation team. Tasks included data mappings, data collection worksheets preparation, pre-load validation, creating load reports, managing global and local code sets, on-site floor walking, CDS validation and reconciliation, reporting compliance status report and preparing reporting gap analysis reports.

• North Bristol NHS Trust
• Royal Free Hampstead NHS Trust
• Southampton University Hospitals NHS Trust
• Medway NHS Trust
• Gloucestershire Hospitals NHS Foundation Trust
• Barts and the London NHS Trust
• Imperial College Healthcare NHS Trust
• Royal Free Hampstead NHS Trust
• St.George's NHS Foundation Trust

Mark gives his views on DCWs in Cerner projects

 

Report Validation
A key challenge in Cerner projects has been ensuring the continuity of business reporting. Avoca have hands on experience and know the importance of accurate validation of your reports. We work with you and Cerner members of staff to identify and resolve issues, analysing and testing data and writing bespoke reports.

 

Mark gives some reporting tips.

 

Our experience of Cerner report validation includes:  

Extract Objectives
Adhoc, statutory and user report validation and reconciliation	Reconciling and investigating errors between legacy PAS and warehouse adhoc, statutory and user report.
CDS validation and reconciliation	Reconciling and investigating errors between legacy PAS and Cerner Millennium CDS extracts.
Report production	Creating complex reports through querying legacy data against specified criteria to produce reports for manual data entry. For example, to ensure that 18 week clock stop and starts were producing correct 18 week wait times.
Error investigation and manual delta file production to rectify known issues	Investigation and resolution of trust queries (pre and post go live).
Clinic build validation	Using the legacy PAS to validate target system build and identify errors for correction.
Post go live upload file creation	Post go live upload files created and thoroughly tested to resolve manual cut over data entry back log.
Liaison with trust administrative and management staff (and 3rd party suppliers) Warehouse feeds	Working with trust staff to identify and resolve migration errors and trends and reporting progress to management staff. IM200 and Cerner CDS extract feeds to the Data Warehouse