HERC: Data FAQs - VA Cost Data
Attention A T users. To access the menus on this page please perform the following steps. 1. Please switch auto forms mode to off. 2. Hit enter to expand a main menu option (Health, Benefits, etc). 3. To enter and activate the submenu links, hit the down arrow. You will now be able to tab or arrow up or down through the submenu options to access/activate the submenu links.
Locator
Contact
Search HERC

Data FAQs - VA Cost Data

Menu
Menu

By category
View All |  Comparing Costs |  Cost Analysis |  Determine Cost of X |  Missing and Outlier Data |  Non-VA Costs |  Pharmacy |  Staff and Labor |  VA Cost Data

+How do I determine the annual cost of VA medical care for a patient with X condition?
April 2023

First, determine how you will define the condition of interest (e.g., diagnosis codes), and create a comprehensive list of codes. When setting the cohort parameters, consider whether patients can enter and/or leave the cohort (e.g., if they have a condition that is curable) or if there is a time frame for the diagnosis.

Next, choose which cost data is the best fit for the study (Managerial Cost Accounting (MCA) data or Health Economics Resource Center (HERC) Average Cost data). For more information on the two data sources, review the question Which VA cost data source should I use: HERC or MCA?.

After choosing your cost data source, determine how you want to calculate annual cost, e.g., calendar year, fiscal year, a year from randomization date. Determine how you want to treat stays that continue beyond the study year. Define the boundaries of the data you want to include. Do you want to include inpatient, outpatient and pharmacy data? Do you want to include VA data only; VA data plus data for care paid for by VA but received in the community (i.e. community care data); or VA data, community care data, and non-VA data (e.g. Medicare)?

After DART approval, researchers will work with a VINCI data manager to pull data for the defined cohort. Merge the cohort file with the cost data. For more information on how to merge these data, see VINCI documentation on linking patient data in CDW, available on VINCI Central https://vincicentral.vinci.med.va.gov/SitePages/Home.aspx (VA intranet only). Consider whether you want to include all costs or only costs related to the diagnosis. If you want to limit to costs for a specific condition, consider partnering with a clinical expert and/or limiting to a condition with clearly defined associated costs.

 

+How do I determine the total cost for a patient/cohort in X time frame?
April 2023

First, determine how you will define the condition of interest (e.g., diagnosis codes), and create a comprehensive list of codes.

Next, determine whether you want to use Managerial Cost Accounting (MCA) data or Health Economics Resource Center (HERC) Average Cost data. For more information on the two data sources, review the question Which VA cost data source should I use: HERC or MCA?

After DART approval, researchers will work with a VINCI data manager to pull data for the defined cohort. Merge the cohort file with the cost data and pull costs. For more information on how to merge these data, see VINCI documentation on linking patient data in CDW, available on the VINCI intranet site https://vaww.vinci.med.va.gov/ (VA intranet only). Link your cohort file to any other data sources your team has decided to include (e.g., Community Care or Medicare).

As you design your analysis plan, consider which data you want to include. Do you want to include inpatient, outpatient, and pharmacy costs? Do you want to include VA data only; VA data plus data for care paid for by VA but received in the community (i.e., community care data); or VA data, community care data, and non-VA data (e.g., Medicare)? Recognize the unknown costs that are omitted from your analyses, e.g. Medicare Advantage, Medicaid, and private insurance. Consider whether cleaned datasets already exist for your cohort, e.g., Health and Retirement Survey (HRS) data or Medical Expenditure Panel Survey (MEPS) data.

for additional advice including sample SAS files, contact HERC at herc@va.gov.

+Why are some records in CDW Outpatient data missing a corresponding record in the HERC Outpatient Average Cost Dataset?
April 2021

The HERC outpatient cost estimates are created using the MedSAS outpatient dataset. (Through FY17, the MedSAS Outpatient file was created using National Patient Care Database (NPCD) data; beginning FY18, it is sourced from CDW data). The MedSAS outpatient data do not include all the records that can be found in the CDW Outpatient schema; MedSAS files only include a subset of visits that are considered “workload,” i.e., an encounter that is billable in the private sector. A visit is considered an encounter when it involves professional contact with a patient for diagnosis, evaluation, or treatment. (Therefore, administrative or duplicate records would not count as workload.) Data users can look at WorkloadLogicFlag within the CDW Outpatient schema to see whether a visit is considered workload. More information about the Workload logic flag and can be found in Appendix D of VIReC’s CDW Outpatient Factbook (available on the VIReC intranet site). Note that while the Workload logic flag is the primary filter, some additional logic is also applied to create the final MedSAS Outpatient dataset.

