Duplicate patient records on Choose and Book, 200 "major incidents", and NPfIT secrecy

A team of people is working to stop medical information going missing after a software upgrade under the NHS’s IT Programme led to hundreds of unwanted, incorrect and duplicate patient records being created every day.

The problem involves NHS sites in Greater Manchester and raises questions about how well some systems are being tested before going live as part the £12.4bn National Programme for IT [NPfIT].

Internal documents show that the duplicate patient records are incorrect. They have been created on the assumption that patients do not already have a record – even if they do. If these duplicates are left in place it could lead to clinicians seeing patients without access to important medical history.

To stop this happening, patent records have to merged with the duplicates quickly. If a backlog of unmerged records builds, hospital record libraries could send to clinics, days in advance of an appointment, the wrong patient file based on the duplicate record – which could be that of an entirely new patient.


The internal documents also warn that the merging of duplicates with the main record will create significant additional work, and could cause confusion later.

This is because the merged record may have to be unscrambled later so that the different identification details and numbers – which are retained when the duplicates and main record are brought together – do not confuse patient administration systems.

The problem has arisen after a software upgrade, Maintenance Release 1 of the iPM patient administration system supplied by NPfIT local service provider CSC and its subcontractor iSoft.

The upgrade over the weekend of 21/22 April 2007 led to up to 400 duplicate records being created each day for patients who had hospital appointments arranged as part of the NPfIT Choose and Book system.

The incident comes at a time when some staff at one of the hospitals affected, University Hospital South Manchester Foundation Trust, are already having to cope with a long list of Choose and Book work-arounds – manual or semi-manual ways of avoiding software bugs or problems waiting to be fixed in iPM or Choose and Book.

Computer Weekly has received other internal documents that show the incident in Greater Manchester is not isolated. There have been about 200 “major incidents” at hospitals across England in the four months to the end of January 2007.

Dozens are in the highest “severity one” classification and some of these incidents have affected NHS sites across England. Failures include PACS digital x-ray equipment and radiology information systems.

Connecting for Health refuses to publish details of major incidents but says the number is decreasing.

Last month Lord Hunt, the health minister, dismissed a report of the Public Accounts Committee that was highly critical of the NPfIT. Lord Hunt said the committee’s report was based on one published by the National Audit Office that was “out of date”.

But the incidents mentioned in the internal documents happened after the report of the National Audit Office in June 2006.

The Health Committee of the House of Commons began its inquiry into aspects of the NPfIT on 26 April 2007 but its narrow terms of reference exclude looking into the threats to healthcare of troubled NPfIT go-lives.

In a joint statement Connecting for Health and CSC said:

“A scheduled upgrade to the latest version of the iPM Patient Administration System was undertaken for all organisations in Greater Manchester using the iPM system solution during the weekend of 21st/22nd April. This includes University Hospital South Manchester Foundation Trust and PCT Clinical Assessment Centres who all currently make extensive use of the Choose and Book system to refer patients to clinical assessment services and outpatient clinics.

“This was the latest in an ongoing programme of upgrades successfully introduced by CSC since the beginning of April. Although comprehensive testing is undertaken prior to the upgrades taking place, it is not unusual for these kinds of upgrades to identify teething problems in the early stages following implementation.

“In this particular upgrade a problem has subsequently occurred with the integration of this Patient Administration System and the Choose and Book system for users in Greater Manchester, which has led to some duplicate patient records being created. We estimate that around 400 duplicate patient records might have been created each day. However, the system is being continually monitored throughout each day and where a duplicate is identified data is being merged to form one single record for each patient.

“To put this in context, in an average day across Greater Manchester, the CSC Alliance processes 15 transactions per second which equates to 1,296,000 transactions across all Patient Administration Systems per day in Greater Manchester. There are over 3.5 million patients in Greater Manchester.

