SUSPbR Data Quality Anne Coulton SUS Data Improvement Team

1
SUS/PbRData QualityAnne CoultonSUS Data
Improvement Team
2
Data Quality - main themes

• Current position
• Processing issues
• Support on interchange processing
• Next steps

3
Data QualityBackground SUS data

• SUS comprises a copy of the McKesson NWCS
  database from 1997/8 - 2004/5 data (nearly 8
  years)
• It took three weeks to extract and populate SUS
  with the data
• As of 11 April 2005 all applicable interchanges
  submitted by Trusts are being picked up by
  McKesson (for NWCS) and BT (for SUS).
• SUS Interchange catch-up / load started in June
  2005

4
Data QualityBackground SUS data

• CDS Types
• Finished Consultant Episodes
• Unfinished Episodes
• Psychiatric Census
• Maternity tails
• Outpatients
• AE
• Elective Admission List

5
Data QualityCurrent Position

• Number of interchanges received for SUS
• For extract 1 7347(excludes zipped files)
• For extract 2 6894
• For extract 3 6170
• (Extract 1 11/04/2005 24/07/2005)
• (Extract 2 25/07/2005 28/10/2005)
• (Extract 3 29/10/2005 24/01/2006)

6
Data QualityCurrent Position

• Percentages of interchanges successfully passed
• For extract 1 99
• For extract 2 85
• For extract 3 67
• Percentages of interchanges still to process
  (10th March)
• Blocked Failed Other
• For extract 1 1 0.1 0
• For extract 2 6 0.4 9
• For extract 3 12 0.5 24

7
Data QualityProcessing Issues

• 32 different reasons for interchange failures
• Intervention and commissioning work to correct
  over 1000 failed interchanges (ongoing)
• The main issues are
• Recipient codes
• Outpatients (diagnosis codes)
• Dates
• EDIFACT

8
Data QualityProcessing Issues

• Zipped Files
• Intervention and agreement on the rejection of
  100s of failed interchanges which have
  subsequently been refreshed with resubmitted
  interchanges
• Non-standard CDS submissions identified
• Inconsistent CDS submission patterns identified

9
Data Quality Processing Issues

• Example of a Trusts problem with dates-
  Outpatients

10
Data Quality Processing Issues

• Example of a Trusts problem with dates- APC

11
Data QualitySupport with Interchange Progress

• Direct Communication with Trusts and Suppliers
  via
• Email
• Telephone
• Indirect Communication
• Web site (current)
• Guidance papers
• Helpdesk

12
Data QualityNext Steps

• Continued work with Trusts and Commissioners
• Commencing work with IQAP and LSPs
• Dedicated SUS Data Quality Web Pages
• Guidance papers, presentation and training
  materials, publications including SHA
  interchange status updates (from 10 March 2006),
  FAQs, links to other programmes (eg HES, ROCR,
  data standards), good practice examples,
  networks, contacts

13
Data QualityNext Steps

• The Development of the National Data Improvement
  Programme
• Remit covers Health and Social Care
• Work plan for improving data quality

14
Data QualityNext Steps

• SUS Programme
• SUS Project Board identified need for SUS Data
  Quality workstream
• Linda Shurlock identified to take lead
• DQ objectives embedded in HSCIC business plan
• Broad Scope Identified

15
Data QualityNext Steps

• Workshop
• Identified
• Requirement for top-level lead
• Content of work plan
• Denise Lievesley, HSCIC Chief Executive, to chair
  the Board

16
Data QualityNext Steps

• Key Characteristics
• Priorities
• Quick Wins
• Opportunities
• Joining Up

17
Data QualityNext Steps

• Structure
• Board
• Support and Delivery Group
• Supporters and Contacts
• Existing Networks

18
Data QualityNext Steps

• Immediate tasks
• CCMDS
• Diagnoses codes in Outpatient CDS
• Reference values
• Health and Social Care National Data Improvement
  Board

19
Feedback please
enquiries_at_ic.nhs.uk