Skip to main content
Top
Published in: BMC Medical Informatics and Decision Making 1/2013

Open Access 01-12-2013 | Research article

Developing model-based algorithms to identify screening colonoscopies using administrative health databases

Authors: Maida J Sewitch, Mengzhu Jiang, Lawrence Joseph, Robert J Hilsden, Alain Bitton

Published in: BMC Medical Informatics and Decision Making | Issue 1/2013

Login to get access

Abstract

Background

Algorithms to identify screening colonoscopies in administrative databases would be useful for monitoring colorectal cancer (CRC) screening uptake, tracking health resource utilization, and quality assurance. Previously developed algorithms based on expert opinion were insufficiently accurate. The purpose of this study was to develop and evaluate the accuracy of model-based algorithms to identify screening colonoscopies in health administrative databases.

Methods

Patients aged 50-75 were recruited from endoscopy units in Montreal, Quebec, and Calgary, Alberta. Physician billing records and hospitalization data were obtained for each patient from the provincial administrative health databases. Indication for colonoscopy was derived using Bayesian latent class analysis informed by endoscopist and patient questionnaire responses. Two modeling methods were used to fit the data, multivariate logistic regression and recursive partitioning. The accuracies of these models were assessed.

Results

689 patients from Montreal and 541 from Calgary participated (January to March 2007). The latent class model identified 554 screening exams. Multivariate logistic regression predictions yielded an area under the curve of 0.786. Recursive partitioning using the latent outcome had sensitivity and specificity of 84.5% (95% CI: 81.5-87.5) and 63.3% (95% CI: 59.7-67.0), respectively.

Conclusions

