Developing an algorithm to identify people with Chronic Obstructive Pulmonary Disease (COPD) using administrative data
BMC Medical Informatics and Decision Making volume 12, Article number: 38 (2012)
An important prerequisite for the Chronic Care Model is to be able to identify, in a valid, simple and inexpensive way, the population with a chronic condition that needs proactive and planned care. We investigated if a set of administrative data could be used to identify patients with Chronic Obstructive Pulmonary Disease in a Danish population.
Seven general practices were asked to identify patients with known Chronic Obstructive Pulmonary Disease in their practices. For the 266 patients (population A), we used administrative data on hospital admissions for lung-related diagnoses, redeemed prescriptions for lung-diseases drugs and lung- function tests combined to develop an algorithm that identified the highest proportion of patients with Chronic Obstructive Pulmonary Disease with the fewest criteria involved. We tested nine different algorithms combining two to four criteria. The simplest algorithm with highest positive predictive value identified 532 patients (population B); with possible diagnosis of Chronic Obstructive Pulmonary Disease in five general practices. The doctors were asked to confirm the diagnosis. The same algorithm identified 2,895 patients whom were asked to confirm their diagnosis (population C).
In population A the chosen algorithm had a positive predictive value of 72.2 % and three criteria: a) discharged patients with a chronic lung-disease diagnosis at least once during the preceding 5 years; or b) redeemed prescription of lung-medication at least twice during the preceding 12 months; or c) at least two spirometries performed at different dates during the preceding 12 months. In population B the positive predictive value was 65.0 % [60.8;69.1 %] and the sensitivity 44.8 % [41.3;48.4 %)] when the “uncertain” were added to where doctors agreed with the diagnosis. For the 1,984 respondents in population C, the positive predictive value was 72.9 % [70.8;74.8 %] and the sensitivity 29.7 % [28.4;31.0 %].
An algorithm based on administrative data has been developed and validated with sufficient positive predictive value to be used as a tool for identifying patients with Chronic Obstructive Pulmonary Disease. Some of the identified patients had other chronic lung-diseases (asthma). The algorithm should mostly be regarded as a tool for identifying chronic lung-disease and further development of the algorithm is needed.
The group of people living with non-communicable diseases (NCD) or chronic conditions is growing as life-expectancy increases, treatment options improve, inappropriate lifestyle spreads, and the diagnostic activity grows. Thus, we need initiatives to devise an efficient healthcare strategy . To offer a professional and effective treatment, the care needs to be well structured and integrated within the healthsystem [2, 3]. One model which frames comprehensive care is the Chronic Care Model . Identifying patients already treated in the healthsystem seems beneficial for planning their care and might diminish the number of emergency contacts they have with the healthsystem. The model requires that the population with the chronic conditions and the initial stages of disease is identified ; this prerequisites a comprehensive, timely and valid registration in all parts of a healthcare system.
In a Dutch study, Steuten et al. found that self-reported medication compliance, physical activity, disease specific knowledge, non-smoking behaviour, patient satisfaction and health related quality of life increased in populations with chronic disease when implementing a disease management program focusing on patient education, protocolised assessment and treatment of COPD, and care coordination. They also found improvement in health utility .
Chronic Obstructive Pulmonary Disease (COPD) is an under-diagnosed, irreversible and potentially life-threatening condition where secondary prevention, treatment and rehabilitation can help control the symptoms, increase the patient’s quality of life and delay disease progression . Newly published results indicate that of 3 million people at 35 years or older, 430,000 (14.3 %) live with COPD  in Denmark; and of these approximately 120,000 (4.0 %) have been diagnosed . One very important prerequisite for implementing high impact disease management programs is being able to identify the target population . In Denmark, patients in hospitals are coded according to the International Classification of Diagnosis (ICD-10) which also identifies patients with chronic conditions. However, most people with chronic diseases are seen in primary care, and in Denmark a systematic coding of diagnoses has not yet been fully established in general practice. Consequently, we need to develop additional models for identification based on administrative data Therefore, the aim of this study is to develop and test a method for identification of patients living with COPD in a Danish population based on administrative data.
The use of healthcare services is free at the point of use in Denmark, and the healthcare system is financed by taxes. The approximately 3,600 general practitioners (GPs) have an average of 1500 patients on their list as 98 % of the population is registered with a GP. The GPs are gatekeepers in terms of access to the rest of the healthcare system; a referral from the GP is mandatory except for emergency admission. All GPs use electronic medical records which mean that each patient’s record is electronically searchable and all communication in and out of practice is electronically based.
Overall study design
The algorithm was developed in three steps and in three different GP and patient populations. First, one group of GPs were asked to identify a list of their patients with a known diagnosis of COPD -population A . Based on administrative data, the simplest algorithm which identified as many of these as possible was developed. Then patients with COPD were sampled according to the algorithm and GPs in other practices were asked to verify the diagnosis from their records -population B. Finally, another group of sampled patients were asked to verify whether they had COPD or not - population C.
All citizens living in Denmark are registered with a unique personal identification number called a CPR-number. Linking of all national registries with the CPR-number is therefore possible at the individual level . Data about inhabitants’ use of general practice was obtained from the Danish National Health Insurance Service Registry (see Additional file 1 for healthcare use data) . From the Regional Prescription Registry which contains information on all dispensed prescriptions (ATC-codes) in the Central Denmark Region (see Appendix 1 for ATC-codes used)  data on sampled inhabitants’ use of prescribed medication was collected. Out-patient visits, emergency-room visits, hospital admissions and discharges were collected from the Patient Administrative System (PAS) based on ICP-10 codes (see Additional file 1 for diagnosis).
Seven practices with 26 GPs in the county of Aarhus accepted to identify all patients in their practice with a known diagnosis of COPD. For these patients - population A, register data was collected based on their CPR-number on in- and outpatient attendance five years back, redeemed prescriptions during the preceding 12 months, and the number of spirometries performed at GPs and specialists during the preceding 12 months (See Additional file 2). Different combinations were then set up and tested for performance in identifying the patients with COPD identified by the GPs. The algorithm with the highest positive predictive value (PPV), and which was also the simplest, was regarded as being most appropriate. Thus, each algorithm was tested for the ability to identify the patients identified with COPD measured by PPV with 95 % confidence intervals (95%CI). A total of nine relevant algorithms were evaluated (See Additional file 3).
The chosen algorithm was used to identify patients with possible COPD in five different practices with a total of 17 GPs in the Central Denmark Region - population B. The GPs were asked to confirm or repudiate the diagnosis of COPD or state “unsure”. The GPs were asked to refer to the GOLD guidelines where the diagnosis of COPD is confirmed by means of post-bronchodilator spirometry which shows a forced expiratory volume in one second (FEV1)/forced vital capacity (FVC) < 70 %. The algorithm identified patients who had been in contact with different parts of the healthcare system for lung-related complaints; consequently the category “unsure” was added to the confirmed verified diagnosis of COPD.
Patients sampled by means of the algorithm were asked to verify their diagnosis. As part of a large randomised study, a questionnaire was sent to patients identified by the algorithm in the Ringkoebing-Skjern and Ikast-Brande municipalities - population C. These patients were asked to confirm or repudiate their potential COPD diagnosis. Non-responders were sent a reminder after three weeks.
For all algorithms, sensitivity, specificity as well as positive and negative predictive values was calculated, and for the final algorithm, it was calculated for age groups too. Hansen et al. found a 9 % overall prevalence for COPD in the population aged 45–85 and this was used as the prevalence measure in order to identify patients with COPD already being treated in the healthcare system. Based on the prevalence, age specific PPV was calculated . For patients aged 35–44, the prevalence for the 45–54 year olds was used and for patients aged 85 and above the prevalence for patients aged 75–84 years was used.
In connection with patient validation, responders and non-responders were compared in terms of gender, age and the criteria used in the algorithm using two sample t-test. The distribution of gender within the two groups was tested by Pearson's chi-squared test and Fischer’s exact test was used for the comparison of the criteria used to identify the patients. Analyses were performed using STATA version 11.0. (StataCorp, College Station, Texas).
The study was approved by the Danish Data Protection Agency (J.nr. 2008-41-2855), the Danish National Board of Health (J. NR.: 7-604-04-2/71/EHE) and the RCT indexed at http://www.clinicaltrials.gov (NCT01228708).
The GPs identified 266 patients in their practices with COPD - population A. Of the algorithms tested on these patients, the simplest algorithm with the highest PPV contained three criteria and a PPV of 72.2 %. The nine best performing algorithms can be seen in Additional file 3.
GP verification - population B
The second group of GPs verified that 244 (45.9 %) of the algorithm identified patients had COPD. For 102 (19.1 %) patients, the GPs were not sure of the diagnoses (Figure 1). Thus, the PPV for a possible or definite COPD was 64.8 % and the sensitivity vas 44.8 [95%CI: 41.3-48.4] and the specificity 97.7 % [95 % CI: 97.3-98.0] (Se Additional file 4). The 10-year age span specific PPVs varied from 30-97 % (Figure 2).
Patient verification - population C
A total of 1,984 (68.5 %) patients identified by the algorithm and eligible for inclusion in the study returned the questionnaire (Figure 3). The sensitivity was 29.7 % [95 % CI: 28.4-31.0] and the specificity 98.9 % [95 % CI: 98.8-99.0] and the overall PPV was 72.8 % [95%CI: 70.8 %;74.8 %] with a prevalence of COPD of 9 % in the Danish population (See Additional file 5). The 10-year age span specific PPVs ranged from 41.8-81.8 % (Figure 4).
No statistically significant difference was found between responders and non-responders regarding gender (p = 0.061) where 54.8 % of responders and 53.7 % of non-responders were women. On averages, responders were 4.5 years older than non-responders, 65.6 (SD 12.6) years and 61.1 (SD 14.8) respectively, (p < 0.001). Of the identified patients, 80.2 % were found using one criterion - 78.5 % in the responders and 81.9 % in the non-responders group. More responders (121 (6.1 %)) than non-responders (36 (3.9 %)) were identified by their use of medication and having had a spirometry performed. All three criteria in the algorithm identified three (0.3 %) of the non-responders and 27 (1.4 %) of the responders, (p = 0.005).
Developing an algorithm for COPD combining data from the GP, administrative data and verifying the performance of this algorithm among GPs and patients, showed that an algorithm using three variables derived from register data could identify between 30 % and 97 % depending on age of the COPD population. The relatively low PPV for younger groups might be explained by the inclusion of many patients with asthma.
The chosen algorithm identified close to three quarters of patients with COPD in the population aged 35 years and up in population B and C. If we look at the population aged 55 years and up the identification rate increased. Age was therefore an important variable that could be considered in the algorithm as well.
Strengths and weaknesses
We developed the algorithm from registry data on hospital and prescription data which have been shown to be highly valid [16–19]. When testing the algorithm with patients in population C, the percentages verifying their diagnosis were higher than testing it with GPs in population B.
We have a selection bias as there is a higher likelihood of responding when one is identified by three criteria instead of two or one. This leads us to believe that more patients in population C with an already verified diagnosis have answered the survey. The older the age group, the less the difference was in the PPV between the patients' verification of their diagnosis in population C and the GPs' verification in population B. The responders in population C were representative for the population identified by the algorithm in terms of gender.
A very high specificity of the algorithm is one of its strengths. It ensures that people who have been hospitalized with a lung-related diagnosis, been prescribed lung-related medication or had a spirometry test for other diagnoses will not unnecessarily be suspected of having COPD.
When asking the initial 26 GPs to identify the patients with COPD in their practice - population A, the GOLD guidelines for COPD was not specified . This could both mean that less and that more patients could have been identified, probably more, considering the fact that it has been suggested that the overall prevalence of people with COPD is 14.2 %.This number includes a sizeable portion of people with mild COPD who would not have come in contact with the healthcare system regarding their lung-disease. Thus; we might regard the patients identified by the algorithm as being the sickest patients.We decided to use the overall prevalence of 9 % as suggested by Hansen et al. They standardized to the Danish population based on their study of a stratified sample of 4,757 people out of 299,000 Danes aged 45–84 years. The 14.3 % prevalence suggested by Loekke et al. only applied to people aged 35 and above and was calculated on the basis of a study of a much smaller sample. We therefore found it relevant to use the prevalence from the study by Hansen et al. in our study.
We chose to consider the ‘unsure’ answers as a positive diagnoses as the patients in population B had been identified by at least one of the criteria and therefore had been in contact with the healthcare system due to a lung-related issue. In addition, the GPs could not reject the diagnosis. An information bias is that not all the ‘unsure’ answers from GPs might be positive answers to a COPD diagnosis, but could be identifying another lung-related disease in population B. We could consider that the algorithm identifies patients with a lung-related disease and not only patients with COPD.
If we want to further develop the algorithm to only identify patients with COPD, we could include more variables, e.g. the International Classification of Primary Care (ICPC-2) codes, the use of which will become compulsory in general practice in Denmark before 2013. We could decide to use the algorithm in its present form for people aged 55 or older as it has the best properties in this group.
Comparisons with other studies
Different studies have used data from different sources to identify people who have or might have COPD. In the United States, a study developed an algorithm for identifying people at risk of having unidentified COPD from healthcare utilization data and found it to be a useful screening tool. Another American study found that pharmacy utilization efficiently identified persons at risk of undiagnosed COPD . A Canadian study used health administrative data to identify cohorts of patients with asthma with the purpose of monitoring the population and for healthcare research . They found that their algorithm would be enhanced if hospital data was added to the GPs' data. These studies support our approach in this study of being able to identify patients with COPD from administrative data in order to enhance the proactive care and have an identified population for research and quality improvement purposes.
A Danish study suggests that COPD is under-recorded when patients have been admitted with a different acute lung-related diagnosis . This emphasises the need to use the diagnosis for all lung-related diseases when identifying patients.
An English study found that when general practice had identified a high-risk COPD population from their own data, a trend towards reduction of hospital admissions and inpatient days was found compared to the situation where the COPD population was not identified . This could be investigated further in a Danish setting by using the algorithm to identify a Danish population.
As COPD is one of the chronic conditions, the Danish health system wishes to identify, monitor and enhance the rehabilitation for , a targeted system that efficiently identifies patients with COPD is attractive from the perspective of secondary prevention which serves to identify and treat people with preclinical disease and those who have developed the disease. Organized efforts aimed at identification for proactive care of the patients with COPD are especially important as the health gains are better the earlier the patient is diagnosed, and the long-term prognosis of COPD may improve with early intervention [26, 27].
We have developed an algorithm based on administrative data and we have tested it with both GPs and patients. The algorithm is found to have sufficient PPV to be used as a screening tool in the identification of patients with COPD in a general population in Denmark, especially among the group of elderly. This algorithm can be useful for the health system both to identify the patients who will benefit from proactive care and those who need integrated care for this progressive and irreversible illness.
Chronic Obstructive Pulmonary Disease
International Classification of Disease - version 10
International Classification of Primary Care - version 2
Negative Predictive Value
Patient Administrative System
Positive Predictive Value
Wagner EH, Austin BT, Davis C, Hindmarsh M, Schaefer J, Bonomi A: Improving chronic illness care: translating evidence into action. Health Aff (Millwood). 2001, 20: 64-78. 10.1377/hlthaff.20.6.64.
Nolte E, Knai C, McKee M: Managing Chronic Conditions - experience in eight countries. World Health Organization, on behalf of the European Observatory on Health Systems and Policies. 2008
Groves T, Wagner EH: High quality care for people with chronic diseases. BMJ. 2005, 330: 609-610. 10.1136/bmj.330.7492.609.
Bodenheimer T, Wagner EH, Grumbach K: Improving primary care for patients with chronic illness. JAMA. 2002, 288: 1775-1779. 10.1001/jama.288.14.1775.
Wagner EH: Chronic disease management: what will it take to improve care for chronic illness?. Eff Clin Pract. 1998, 1: 2-4.
Steuten L, Vrijhoef B: van MF, Wesseling GJ, Spreeuwenberg C: Evaluation of a regional disease management programme for patients with asthma or chronic obstructive pulmonary disease. Int J Qual Health Care. 2006, 18: 429-436. 10.1093/intqhc/mzl052.
National Board of Health, Denmark: Disease Management Programs for Chronic Disease -Generic Model and Model for diabetes. 2008, National Board of Health, In Danish
Løkke A, Lange P, Scharling H, Fabricius P, Vestbo J: Developing COPD: a 25 year follow up study of the general population. Thorax. 2006, 61: 935-9. 10.1136/thx.2006.062802.
Hansen JG: The prevalence of Chronic Obstructive Pulmonary Disease. Ugeskr Laeger. 2009, 171: 2986-8. In Danish
Ham C: Learning from Kaiser Permanente, a progress report. 2003, Department of Health, London
Pedersen CB: The Danish Civil Registration System. Scand J Public Health. 2011, 39: 22-25. 10.1177/1403494810387965.
Sahl Andersen J, de Fine Olivarius N, Krasnik A: The Danish National Health Service Register. Scand J Public Health. 2011, 39: 34-37. 10.1177/1403494810394718.
Wallach Kildemoes H, Sorensen HT, Hallas J: The Danish National Prescription Registry. Scand J Public Health. 2011, 39: 38-41. 10.1177/1403494810394717.
Pauwels RA, Buist AS, Ma P, Jenkins CR, Hurd SS: Global strategy for the diagnosis, management, and prevention of chronic obstructive pulmonary disease: National Heart, Lung, and Blood Institute and World Health Organization Global Initiative for Chronic Obstructive Lung Disease (GOLD): executive summary. Respir Care. 2001, 46: 798-825.
Hansen JG, Pedersen L, Overvad K, Omland O, Jensen HK, Sorensen HT: Prevalence of chronic obstructive pulmonary disease–secondary publication. Ugeskr Laeger. 2009, 171: 2986-2988.
Sorensen HT: SFEE: Research in the Danish health service system: completeness and validity of prescription data, illustrated by analysis of utilization of oral anticoagulants. Int J Risk Saf Med. 1995, 7: 41-14.
Hallas J: Drug utilization statistics for individual-level pharmacy dispensing data. Pharmacoepidemiol Drug Saf. 2005, 14: 455-463. 10.1002/pds.1063.
Wogelius P, Poulsen S, Sorensen HT: Validity of parental-reported questionnaire data on Danish children's use of asthma-drugs: a comparison with a population-based prescription database. Eur J Epidemiol. 2005, 20: 17-22. 10.1007/s10654-004-1501-6.
Moth G, Vedsted P, Schiotz P: Identification of asthmatic children using prescription data and diagnosis. Eur J Clin Pharmacol. 2007, 63: 605-611. 10.1007/s00228-007-0286-4.
Rabe KF, Hurd S, Anzueto A, Barnes PJ, Buist SA, Calverley P, Fukuchi Y, Jenkins C, Rodriguez-Roisin R: van WC, Zielinski J: Global strategy for the diagnosis, management, and prevention of chronic obstructive pulmonary disease: GOLD executive summary. Am J Respir Crit Care Med. 2007, 176: 532-555. 10.1164/rccm.200703-456SO.
Mapel DW, Petersen H, Roberts MH, Hurley JS, Frost FJ, Marton JP: Can outpatient pharmacy data identify persons with undiagnosed COPD?. Am J Manag Care. 2010, 16: 505-512.
To T, Dell S, Dick PT, Cicutto L, Harris JK, MacLusky IB, Tassoudji M: Case verification of children with asthma in Ontario. Pediatr Allergy Immunol. 2006, 17: 69-76. 10.1111/j.1399-3038.2005.00346.x.
Thomsen RW, Lange P, Hellquist B, Frausing E, Bartels PD, Krog BR, Hansen AM, Buck D, Bunk AE: Validity and underrecording of diagnosis of COPD in the Danish National Patient Registry. Respir Med. 2011, 105: 1063-1068. 10.1016/j.rmed.2011.01.012.
Gruffydd-Jones K, Richman J, Jones RC, Wang X: A pilot study of identification and case management of high-risk COPD patients in a general practice. Fam Pract. 2010, 27: 494-498. 10.1093/fampra/cmq045.
National Board of Health: COPD- Chronic Obstructive Pulmonary Disease: Recommendations for tracking, following, treating and rehabilitate. 2007, 2-In Danish
Doherty DE, Chapman KR, Martinez FJ, Belfer MH: The value of early diagnosis for effective management of chronic obstructive pulmonary disease. J Fam Pract. 2007, 56: S1-24.
Pauwels RA, Rabe KF: Burden and clinical features of chronic obstructive pulmonary disease (COPD). Lancet. 2004, 364: 613-620. 10.1016/S0140-6736(04)16855-4.
The pre-publication history for this paper can be accessed here:http://www.biomedcentral.com/1472-6947/12/38/prepub
The study was carried out at the Research Unit for General Practice in Aarhus and further funded by Ringkoebing-Skjern Municipality, the Central Denmark Region and the Medical Research Fund at Aarhus University, Denmark. We would like to thank the patients and GPs for their contribution. Johannes Traberg Christiansen and Jens Jørgen Jeppesen, Central Denmark Region and Kaare Rud Flarup, Research Centre for Cancer Diagnosis in Primary Care most helpfully provided data from registries. We thank Dr. Jens Rubak for his help selecting GP practices and Dr. Jens Georg Hansen who generously shared background data from his study.
The authors declare that they have no competing interests.
PV conceived the study idea, participated in its design and in developing the algorithm and he helped to draft the manuscript. IS participated in the study design and in developing the algorithm and performed the statistical analyses. LK carried out data collection related to the GPs' verification of the algorithm. MS coordinated the study, carried out the questionnaire survey, participated in the study design and drafted the manuscript. All authors have read and approved the final manuscript.
Electronic supplementary material
Additional file 3: Patient identified with COPD using different algorithms for population A. An inclusion prerequisite was to be aged 35 or above and alive at the time of identification in the registries. (PDF 83 KB)
Additional file 4: The characteristics of algorithm-identified patients for whom the GP were asked to verify the COPD diagnosis - population B. The prevalence of COPD suggested by Hansen et al.(16)was used. (PDF 83 KB)
Additional file 5: The characteristics of algorithm-identified patients whom were asked to verify their COPD diagnosis - population C. The patients were divided into ten year age groups. Data from Statistics Denmark were used for the population in 2007. The prevalence of COPD suggested by Hansen et al.(16)was used. (PDF 75 KB)
About this article
Cite this article
Smidth, M., Sokolowski, I., Kærsvang, L. et al. Developing an algorithm to identify people with Chronic Obstructive Pulmonary Disease (COPD) using administrative data. BMC Med Inform Decis Mak 12, 38 (2012). https://doi.org/10.1186/1472-6947-12-38