Skip to main content
SpringerLink
Log in

Evidence-Based Decision-Making 6: Utilization of Administrative Databases for Health Services Research

  • Protocol
  • First Online:
Clinical Epidemiology

Part of the book series: Methods in Molecular Biology ((MIMB,volume 1281))

Abstract

Health-care systems require reliable information on which to base health-care planning and make decisions, as well as to evaluate their policy impact. Administrative data provide important information about health services use, expenditures, clinical outcomes, and may be used to assess quality of care. With increased digitalization and accessibility of administrative databases, these data are more readily available for health service research purposes, aiding evidence-based decision-making. This chapter discusses the utility of administrative data for population-based studies of health and health care.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Protocol
USD 49.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 129.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 169.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD 249.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  1. Iezzoni LI (1997) Assessing quality using administrative data. Ann Intern Med 127:666–674

    Article  CAS  PubMed  Google Scholar 

  2. Cowper DC, Hynes DM, Kubal JD, Murphy PA (1999) Using administrative databases for outcomes research: select examples from VA health services research and development. J Med Syst 23:249–259

    Article  CAS  PubMed  Google Scholar 

  3. Fantini M, Cisbani L, Manzoli L, Vertrees J, Lorenzoni L (2003) On the use of administrative databases to support planning activities the case of the evaluation of neonatal case-mix in the Emilia-Romagna region using DRG and APR-DRG classification systems. Eur J Public Health 13:138–145

    Article  CAS  PubMed  Google Scholar 

  4. Malenka DJ, McLerran D, Roos N, Fisher ES, Wennberg JE (1994) Using administrative data to describe casemix: a comparison with the medical record. J Clin Epidemiol 47:1027–1032

    Article  CAS  PubMed  Google Scholar 

  5. Ray WA (1997) Policy and program analysis using administrative databases. Ann Intern Med 127:712–718

    Article  CAS  PubMed  Google Scholar 

  6. Virnig BA, McBean M (2001) Administrative data for public health surveillance and planning. Annu Rev Public Health 22:213–230

    Article  CAS  PubMed  Google Scholar 

  7. Tricco AC, Pham B, Rawson NS (2008) Manitoba and Saskatchewan administrative health care utilization databases are used differently to answer epidemiologic research questions. J Clin Epidemiol 61:192–197.e112

    Article  PubMed  Google Scholar 

  8. Bello A, Hemmelgarn B, Manns B, Tonelli M (2012) Use of administrative databases for health-care planning in CKD. Nephrol Dial Transplant 27:iii12–iii18

    PubMed  Google Scholar 

  9. Rucker D, Hemmelgarn BR, Lin M, Manns BJ, Klarenbach SW, Ayyalasomayajula B, James MT, Bello A, Gordon D, Jindal KK (2011) Quality of care and mortality are worse in chronic kidney disease patients living in remote areas. Kidney Int 79:210–217

    Article  PubMed  Google Scholar 

  10. Wiebe N, Klarenbach SW, Chui B, Ayyalasomayajula B, Hemmelgarn BR, Jindal K, Manns B, Tonelli M (2012) Adding specialized clinics for remote-dwellers with chronic kidney disease: a cost-utility analysis. Clin J Am Soc Nephrol 7:24–34

    Article  PubMed Central  PubMed  Google Scholar 

  11. Suissa S, Garbe E (2007) Primer: administrative health databases in observational studies of drug effects—advantages and disadvantages. Nat Clin Pract Rheumatol 3:725–732

    Article  CAS  PubMed  Google Scholar 

  12. Kokotailo RA, Hill MD (2005) Coding of stroke and stroke risk factors using international classification of diseases, revisions 9 and 10. Stroke 36:1776–1781

    Article  PubMed  Google Scholar 

  13. Peter CA, Paul AD, Jack VT (2002) A multicenter study of the coding accuracy of hospital discharge administrative data for patients admitted to cardiac care units in Ontario. Am Heart J 144:290–296

    Article  Google Scholar 

  14. Ronksley PE, Tonelli M, Quan H, Manns BJ, James MT, Clement FM, Samuel S, Quinn RR, Ravani P, Brar SS (2012) Validating a case definition for chronic kidney disease using administrative data. Nephrol Dial Transplant 27:1826–1831

    Article  CAS  PubMed  Google Scholar 

  15. Grimes DA (2010) Epidemiologic research using administrative databases: garbage in, garbage out. Obstet Gynecol 116:1018–1019

    Article  PubMed  Google Scholar 

  16. Iezzoni L, Foley S, Daley J, Hughes J, Fisher E, Heeren T (1991) Comorbidities, complications, and coding bias. Does the number of diagnosis codes matter in predicting in-hospital mortality? JAMA 267:2197–2203

    Article  Google Scholar 

  17. Jollis JG, Ancukiewicz M, DeLong ER, Pryor DB, Muhlbaier LH, Mark DB (1993) Discordance of databases designed for claims payment versus clinical information systems: implications for outcomes research. Ann Intern Med 119:844–850

    Article  CAS  PubMed  Google Scholar 

  18. Hux JE, Ivis F, Flintoft V, Bica A (2002) Diabetes in Ontario: determination of prevalence and incidence using a validated administrative data algorithm. Diabetes Care 25:512–516

    Article  PubMed  Google Scholar 

  19. Quan H, Sundararajan V, Halfon P, Fong A, Burnand B, Luthi J-C, Saunders LD, Beck CA, Feasby TE, Ghali WA (2005) Coding algorithms for defining comorbidities in ICD-9-CM and ICD-10 administrative data. Med Care 43:1130–1139

    Article  PubMed  Google Scholar 

  20. Clement FM, James MT, Chin R, Klarenbach SW, Manns BJ, Quinn RR, Ravani P, Tonelli M, Hemmelgarn BR (2011) Validation of a case definition to define chronic dialysis using outpatient administrative data. BMC Med Res Methodol 11:25

    Article  PubMed Central  PubMed  Google Scholar 

  21. Jones SS, Adams JL, Schneider EC, Ringel JS, McGlynn EA (2010) Electronic health record adoption and quality improvement in US hospitals. Am J Manag Care 16:SP64–SP71

    PubMed  Google Scholar 

  22. Lillard LA, Farmer MM (1997) Linking Medicare and national survey data. Ann Intern Med 127:691–695

    Article  CAS  PubMed  Google Scholar 

  23. Interdisciplinary Chronic Disease Collaboration (2008) The research to health policy cycle: a tool for better management of chronic noncommunicable diseases. J Nephrol 21:621–631

    Google Scholar 

  24. Black N (2001) Evidence based policy: proceed with care. BMJ 323:275

    Article  PubMed Central  CAS  PubMed  Google Scholar 

  25. Wennberg J, Gittelsohn A (1973) Small area variations in health care delivery a population-based health information system can guide planning and regulatory decision-making. Science 182:1102–1108

    Article  CAS  PubMed  Google Scholar 

  26. Relman AS (1988) Assessment and accountability: the third revolution in medical care. N Engl J Med 319:1220

    Article  CAS  PubMed  Google Scholar 

  27. Roper WL, Winkenwerder W, Hackbarth GM, Krakauer H (1988) Effectiveness in health care. An initiative to evaluate and improve medical practice. N Engl J Med 319:1197

    Article  CAS  PubMed  Google Scholar 

  28. Gabriel S, Crowson C, O’Fallon W (1995) Costs of osteoarthritis: estimates from a geographically defined population. J Rheumatol Suppl 43:23–25

    CAS  PubMed  Google Scholar 

  29. Clancy CM, Eisenberg JM (1997) Outcomes research at the agency for health care policy and research. Dis Manage Clin Outcomes 1:72–80

    Article  Google Scholar 

  30. Lave JR, Pashos CL, AndersonN G, Brailer D, Bubolz T, Conrad D, Freund DA, Fox SH, Keeler E, Lipscomb J (1994) Costing medical care: using Medicare administrative data. Med Care 32:JS77

    Article  CAS  PubMed  Google Scholar 

  31. Mitchell JB, Bubolz T, Paul JE, Pashos CL, Escarce JJ, Muhlbaier LH, Wiesman JM, Young WW, EPSTEIN R, Javitt JC (1994) Using Medicare claims for outcomes research. Med Care 32:JS38

    Article  CAS  PubMed  Google Scholar 

  32. Institute of Medicine Committee on Quality of Health in America (2001) Crossing the quality chasm: a new health system for the 21st century. National academies press, Washington, DC, pp 1–337

    Google Scholar 

  33. Canadian Institute for Health Information (2004) Health care in Canada 2004. Cihi, Ottawa

    Google Scholar 

  34. The Bristol Royal Infirmary inquiry: the report of the public inquiry into children’s heart surgery at the Bristol Royal Infirmary 1984–1995. London, UK 2001

    Google Scholar 

  35. National Health and Hospitals Reform Commission (Australia). Australia. Dept. of health and ageing (2009) A healthier future for all Australians final report June 2009. Dept. of health and ageing, Canberra, a.C.T

    Google Scholar 

  36. Winglee M, Valliant R, Scheuren F (2005) A case study in record linkage. Surv Methodol 31:3–11

    Google Scholar 

  37. Black N, Barker M, Payne M (2004) Cross sectional survey of multicentre clinical databases in the United Kingdom. BMJ 328:1478

    Article  PubMed Central  PubMed  Google Scholar 

  38. Evans S, Bohensky M, Cameron P, McNeil J (2011) A survey of Australian clinical registries: can quality of care be measured? Intern Med J 41:42–48

    Article  CAS  PubMed  Google Scholar 

  39. Holman CAJ, Bass AJ, Rouse IL, Hobbs MS (1999) Population-based linkage of health records in Western Australia: development of a health services research linked database. Aust N Z J Public Health 23:453–459

    Article  CAS  PubMed  Google Scholar 

  40. Chamberlayne R, Green B, Barer ML, Hertzman C, Lawrence WJ, Sheps SB (1997) Creating a population-based linked health database: a new resource for health services research. Can J Public Health 89:270–273

    Google Scholar 

  41. Hemmelgarn BR, Clement F, Manns BJ, Klarenbach S, James MT, Ravani P, Pannu N, Ahmed SB, MacRae J, Jindal K, Quinn R, Culleton BF, Wiebe N, Krause R, Thorlacius L, Tonelli M (2009) Overview of the Alberta kidney disease network. BMC Nephrol 10:30

    Article  PubMed Central  PubMed  Google Scholar 

  42. Acheson E, Evans J (1964) The Oxford record linkage study: a review of the method with some preliminary results. Proc R Soc Med 57:269

    PubMed Central  CAS  PubMed  Google Scholar 

  43. Kendrick S, Clarke J (1993) The Scottish record linkage system. Health Bull (Edinb) 51:72–79

    CAS  Google Scholar 

  44. Conley J, Tonelli M, Quan H, Manns BJ, Palacios-Derflingher L, Bresee LC, Khan N, Hemmelgarn BR (2012) Association between GFR, proteinuria, and adverse outcomes among White, Chinese, and South Asian individuals in Canada. Am J Kidney Dis 59:390–399

    Article  PubMed  Google Scholar 

  45. Samuel SM, Palacios-Derflingher L, Tonelli M, Manns B, Crowshoe L, Ahmed SB, Jun M, Saad N, Hemmelgarn BR (2013) Association between First Nations ethnicity and progression to kidney failure by presence and severity of albuminuria. CMAJ 186:E86–E94, 130776

    Article  PubMed  Google Scholar 

  46. Deved V, Jette N, Quan H, Tonelli M, Manns B, Soo A, Barnabe C, Hemmelgarn BR (2013) Quality of care for First Nations and non-First Nations People with diabetes. Clin J Am Soc Nephrol 8:1188–1194

    Article  PubMed Central  PubMed  Google Scholar 

  47. Ayyalasomayajula B, Wiebe N, Hemmelgarn BR, Bello A, Manns B, Klarenbach S, Tonelli M (2011) A novel technique to optimize facility locations of new nephrology services for remote areas. Clin J Am Soc Nephrol 6:2157–2164

    Article  PubMed Central  PubMed  Google Scholar 

  48. Faruque LI, Ayyalasomayajula B, Pelletier R, Klarenbach S, Hemmelgarn BR, Tonelli M (2012) Spatial analysis to locate new clinics for diabetic kidney patients in the underserved communities in Alberta. Nephrol Dial Transplant 27:4102–4109

    Article  PubMed  Google Scholar 

  49. Schorr M, Hemmelgarn BR, Tonelli M, Soo A, Manns BJ, Bresee LC (2013) Assessment of serum creatinine and kidney function among incident metformin users. Can J Diabetes 37:226–230

    Article  PubMed  Google Scholar 

  50. Turin TC, Tonelli M, Manns BJ, Ravani P, Ahmed SB, Hemmelgarn BR (2012) Chronic kidney disease and life expectancy. Nephrol Dial Transplant 27:3182–3186

    Article  CAS  PubMed  Google Scholar 

  51. Turin TC, Tonelli M, Manns BJ, Ahmed SB, Ravani P, James M, Hemmelgarn BR (2012) Lifetime risk of ESRD. J Am Soc Nephrol 23:1569–1578

    Article  PubMed Central  PubMed  Google Scholar 

  52. Hemmelgarn BR, James MT, Manns BJ, O’Hare AM, Muntner P, Ravani P, Quinn RR, Turin TC, Tan Z, Tonelli M (2012) Rates of treated and untreated kidney failure in older vs younger adults. JAMA 307:2507–2515

    Article  CAS  PubMed  Google Scholar 

  53. McBrien KA, Manns BJ, Chui B, Klarenbach SW, Rabi D, Ravani P, Hemmelgarn B, Wiebe N, Au F, Clement F (2013) Health care costs in people with diabetes and their association with glycemic control and kidney function. Diabetes Care 36:1172–1180

    Article  PubMed Central  PubMed  Google Scholar 

  54. Hemmelgarn BR, Manns BJ, Lloyd A, James MT, Klarenbach S, Quinn RR, Wiebe N, Tonelli M (2010) Relation between kidney function, proteinuria, and adverse outcomes. JAMA 303:423–429

    Article  CAS  PubMed  Google Scholar 

  55. Shurraw S, Hemmelgarn B, Lin M, Majumdar SR, Klarenbach S, Manns B, Bello A, James M, Turin TC, Tonelli M (2011) Association between glycemic control and adverse outcomes in people with diabetes mellitus and chronic kidney disease: a population-based cohort study. Arch Intern Med 171:1920–1927

    Article  PubMed  Google Scholar 

  56. Turin TC, James M, Ravani P, Tonelli M, Manns BJ, Quinn R, Jun M, Klarenbach S, Hemmelgarn BR (2013) Proteinuria and rate of change in kidney function in a community-based population. J Am Soc Nephrol 24:1661–1667

    Article  PubMed Central  PubMed  Google Scholar 

  57. Alexander RT, Hemmelgarn BR, Wiebe N, Bello A, Samuel S, Klarenbach SW, Curhan GC, Tonelli M (2013) Kidney stones and cardiovascular events: a cohort study. Clin J Am Soc Nephrol 04960513

    Google Scholar 

  58. Tonelli M, Muntner P, Lloyd A, Manns BJ, James MT, Klarenbach S, Quinn RR, Wiebe N, Hemmelgarn BR (2011) Using proteinuria and estimated glomerular filtration rate to classify risk in patients with chronic kidney disease: a cohort study. Ann Intern Med 154:12–21

    Article  PubMed  Google Scholar 

  59. Chou SH, Tonelli M, Bradley JS, Gourishankar S, Hemmelgarn BR (2006) Quality of care among aboriginal hemodialysis patients. Clin J Am Soc Nephrol 1:58–63

    Article  PubMed  Google Scholar 

  60. Tonelli M, Manns B, Culleton B, Klarenbach S, Hemmelgarn B, Wiebe N, Gill JS (2007) Association between proximity to the attending nephrologist and mortality among patients receiving hemodialysis. Can Med Assoc J 177:1039–1044

    Article  Google Scholar 

  61. Ronksley PE, Ravani P, Sanmartin C, Quan H, Manns B, Tonelli M, Hemmelgarn BR (2013) Patterns of engagement with the health care system and risk of subsequent hospitalization amongst patients with diabetes. BMC Health Serv Res 13:399

    Article  PubMed Central  PubMed  Google Scholar 

  62. James MT, Quan H, Tonelli M, Manns BJ, Faris P, Laupland KB, Hemmelgarn BR (2009) CKD and risk of hospitalization and death with pneumonia. Am J Kidney Dis 54:24–32

    Article  PubMed  Google Scholar 

  63. Manns B, Hemmelgarn B, Tonelli M, Au F, Chiasson TC, Dong J, Klarenbach S (2010) Population based screening for chronic kidney disease: cost effectiveness study. BMJ 341:c5869

    Article  PubMed Central  PubMed  Google Scholar 

  64. Hemmelgarn BR, Zhang J, Manns BJ, James MT, Quinn RR, Ravani P, Klarenbach SW, Culleton BF, Krause R, Thorlacius L (2010) Nephrology visits and health care resource use before and after reporting estimated glomerular filtration rate. JAMA 303:1151–1158

    Article  CAS  PubMed  Google Scholar 

  65. Manns BJ, Tonelli M, Zhang J, Campbell DJ, Sargious P, Ayyalasomayajula B, Clement F, Johnson JA, Laupacis A, Lewanczuk R (2012) Enrolment in primary care networks: impact on outcomes and processes of care for patients with diabetes. Can Med Assoc J 184:E144–E152

    Article  Google Scholar 

  66. Hemmelgarn BR, Manns BJ, Straus S, Naugler C, Holroyd-Leduc J, Braun TC, Levin A, Klarenbach S, Lee PF, Hafez K, Schwartz D, Jindal K, Ervin K, Bello A, Turin TC, McBrien K, Elliott M, Tonelli M (2012) Knowledge translation for nephrologists: strategies for improving the identification of patients with proteinuria. J Nephrol 25:933–943

    Article  PubMed  Google Scholar 

  67. Turin TC, Coresh J, Tonelli M, Stevens PE, de Jong PE, Farmer CKT, Matsushita K, Hemmelgarn BR (2012) One-year change in kidney function is associated with an increased mortality risk. Am J Nephrol 36:41–49

    Article  PubMed  Google Scholar 

  68. Turin TC, Coresh J, Tonelli M, Stevens PE, de Jong PE, Farmer CK, Matsushita K, Hemmelgarn BR (2012) Short-term change in kidney function and risk of end-stage renal disease. Nephrol Dial Transplant 27:3835–3843

    Article  CAS  PubMed  Google Scholar 

  69. Turin TC, Coresh J, Tonelli M, Stevens PE, de Jong PE, Farmer CK, Matsushita K, Hemmelgarn BR (2013) Change in the estimated glomerular filtration rate over time and risk of all-cause mortality. Kidney Int 83:684–691

    Article  CAS  PubMed  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Family Medicine, University of Calgary, Calgary, AL, Canada

    Tanvir Turin Chowdhury

  2. Department of Medicine, University of Calgary, Calgary, AL, Canada

    Brenda Hemmelgarn

  3. Department of Community Health Sciences, University of Calgary, Calgary, AL, Canada

    Brenda Hemmelgarn

  4. Foothills Medical Centre, 1403 29th Street NW, Calgary, AB, Canada, T2N 2T9

    Brenda Hemmelgarn