Model-based algorithms using administrative data failed to identify screening colonoscopies with sufficient accuracy. Nevertheless, the approach of constructing a latent reference standard against which model-based algorithms were evaluated may be useful for validating administrative data in other contexts where there lacks a gold standard.
Appendix
Available only for authorised users
Literature
2.
go back to reference Lee DS, Donovan L, Austin PC, Gong Y, Liu PP, Rouleau JL, Tu JV: Comparison of coding of heart failure and comorbidities in administrative and clinical data for use in outcomes research. Med Care. 2005, 43 (2): 182-188. 10.1097/00005650-200502000-00012.CrossRefPubMed Lee DS, Donovan L, Austin PC, Gong Y, Liu PP, Rouleau JL, Tu JV: Comparison of coding of heart failure and comorbidities in administrative and clinical data for use in outcomes research. Med Care. 2005, 43 (2): 182-188. 10.1097/00005650-200502000-00012.CrossRefPubMed
3.
go back to reference Januel JM, Luthi JC, Quan H, Borst F, Taffe P, Ghali WA, Burnand B: Improved accuracy of co-morbidity coding over time after the introduction of ICD-10 administrative data. BMC Health Serv Res. 2011, 11: 194-10.1186/1472-6963-11-194.CrossRefPubMedPubMedCentral Januel JM, Luthi JC, Quan H, Borst F, Taffe P, Ghali WA, Burnand B: Improved accuracy of co-morbidity coding over time after the introduction of ICD-10 administrative data. BMC Health Serv Res. 2011, 11: 194-10.1186/1472-6963-11-194.CrossRefPubMedPubMedCentral
4.
go back to reference Wilchesky M, Tamblyn RM, Huang A: Validation of diagnostic codes within medical services claims. J Clin Epidemiol. 2004, 57 (2): 131-141. 10.1016/S0895-4356(03)00246-4.CrossRefPubMed Wilchesky M, Tamblyn RM, Huang A: Validation of diagnostic codes within medical services claims. J Clin Epidemiol. 2004, 57 (2): 131-141. 10.1016/S0895-4356(03)00246-4.CrossRefPubMed
5.
go back to reference Randolph WM, Mahnken JD, Goodwin JS, Freeman JL: Using Medicare data to estimate the prevalence of breast cancer screening in older women: comparison of different methods to identify screening mammograms. Health Serv Res. 2002, 37 (6): 1643-1657. 10.1111/1475-6773.10912.CrossRefPubMedPubMedCentral Randolph WM, Mahnken JD, Goodwin JS, Freeman JL: Using Medicare data to estimate the prevalence of breast cancer screening in older women: comparison of different methods to identify screening mammograms. Health Serv Res. 2002, 37 (6): 1643-1657. 10.1111/1475-6773.10912.CrossRefPubMedPubMedCentral
6.
go back to reference Gregory KD, Korst LM, Gornbein JA, Platt LD: Using administrative data to identify indications for elective primary cesarean delivery. Health Serv Res. 2002, 37 (5): 1387-1401. 10.1111/1475-6773.10762.CrossRefPubMedPubMedCentral Gregory KD, Korst LM, Gornbein JA, Platt LD: Using administrative data to identify indications for elective primary cesarean delivery. Health Serv Res. 2002, 37 (5): 1387-1401. 10.1111/1475-6773.10762.CrossRefPubMedPubMedCentral
7.
go back to reference Fisher DA, Grubber JM, Castor JM, Coffman CJ: Ascertainment of colonoscopy indication using administrative data. Dig Dis Sci. 2010, 55 (6): 1721-1725. 10.1007/s10620-010-1200-y.CrossRefPubMed Fisher DA, Grubber JM, Castor JM, Coffman CJ: Ascertainment of colonoscopy indication using administrative data. Dig Dis Sci. 2010, 55 (6): 1721-1725. 10.1007/s10620-010-1200-y.CrossRefPubMed
8.
go back to reference Myers RP, Shaheen AA, Fong A, Wan AF, Swain MG, Hilsden RJ, Sutherland L, Quan H: Validation of coding algorithms for the identification of patients with primary biliary cirrhosis using administrative data. Can J Gastroenterol. 2010, 24 (3): 175-182.CrossRefPubMedPubMedCentral Myers RP, Shaheen AA, Fong A, Wan AF, Swain MG, Hilsden RJ, Sutherland L, Quan H: Validation of coding algorithms for the identification of patients with primary biliary cirrhosis using administrative data. Can J Gastroenterol. 2010, 24 (3): 175-182.CrossRefPubMedPubMedCentral
9.
go back to reference Benchimol EI, Guttmann A, Griffiths AM, Rabeneck L, Mack DR, Brill H, Howard J, Guan J, To T: Increasing incidence of paediatric inflammatory bowel disease in Ontario, Canada: evidence from health administrative data. Gut. 2009, 58 (11): 1490-1497. 10.1136/gut.2009.188383.CrossRefPubMed Benchimol EI, Guttmann A, Griffiths AM, Rabeneck L, Mack DR, Brill H, Howard J, Guan J, To T: Increasing incidence of paediatric inflammatory bowel disease in Ontario, Canada: evidence from health administrative data. Gut. 2009, 58 (11): 1490-1497. 10.1136/gut.2009.188383.CrossRefPubMed
10.
go back to reference Richardson P, Henderson L, Davila JA, Kramer JR, Fitton CP, Chen GJ, El-Serag HB: Surveillance for hepatocellular carcinoma: development and validation of an algorithm to classify tests in administrative and laboratory data. Dig Dis Sci. 2010, 55 (11): 3241-3251. 10.1007/s10620-010-1387-y.CrossRefPubMed Richardson P, Henderson L, Davila JA, Kramer JR, Fitton CP, Chen GJ, El-Serag HB: Surveillance for hepatocellular carcinoma: development and validation of an algorithm to classify tests in administrative and laboratory data. Dig Dis Sci. 2010, 55 (11): 3241-3251. 10.1007/s10620-010-1387-y.CrossRefPubMed
11.
go back to reference Korst LM, Gregory KD, Gornbein JA: Elective primary caesarean delivery: accuracy of administrative data. Paediatric perinatal epidemiol. 2004, 18 (2): 112-119. 10.1111/j.1365-3016.2003.00540.x.CrossRef Korst LM, Gregory KD, Gornbein JA: Elective primary caesarean delivery: accuracy of administrative data. Paediatric perinatal epidemiol. 2004, 18 (2): 112-119. 10.1111/j.1365-3016.2003.00540.x.CrossRef
12.
go back to reference El-Serag HB, Petersen L, Hampel H, Richardson P, Cooper G: The use of screening colonoscopy for patients cared for by the Department of Veterans Affairs. Arch Intern Med. 2006, 166 (20): 2202-2208. 10.1001/archinte.166.20.2202.CrossRefPubMed El-Serag HB, Petersen L, Hampel H, Richardson P, Cooper G: The use of screening colonoscopy for patients cared for by the Department of Veterans Affairs. Arch Intern Med. 2006, 166 (20): 2202-2208. 10.1001/archinte.166.20.2202.CrossRefPubMed
13.
go back to reference Haque R, Chiu V, Mehta KR, Geiger AM: An automated data algorithm to distinguish screening and diagnostic colorectal cancer endoscopy exams. J Nat Cancer Inst Mono. 2005, 35: 116-118.CrossRef Haque R, Chiu V, Mehta KR, Geiger AM: An automated data algorithm to distinguish screening and diagnostic colorectal cancer endoscopy exams. J Nat Cancer Inst Mono. 2005, 35: 116-118.CrossRef
14.
go back to reference Leddin D, Bridges RJ, Morgan DG, Fallone C, Render C, Plourde V, Gray J, Switzer C, McHattie J, Singh H: Survey of access to gastroenterology in Canada: the SAGE wait times program. Can J Gastroenterol. 2010, 24 (1): 20-25.CrossRefPubMedPubMedCentral Leddin D, Bridges RJ, Morgan DG, Fallone C, Render C, Plourde V, Gray J, Switzer C, McHattie J, Singh H: Survey of access to gastroenterology in Canada: the SAGE wait times program. Can J Gastroenterol. 2010, 24 (1): 20-25.CrossRefPubMedPubMedCentral
15.
go back to reference Levin B, Lieberman DA, McFarland B, Smith RA, Brooks D, Andrews KS, Dash C, Giardiello FM, Glick S, Levin TR: Screening and surveillance for the early detection of colorectal cancer and adenomatous polyps, 2008: a joint guideline from the American Cancer Society, the US Multi-Society Task Force on Colorectal Cancer, and the American College of Radiology. CA Cancer J Clin. 2008, 58 (3): 130-160. 10.3322/CA.2007.0018.CrossRefPubMed Levin B, Lieberman DA, McFarland B, Smith RA, Brooks D, Andrews KS, Dash C, Giardiello FM, Glick S, Levin TR: Screening and surveillance for the early detection of colorectal cancer and adenomatous polyps, 2008: a joint guideline from the American Cancer Society, the US Multi-Society Task Force on Colorectal Cancer, and the American College of Radiology. CA Cancer J Clin. 2008, 58 (3): 130-160. 10.3322/CA.2007.0018.CrossRefPubMed
16.
go back to reference Rex DK, Johnson DA, Anderson JC, Schoenfeld PS, Burke CA, Inadomi JM: American College of Gastroenterology guidelines for colorectal cancer screening 2009 [corrected]. Am J Gastroenterol. 2009, 104 (3): 739-750. 10.1038/ajg.2009.104.CrossRefPubMed Rex DK, Johnson DA, Anderson JC, Schoenfeld PS, Burke CA, Inadomi JM: American College of Gastroenterology guidelines for colorectal cancer screening 2009 [corrected]. Am J Gastroenterol. 2009, 104 (3): 739-750. 10.1038/ajg.2009.104.CrossRefPubMed
17.
go back to reference Segnan N, Patnick J, von Karsa L: European guidelines for quality assurance in colorectal cancer screening and diagnosis. 2010, Luxembourg: Publications Office of the European Union Segnan N, Patnick J, von Karsa L: European guidelines for quality assurance in colorectal cancer screening and diagnosis. 2010, Luxembourg: Publications Office of the European Union
18.
go back to reference Leddin DJ, Enns R, Hilsden R, Plourde V, Rabeneck L, Sadowski DC, Signh H: Canadian Association of Gastroenterology position statement on screening individuals at average risk for developing colorectal cancer: 2010. Can J Gastroenterol. 2010, 24 (12): 705-714.CrossRefPubMedPubMedCentral Leddin DJ, Enns R, Hilsden R, Plourde V, Rabeneck L, Sadowski DC, Signh H: Canadian Association of Gastroenterology position statement on screening individuals at average risk for developing colorectal cancer: 2010. Can J Gastroenterol. 2010, 24 (12): 705-714.CrossRefPubMedPubMedCentral
20.
go back to reference Harewood GC, Lieberman DA: Colonoscopy practice patterns since introduction of medicare coverage for average-risk screening. Clin Gastroenterol Hepatol. 2004, 2 (1): 72-77. 10.1016/S1542-3565(03)00294-5.CrossRefPubMed Harewood GC, Lieberman DA: Colonoscopy practice patterns since introduction of medicare coverage for average-risk screening. Clin Gastroenterol Hepatol. 2004, 2 (1): 72-77. 10.1016/S1542-3565(03)00294-5.CrossRefPubMed
21.
go back to reference White A, Vernon SW, Franzini L, Du XL: Racial and ethnic disparities in colorectal cancer screening persisted despite expansion of Medicare's screening reimbursement. Cancer Epidem Biomar. 2011, 20 (5): 811-817. 10.1158/1055-9965.EPI-09-0963.CrossRef White A, Vernon SW, Franzini L, Du XL: Racial and ethnic disparities in colorectal cancer screening persisted despite expansion of Medicare's screening reimbursement. Cancer Epidem Biomar. 2011, 20 (5): 811-817. 10.1158/1055-9965.EPI-09-0963.CrossRef
22.
go back to reference Rex DK, Petrini JL, Baron TH, Chak A, Cohen J, Deal SE, Hoffman B, Jacobson BC, Mergener K, Petersen BT: Quality indicators for colonoscopy. Am J Gastroenterol. 2006, 101 (4): 873-885.CrossRefPubMed Rex DK, Petrini JL, Baron TH, Chak A, Cohen J, Deal SE, Hoffman B, Jacobson BC, Mergener K, Petersen BT: Quality indicators for colonoscopy. Am J Gastroenterol. 2006, 101 (4): 873-885.CrossRefPubMed
23.
go back to reference Baxter NN, Goldwasser MA, Paszat LF, Saskin R, Urbach DR, Rabeneck L: Association of colonoscopy and death from colorectal cancer. Ann Intern Med. 2009, 150 (1): 1-8. 10.7326/0003-4819-150-1-200901060-00306.CrossRefPubMed Baxter NN, Goldwasser MA, Paszat LF, Saskin R, Urbach DR, Rabeneck L: Association of colonoscopy and death from colorectal cancer. Ann Intern Med. 2009, 150 (1): 1-8. 10.7326/0003-4819-150-1-200901060-00306.CrossRefPubMed
24.
go back to reference Fletcher RH, Nadel MR, Allen JI, Dominitz JA, Faigel DO, Johnson DA, Lane DS, Lieberman D, Pope JB, Potter MB: The quality of colonoscopy services–responsibilities of referring clinicians: a consensus statement of the Quality Assurance Task Group, National Colorectal Cancer Roundtable. J Gen Intern Med. 2010, 25 (11): 1230-1234. 10.1007/s11606-010-1446-2.CrossRefPubMedPubMedCentral Fletcher RH, Nadel MR, Allen JI, Dominitz JA, Faigel DO, Johnson DA, Lane DS, Lieberman D, Pope JB, Potter MB: The quality of colonoscopy services–responsibilities of referring clinicians: a consensus statement of the Quality Assurance Task Group, National Colorectal Cancer Roundtable. J Gen Intern Med. 2010, 25 (11): 1230-1234. 10.1007/s11606-010-1446-2.CrossRefPubMedPubMedCentral
25.
go back to reference Rex DK, Bond JH, Winawer S, Levin TR, Burt RW, Johnson DA, Kirk LM, Litlin S, Lieberman DA, Waye JD: Quality in the technical performance of colonoscopy and the continuous quality improvement process for colonoscopy: recommendations of the U.S. Multi-Society Task Force on Colorectal Cancer. Am J Gastroenterol. 2002, 97 (6): 1296-1308. 10.1111/j.1572-0241.2002.05812.x.CrossRefPubMed Rex DK, Bond JH, Winawer S, Levin TR, Burt RW, Johnson DA, Kirk LM, Litlin S, Lieberman DA, Waye JD: Quality in the technical performance of colonoscopy and the continuous quality improvement process for colonoscopy: recommendations of the U.S. Multi-Society Task Force on Colorectal Cancer. Am J Gastroenterol. 2002, 97 (6): 1296-1308. 10.1111/j.1572-0241.2002.05812.x.CrossRefPubMed
26.
go back to reference Lieberman D: Pitfalls of using administrative data for research. Dig Dis Sci. 2010, 55 (6): 1506-1508. 10.1007/s10620-010-1246-x.CrossRefPubMed Lieberman D: Pitfalls of using administrative data for research. Dig Dis Sci. 2010, 55 (6): 1506-1508. 10.1007/s10620-010-1246-x.CrossRefPubMed
27.
go back to reference Sewitch MJ, Stein D, Joseph L, Bitton A, Hilsden RJ, Rabeneck L, Paszat L, Tinmouth J, Cooper MA: Comparing patient and endoscopist perceptions of the colonoscopy indication. Can J Gastroenterol. 2010, 24 (11): 656-660.CrossRefPubMedPubMedCentral Sewitch MJ, Stein D, Joseph L, Bitton A, Hilsden RJ, Rabeneck L, Paszat L, Tinmouth J, Cooper MA: Comparing patient and endoscopist perceptions of the colonoscopy indication. Can J Gastroenterol. 2010, 24 (11): 656-660.CrossRefPubMedPubMedCentral
28.
go back to reference Joseph L, Gyorkos TW, Coupal L: Bayesian estimation of disease prevalence and the parameters of diagnostic tests in the absence of a gold standard. Am J Epidemiol. 1995, 141 (3): 263-272.PubMed Joseph L, Gyorkos TW, Coupal L: Bayesian estimation of disease prevalence and the parameters of diagnostic tests in the absence of a gold standard. Am J Epidemiol. 1995, 141 (3): 263-272.PubMed
29.
go back to reference Dendukuri N, Joseph L: Bayesian approaches to modeling the conditional dependence between multiple diagnostic tests. Biometrics. 2001, 57 (1): 158-167. 10.1111/j.0006-341X.2001.00158.x.CrossRefPubMed Dendukuri N, Joseph L: Bayesian approaches to modeling the conditional dependence between multiple diagnostic tests. Biometrics. 2001, 57 (1): 158-167. 10.1111/j.0006-341X.2001.00158.x.CrossRefPubMed
30.
go back to reference Kass RE, Raftery AE: Bayes Factors. J Am Stat Assoc. 1995, 90: 773-795. 10.1080/01621459.1995.10476572.CrossRef Kass RE, Raftery AE: Bayes Factors. J Am Stat Assoc. 1995, 90: 773-795. 10.1080/01621459.1995.10476572.CrossRef
31.
go back to reference Hanley JA, McNeil BJ: The meaning and use of the area under a receiver operating characteristic (ROC) curve. Radiology. 1982, 143 (1): 29-36.CrossRefPubMed Hanley JA, McNeil BJ: The meaning and use of the area under a receiver operating characteristic (ROC) curve. Radiology. 1982, 143 (1): 29-36.CrossRefPubMed
32.
go back to reference R Development Core Team: R: A language and environment for statistical computing. 2005, Vienna, Austria: R Foundation for Statistical Computing R Development Core Team: R: A language and environment for statistical computing. 2005, Vienna, Austria: R Foundation for Statistical Computing
33.
go back to reference Breiman L, Friedman JH, Olshen RA, Stone CJ: Classification and Regression Trees. 1984, Belmont CA: Wadsworth International Group Breiman L, Friedman JH, Olshen RA, Stone CJ: Classification and Regression Trees. 1984, Belmont CA: Wadsworth International Group
34.
go back to reference Strobl C, Malley J, Tutz G: An introduction to recursive partitioning: rationale, application, and characteristics of classification and regression trees, bagging, and random forests. Psychol Methods. 2009, 14 (4): 323-348.CrossRefPubMedPubMedCentral Strobl C, Malley J, Tutz G: An introduction to recursive partitioning: rationale, application, and characteristics of classification and regression trees, bagging, and random forests. Psychol Methods. 2009, 14 (4): 323-348.CrossRefPubMedPubMedCentral
35.
go back to reference Sewitch MJ, Hilsden R, Joseph L, Rabeneck L, Paszat L, Bitton A, Cooper M-A: Qualitative study of physician perspectives on classifying screening and non-screening colonoscopy using administrative health data: adding practice does not make perfect. Can J Gastroenterol. 2012, 26: 889-893.CrossRefPubMedPubMedCentral Sewitch MJ, Hilsden R, Joseph L, Rabeneck L, Paszat L, Bitton A, Cooper M-A: Qualitative study of physician perspectives on classifying screening and non-screening colonoscopy using administrative health data: adding practice does not make perfect. Can J Gastroenterol. 2012, 26: 889-893.CrossRefPubMedPubMedCentral
36.
go back to reference Bernstein CN, Blanchard JF, Rawsthorne P, Wajda A: Epidemiology of Crohn's disease and ulcerative colitis in a central Canadian province: a population-based study. Am J Epidemiol. 1999, 149 (10): 916-924. 10.1093/oxfordjournals.aje.a009735.CrossRefPubMed Bernstein CN, Blanchard JF, Rawsthorne P, Wajda A: Epidemiology of Crohn's disease and ulcerative colitis in a central Canadian province: a population-based study. Am J Epidemiol. 1999, 149 (10): 916-924. 10.1093/oxfordjournals.aje.a009735.CrossRefPubMed
Metadata
Title
Developing model-based algorithms to identify screening colonoscopies using administrative health databases
Authors
Maida J Sewitch
Mengzhu Jiang
Lawrence Joseph
Robert J Hilsden
Alain Bitton
Publication date
01-12-2013
Publisher
BioMed Central
Published in
BMC Medical Informatics and Decision Making / Issue 1/2013
Electronic ISSN: 1472-6947
DOI
https://doi.org/10.1186/1472-6947-13-45

Other articles of this Issue 1/2013

BMC Medical Informatics and Decision Making 1/2013 Go to the issue