Skip to main content
Top
Published in: BMC Health Services Research 1/2017

Open Access 01-12-2017 | Technical advance

Developing a standardized healthcare cost data warehouse

Authors: Sue L. Visscher, James M. Naessens, Barbara P. Yawn, Megan S. Reinalda, Stephanie S. Anderson, Bijan J. Borah

Published in: BMC Health Services Research | Issue 1/2017

Login to get access

Abstract

Background

Research addressing value in healthcare requires a measure of cost. While there are many sources and types of cost data, each has strengths and weaknesses. Many researchers appear to create study-specific cost datasets, but the explanations of their costing methodologies are not always clear, causing their results to be difficult to interpret. Our solution, described in this paper, was to use widely accepted costing methodologies to create a service-level, standardized healthcare cost data warehouse from an institutional perspective that includes all professional and hospital-billed services for our patients.

Methods

The warehouse is based on a National Institutes of Research–funded research infrastructure containing the linked health records and medical care administrative data of two healthcare providers and their affiliated hospitals. Since all patients are identified in the data warehouse, their costs can be linked to other systems and databases, such as electronic health records, tumor registries, and disease or treatment registries.

Results

We describe the two institutions’ administrative source data; the reference files, which include Medicare fee schedules and cost reports; the process of creating standardized costs; and the warehouse structure. The costing algorithm can create inflation-adjusted standardized costs at the service line level for defined study cohorts on request.

Conclusion

