Data File Search
What does this file include? (variable highlights)NDI date of deathICD-10 description and code for cause of deathUnderlying conditions for cause of deathCDC category code for cause of deathSpecial considerationsOnly beneficiaries with a date of death in the annual MAX PS file are included in the file. The date can be the MSIS date of death or the Medicare date of death reported in MAX for the dually eligible.Some states are not included in the later years. See specific availiability below.This is a segment...
Program:
Medicaid
What does this file include? (variable highlights)Three flags for each chronic condition (based on end of calendar year):Medicaid only (found in Medicaid claims)Medicare only (found in Medicare claims)Combined data (found in Medicare and Medicaid claims)Special considerationsThe algorithms used to assign the flags are available from the CCW website.Algorithms that include multi-year look-back periods are applied without the purchase of additional years of data.This is a segment of the MESF file. Another...
Program:
Medicaid
What does this file include? (variable highlights)Two flags for each chronic condition:First ever occurrence dateEnd of year indicatorThis file is a segment that can be requested in addition to the Master Beneficiary Summary File (MBSF) base file.Special considerationsThis file uses information from Fee-For-Service (FFS) Medicare claims.
Program:
Medicare
What does this file include? (variable highlights)NDI date of deathICD-10 code for cause of deathUnderlying conditions for cause of deathCDC category code for cause of deathThis file is a segment that can be requested in addition to the Master Beneficiary Summary File (MBSF) base file.
Program:
Medicare
What does this file include? (variable highlights)Summary of utilization and total annual payments for services such as:physician visits, dialysis, DME, IP recorded emergency room visits, Ambulatory Surgical Centers, anesthesia, imaging, Part B drugs from Fee-for-service (FFS) MedicareNumber of hospital stays, Medicare covered days and total annual inpatient payments for services covered by FFS MedicareSummary of Part D payments, events and prescription fillsThis file is a segment that can be requested in...
Program:
Medicare
What does this file include? (variable highlights)
Three flags for each chronic condition:
First occurrence date
Mid year indicator
End of year indicator
Special considerations
The algorithms used to assign the flags are available from the CCW website.
Algorithms requiring a multiple-year look back period are completed without requiring the researcher to order multiple years of data.
Algorithms search data from Medicare Fee-For-Service (FFS) claims.
This file is a segment that can be requested in addition...
Program:
Medicare
What does this file include? (variable highlights)State, county annual SSA codesState, county monthly FIPS codesZip code, State and CountyDate of birth, date of deathRaceReason for entitlementMonthly enrollment for each part of the Medicare program, A/B/C/DDual eligible statusPart C plan and enrollment informationPart D plan and enrollment informationPart D low income cost sharingSpecial considerationsFour additional segments are available for order with this file:Chronic ConditionsOther Chronic...
Program:
Medicare
What does this file include? (variable highlights)Bene_ID (links to all other CMS Research Identifiable Files (RIF))State, county, zipcodeDate of birth, gender, raceEligibility categoryDual Medicare-Medicaid eligibilityMedicaid managed care enrollmentSummary utilization, Medicaid payments
Program:
Medicaid
What does this file include? (variable highlights)5 diagnosis codesAdmission dateCharges and payments (FFS only)Provider identifierPatient discharge status or destinationCounts of covered daysSpecial considerationsEncounter record reporting may not be complete. Data reporting may vary by state, year and eligibility group.Stays may be made up of multiple records.Long term care services provided to community-dwelling beneficiaries are found the MAX OT file.
Program:
Medicaid
What does this file include? (variable highlights)10 diagnosis code fields7 procedure code fieldsDischarge statusCharges and payments (FFS only)Provider identifier Special considerationsEncounter record reporting may not be complete. Data reporting may vary by state, year and eligibility group.
Program:
Medicaid
What does this file include? (variable highlights)As appropriate for the type of service on the record:2 diagnosis codes1 procedure codeBroadly defined Type of Service codesCharges and payments (FFS only)Provider identifierSpecial considerationsEncounter record reporting may not be complete. Data reporting may vary by state, year and eligibility group
Program:
Medicaid
The Medicaid RX Prescription Drug file includes fee-for-service (FFS) claim and managed care encounter records that contain a National Drug Code (NDC) for a filled prescription.What does this file include? (variable highlights)National Drug Code (NDC)Days supply covered by the prescriptionCharges and Medicaid payments (FFS only)National Provider Identifier (NPI) for the billing providerSpecial considerationsEncounter record reporting may not be complete. Data reporting may vary by state, year, eligibility...
Program:
Medicaid
What does this file include? (variable highlights)Practice IdentifierEligible professional NPIEligible professional subject to the VMProvider specialtyNo practice-level Quality and Resource Use Report (QRUR) or VM information (must link to VM Practice-Level RIF)Special considerationsData documentation is specific to each performance year.Two additional VM program RIFs are available:VM Practice-Level RIFVM Beneficiary-Level RIF
Program:
Medicare
What does this file include? (variable highlights)Whether beneficiary met target criteriaLong term care residenceNumber of drug-therapy recommendations madeNumber of drug-therapy problems resolvedLinking variableCCW Beneficiary IDsWhy do researchers request this file?Assess the effect of medication management on prescribing patterns and clinical outcomeIdentify cost of illness impact of the Part D MTM programSpecial considerationsAll beneficiaries in the file were enrolled in MTM at some point during the...
Program:
Medicare
What does this file include? (variable highlights)Part D Plan enrollment and disenrollment datesEnrollment type, eg: auto, facilitated, passive, point of saleMonths of LIS subsidyBeneficiary self-selector indicatorContract IDPlan IDLinking variables:CCW Beneficiary ID: linkage to the PDE and all other CMS Medicare or Medicaid data filesContract ID and Plan ID: linkage to the Part D Plan Characteristics fileWhy do researchers request this file?Conduct research that identifies LIS beneficiaries and studies...
Program:
Medicare
What does this file include? (variable highlights)Service dateProduct Service ID (NDC code)Quantity dispensedDays supplyCostPaymentLinkage variables:Plan Contract ID, Plan Benefit Package ID for linkage to Plan Characteristics fileProduct ID (NDC code) used by the CCW to link to the Drug Characteristics dataBeneficiary Id for linkage to MTM and Plan Election characteristics files, CMS utilization, enrollment and assessment data for Medicare and MedicaidFormulary drug identifier for linkage to the Part D...
Program:
Medicare
What does this file include? (variable highlights)CCW Formulary Drug IdentifierTier IDStep Therapy IndicatorQuantity LimitPrior authorizationLinking variables to the PDE file record:Formulary Identification Number (in each sub-file)Why do researchers request this file?To examine differences in utilization based on formulary inclusion or restrictionsTo examine plan differences in formulariesSpecial considerationsLinking variables provide information for each Part D Drug Event (PDE) record.The Tier ID...
Program:
Medicare
What does this file include? (variable highlights)
Pharmacy type
Pharmacy dispenser type code
Pharmacy Primary Taxonomy code
DME service
Walk-in service
Linking variable to the PDE file:
CCW Pharmacy ID
Why do researchers request this file?
Evaluate medication possession rates by pharmacy type
Assess the effect of pharmacy type on clinical outcomes
Special considerations
Beginning with the CY2014 file, it is possible to request an unencrypted pharmacy identifier.
Researchers who request and are approved by...
Program:
Medicare
What does this file include? (variable highlights)Initial and gap coverage limitsPlan premium amountPlan service area descriptionCrosswalk of current plan ID to previous yearsDemonstration typeSpecial needs plan typeLinkage variables to the PDE and to each of the Plan Characteristic File sub-files:Plan Contract ID, Plan Benefit Package ID (use in combination to link to specific plan)Why do researchers request this file?Studies that compare medication usage and clinical outcomes by plan benefitsSpecial...
Program:
Medicare
What does this file include? (variable highlights)
Primary Taxonomy Code
Practice location (state)
Academic or Professional Credential for the prescriber
Linkage variables to the PDE file:
CCW Prescriber Identifier
Why do researchers request this file?
Studies describing prescribing patterns based on prescriber specialty
Evaluation of clinical outcome based on prescriber characteristics
Special considerations
Prior to CY2014 data, the prescriber ID is the encrypted CCW Prescriber ID, which cannot be linked...
Program:
Medicare
What does this file include? (variable highlights)Product ID (NDC) used to link Drug Characteristics to PDE filebrand namegeneric namestrengthform of the drugWhy do researchers request this file?Researchers who do not have access to a proprietary NDC database use this file to identify specific drugs, strengths and formulationStudies assessing pharmaceutical treatment that compare strengths and/or formulations of prescription drugsStudies evaluating drug utilization under the Medicare Part D program.Special...
Program:
Medicare
What does this file include? (variable highlights)diagnosis (ICD diagnosis)procedure (CPT code)dates of servicechargesallowed amountsreimbursement amountprovider NPI number
Program:
Medicare
What does this file include? (variable highlights)diagnosis, (ICD diagnosis code)services provided (CMS Common Procedure Coding System (HCPCS) codes)dates of servicechargereimbursement amountssupplier provider numbersupplier NPI
Program:
Medicare
What does this file include? (variable highlights)type of visit (eg: skilled care, home health aide, physical therapy)quantity of servicesdiagnosis (ICD diagnosis),dates of servicereimbursement amounthome health agency provider number
Program:
Medicare
What does this file include? (variable highlights)the level of hospice care received (e.g., home health aide, skilled nursing care)diagnosis (ICD diagnosis codes)the dates of servicesubmitted chargesreimbursement amountshospice provider number
Program:
Medicare