+How do I determine the cost of procedure X at VA?
October 2020

To determine the cost of procedure X at VA, first identify the procedure codes of interest. CPT codes are used for outpatient data, while ICD-10 procedure codes are used for inpatient care. Note that some inpatient procedures are captured with CPT, but that is the discretion of the physician. VA employs professional coders to enter ICD-10 codes for inpatient care, so best to use these.

You can either use the MCA National Data Extracts (NDEs) or HERC Average Cost data to identify health care costs. Because neither data source contains sufficient clinical information such as procedures, you will first need to use the procedure codes to extract encounters of interest from the encounter files (i.e., MedSAS, CDW, OMOP). For example, if you were interested in cataract, you could extract all encounters where one of the CPT codes is 66984 (basic cataract) and 66982 (complex cataract). This would yield all cataracts for a given period of time and/or location. You would then merge these encounters to the HERC or MCA data. See HERC's Average Cost guidebooks or the MCA NDE Guidebook for details on merging datasets.

Outpatient procedures using MCA data: MCA OUT NDE contains outpatient costs per clinic stop per day. Once you’ve merged your encounter and cost datasets, you can use the Total Cost variable (ActTotCost or ocst_tot) in the MCA Outpatient (OUT) NDE to determine the cost of the encounter associated with your procedure of interest for all outpatient encounters.

Outpatient procedures using HERC Average Cost data: HERC outpatient average cost data contain a VA cost estimate that is based on hypothetical Medicare reimbursement per CPT code. HERC costs are reconciled so that the estimates tally to actual national VA expenditures for that type of care. HERC Outpatient average cost estimates include the HERC Value (PAYMHERC), the National VA average cost (COSTN), and the local VA average cost (COSTL) for each encounter.

Inpatient procedures using MCA Data: Both the Discharge (DISCH) and Treating Specialty (TRT) NDEs contain information about the cost of inpatient stays. One advantage to using the TRT NDE is that a new record is created for each change in treating specialty during an encounter. This can be used to limit costs to those related to the procedure of interest and remove unrelated costs (e.g. the cost of long-term care). Use the Placeholder Total Cost variable (TotCost or tcst_tot) to determine costs for the inpatient stay.

Inpatient procedures using HERC Average Cost Data: HERC Inpatient Average Cost data contain the national average cost of a hospital stay given its Diagnosis Related Group (DRG), overall length of stay, and days in intensive care. Files include local cost (costl) and national cost (costn) estimates. The average cost method assigns the same cost to all inpatient stays with the same demographic and discharge information. Therefore, stays with identical characteristics will have the same cost. if you are interested in comparing the cost of two procedures, these data may not be appropriate.

The costs described here are the costs associated with the encounter for the procedure of interest. Depending on your study, you may want to consider whether to include additional costs (e.g. follow up visits, travel time, medication costs) or break down costs to the department level, using the Intermediate Product Department (IPD) Inpatient and Outpatient NDEs.

For more information on MCA NDEs, visit HERC’s MCA NDEs webpage. Information on HERC Inpatient and Outpatient Average Cost data is available in the Average Cost guidebooks.

+How do I determine the cost of treating a patient in X department/clinic stop?
February 2020

First, determine which VA cost data source better fits your study’s needs: Managerial Cost Accounting (MCA) data or Health Economics Resource Center (HERC) Average Cost data. Both data sources include clinic stop. For more information on the two data sources, review the question Which VA cost data source should I use: HERC or MCA?

Are you interested in costs for a specific cohort? If so, merge the cohort file to the cost data (HERC or MCA). For more information on how to merge these data, see VINCI documentation on linking patient data in CDW, available on the VINCI intranet site https://vaww.vinci.med.va.gov/ (VA intranet only).

Consider whether you are looking at the cost for a given time frame or for select VA Medical Centers. If so, limit the data accordingly. Consider also whether to include all costs (fixed and/or variable). You can then limit to the specific clinic stop to calculate the average cost of treating a patient.

+How do I deal with observations that show pharmacy costs as negative?
January 2020

