1
|
Carvalho R, Lobo M, Oliveira M, Oliveira AR, Lopes F, Souza J, Ramalho A, Viana J, Alonso V, Caballero I, Santos JV, Freitas A. Analysis of root causes of problems affecting the quality of hospital administrative data: A systematic review and Ishikawa diagram. Int J Med Inform 2021; 156:104584. [PMID: 34634526 DOI: 10.1016/j.ijmedinf.2021.104584] [Citation(s) in RCA: 2] [Impact Index Per Article: 0.7] [Reference Citation Analysis] [Abstract] [Key Words] [Track Full Text] [Journal Information] [Subscribe] [Scholar Register] [Received: 04/16/2021] [Revised: 09/14/2021] [Accepted: 09/15/2021] [Indexed: 10/20/2022]
Abstract
INTRODUCTION Administrative hospital databases represent an important tool for hospital financing in many national health systems and are also an important data source for clinical, epidemiological and health services research. Therefore, the data quality of such databases is of utmost importance. This paper aims to present a systematic review of root causes of data quality problems affecting administrative hospital data, creating a catalogue of potential issues for data quality analysts to explore. METHODS The MEDLINE and Scopus databases were searched using inclusion criteria based on two following concept blocks: (1) administrative hospital databases and (2) data quality. Studies' titles and abstracts were screened by two reviewers independently. Three researchers independently selected the screened studies based on their full texts and then extracted the potential root causes inferred from them. These were subsequently classified according to the Ishikawa model based on 6 categories: "Personnel", "Material", "Method", "Machine", "Mission" and "Management". RESULTS The result of our investigation and the contribution of this paper is a classification of the potential (105) root causes found through a systematic review of the 77 relevant studies we have identified and analyzed. The result was represented by an Ishikawa diagram. Most of the root causes (25.7%) were associated with the category "Personnel" - people's knowledge, preferences, education and culture, mostly related to clinical coders and health care providers activities. The quality of hospital documentation, within category "Material", and aspects related to financial incentives or disincentives, within category "Mission", were also frequently cited in the literature as relevant root causes for data quality issues. CONCLUSIONS The resultant catalogue of root causes, systematized using the Ishikawa framework, provides a compilation of potential root causes of data quality issues to be considered prior to reusing these data and that can point to actions aimed at improving data quality.
Collapse
Affiliation(s)
- Roberto Carvalho
- MEDCIDS - Department of Community Medicine, Information and Health Decision Sciences, Faculty of Medicine, University of Porto, Portugal.
| | - Mariana Lobo
- MEDCIDS - Department of Community Medicine, Information and Health Decision Sciences, Faculty of Medicine, University of Porto, Portugal; CINTESIS - Centre for Health Technology and Services Research, Faculty of Medicine, University of Porto, Portugal.
| | - Mariana Oliveira
- MEDCIDS - Department of Community Medicine, Information and Health Decision Sciences, Faculty of Medicine, University of Porto, Portugal
| | - Ana Raquel Oliveira
- MEDCIDS - Department of Community Medicine, Information and Health Decision Sciences, Faculty of Medicine, University of Porto, Portugal
| | - Fernando Lopes
- MEDCIDS - Department of Community Medicine, Information and Health Decision Sciences, Faculty of Medicine, University of Porto, Portugal; CINTESIS - Centre for Health Technology and Services Research, Faculty of Medicine, University of Porto, Portugal.
| | - Júlio Souza
- MEDCIDS - Department of Community Medicine, Information and Health Decision Sciences, Faculty of Medicine, University of Porto, Portugal
| | - André Ramalho
- MEDCIDS - Department of Community Medicine, Information and Health Decision Sciences, Faculty of Medicine, University of Porto, Portugal; CINTESIS - Centre for Health Technology and Services Research, Faculty of Medicine, University of Porto, Portugal
| | - João Viana
- MEDCIDS - Department of Community Medicine, Information and Health Decision Sciences, Faculty of Medicine, University of Porto, Portugal; CINTESIS - Centre for Health Technology and Services Research, Faculty of Medicine, University of Porto, Portugal
| | - Vera Alonso
- CINTESIS - Centre for Health Technology and Services Research, Faculty of Medicine, University of Porto, Portugal
| | - Ismael Caballero
- Institute of Information Systems and Technologies (ITSI), University of Castilla-La Mancha, Ciudad Real, Castilla-La Mancha, Ciudad Real, Spain.
| | - João Vasco Santos
- MEDCIDS - Department of Community Medicine, Information and Health Decision Sciences, Faculty of Medicine, University of Porto, Portugal; CINTESIS - Centre for Health Technology and Services Research, Faculty of Medicine, University of Porto, Portugal; Public Health Unit, ACES Grande Porto VIII - Espinho/Gaia, ARS Norte, Portugal
| | - Alberto Freitas
- MEDCIDS - Department of Community Medicine, Information and Health Decision Sciences, Faculty of Medicine, University of Porto, Portugal; CINTESIS - Centre for Health Technology and Services Research, Faculty of Medicine, University of Porto, Portugal.
| |
Collapse
|
2
|
Ojeda-Thies C, Brent L, Currie CT, Costa M. Fragility Fracture Audit. ACTA ACUST UNITED AC 2020. [DOI: 10.1007/978-3-030-48126-1_19] [Citation(s) in RCA: 0] [Impact Index Per Article: 0] [Reference Citation Analysis] [Track Full Text] [Journal Information] [Subscribe] [Scholar Register] [Indexed: 03/05/2023]
|
3
|
Mahbubani K, Georgiades F, Goh EL, Chidambaram S, Sivakumaran P, Rawson T, Ray S, Hudovsky A, Gill D. Clinician-directed improvement in the accuracy of hospital clinical coding. Future Healthc J 2018; 5:47-51. [PMID: 31098532 PMCID: PMC6510043 DOI: 10.7861/futurehosp.5-1-47] [Citation(s) in RCA: 13] [Impact Index Per Article: 2.2] [Reference Citation Analysis] [Abstract] [Key Words] [Track Full Text] [Journal Information] [Subscribe] [Scholar Register] [Indexed: 11/27/2022]
Abstract
'Payment by results' (PbR) remuneration for healthcare services relies on the accurate conversion of diagnoses into Healthcare Resource Group (HRG) codes that are then reimbursed. Inconsistencies in documentation can result in inaccuracies in this process, with consequent implications for measuring activity, disease incidence and organisational performance. The aim of this study was to determine if clinician involvement increases accuracy in the coding of medical cases. Selected records of medical patients admitted to a London NHS trust between November and December 2016 were reviewed by a coding auditor and a clinician. Any changes to the codes and HRG tariff were noted. In total, 123 cases were considered. Changes in code were made on 68 instances, resulting in an overall increase in remuneration of £39,215; an average of £318 per patient. The primary HRG code was changed in 31 cases which accounted for £28,040 of the increase in tariff. In conclusion, clinician involvement can help with documentation ambiguities, thus improving the accuracy of the coding process in a medical setting. Although such collaborative working offers advantages for both the clinician and the coding team, further work is required to investigate the feasibility of this recommendation on a larger scale.
Collapse
|
4
|
Donati-Bourne JF, Bodalia R, Muthuveloe D, Inglis JA, Rukin NJ. Does a coding sticker for percutaneous nephrolithotomy improve clinical coding accuracy and increase financial remuneration? JOURNAL OF CLINICAL UROLOGY 2017. [DOI: 10.1177/2051415817715852] [Citation(s) in RCA: 0] [Impact Index Per Article: 0] [Reference Citation Analysis] [Abstract] [Track Full Text] [Journal Information] [Subscribe] [Scholar Register] [Indexed: 11/17/2022]
Abstract
Objective: This study aimed to evaluate whether a coding sticker for percutaneous nephrolithotomy (PCNL), completed by the surgeon after the operation note, improved the accuracy of clinical coding and the financial remuneration for PCNL. Patients and methods: A retrospective study was undertaken including all PCNLs performed in a single centre between October 2014 and June 2016. PCNL clinical coding was obtained and applied to yield a Healthcare Resource Group (HRG) code, which was in turn used to calculate the tariff the Trust received for the case. Remuneration and clinical coding accuracy were compared pre- and post-coding sticker introduction. Results: Thirty-three cases were included in the study. Eleven patients were reviewed before the introduction of the sticker and 22 after the introduction of the PCNL sticker. Overall mean clinical coding accuracy improved from 65% to 94% after the stickers’ introduction. This resulted in an overall mean increase in remuneration of £501 per case (from £2946 to £3447). Conclusion: The implementation of a simple coding sticker for completion after a PCNL improves clinical coding accuracy and increases the financial remuneration.
Collapse
Affiliation(s)
| | - R Bodalia
- Royal Wolverhampton Hospitals NHS Trust, UK
| | | | - JA Inglis
- Royal Wolverhampton Hospitals NHS Trust, UK
| | - NJ Rukin
- Redcliffe Hospital, Metro North Hospital and Health Service, Australia
| |
Collapse
|
5
|
Bedi N, Greenham OE, Inglis JA, Rukin NJ. Can an operative coding sticker improve coding accuracy and remuneration for upper tract stone-related procedures? JOURNAL OF CLINICAL UROLOGY 2017. [DOI: 10.1177/2051415817689977] [Citation(s) in RCA: 0] [Impact Index Per Article: 0] [Reference Citation Analysis] [Abstract] [Track Full Text] [Journal Information] [Subscribe] [Scholar Register] [Indexed: 11/17/2022]
Abstract
Objective: Rigid ureteroscopy, flexible uretero-renoscopy and ureteric stenting are commonly performed procedures. Operative clinical coding and remuneration varies depending on the procedure. We determined if loss of remuneration, through poor operative coding, could be improved with an operative coding sticker. Patients and methods: We performed a retrospective review of 133 random stone-related procedures (rigid ureteroscopy/flexible uretero-renoscopy and ureteric stenting). Using the Office of Population Censuses and Surveys codes, we compared actual operative coding and urological surgeon coding. We introduced an operative coding sticker and prospectively re-audited to determine if coding accuracy improved. Results: Flexible uretero-renoscopy was initially miscoded in 29 of 53 cases (55%), with a loss of remuneration of £1014 per case. Rigid ureteroscopies were correctly coded in 99% of cases, but ureteric stenting was only correctly coded in 82%. The introduction of the coding sticker resulted in improved coding accuracy rates of 100% for rigid ureteroscopy, 95% for flexible uretero-renoscopy and 100% for ureteric stenting. Overall, coding accuracy improved from 54% to 99%. We estimate this coding sticker will improve our departmental remuneration by £67,938 per year. Conclusion: Rigid ureteroscopy, flexible uretero-renoscopy and ureteric stenting were initially poorly coded. The introduction of a simple operative coding sticker improved coding compliance to 99% and increased operative remuneration.
Collapse
Affiliation(s)
- Nishant Bedi
- Department of Urological Surgery, Royal Wolverhampton Hospital NHS Trust, UK
| | - Olivia E Greenham
- Department of Urological Surgery, Royal Wolverhampton Hospital NHS Trust, UK
| | - John A Inglis
- Department of Urological Surgery, Royal Wolverhampton Hospital NHS Trust, UK
| | - Nicholas J Rukin
- Department of Urological Surgery, Royal Wolverhampton Hospital NHS Trust, UK
| |
Collapse
|
6
|
Cheema ZA, Khwaja SA. Implications of miscoding urological procedures in an era of financial austerity - 'Every Penny Counts'. JRSM Open 2015; 6:2054270415593463. [PMID: 26266039 PMCID: PMC4527370 DOI: 10.1177/2054270415593463] [Citation(s) in RCA: 6] [Impact Index Per Article: 0.7] [Reference Citation Analysis] [Abstract] [Key Words] [Track Full Text] [Download PDF] [Figures] [Journal Information] [Subscribe] [Scholar Register] [Indexed: 11/17/2022] Open
Abstract
Objectives The study aimed to find out any inaccuracy in coding of elective urology procedures and associated financial implications. Design Retrospective audit and re-audit. Settings Introduction of payment by results was introduced in the NHS in England in 2002. This meant that hospitals are paid on individual patient basis according to their human resource group (HRG) rather than a block contract. Current coding system uses office of population census and surveys classification. These along with other variables determine the final human resource group code defining final payment. Participants None. Main outcome measure Retrospective analysis of coding for all inpatient urological procedures was performed over a period of two months. All documented Office of Population Census and Surveys codes were recorded and reviewed by urology trainee along with the head of professional coders. As a result of first analysis the deficiencies were identified and revised Office of Population Census and Surveys codes were used to generate the final human resource group codes. After six months a re-audit was done. Results In the initial study, 121 cases were reviewed. Twenty per cent of these cases were miscoded. The revised Office of Population Census and Surveys codes led to change of final human resource group code and hence recovery of a payment of £10,716. Analysis after six months showed a considerable improvement with incorrect coding reduced to 11%. Conclusion Our findings highlight potential discrepancies in coding which can lead to significant financial loss. It is important that surgeons involve and train the coding department so that coding errors can be avoided. This will put us in better position to deal with Nicolson Challenge.
Collapse
Affiliation(s)
- Zubair A Cheema
- Department of Urology, Burton Hospitals NHS Foundation Trust, Burton upon Trent, Staffordshire, DE13 0RB, UK
| | - Sikandar A Khwaja
- Department of Urology, Burton Hospitals NHS Foundation Trust, Burton upon Trent, Staffordshire, DE13 0RB, UK
| |
Collapse
|
7
|
Faizi M, Farrier AJ, Venkatesan M, Thomas C, Uzoigwe CE, Balasubramanian S, Smith RP. Is body temperature an independent predictor of mortality in hip fracture patients? Injury 2014; 45:1942-5. [PMID: 25458058 DOI: 10.1016/j.injury.2014.09.024] [Citation(s) in RCA: 11] [Impact Index Per Article: 1.1] [Reference Citation Analysis] [Abstract] [MESH Headings] [Track Full Text] [Journal Information] [Submit a Manuscript] [Subscribe] [Scholar Register] [Received: 08/06/2014] [Revised: 09/22/2014] [Accepted: 09/27/2014] [Indexed: 02/02/2023]
Abstract
INTRODUCTION Admission body temperature is a critical parameter in all trauma patients. Low admission temperature is strongly associated with adverse outcomes. We have previously shown, in a prospective study that low admission body temperature is common and associated with high mortality in hip fracture patients (Uzoigwe et al., 2014). However, no previous studies have evaluated whether admission temperature is an independent predictor of mortality in hip fracture patients after adjustment for the 7 recognised independent prognostic indicators (Maxwell et al., 2008). METHODS We retrospectively collated data on all patients presenting to our institution between June 2011 and February 2013 with a hip fracture. This included patients involved in the original prospective study (Uzoigwe et al., 2014). Admission tympanic temperature, measured on initial presentation at triage, was recorded. The prognosticators of age, gender, source of admission, abbreviated mental test score, haemoglobin, co-morbid disease and the presence or absence of malignancy were also recorded. Using multiple logistic regression, adjustment was made for these potentially confounding prognostic indicators of 30-day mortality, to determine if admission low body temperature were independently linked to mortality. RESULTS 1066 patients were included. 781 patients, involved in the original prospective study (Uzoigwe et al., 2014), presented in the relevant time frame and were included in the retrospective study. The mean age was 81. There were 273 (26%) men and 793 (74%) women. 407 (38%) had low body temperature (<36.5 °C). Adjustment was made for age, gender, source of admission, abbreviated mental test score, haemoglobin, co-morbid disease and the presence or absence of malignancy. Those with low body temperature had an adjusted odds ratio of 30-day mortality that was 2.1 times that of the euthermic (36.5–37.5 °C). CONCLUSIONS Low body temperature is strongly and independently associated with 30-day mortality in hip fracture patients.
Collapse
|
8
|
Middleton RG, Uzoigwe CE, Young PS, Smith R, Gosal HS, Holt G. Peri-operative mortality after hemiarthroplasty for fracture of the hip: does cement make a difference? Bone Joint J 2014; 96-B:1185-91. [PMID: 25183588 DOI: 10.1302/0301-620x.96b9.33935] [Citation(s) in RCA: 39] [Impact Index Per Article: 3.9] [Reference Citation Analysis] [Abstract] [Key Words] [Track Full Text] [Journal Information] [Submit a Manuscript] [Subscribe] [Scholar Register] [Indexed: 11/05/2022]
Abstract
We aimed to determine whether cemented hemiarthroplasty is associated with a higher post-operative mortality and rate of re-operation when compared with uncemented hemiarthroplasty. Data on 19 669 patients, who were treated with a hemiarthroplasty following a fracture of the hip in a nine-year period from 2002 to 2011, were extracted from NHS Scotland's acute admission database (Scottish Morbidity Record, SMR01). We investigated the rate of mortality at day 0, 1, 7, 30, 120 and one-year post-operatively using 12 case-mix variables to determine the independent effect of the method of fixation. At day 0, those with a cemented hemiarthroplasty had a higher rate of mortality (p < 0.001) compared with those with an uncemented hemiarthroplasty, equivalent to one extra death per 424 procedures. By day one this had become one extra death per 338 procedures. Increasing age and the five-year co-morbidity score were noted as independent risk factors. By day seven, the cumulative rate of mortality was less for cemented hemiarthroplasty though this did not reach significance until day 120. The rate of re-operation was significantly higher for uncemented hemiarthroplasty. Despite adjusting for 12 confounding variables, these only accounted for 15% of the observed variability. The debate about the choice of the method of fixation for a hemiarthroplasty with respect to the rate of mortality or the risk of re-operation may be largely superfluous. Our results suggest that uncemented hemiarthroplasties may have a role to play in elderly patients with significant co-morbid disease.
Collapse
Affiliation(s)
- R G Middleton
- Royal Cornwall Hospital, Truro, Cornwall TR1 3LJ, UK
| | - C E Uzoigwe
- Leicester Royal Infirmary, Leicester, Leicestershire, LE1 5WW, UK
| | - P S Young
- Southern General Hospital, Glasgow, Lanarkshire G51 4TF, UK
| | - R Smith
- Scottish Hip Fracture Audit, Edinburgh EH12 9EB, UK
| | - H S Gosal
- Cheltenham General Hospital, Cheltenham, Gloucsestershire GL53 7AN, UK
| | - G Holt
- Crosshouse Hospital, Kilmarnock, East Ayrshire, KA2 0BE, UK
| |
Collapse
|
9
|
Racy M, Al-Nammari S, Hing CB. A survey of trauma database utilisation in England. Injury 2014; 45:624-8. [PMID: 24219900 DOI: 10.1016/j.injury.2013.10.020] [Citation(s) in RCA: 3] [Impact Index Per Article: 0.3] [Reference Citation Analysis] [Abstract] [Key Words] [Track Full Text] [Journal Information] [Submit a Manuscript] [Subscribe] [Scholar Register] [Received: 08/24/2013] [Revised: 10/01/2013] [Accepted: 10/11/2013] [Indexed: 02/02/2023]
Abstract
Trauma registries are used worldwide to coordinate patient care as well as provide data for audit and research purposes. National registries collect this data, producing research opportunities, outcome standards and a means by which to benchmark trauma centre performance. The Trauma Audit and Research Network (TARN) is the UK national registry, with data upload being mandatory from all major trauma centres (MTCs), a process which is manual and time and resource intensive. A telephone survey was carried out to collect data from all 26 MTCs in England. A questionnaire was designed to identify how data was collected at a local level, what software and methods were used and what resources were allocated to collect and upload trauma data to the TARN. Further information on hospital size and number of beds was collected from internet searches. Twenty-three MTCs were contacted in total. The majority used Microsoft Excel, with the next most common programme being Bluespier. Other commercially available registries used included Collector, VTOMS and McKesson. One trust created its own software and three used no electronic database at all. Electronic patient record integration was variable and limited to some commercially available registries. The mean number of TARN data collectors was two per centre, with a mean duration of data collection of 4.5 years. The wide range of software options and their lack of integration with the hospital electronic patient records results in the duplication of data as well as requiring time and resources. This may also be due to the difference in data required for coordinating on-going patient care and that required for upload to the TARN. Whilst some of these programmes do have the capabilities for automatic data upload, further efforts must be made to provide a cohesive system that provides the required integration and customisability in order to improve efficiency and ultimately trauma care.
Collapse
Affiliation(s)
- M Racy
- CT2 Orthopaedics, St George's Hospital, Tooting, UK.
| | - S Al-Nammari
- SpR Orthopaedics, St George's Hospital, Tooting, UK
| | - C B Hing
- St George's Hospital, Tooting, UK
| |
Collapse
|
10
|
Vu T, Davie G, Barson D, Day L, Finch CF. Accuracy of evidence-based criteria for identifying an incident hip fracture in the absence of the date of injury: a retrospective database study. BMJ Open 2013; 3:bmjopen-2013-003222. [PMID: 23869105 PMCID: PMC3717473 DOI: 10.1136/bmjopen-2013-003222] [Citation(s) in RCA: 10] [Impact Index Per Article: 0.9] [Reference Citation Analysis] [Abstract] [Key Words] [Track Full Text] [Download PDF] [Journal Information] [Submit a Manuscript] [Subscribe] [Scholar Register] [Indexed: 11/04/2022] Open
Abstract
OBJECTIVES Hospital discharge data (HDD) in many health systems do not capture the date of injury (DOI); the absence of this date hinders researchers' ability to distinguish repeat from incident injury admissions. Various approaches using somewhat arbitrary criteria have been explored to increase the accuracy of incident injury identification. However, these approaches have not been validated against a data source which contains DOI. The aim of this study was to determine the accuracy of evidence-based criteria for identifying fall-related incident hip fractures in the absence of DOI using HDD containing DOI as the reference standard. DESIGN Retrospective database study. SETTING New Zealand. PARTICIPANTS 8761 patients aged 65+ years admitted for fall-related hip fracture between 1 July 2005 and 30 June 2008, inclusive. OUTCOME MEASURES We defined person-identifying HDD containing DOI as the reference standard and calculated measures of the accuracy of evidence-based criteria for identifying fall-related incident hip fractures from HDD not containing DOI. The criteria were principal diagnosis of hip fracture, mechanism of injury indicating a fall, admission type emergency, admission source other than a transfer and presence of hip operation code(s). For a subsequent fall-related hip fracture, additional criteria were time between successive hip fractures ≥120 days, and all external cause-of-injury codes being different to those for the previous hip fracture. RESULTS The sensitivity and specificity of the criteria for identifying fall-related incident hip fractures from data not containing DOI were 96.7% and 99.3%, respectively, compared with the reference standard. The application of these criteria resulted in a slight underestimation of the percentage of patients with multiple hip fractures. CONCLUSIONS Although it is preferable to have DOI; this study demonstrates that evidence-based criteria can be used to reliably identify fall-related incident hip fractures from the person-identifying HDD when DOI is unavailable.
Collapse
Affiliation(s)
- Trang Vu
- Monash Injury Research Institute, Monash University, Melbourne, Victoria, Australia
| | - Gabrielle Davie
- Injury Prevention Research Unit, Department of Preventive and Social Medicine, University of Otago, Dunedin, New Zealand
| | - David Barson
- Injury Prevention Research Unit, Department of Preventive and Social Medicine, University of Otago, Dunedin, New Zealand
| | - Lesley Day
- Monash Injury Research Institute, Monash University, Melbourne, Victoria, Australia
| | - Caroline F Finch
- Monash Injury Research Institute, Monash University, Melbourne, Victoria, Australia
| |
Collapse
|
11
|
Impact of coding errors on departmental income: an audit of coding of microvascular free tissue transfer cases using OPCS-4 in UK. Br J Oral Maxillofac Surg 2012; 50:85-7. [DOI: 10.1016/j.bjoms.2011.01.005] [Citation(s) in RCA: 9] [Impact Index Per Article: 0.8] [Reference Citation Analysis] [Track Full Text] [Journal Information] [Subscribe] [Scholar Register] [Received: 11/26/2010] [Accepted: 01/10/2011] [Indexed: 11/18/2022]
|