The resulting standardized costs contained in the data warehouse can be used to create detailed, bottom-up analyses of professional and facility costs of procedures, medical conditions, and patient care cycles without revealing business-sensitive information.
After its creation, a standardized cost data warehouse is relatively easy to maintain and can be expanded to include data from other providers. Individual investigators who may not have sufficient knowledge about administrative data do not have to try to create their own standardized costs on a project-by-project basis because our data warehouse generates standardized costs for defined cohorts upon request.
Appendix
Available only for authorised users
Literature
1.
go back to reference Berwick DM, Nolan TW, Whittington J. The triple aim: care, health, and cost. Health Aff (Millwood). 2008;27(3):759–69.CrossRef Berwick DM, Nolan TW, Whittington J. The triple aim: care, health, and cost. Health Aff (Millwood). 2008;27(3):759–69.CrossRef
2.
go back to reference Riley GF. Administrative and claims records as sources of health care cost data. Med Care. 2009;47(7 Suppl 1):S51–5.CrossRefPubMed Riley GF. Administrative and claims records as sources of health care cost data. Med Care. 2009;47(7 Suppl 1):S51–5.CrossRefPubMed
3.
go back to reference Guglielmo WJ. FTC to doctors: price fixing won’t fly. Med Econ. 2003;80:85. Guglielmo WJ. FTC to doctors: price fixing won’t fly. Med Econ. 2003;80:85.
4.
go back to reference Kauk J, Hill AD, Althausen PL. Healthcare fundamentals. J Orthop Trauma. 2014;28(7 Suppl):S25–41.CrossRefPubMed Kauk J, Hill AD, Althausen PL. Healthcare fundamentals. J Orthop Trauma. 2014;28(7 Suppl):S25–41.CrossRefPubMed
5.
go back to reference Lipscomb J, Yabroff KR, Brown ML, Lawrence W, Barnett PG. Health care costing: data, methods, current applications. Med Care. 2009;47(7 Suppl 1):S1–6.CrossRefPubMed Lipscomb J, Yabroff KR, Brown ML, Lawrence W, Barnett PG. Health care costing: data, methods, current applications. Med Care. 2009;47(7 Suppl 1):S1–6.CrossRefPubMed
6.
go back to reference Hilsenrath P, Eakin C, Fischer K. Price-transparency and cost accounting: challenges for health care organizations in the consumer- driven era. Inquiry. 2015;10:52. Hilsenrath P, Eakin C, Fischer K. Price-transparency and cost accounting: challenges for health care organizations in the consumer- driven era. Inquiry. 2015;10:52.
7.
go back to reference Xu X, Grossetta Nardini HK, Ruger JP. Micro-costing studies in the health and medical literature: protocol for a systematic review. Syst Rev. 2014;3:47.CrossRefPubMedPubMedCentral Xu X, Grossetta Nardini HK, Ruger JP. Micro-costing studies in the health and medical literature: protocol for a systematic review. Syst Rev. 2014;3:47.CrossRefPubMedPubMedCentral
8.
go back to reference Lipscomb J, Ancukiewicz M, Parmigiani G, Hasselblad V, Samsa G, Matchar DB. Predicting the cost of illness: a comparison of alternative models applied to stroke. Med Decis Mak. 1998;18(2 Suppl):S39–56.CrossRef Lipscomb J, Ancukiewicz M, Parmigiani G, Hasselblad V, Samsa G, Matchar DB. Predicting the cost of illness: a comparison of alternative models applied to stroke. Med Decis Mak. 1998;18(2 Suppl):S39–56.CrossRef
9.
go back to reference Rocca WA, Yawn BP, St Sauver JL, Grossardt BR, Melton LJ 3rd. History of the Rochester Epidemiology Project: half a century of medical records linkage in a US population. Mayo Clin Proc. 2012;87(12):1202–13. Epub 2012 Nov 28CrossRefPubMedPubMedCentral Rocca WA, Yawn BP, St Sauver JL, Grossardt BR, Melton LJ 3rd. History of the Rochester Epidemiology Project: half a century of medical records linkage in a US population. Mayo Clin Proc. 2012;87(12):1202–13. Epub 2012 Nov 28CrossRefPubMedPubMedCentral
10.
go back to reference St Sauver JL, Grossardt BR, Leibson CL, Yawn BP, Melton LJ 3rd, Rocca WA. Generalizability of epidemiological findings and public health decisions: an illustration from the Rochester Epidemiology Project. Mayo Clin Proc. 2012;87(2):151–60.CrossRefPubMedPubMedCentral St Sauver JL, Grossardt BR, Leibson CL, Yawn BP, Melton LJ 3rd, Rocca WA. Generalizability of epidemiological findings and public health decisions: an illustration from the Rochester Epidemiology Project. Mayo Clin Proc. 2012;87(2):151–60.CrossRefPubMedPubMedCentral
11.
go back to reference St Sauver JL, Grossardt BR, Yawn BP, Melton LJ 3rd, Rocca WA. Use of a medical records linkage system to enumerate a dynamic population over time: the Rochester epidemiology project. Am J Epidemiol. 2011;173(9):1059–68. Epub 2011 Mar 23CrossRefPubMedPubMedCentral St Sauver JL, Grossardt BR, Yawn BP, Melton LJ 3rd, Rocca WA. Use of a medical records linkage system to enumerate a dynamic population over time: the Rochester epidemiology project. Am J Epidemiol. 2011;173(9):1059–68. Epub 2011 Mar 23CrossRefPubMedPubMedCentral
15.
go back to reference Shwartz M, Young DW, Siegrist R. The ratio of costs to charges: how good a basis for estimating costs? Inquiry. 1995–1996;32(4):476–81. Shwartz M, Young DW, Siegrist R. The ratio of costs to charges: how good a basis for estimating costs? Inquiry. 1995–1996;32(4):476–81.
19.
go back to reference Yawn BP, Yawn RA, Geier GR, Xia Z, Jacobsen SJ. The impact of requiring patient authorization for use of data in medical records research. J Fam Pract. 1998;47(5):361–5.PubMed Yawn BP, Yawn RA, Geier GR, Xia Z, Jacobsen SJ. The impact of requiring patient authorization for use of data in medical records research. J Fam Pract. 1998;47(5):361–5.PubMed
20.
go back to reference Jacobsen SJ, Xia Z, Campion ME, et al. Potential effect of authorization bias on medical record research. Mayo Clin Proc. 1999;74(4):330–8.CrossRefPubMed Jacobsen SJ, Xia Z, Campion ME, et al. Potential effect of authorization bias on medical record research. Mayo Clin Proc. 1999;74(4):330–8.CrossRefPubMed
21.
go back to reference Curtis JL, Harvey DB, Willie S, et al. Causes and costs for ED visits after pediatric adenotonsillectomy. Otolaryngol Head Neck Surg. 2015;152(4):691–6. Epub 2015 Mar 2CrossRefPubMed Curtis JL, Harvey DB, Willie S, et al. Causes and costs for ED visits after pediatric adenotonsillectomy. Otolaryngol Head Neck Surg. 2015;152(4):691–6. Epub 2015 Mar 2CrossRefPubMed
22.
go back to reference Meier JD, Zhang Y, Greene TH, Curtis JL, Srivastava R. Variation in pediatric outpatient adenotonsillectomy costs in a multihospital network. Laryngoscope. 2015;125(5):1215–20. Epub 2014 Nov 1CrossRefPubMed Meier JD, Zhang Y, Greene TH, Curtis JL, Srivastava R. Variation in pediatric outpatient adenotonsillectomy costs in a multihospital network. Laryngoscope. 2015;125(5):1215–20. Epub 2014 Nov 1CrossRefPubMed
23.
go back to reference Filice GA, Nyman JA, Lexau C, et al. Excess costs and utilization associated with methicillin resistance for patients with Staphylococcusaureus infection. Infect Control Hosp Epidemiol. 2010;31(4):365–73.CrossRefPubMed Filice GA, Nyman JA, Lexau C, et al. Excess costs and utilization associated with methicillin resistance for patients with Staphylococcusaureus infection. Infect Control Hosp Epidemiol. 2010;31(4):365–73.CrossRefPubMed
24.
go back to reference Abbott MM, Meara JG. Value-based cleft lip-cleft palate care: a progress report. Plast Reconstr Surg. 2010;126(3):1020–5.CrossRefPubMed Abbott MM, Meara JG. Value-based cleft lip-cleft palate care: a progress report. Plast Reconstr Surg. 2010;126(3):1020–5.CrossRefPubMed
25.
go back to reference Chang SB, Askew RL, Xing Y, et al. Prospective assessment of postoperative complications and associated costs following inguinal lymph node dissection (ILND) in melanoma patients. Ann Surg Oncol. 2010;17(10):2764–72. Epub 2010 Mar 25CrossRefPubMedPubMedCentral Chang SB, Askew RL, Xing Y, et al. Prospective assessment of postoperative complications and associated costs following inguinal lymph node dissection (ILND) in melanoma patients. Ann Surg Oncol. 2010;17(10):2764–72. Epub 2010 Mar 25CrossRefPubMedPubMedCentral
26.
go back to reference Suh DC, Powers CA, Barone JA, Shin H, Kwon J, Goodin S. Full costs of dispensing and administering fluorouracil chemotherapy for outpatients: a microcosting study. Res Social Adm Pharm. 2010;6(3):246–56.CrossRefPubMedPubMedCentral Suh DC, Powers CA, Barone JA, Shin H, Kwon J, Goodin S. Full costs of dispensing and administering fluorouracil chemotherapy for outpatients: a microcosting study. Res Social Adm Pharm. 2010;6(3):246–56.CrossRefPubMedPubMedCentral
27.
go back to reference Nyman JA, Lees CH, Bockstedt LA, et al. Cost of screening intensive care unit patients for methicillin-resistant Staphylococcus aureus in hospitals. Am J Infect Control. 2011 Feb;39(1):27–34.CrossRefPubMed Nyman JA, Lees CH, Bockstedt LA, et al. Cost of screening intensive care unit patients for methicillin-resistant Staphylococcus aureus in hospitals. Am J Infect Control. 2011 Feb;39(1):27–34.CrossRefPubMed
28.
go back to reference Shrestha RK, Gardner L, Marks G, et al. Estimating the cost of increasing retention in care for HIV-infected patients: results of the CDC/HRSA retention in care trial. J Acquir Immune Defic Syndr. 2015;68(3):345–50.CrossRefPubMedPubMedCentral Shrestha RK, Gardner L, Marks G, et al. Estimating the cost of increasing retention in care for HIV-infected patients: results of the CDC/HRSA retention in care trial. J Acquir Immune Defic Syndr. 2015;68(3):345–50.CrossRefPubMedPubMedCentral
29.
go back to reference Delgado RI, Swint JM, Lairson DR, Johnson NP, Gould KL, Sdringola S. Cost analysis of PET and comprehensive lifestyle modification for the reversal of atherosclerosis. J Nucl Med. 2014;55(1):80–7. Epub 2013 Dec 12CrossRefPubMed Delgado RI, Swint JM, Lairson DR, Johnson NP, Gould KL, Sdringola S. Cost analysis of PET and comprehensive lifestyle modification for the reversal of atherosclerosis. J Nucl Med. 2014;55(1):80–7. Epub 2013 Dec 12CrossRefPubMed
30.
go back to reference Schousboe JT, Paudel ML, Taylor BC, et al. Estimating true resource costs of outpatient care for Medicare beneficiaries: standardized costs versus Medicare payments and charges. Health Serv Res. 2015; [Epub ahead of print] Schousboe JT, Paudel ML, Taylor BC, et al. Estimating true resource costs of outpatient care for Medicare beneficiaries: standardized costs versus Medicare payments and charges. Health Serv Res. 2015; [Epub ahead of print]
31.
go back to reference Schousboe JT, Paudel ML, Taylor BC, et al. Estimation of standardized hospital costs from Medicare claims that reflect resource requirements for care: impact for cohort studies linked to Medicare claims. Health Serv Res. 2014;49(3):929–49. Epub 2014 Jan 24CrossRefPubMedPubMedCentral Schousboe JT, Paudel ML, Taylor BC, et al. Estimation of standardized hospital costs from Medicare claims that reflect resource requirements for care: impact for cohort studies linked to Medicare claims. Health Serv Res. 2014;49(3):929–49. Epub 2014 Jan 24CrossRefPubMedPubMedCentral
32.
go back to reference Ritzwoller DP, Goodman MJ, Maciosek MV, et al. Creating standard cost measures across integrated health care delivery systems. J Natl Cancer Inst Monogr. 2005;35:80–7.CrossRef Ritzwoller DP, Goodman MJ, Maciosek MV, et al. Creating standard cost measures across integrated health care delivery systems. J Natl Cancer Inst Monogr. 2005;35:80–7.CrossRef
33.
go back to reference Mabry CD, Kalkwarf KJ, Betzold RD, et al. Determining the hospital trauma financial impact in a statewide trauma system. J Am Coll Surg. 2015;220(4):446–58. Epub 2015 Jan 9CrossRefPubMedPubMedCentral Mabry CD, Kalkwarf KJ, Betzold RD, et al. Determining the hospital trauma financial impact in a statewide trauma system. J Am Coll Surg. 2015;220(4):446–58. Epub 2015 Jan 9CrossRefPubMedPubMedCentral
34.
go back to reference Bittl JA, Cohen DJ, Seek MM, Feldman RL. Economic analysis of angiography and preemptive angioplasty to prevent hemodialysis- access thrombosis. Catheter Cardiovasc Interv. 2010;75(1):14–21.PubMed Bittl JA, Cohen DJ, Seek MM, Feldman RL. Economic analysis of angiography and preemptive angioplasty to prevent hemodialysis- access thrombosis. Catheter Cardiovasc Interv. 2010;75(1):14–21.PubMed
35.
go back to reference Meenan RT, Goodman MJ, Fishman PA, Hornbrook MC, O’Keeffe-Rosetti MC, Bachman DJ. Issues in pooling administrative data for economic evaluation. Am J Manag Care. 2002;8(1):45–53.PubMed Meenan RT, Goodman MJ, Fishman PA, Hornbrook MC, O’Keeffe-Rosetti MC, Bachman DJ. Issues in pooling administrative data for economic evaluation. Am J Manag Care. 2002;8(1):45–53.PubMed
38.
go back to reference Wagner JL, Alberts SR, Sloan JA, et al. Incremental costs of enrolling cancer patients in clinical trials: a population-based study. J Natl Cancer Inst. 1999;91(10):847–53. Erratum in: J Natl Cancer Inst. 2000;92(2):164–5CrossRefPubMed Wagner JL, Alberts SR, Sloan JA, et al. Incremental costs of enrolling cancer patients in clinical trials: a population-based study. J Natl Cancer Inst. 1999;91(10):847–53. Erratum in: J Natl Cancer Inst. 2000;92(2):164–5CrossRefPubMed
39.
go back to reference Dunlay SM, Shah ND, Shi Q, et al. Lifetime costs of medical care after heart failure diagnosis. Circ Cardiovasc Qual Outcomes. 2011;4(1):68–75. Epub 2010 Dec 7CrossRefPubMed Dunlay SM, Shah ND, Shi Q, et al. Lifetime costs of medical care after heart failure diagnosis. Circ Cardiovasc Qual Outcomes. 2011;4(1):68–75. Epub 2010 Dec 7CrossRefPubMed
40.
go back to reference Cook D, Thompson JE, Habermann EB, et al. From ‘solution shop’ model to ‘focused factory’ in hospital surgery: increasing care value and predictability. Health Aff (Millwood). 2014;33(5):746–55.CrossRef Cook D, Thompson JE, Habermann EB, et al. From ‘solution shop’ model to ‘focused factory’ in hospital surgery: increasing care value and predictability. Health Aff (Millwood). 2014;33(5):746–55.CrossRef
41.
go back to reference Kremers HM, Visscher SL, Kremers WK, Naessens JM, Lewallen DG. The effect of obesity on direct medical costs in total knee arthroplasty. J Bone Joint Surg Am. 2014;96(9):718–24.CrossRefPubMed Kremers HM, Visscher SL, Kremers WK, Naessens JM, Lewallen DG. The effect of obesity on direct medical costs in total knee arthroplasty. J Bone Joint Surg Am. 2014;96(9):718–24.CrossRefPubMed
42.
go back to reference Maradit Kremers H, Visscher SL, Kremers WK, Naessens JM, Lewallen DG. Obesity increases length of stay and direct medical costs in total hip arthroplasty. Clin Orthop Relat Res. 2014;472(4):1232–9. Epub 2013 Oct 8CrossRefPubMed Maradit Kremers H, Visscher SL, Kremers WK, Naessens JM, Lewallen DG. Obesity increases length of stay and direct medical costs in total hip arthroplasty. Clin Orthop Relat Res. 2014;472(4):1232–9. Epub 2013 Oct 8CrossRefPubMed
43.
go back to reference Warner DO, Borah BJ, Moriarty J, Schroeder DR, Shi Y, Shah ND. Smoking status and healthcare costs in the perioperative period: a population-based study. JAMA Surg. 2014;149(3):259–66.CrossRefPubMedPubMedCentral Warner DO, Borah BJ, Moriarty J, Schroeder DR, Shi Y, Shah ND. Smoking status and healthcare costs in the perioperative period: a population-based study. JAMA Surg. 2014;149(3):259–66.CrossRefPubMedPubMedCentral
44.
go back to reference Cohoon KP, Leibson CL, Ransom JE, et al. Direct medical costs attributable to venous thromboembolism among persons hospitalized for major operation: a population-based longitudinal study. Surgery. 2015;157(3):423–31. Epub 2015 Jan 26CrossRefPubMedPubMedCentral Cohoon KP, Leibson CL, Ransom JE, et al. Direct medical costs attributable to venous thromboembolism among persons hospitalized for major operation: a population-based longitudinal study. Surgery. 2015;157(3):423–31. Epub 2015 Jan 26CrossRefPubMedPubMedCentral
45.
go back to reference Suri RM, Thompson JE, Burkhart HM, et al. Improving affordability through innovation in the surgical treatment of mitral valve disease. Mayo Clin Proc. 2013;88(10):1075–84.CrossRefPubMed Suri RM, Thompson JE, Burkhart HM, et al. Improving affordability through innovation in the surgical treatment of mitral valve disease. Mayo Clin Proc. 2013;88(10):1075–84.CrossRefPubMed
Metadata
Title
Developing a standardized healthcare cost data warehouse
Authors
Sue L. Visscher
James M. Naessens
Barbara P. Yawn
Megan S. Reinalda
Stephanie S. Anderson
Bijan J. Borah
Publication date
01-12-2017
Publisher
BioMed Central
Published in
BMC Health Services Research / Issue 1/2017
Electronic ISSN: 1472-6963
DOI
https://doi.org/10.1186/s12913-017-2327-8

Other articles of this Issue 1/2017

BMC Health Services Research 1/2017 Go to the issue