Negative costs in the MCA pharmacy data are often due to a medication being returned, and data users should treat these negative costs as valid and keep these costs in the dataset. See the guidebook Research Guide to the Managerial Cost Accounting National Cost Extracts for additional details about the reasons for the presence of negative costs. We recommend applying cost cleaning procedures (see the question How do I correct outliers in pharmacy data?) to the absolute value of the cost and retaining the original negative sign.

+Which VA cost data source should I use: HERC or MCA?
November 2019

There are two main sources of encounter-level cost data in VA administrative data: Managerial Cost Accounting (MCA) data and Health Economics Resource Center (HERC) Average Cost data. VA researchers and operations users who need to evaluate costs may find themselves asking, “Which source of VA cost data is best for my project?” These datasets are created for different purposes and are built using different methodology, so understanding the characteristics of both datasets is important before deciding which to use.

We provide a brief summary to help researchers and operations users determine which VA cost data source is best for their project needs.

Purpose of the data

MCA data is created using a local, activity-based method and is the official managerial cost accounting system for the entire VA. Each VAMC determines the relative value units of products, the components of encounters, and then uses staff labor mapping along with RVUs to assign costs to encounters. MCA data contain the cost of each VA hospital stay, outpatient visit, and dispensed outpatient prescription. Since MCA data are designed for management, users will find specific cost information for encounters. MCA is the most frequently used source of data for VA economic research.

HERC Average Cost data represents the estimated cost of each VA encounter. These estimates are created by distributing VA aggregate costs to patient encounter-level utilization using the hypothetical Medicare payment for each service. HERC Average Cost data include national estimates which eliminates the geographic variations in cost for similar encounters. HERC Average Cost data are designed for research; the purpose of these data is for users to quickly understand the average cost of all VA health care services and compare costs to systems outside VA (e.g. Medicare).

Advantages of MCA data

  • MCA cost estimates reflect facility differences in the production of health care services
  • MCA includes pharmacy cost data
  • MCA includes state nursing home stays
  • MCA data are considered more precise than HERC data

Advantages of HERC Average Cost data

  • HERC data provides costs that are consistent across similar encounters and across VAMCs
  • HERC Average Cost data allow for comparison to non-VA healthcare costs

MCA data is best when

  • You need local cost estimates
  • You want to compare costs between VA facilities, providers, or procedures (Make sure to control for geographic wage differences, if applicable)
  • When conducting implementation work where you want to focus on variable costs rather than total costs

HERC data is best when

  • You want to generalize VA costs to non-VA health systems
  • You want data that is already cleaned and summarized
  • The precise costs of specific services are not important

Recommendation

Consider the specific needs and goals of your project. If possible, use both cost data sources; one as the primary data source and one as a sensitivity analysis.

Learn More

More information is available in the seminar VA Costs: HERC versus MCA.

Visit the Managerial Cost Accounting (MCA) webpage and the HERC Average Cost Inpatient and Outpatient pages for more information about each of these data sources.

+What is the correlation between CMS and MCA RVUs?
November 2019

Although they share the same name, Relative Value Units (RVUs) created for the Centers for Medicare and Medicaid Services (CMS) are not the same RVUs used in the VA Managerial Cost Accounting (MCA) system.

MCA RVUs

MCA is an activity-based costing system. Activity-based costing combines activity reports, financial data, workload, and intermediate products used in encounters and hospitals stays (Azoulay 2007). These cost estimates are regarded as a more accurate measure of resource use than cost-adjusted charges (Ross 2004; Udpa 2006). RVUs are essential part of MCA and other activity-based costing systems.

MCA RVUs are used to find the cost of intermediate products, specific health care services such as a cholesterol test, a chest x-ray, or a 20-minute clinic visit. MCA tracks the cost of each department and the intermediate products it produces. Each intermediate product has an RVU. The total cost of the department is divided by number of RVUs it produces, giving the cost per RVU, so that the cost of each intermediate product can be found. The cost of a hospital stay or outpatient visits is found by adding together the cost of all the intermediate products used in that stay (or visit).

