Developing a standardized healthcare cost data warehouse

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

Research output: Contribution to journalArticle

25 Citations (Scopus)

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.

Original languageEnglish (US)
Article number396
JournalBMC Health Services Research
Volume17
Issue number1
DOIs
StatePublished - Jun 12 2017

Fingerprint

Health Care Costs
Costs and Cost Analysis
Information Storage and Retrieval
Registries
Fee Schedules
Research Personnel
Electronic Health Records
Economic Inflation
Medicare
Research
Health Personnel
Medical Records
Patient Care
Cohort Studies
Databases
Delivery of Health Care

Keywords

  • Cost data warehouse
  • Microcosting
  • Olmsted County Healthcare Expenditure and Utilization Database (OCHEUD)
  • Rochester Epidemiology Project (REP)
  • Standardized healthcare costs

ASJC Scopus subject areas

  • Health Policy

Cite this

Developing a standardized healthcare cost data warehouse. / Visscher, Sue L.; Naessens, James M; Yawn, Barbara P.; Reinalda, Megan S.; Anderson, Stephanie S.; Borah, Bijan J.

In: BMC Health Services Research, Vol. 17, No. 1, 396, 12.06.2017.

Research output: Contribution to journalArticle

Visscher, Sue L. ; Naessens, James M ; Yawn, Barbara P. ; Reinalda, Megan S. ; Anderson, Stephanie S. ; Borah, Bijan J. / Developing a standardized healthcare cost data warehouse. In: BMC Health Services Research. 2017 ; Vol. 17, No. 1.
@article{935b362a8db74162bd9b574ae117433d,
title = "Developing a standardized healthcare cost data warehouse",
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.",
keywords = "Cost data warehouse, Microcosting, Olmsted County Healthcare Expenditure and Utilization Database (OCHEUD), Rochester Epidemiology Project (REP), Standardized healthcare costs",
author = "Visscher, {Sue L.} and Naessens, {James M} and Yawn, {Barbara P.} and Reinalda, {Megan S.} and Anderson, {Stephanie S.} and Borah, {Bijan J}",
year = "2017",
month = "6",
day = "12",
doi = "10.1186/s12913-017-2327-8",
language = "English (US)",
volume = "17",
journal = "BMC Health Services Research",
issn = "1472-6963",
publisher = "BioMed Central",
number = "1",

}

TY - JOUR

T1 - Developing a standardized healthcare cost data warehouse

AU - Visscher, Sue L.

AU - Naessens, James M

AU - Yawn, Barbara P.

AU - Reinalda, Megan S.

AU - Anderson, Stephanie S.

AU - Borah, Bijan J

PY - 2017/6/12

Y1 - 2017/6/12

N2 - 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.

AB - 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.

KW - Cost data warehouse

KW - Microcosting

KW - Olmsted County Healthcare Expenditure and Utilization Database (OCHEUD)

KW - Rochester Epidemiology Project (REP)

KW - Standardized healthcare costs

UR - http://www.scopus.com/inward/record.url?scp=85020387115&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=85020387115&partnerID=8YFLogxK

U2 - 10.1186/s12913-017-2327-8

DO - 10.1186/s12913-017-2327-8

M3 - Article

C2 - 28606088

AN - SCOPUS:85020387115

VL - 17

JO - BMC Health Services Research

JF - BMC Health Services Research

SN - 1472-6963

IS - 1

M1 - 396

ER -