“Local Service Provider (LSP) CSC has identified the root cause of the problem and is developing a permanent fix. The fix will be applied to all users in Greater Manchester who received the recent upgrade as soon as it is available in the next 2-3 weeks. Prior to the application of the permanent fix, an interim solution has been put in place to identify the duplicate records and correct them. This has now been put in place with the full agreement of those organisations affected and will have minimal impact on the users of the system and no impact on the delivery of patient care.”

Related articles:

1) National press follows up Computer Weekly’s article on National Programme for IT incidents

2) Duplicate patient records in Manchester – the risks and how it happened

3) Is government trying to control information on problems after NPfIT go- lives?

4) Some examples of “Major Incidents“.

5) Connecting for Health attacks NHS users over reporting of major incidents

Join the conversation

4 comments

Send me notifications when other members comment.

Please create a username to comment.

We are in the business of identifying and correcting duplicate records created and stored in databases. We have helped Lewisham NHS Hospital trust overcome their problem of duplicate creation... Case study...

The organisation

The Lewisham Hospital NHS Trust comprises University Hospital Lewisham, The Children's Hospital Lewisham and Dunoran Home (a residential nursing home in Bromley). The Trust manages approximately 650 beds and currently employs around 2,500 staff.

The data quality challenge

The south-east London hospitals were seen as having problems with fragmented patient records, particularly the difficulty of identifying whether a record existed for a newly-admitted patient.

When patients were admitted to hospital, they were not always correctly identified as having an existing medical record, often due to a change of name or address; sometimes the patient's state of health made it difficult to get accurate details and sometimes it is simply a case of a clerical error in not finding the patient on the system. New records were then opened for them and their previous history lost to their clinical team.

With approximately 150 'new patient' registrations each day to be compared against the 930,000 existing records in the Lewisham Hospital NHS Trust database, the search for duplicate records was a time-consuming manual task, taking more than half a day. At one stage there was a six month backlog.

As Terry Walton, IT Manager at Lewisham Hospital, points out, "This is not just about meeting government targets and overcoming fragmented patient records. There is a clinical risk if a newly-admitted patient is not identified as having an existing record with us."

Having clean, high integrity patient data is also an essential requirement for connecting to the Connecting for Health Local Service provider.

In his quest to achieve a single patient view, Terry applied for funding from Connecting for Health. He organised a joint procurement for the Lewisham Hospital NHS Trust, Kings College Hospital NHS Trust and the South London and Maudesley NHS Trust.

The solution

After considering three possible vendors, Terry and his team chose DQ Global's Match as being the best value for money and providing the greatest east of use. Match works directly with the database to link disparate data sources and identify and process duplicates for a fast and accurate single patient view

The results

Using Match, searching for new patient records in the database takes about 10 minutes. Every day, around 10-15 records are identified where the patient has an existing medical record at the hospital. That's over 4,000 patient records a year that are correctly merged with their previous medical record, maintaining integrity of the patient's record and ensuring they receive the appropriate treatment. Match has also been used to check the entire database of 930,000 records for the duplicates which were being created before checking started three years ago. In less than one hour, Match identified 16,000 duplicates which have now been corrected.

The efficiencies gained through using Match ensure that Lewisham and the other south-east London hospitals are fully on top of their patient records.

Using Match, searching for new patient records in the database takes about 10 minutes. Every day, around 10-15 records are identified where the patient has an existing medical record at the hospital. That's over 4,000 patient records a year that are correctly merged with their previous medical record, maintaining integrity of the patient's record and ensuring they receive the appropriate treatment. Match has also been used to check the entire database of 930,000 records for the duplicates which were being created before checking started three years ago. In less than one hour, Match identified 16,000 duplicates which have now been corrected.

The efficiencies gained through using Match ensure that Lewisham and the other south-east London hospitals are fully on top of their patient records.

Bottom line, we have the technology to solve these problems but frankly don't know who to talk to. We looking forward to hearing from CSC, iSoft, Connecting For Health or Lord Hunt.

Martin Doyle (CEO) DQ Global 01329 227505