MCA tracks each type of cost separately (e.g., labor, supplies, management overhead, contract services, and as many as 13 different cost types). Each type of cost has its own set of RVUs. MCA has a standard set of RVUs, but these may be tailored to reflect the specifics of the cost of production at each medical center or department within the medical center. The result is an estimate of costs based on the cost of the department and the intermediate products it produces. MCA cost estimates thus reflect the variations in cost that result from differences in staff and supply costs, efficiency, and the mix of intermediate products used in providing care. The resulting cost estimate reflects resources used in providing care, providing researchers with the opportunity to study variations in cost. For example, HERC researchers have used MCA to find the difference cost that result from different techniques for Coronary Artery Bypass Graft (CABG) surgery.

While the MCA estimates can be highly accurate, the method has the potential for occasional errors. Incorrect mapping of costs and products can distribute the cost of a department to the wrong products or to too few products. MCA has worked over the years to develop auditing and cleaning systems, but researchers should verify MCA cost data. MCA National Data Extracts are available at CDW. Record layouts, metadata, and the Technical Guide are available on the MCA Office website (intranet only).

CMS RVUs

The RVUs developed for the Centers for Medicare and Medicaid Services (CMS) are used to calculate payments to providers. These RVUs do not represent cost, but were designed to compensate providers based on time, mental effort, technical skill, judgment, and stress. Services are characterized by Current Procedure and Terminology (CPT) code, and separate RVUs are created for physician work, practice expense, and malpractice expense. If the researcher knows the CPT coding of a service, CMS

RVUs can be used to estimate the Medicare reimbursement. Medicare reimbursement is sometimes used as a surrogate for costs; it is used that way in the HERC outpatient average cost datasets.

There are limitations with the CMS RVU approach. Notably, the source of CMS RVUs, the Resource Based Relative Value System (RBRVS), was not designed to reflect the actual costs of care, but to set reimbursement as part of a public process that includes comment and input from medical specialty organizations. Critics of the RBRVS reimbursement system say that it is fundamentally flawed because of its reliance on CPT codes to represent provider services. This criticism holds that the CPT coding system can distinguish greater complexity for procedures but not for evaluation and management services (Kumetz and Goodson 2013). MCA does not use RBRVS RVUs, but instead bases its relative values on measures of resource use, such are minutes of time in the operating room or length of the clinic visit.

Given that MCA and CMS RVUs are different entities, the correlation between CMS and MCA is an empirical question. HERC creates the HERC average cost data using RVUs from CMS and other sources which researchers could use to test the correlation. Studies by Chapko et al (2008) and Phibbs and Schmit (2007) indicate that the datasets are highly correlated.

References

  • Azoulay A, Doris NM, Filion KB, Caron J, Pilote L, Eisenberg MJ. The use of the transition cost accounting system in health services research. Cost Eff Resour Alloc. 2007;5:11.
  • Chapko M, Liu C, Perkins M, et al. Equivalence of two healthcare costing methods: bottom-up and top-down. Health Econ (2008); 18(10):1188-201.
  • Kumetz E, Goodson JD. The undervaluation of evaluation and management professional services: the lasting impact of current procedural terminology code deficiencies on physician payment. Chest (2013); 144(3):740-745.
  • Phibbs CS, Schmitt SK. A Comparison of Outpatient Costs from the FY 2001 HERC and DSS National Data Extract Datasets. Technical Report 14. Menlo Park CA. VA Palo Alto, Health Economics Resource Center; 2007.
  • Ross TK. Analyzing health care operations using ABC. J Health Care Finance. Spring 2004;30(3):1-20.
  • Udpa S. Activity-based costing for hospitals. Health Care Manage Rev. Summer 1996;21(3):83-96.

+Can I use DRG in VA administrative data to understand cost or resource use?
November 2019

Diagnosis-Related Groups (DRGs) were created by the Health Care Financing Administration (now CMS) in the early 1980s for inpatient payment. Although VA has included the DRG variable, it does not have the same meaning within VA. VA has a different definition of inpatient stay than CMS. Imagine a VA patient transferred from medical/surgical, to nursing home, back to medical/surgical, then to rehab. If these bedsections were contiguous, then VA considers this one stay and assigns it one DRG. However, CMS would treat this as more than one stay (possibly four) and assign a DRG to each. Additionally, there is a lot that affects costs and resource use beyond DRG. Therefore, we suggest using the MCA or HERC data rather than DRG to understand cost or resource use.

HERC has created guidebooks for researchers interesting in learning more about MCA and HERC data. The inpatient data webpage contains more information on DRG and how that goes into estimating payment.