Skip to main content
Top
Published in: BMC Medical Research Methodology 1/2017

Open Access 01-12-2017 | Research article

The impact of the lookback period and definition of confirmatory events on the identification of incident cancer cases in administrative data

Authors: Jonas Czwikla, Kathrin Jobski, Tania Schink

Published in: BMC Medical Research Methodology | Issue 1/2017

Login to get access

Abstract

Background

This cohort study examined the impact of the lengths of lookback and confirmation periods as well as the definition of confirmatory events on the number of incident cancer cases identified and age-standardized cumulative incidences (ACI) estimated in administrative data using German cancer registry data as a benchmark.

Methods

ACI per 100,000 insured persons for breast, prostate and colorectal cancer were estimated using BARMER Statutory Health Insurance claims data. Incident cancer cases were defined as having an in- or outpatient diagnosis in 2013, no diagnosis in a lookback period of 1 year and a second diagnosis (or death) in a confirmation period of 1 quarter. We varied lookback periods from 1 to 7 years, confirmation periods from 1 to 4 quarters as well as the definition of confirmatory events and compared ACI estimates to cancer registry data.

Results

ACI were higher for breast (138.7) and prostate (103.6) but lower for colorectal cancer (42.1) when compared to cancer registries (119.3, 98.0 and 45.5, respectively). Extending the lookback period to 7 years reduced ACI to 129.0, 95.1 and 38.3. An extended confirmation period of 4 quarters increased ACI to 151.3, 114.9 and 46.8. Including breast and colorectal surgeries as a confirmatory event reduced ACI to 114.9 and 37.1, respectively.

Conclusions