Authors
  1. Tanvir Turin Chowdhury
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Brenda Hemmelgarn
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Brenda Hemmelgarn .

Editor information

Editors and Affiliations

  1. Memorial University of Newfoundland, St. John's, Newfoundland and Labrador, Canada

    Patrick S. Parfrey

  2. Memorial University of Newfoundland, St. John's, Newfoundland and Labrador, Canada

    Brendan J. Barrett

Rights and permissions

Reprints and permissions

Copyright information

© 2015 Springer Science+Business Media New York

About this protocol

Cite this protocol

Chowdhury, T.T., Hemmelgarn, B. (2015). Evidence-Based Decision-Making 6: Utilization of Administrative Databases for Health Services Research. In: Parfrey, P., Barrett, B. (eds) Clinical Epidemiology. Methods in Molecular Biology, vol 1281. Humana Press, New York, NY. https://doi.org/10.1007/978-1-4939-2428-8_28

Download citation

  • DOI: https://doi.org/10.1007/978-1-4939-2428-8_28

  • Published:

  • Publisher Name: Humana Press, New York, NY

  • Print ISBN: 978-1-4939-2427-1

  • Online ISBN: 978-1-4939-2428-8

  • eBook Packages: Springer Protocols

Publish with us

Policies and ethics

Search

Navigation