Cancel
A solution to the NHS duplicate problem!

Having helped Lewisham NHS Hospital trust overcome their problem of duplicate creation, I belive DQ Global - who are in the business of identifying and correcting duplicate records created and stored in databases - can solve the problem... Case study...

The organisation

The Lewisham Hospital NHS Trust comprises University Hospital Lewisham, The Children's Hospital Lewisham and Dunoran Home (a residential nursing home in Bromley). The Trust manages approximately 650 beds and currently employs around 2,500 staff.

The data quality challenge

The south-east London hospitals were seen as having problems with fragmented patient records, particularly the difficulty of identifying whether a record existed for a newly-admitted patient.

When patients were admitted to hospital, they were not always correctly identified as having an existing medical record, often due to a change of name or address; sometimes the patient's state of health made it difficult to get accurate details and sometimes it is simply a case of a clerical error in not finding the patient on the system. New records were then opened for them and their previous history lost to their clinical team.

With approximately 150 'new patient' registrations each day to be compared against the 930,000 existing records in the Lewisham Hospital NHS Trust database, the search for duplicate records was a time-consuming manual task, taking more than half a day. At one stage there was a six month backlog.

The former IT Manager at Lewisham Hospital, pointed out, "This is not just about meeting government targets and overcoming fragmented patient records. There is a clinical risk if a newly-admitted patient is not identified as having an existing record with us."

Having clean, high integrity patient data is also an essential requirement for connecting to the Connecting for Health Local Service provider.

In his quest to achieve a single patient view, he applied for funding from Connecting for Health. He organised a joint procurement for the Lewisham Hospital NHS Trust, Kings College Hospital NHS Trust and the South London and Maudesley NHS Trust.

The solution

After considering three possible vendors, the selection team chose DQ Global's Match as being the best value for money and providing the greatest east of use. Match works directly with the database to link disparate data sources and identify and process duplicates for a fast and accurate single patient view

The results

Using Match, searching for new patient records in the database takes about 10 minutes. Every day, around 10-15 records are identified where the patient has an existing medical record at the hospital. That's over 4,000 patient records a year that are correctly merged with their previous medical record, maintaining integrity of the patient's record and ensuring they receive the appropriate treatment. Match has also been used to check the entire database of 930,000 records for the duplicates which were being created before checking started three years ago. In less than one hour, Match identified 16,000 duplicates which have now been corrected.

The efficiencies gained through using Match ensure that Lewisham and the other south-east London hospitals are fully on top of their patient records.

Using Match, searching for new patient records in the database takes about 10 minutes. Every day, around 10-15 records are identified where the patient has an existing medical record at the hospital. That's over 4,000 patient records a year that are correctly merged with their previous medical record, maintaining integrity of the patient's record and ensuring they receive the appropriate treatment. Match has also been used to check the entire database of 930,000 records for the duplicates which were being created before checking started three years ago. In less than one hour, Match identified 16,000 duplicates which have now been corrected.

The efficiencies gained through using Match ensure that Lewisham and the other south-east London hospitals are fully on top of their patient records.

Bottom line, we have the technology to solve these problems but frankly don't know who to talk to. We looking forward to hearing from CSC, iSoft, Connecting For Health or Lord Hunt.

Martin Doyle (CEO) DQ Global 01329 227505

Cancel
I have great worries over the security of electronic patient records, especially the PACS system.

My partner died very suddenly in a hospital in Shropshire this year and I requested a copy of an X-ray that he had taken on the day he died. The x-ray that I have been provided with is of a different patient. I know this because I have a comparative one that he had taken at a different hospital last year. Someone has obviously altered the image and I find this appalling. How can the NHS say that the new system is safe and secure?

Cancel
what happened to Dunoran home?

Why did it get shut down?

Cancel

-ADS BY GOOGLE

SearchCIO

SearchSecurity

SearchNetworking

SearchDataCenter

SearchDataManagement

Close