State Data
Resource Center

Resources for States Integrating Medicare and Medicaid Data

The SDRC Team offers State Medicaid Agencies advice on how to use Medicare data for Medicare-Medicaid care coordination and program integrity activities. In addition to this advice, the following external websites can provide State Medicaid Agencies with detailed information on the variables and layouts of Medicare data:

  • CCW Data
  • The Chronic Condition Warehouse (CCW) provides information on Medicare Parts A & B and Assessments (MDS, OASIS, Swing Bed, and IRF-PAI) data.
  • Enhancements to the CCW
  • The CCW contains Medicare and Medicaid claims, eligibility, and enrollment data. The CCW also contains indicators (i.e., "flags") for 27 chronic conditions, which were originally chosen based on their high prevalence among elderly Medicare-only beneficiaries. MMCO has expanded these flags for all years of existing data (2000-2008) to include the following: 1) the Medicaid-only population; 2) identification of individuals among the Medicare-Medicaid enrollee population with the original 27 conditions for both Medicare and Medicaid claims; rather than solely their Medicare experience; and 3) additional flags for all three populations with conditions that are known to affect Medicare-Medicaid enrollees with disabilities and Medicaid-only beneficiaries.
    MMCO developed and has made available CCW flags for 9 mental health conditions, tobacco use, and 15 conditions related to intellectual, developmental, and physical disability with the assistance of subject matter experts.
  • Coordination of Benefits Agreement (COBA) Companion Guides
  • COBC’s COBA HIPAA 5010 Companion Guide provides information for preparing and testing HIPAA 5010 COBA transactions. This guide provides information in understanding what values will appear in various fields on the outbound 837 claims.
    Washington Publishing Company (WPC) provides the HIPAA 5010 837-I and 837-P Technical Report Version 3 (TR-3) Guides These comprehensive guides fully lay out the rules for HIPAA implementation of the 837 claims. There is a charge for these consolidated guides through WPC.
  • Medicare-Medicaid Linked Enrollee Analytic Data Source (MMLEADS) Version 2.0
  • MMLEADS is a suite of 2006-2012 linked data files for Medicare-Medicaid eligibility, enrollment, utilization, and expenditure data. This data source includes health care information for all dually eligible Medicare-Medicaid enrollees, and, for comparison purposes, all Medicare-only beneficiaries and Medicaid-only beneficiaries with disabilities. MMLEADS provides utilization and expenditure metrics based on MMCO’s preferred method of identifying Medicare-Medicaid enrollees (e.g., from the monthly "State MMA File"), while also keeping the flexibility to generate metrics according to other user-defined criteria. MMLEADS contains a linking variable for linking to other data (e.g., survey, assessment, claims) that are housed in the Chronic Condition Warehouse (CCW).
  • SDRC Tip Sheet – Public Use Files (PUFs)
  • This tip sheet contains a list of free, publicly available data files that include Medicare and Medicaid services at the beneficiary and provider levels, data by state, and data file guides.
  • MMLEADS Public Use File (PUF)
  • The MMLEADS Public Use File (PUF) data are based off MMLEADS, version 2.0. The 2006-2012 aggregated data include information on full and partial Medicare-Medicaid enrollees, and also for comparison purposes - Medicare only enrollees and Medicaid only (eligible via disability) enrollees. The MMLEADS PUF data and User Guide are available for download.
  • State-CMS File Exchanges
  • Since 2005, State Medicaid Agencies have been submitting files at least monthly to CMS to identify all dually eligible beneficiaries. This includes full-benefit dual-eligible beneficiaries and partial-benefit dual-eligible beneficiaries (i.e., those who get Medicaid help with Medicare premiums, and often for cost-sharing). The file is called the "MMA File" (after the Medicare Prescription Drug, Improvement, and Modernization Act of 2003), but occasionally referred to as the "State Phasedown file."

    The MAPD State User Guide has additional information pertinent to the content of multiple monthly files. To access the user guide, download the following document: MAPD State User Guide .

    State Medicaid Agencies can also download the following data documentation:
  • Prescription Drug Event (PDE) File Layout
  • The PDE File Layout spreadsheet describes both the structure and variables contained within PDE files.
  • Part D Netting Explanation
  • The Part D Netting Explanation document explains the data elements that CMS has developed to enable PDE users to identify and net unique prescription drug claims.
  • Integrating Monthly Files into Part D Final Action
  • The Integrating Monthly Files into Part D Final Action document explains the additional steps necessary to identify final action records within the Prescription Drug Event data when incorporating the monthly update files.

    For additional technical advice on Medicare data variables and layouts, contact the SDRC Team by phone at (877) 657-9889 or by email at