The choice of lookback and confirmation periods and the definition of confirmatory events have considerable impact on the number of incident cancer cases identified and ACI estimated. Researchers need to be aware of potential misclassification when identifying incident cancer cases in administrative data. Further validation studies as well as studies using administrative data to estimate cancer incidences should consider several choices of the lookback and confirmation periods and the definition of confirmatory events to show how these parameters impact the validity and robustness of their results.
Appendix
Available only for authorised users
Literature
1.
go back to reference Stewart B, Wild C, editors. World Cancer Report 2014. International Agency for Research on Cancer, WHO: Lyon; 2014. Stewart B, Wild C, editors. World Cancer Report 2014. International Agency for Research on Cancer, WHO: Lyon; 2014.
2.
go back to reference Mahnken JD, Keighley JD, Girod DA, Chen X, Mayo MS. Identifying incident oral and pharyngeal cancer cases using Medicare claims. BMC Oral Health. 2013;13:1.CrossRefPubMedPubMedCentral Mahnken JD, Keighley JD, Girod DA, Chen X, Mayo MS. Identifying incident oral and pharyngeal cancer cases using Medicare claims. BMC Oral Health. 2013;13:1.CrossRefPubMedPubMedCentral
3.
go back to reference Baldi I, Vicari P, Di Cuonzo D, Zanetti R, Pagano E, Rosato R, Sacerdote C, Segnan N, Merletti F, Ciccone G. A high positive predictive value algorithm using hospital administrative data identified incident cancer cases. J Clin Epidemiol. 2008;61(4):373–9.CrossRefPubMed Baldi I, Vicari P, Di Cuonzo D, Zanetti R, Pagano E, Rosato R, Sacerdote C, Segnan N, Merletti F, Ciccone G. A high positive predictive value algorithm using hospital administrative data identified incident cancer cases. J Clin Epidemiol. 2008;61(4):373–9.CrossRefPubMed
4.
go back to reference Nattinger AB, Laud PW, Bajorunaite R, Sparapani RA, Freeman JL. An algorithm for the use of Medicare claims data to identify women with incident breast cancer. Health Serv Res. 2004;39(6 Pt 1):1733–50.CrossRefPubMedPubMedCentral Nattinger AB, Laud PW, Bajorunaite R, Sparapani RA, Freeman JL. An algorithm for the use of Medicare claims data to identify women with incident breast cancer. Health Serv Res. 2004;39(6 Pt 1):1733–50.CrossRefPubMedPubMedCentral
5.
go back to reference Ramsey SD, Mandelson MT, Etzioni R, Harrison R, Smith R, Taplin S. Can administrative data identify incident cases of colorectal cancer? A comparison of two health plans. Health Serv Outcome Res Methodol. 2004;5(1):27–37.CrossRef Ramsey SD, Mandelson MT, Etzioni R, Harrison R, Smith R, Taplin S. Can administrative data identify incident cases of colorectal cancer? A comparison of two health plans. Health Serv Outcome Res Methodol. 2004;5(1):27–37.CrossRef
6.
go back to reference Koroukian SM, Cooper GS, Rimm AA. Ability of Medicaid claims data to identify incident cases of breast cancer in the Ohio Medicaid population. Health Serv Res. 2003;38(3):947–60.CrossRefPubMedPubMedCentral Koroukian SM, Cooper GS, Rimm AA. Ability of Medicaid claims data to identify incident cases of breast cancer in the Ohio Medicaid population. Health Serv Res. 2003;38(3):947–60.CrossRefPubMedPubMedCentral
7.
go back to reference Freeman JL, Zhang D, Freeman DH, Goodwin JS. An approach to identifying incident breast cancer cases using Medicare claims data. J Clin Epidemiol. 2000;53(6):605–14.CrossRefPubMed Freeman JL, Zhang D, Freeman DH, Goodwin JS. An approach to identifying incident breast cancer cases using Medicare claims data. J Clin Epidemiol. 2000;53(6):605–14.CrossRefPubMed
8.
go back to reference Leung KM, Hasan AG, Rees KS, Parker RG, Legorreta AP. Patients with newly diagnosed carcinoma of the breast: validation of a claim-based identification algorithm. J Clin Epidemiol. 1999;52(1):57–64.CrossRefPubMed Leung KM, Hasan AG, Rees KS, Parker RG, Legorreta AP. Patients with newly diagnosed carcinoma of the breast: validation of a claim-based identification algorithm. J Clin Epidemiol. 1999;52(1):57–64.CrossRefPubMed
9.
go back to reference Warren JL, Feuer E, Potosky AL, Riley GF, Lynch CF. Use of Medicare hospital and physician data to assess breast cancer incidence. Med Care. 1999;37(5):445–56.CrossRefPubMed Warren JL, Feuer E, Potosky AL, Riley GF, Lynch CF. Use of Medicare hospital and physician data to assess breast cancer incidence. Med Care. 1999;37(5):445–56.CrossRefPubMed
10.
11.
go back to reference Rañopa M, Douglas I, van Staa T, Smeeth L, Klungel O, Reynolds R, Bhaskaran K. The identification of incident cancers in UK primary care databases: a systematic review. Pharmacoepidemiol Drug Saf. 2015;24(1):11–8.CrossRefPubMed Rañopa M, Douglas I, van Staa T, Smeeth L, Klungel O, Reynolds R, Bhaskaran K. The identification of incident cancers in UK primary care databases: a systematic review. Pharmacoepidemiol Drug Saf. 2015;24(1):11–8.CrossRefPubMed
12.
go back to reference Czwikla J, Domhoff D, Giersiepen K. ICD coding quality for outpatient cancer diagnoses in SHI claims data. Z Evid Fortbild Qual Gesundhwes. 2016;118-119:48–55.CrossRefPubMed Czwikla J, Domhoff D, Giersiepen K. ICD coding quality for outpatient cancer diagnoses in SHI claims data. Z Evid Fortbild Qual Gesundhwes. 2016;118-119:48–55.CrossRefPubMed
13.
go back to reference Trautmann F, Schuler M, Schmitt J. Burden of soft-tissue and bone sarcoma in routine care: estimation of incidence, prevalence and survival for health services research. Cancer Epidemiol. 2015;39(3):440–6.CrossRefPubMed Trautmann F, Schuler M, Schmitt J. Burden of soft-tissue and bone sarcoma in routine care: estimation of incidence, prevalence and survival for health services research. Cancer Epidemiol. 2015;39(3):440–6.CrossRefPubMed
14.
go back to reference Goldsbury D, Weber M, Yap S, Banks E, O'Connell DL, Canfell K. Identifying incident colorectal and lung cancer cases in health service utilisation databases in Australia: a validation study. BMC Med Inform Decis Mak. 2017;17(1):23.CrossRefPubMedPubMedCentral Goldsbury D, Weber M, Yap S, Banks E, O'Connell DL, Canfell K. Identifying incident colorectal and lung cancer cases in health service utilisation databases in Australia: a validation study. BMC Med Inform Decis Mak. 2017;17(1):23.CrossRefPubMedPubMedCentral
15.
go back to reference Abbas S, Ihle P, Köster I, Schubert I. Estimation of disease incidence in claims data dependent on the length of follow-up: a methodological approach. Health Serv Res. 2012;47(2):746–55.CrossRefPubMed Abbas S, Ihle P, Köster I, Schubert I. Estimation of disease incidence in claims data dependent on the length of follow-up: a methodological approach. Health Serv Res. 2012;47(2):746–55.CrossRefPubMed
16.
go back to reference Robert Koch-Institute, Association of Population-based Cancer Registries in Germany. Cancer in Germany 2011/2012. 10th ed. Berlin: Robert-Koch-Institute; 2016. Robert Koch-Institute, Association of Population-based Cancer Registries in Germany. Cancer in Germany 2011/2012. 10th ed. Berlin: Robert-Koch-Institute; 2016.
19.
go back to reference Creighton N, Walton R, Roder D, Aranda S, Currow D. Validation of administrative hospital data for identifying incident pancreatic and periampullary cancer cases: a population-based study using linked cancer registry and administrative hospital data in New South Wales, Australia. BMJ Open. 2016;6(7):e011161.CrossRefPubMedPubMedCentral Creighton N, Walton R, Roder D, Aranda S, Currow D. Validation of administrative hospital data for identifying incident pancreatic and periampullary cancer cases: a population-based study using linked cancer registry and administrative hospital data in New South Wales, Australia. BMJ Open. 2016;6(7):e011161.CrossRefPubMedPubMedCentral
20.
go back to reference Stein JD, Blachley TS, Musch DC. Identification of persons with incident ocular diseases using health care claims databases. Am J Ophthalmol. 2013;156(6):1169–75.e3.CrossRefPubMed Stein JD, Blachley TS, Musch DC. Identification of persons with incident ocular diseases using health care claims databases. Am J Ophthalmol. 2013;156(6):1169–75.e3.CrossRefPubMed
21.
go back to reference Roberts AW, Dusetzina SB, Farley JF. Revisiting the washout period in the incident user study design: why 6-12 months may not be sufficient. J Comp Eff Res. 2015;4(1):27–35.CrossRefPubMedPubMedCentral Roberts AW, Dusetzina SB, Farley JF. Revisiting the washout period in the incident user study design: why 6-12 months may not be sufficient. J Comp Eff Res. 2015;4(1):27–35.CrossRefPubMedPubMedCentral
22.
go back to reference German Cancer Society: Annual Report 2016 of the Certified Prostate Cancer Centres. Audit year 2015/indicator year 2014. Berlin: German Cancer Society; 2016. German Cancer Society: Annual Report 2016 of the Certified Prostate Cancer Centres. Audit year 2015/indicator year 2014. Berlin: German Cancer Society; 2016.
23.
go back to reference German Cancer Society: Annual Report 2016 of the Certified Breast Cancer Centres (BCCs). Audit year 2015/indicator year 2014. Berlin: German Cancer Society; 2016. German Cancer Society: Annual Report 2016 of the Certified Breast Cancer Centres (BCCs). Audit year 2015/indicator year 2014. Berlin: German Cancer Society; 2016.
24.
go back to reference German Cancer Society: Annual Report 2016 of the Certified Colorectal Cancer Centres (CrCCs). Audit year 2015/indicator year 2014. Berlin: German Cancer Society; 2016. German Cancer Society: Annual Report 2016 of the Certified Colorectal Cancer Centres (CrCCs). Audit year 2015/indicator year 2014. Berlin: German Cancer Society; 2016.
25.
go back to reference Charlton R, Snowball J, Bloomfield K, de Vries C. Colorectal cancer incidence on the general practice research database. Pharmacoepidemiol Drug Saf. 2012;21(7):775–83.CrossRefPubMed Charlton R, Snowball J, Bloomfield K, de Vries C. Colorectal cancer incidence on the general practice research database. Pharmacoepidemiol Drug Saf. 2012;21(7):775–83.CrossRefPubMed
26.
go back to reference Haynes K, Forde KA, Schinnar R, Wong P, Strom BL, Lewis JD. Cancer incidence in the health improvement network. Pharmacoepidemiol Drug Saf. 2009;18(8):730–6.CrossRefPubMed Haynes K, Forde KA, Schinnar R, Wong P, Strom BL, Lewis JD. Cancer incidence in the health improvement network. Pharmacoepidemiol Drug Saf. 2009;18(8):730–6.CrossRefPubMed
27.
go back to reference Doat S, Samson S, Fagot-Campagna A, Tuppin P, Menegaux F. Estimation of breast, prostate, and colorectal cancer incidence using a French administrative database (general sample of health insurance beneficiaries). Rev Epidemiol Sante Publique. 2016;64(3):145–52.CrossRefPubMed Doat S, Samson S, Fagot-Campagna A, Tuppin P, Menegaux F. Estimation of breast, prostate, and colorectal cancer incidence using a French administrative database (general sample of health insurance beneficiaries). Rev Epidemiol Sante Publique. 2016;64(3):145–52.CrossRefPubMed
28.
go back to reference Cooper GS, Yuan Z, Jethva RN, Rimm AA. Use of Medicare claims data to measure county-level variation in breast carcinoma incidence and mammography rates. Cancer Detect Prev. 2002;26(3):197–202.CrossRefPubMed Cooper GS, Yuan Z, Jethva RN, Rimm AA. Use of Medicare claims data to measure county-level variation in breast carcinoma incidence and mammography rates. Cancer Detect Prev. 2002;26(3):197–202.CrossRefPubMed
29.
go back to reference Kaye JA, Derby LE, del Mar M-MM, Quinn M, Jick H. The incidence of breast cancer in the general practice research database compared with national cancer registration data. Br J Cancer. 2000;83(11):1556–8.CrossRefPubMedPubMedCentral Kaye JA, Derby LE, del Mar M-MM, Quinn M, Jick H. The incidence of breast cancer in the general practice research database compared with national cancer registration data. Br J Cancer. 2000;83(11):1556–8.CrossRefPubMedPubMedCentral
30.
go back to reference McBean AM, Warren JL, Babish JD. Measuring the incidence of cancer in elderly Americans using Medicare claims data. Cancer. 1994;73(9):2417–25.CrossRefPubMed McBean AM, Warren JL, Babish JD. Measuring the incidence of cancer in elderly Americans using Medicare claims data. Cancer. 1994;73(9):2417–25.CrossRefPubMed
31.
go back to reference Whittle J, Steinberg EP, Anderson GF, Herbert R. Accuracy of Medicare claims data for estimation of cancer incidence and resection rates among elderly Americans. Med Care. 1991;29(12):1226–36.CrossRefPubMed Whittle J, Steinberg EP, Anderson GF, Herbert R. Accuracy of Medicare claims data for estimation of cancer incidence and resection rates among elderly Americans. Med Care. 1991;29(12):1226–36.CrossRefPubMed
32.
go back to reference Gilbertson DT, Bradbury BD, Wetmore JB, Weinhandl ED, Monda KL, Liu J, Brookhart MA, Gustafson SK, Roberts T, Collins AJ, et al. Controlling confounding of treatment effects in administrative data in the presence of time-varying baseline confounders. Pharmacoepidemiol Drug Saf. 2016;25(3):269–77.CrossRefPubMed Gilbertson DT, Bradbury BD, Wetmore JB, Weinhandl ED, Monda KL, Liu J, Brookhart MA, Gustafson SK, Roberts T, Collins AJ, et al. Controlling confounding of treatment effects in administrative data in the presence of time-varying baseline confounders. Pharmacoepidemiol Drug Saf. 2016;25(3):269–77.CrossRefPubMed
33.
go back to reference Quantin C, Benzenine E, Hagi M, Auverlot B, Abrahamowicz M, Cottenet J, Fournier E, Binquet C, Compain D, Monnet E, et al. Estimation of national colorectal-cancer incidence using claims databases. J Cancer Epidemiol. 2012;2012:298369.PubMedPubMedCentral Quantin C, Benzenine E, Hagi M, Auverlot B, Abrahamowicz M, Cottenet J, Fournier E, Binquet C, Compain D, Monnet E, et al. Estimation of national colorectal-cancer incidence using claims databases. J Cancer Epidemiol. 2012;2012:298369.PubMedPubMedCentral
34.
go back to reference McClish DK, Penberthy L, Whittemore M, Newschaffer C, Woolard D, Desch CE, Retchin S. Ability of Medicare claims data and cancer registries to identify cancer cases and treatment. Am J Epidemiol. 1997;145(3):227–33.CrossRefPubMed McClish DK, Penberthy L, Whittemore M, Newschaffer C, Woolard D, Desch CE, Retchin S. Ability of Medicare claims data and cancer registries to identify cancer cases and treatment. Am J Epidemiol. 1997;145(3):227–33.CrossRefPubMed
35.
go back to reference Hoffmann F, Koller D. Different regions, differently insured populations? Socio-demographic and health-related differences between insurance funds. Gesundheitswesen. 2017;79(1):e1–9.PubMed Hoffmann F, Koller D. Different regions, differently insured populations? Socio-demographic and health-related differences between insurance funds. Gesundheitswesen. 2017;79(1):e1–9.PubMed
Metadata
Title
The impact of the lookback period and definition of confirmatory events on the identification of incident cancer cases in administrative data
Authors
Jonas Czwikla
Kathrin Jobski
Tania Schink
Publication date
01-12-2017
Publisher
BioMed Central
Published in
BMC Medical Research Methodology / Issue 1/2017
Electronic ISSN: 1471-2288
DOI
https://doi.org/10.1186/s12874-017-0407-4

Other articles of this Issue 1/2017

BMC Medical Research Methodology 1/2017 Go to the issue