BASE Hospice and Prescription Drug Utilization Files

Hospice and Part D prescription drug utilization data files contain both fee-for service (FFS) or Medicare Advantage (MA) enrollees; therefore, they are listed here as other utilization data.

NOTE: Although the MedPAR file does also contain both FFS and MA enrollee utilization data, because the MedPAR includes complete in-patient and skilled nursing facility claims among FFS enrollees, but only “information only” bills or “shadow bills” for MA enrollees, the MedPAR file is listed with the FFS claim files.

Hospice

The Hospice file contains claims data submitted by Hospice providers. Some of the information contained in this file includes the level of hospice care received (e.g., routine home care, inpatient respite care), terminal diagnosis (ICD-9 or ICD-10 diagnosis), the dates of service, reimbursement amount, Hospice provider number, and beneficiary demographic information.

There are multiple parts to this file: base file, revenue center file, condition code file, occurrence code file, span code file, value code file, and demonstration/innovation code file.

View ResDAC’s Hospice File OverviewExternal Web Site Policy
View CCW’s Medicare Claims Record Layout and CodebookExternal Web Site Policy

Medicare Part D Data

In July 2006 Medicare coverage was expanded to include prescription drugs under Medicare Part D, Medicare beneficiaries can enroll in Part D, and either opt to pay the Part D premium out of pocket or have their premiums paid for them, such as for low-income persons receiving medical assistance from their state. The Part D data included in SEER-Medicare begin in 2007.

There are multiple files that are associated with the Part D data:

  • Part D Drug Event File (PDE) DocumentationExternal Web Site Policy - This file includes all transactions covered by Medicare prescription drug plan for both Prescription Drug Plans (PDPs) and Medicare Advantage Prescription Drug Plans (MA-PDs).
    • Drug Characteristic FileExternal Web Site Policy - variables appended to the PDE that describe the drug listed (e.g., NDC, brand and generic name)
  • Plan Characteristics FileExternal Web Site Policy - contains Medicare Advantage plan and Prescription Drug Plan information separated into six subfiles: base/benefit file, premium file, cost sharing tier file, service area file, special needs plans file, and multi-year crosswalk file. The information in the Plan Characteristics File can be linked to the PDE and the MBSF files (using contract and plan identifiers) to assess for variation in utilization and costs by plan type.
    • NOTE: The Multi-year Crosswalk File allows the same contract-plan to be tracked across years (Part D: 2007+; Part C 2015+), because contract and plan identifiers can change on an annual basis. The relationship code and relationship description variables clarify if a contract-plan in the reference year is new, renewal, consolidation, or termination. This annual file will include encrypted identifiers for years prior to 2015 and unencrypted identifiers for 2015 and later.
    • NOTE: The Plan Bridge File provides a crosswalk between the encrypted and unencrypted contract and plan identifiers; in 2015, CMS began releasing unencrypted contract and plan identifiers.
    • NOTE: The Multi-year Crosswalk File and Plan Bridge File can be used together to track plans across time (e.g., if a plan used one, encrypted identifier in 2010 but then switched to a new plan identifier in 2011, use the annual Crosswalk File 2010-2011 to find that change. Then use the Plan Bridge File to link this encrypted plan identifier to its unencrypted plan identifier and then the annual Crosswalk File again to track the same plan after 2015.
  • Formulary File DocumentationExternal Web Site Policy - suite of three subfiles: formulary, excluded drug and Over the Counter Drug that contain information on how the plan covers the prescription drugs filled.
  • Pharmacy Characteristics File DocumentationExternal Web Site Policy - contains information about the pharmacy identified as the source of the drug for each PDE prescription fill record.
    • Pharmacy Bridge FileExternal Web Site Policy - In 2014, CMS changed the pharmacy identifier included on the PDE, this file provides a crosswalk that allows tracking the same pharmacy across this transition year.
      • NOTE: Although one can track the same pharmacy over time, all pharmacy identifiers are encrypted.
  • Prescriber Characteristics File DocumentationExternal Web Site Policy - contains descriptive information for the prescriber identified in the PDE file.
    • Prescriber Bridge FileExternal Web Site Policy - In 2014, CMS changed the Prescriber identifier included on the PDE from the CCW Prescriber ID to the National Provider ID (NPI), this file provides a crosswalk that allows tracking the same prescriber across this transition year.
      • NOTE: Although one can track the same prescriber over time, all prescriber identifiers are encrypted.
  • Part D Medication Therapy Management (MTM) File DocumentationExternal Web Site Policy - indicates whether a beneficiary is enrolled in MTM (e.g., additional service(s) to ensure the best therapeutic outcomes for patients) and the number of drug-therapy recommendations made.

View CCW’s Medicare Claims Record Layout and CodebookExternal Web Site Policy

Last Updated: 29 Jan, 2024