Reminder: DUA and VRDC access needs to be extended or renewed annually. Read more.
Data File Search
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)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 programSpecial…
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 available…
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 CY 2014 file, it is possible to request an unencrypted pharmacy identifier.
Researchers who request and are…
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…
Program:
Medicare
What does this file include? (variable highlights)
Initial and gap coverage limits
Plan premium amount
Plan service area description
Crosswalk of current plan ID to previous years
Demonstration type
Special needs plan type
Linkage 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…
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 year…
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…
Program:
Medicare