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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Similar content being viewed by others
References
Iezzoni LI (1997) Assessing quality using administrative data. Ann Intern Med 127:666–674
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
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
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
Ray WA (1997) Policy and program analysis using administrative databases. Ann Intern Med 127:712–718
Virnig BA, McBean M (2001) Administrative data for public health surveillance and planning. Annu Rev Public Health 22:213–230
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
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
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
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
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
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
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
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
Grimes DA (2010) Epidemiologic research using administrative databases: garbage in, garbage out. Obstet Gynecol 116:1018–1019
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
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
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
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
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
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
Lillard LA, Farmer MM (1997) Linking Medicare and national survey data. Ann Intern Med 127:691–695
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
Black N (2001) Evidence based policy: proceed with care. BMJ 323:275
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
Relman AS (1988) Assessment and accountability: the third revolution in medical care. N Engl J Med 319:1220
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
Gabriel S, Crowson C, O’Fallon W (1995) Costs of osteoarthritis: estimates from a geographically defined population. J Rheumatol Suppl 43:23–25
Clancy CM, Eisenberg JM (1997) Outcomes research at the agency for health care policy and research. Dis Manage Clin Outcomes 1:72–80
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
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
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
Canadian Institute for Health Information (2004) Health care in Canada 2004. Cihi, Ottawa
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
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
Winglee M, Valliant R, Scheuren F (2005) A case study in record linkage. Surv Methodol 31:3–11
Black N, Barker M, Payne M (2004) Cross sectional survey of multicentre clinical databases in the United Kingdom. BMJ 328:1478
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
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
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
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
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
Kendrick S, Clarke J (1993) The Scottish record linkage system. Health Bull (Edinb) 51:72–79
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights 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