Updated research request forms and data security approval requirement effective 4/24/23
Data File Search
What does this file include? (variable highlights)Diagnosis codes (ICD diagnosis)Procedure codes (ICD procedure)Admission/discharge datesFFS Reimbursement amountSNF provider 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
This file includes (variable highlights):
Admission, discharge dates
Diagnosis (ICD diagnosis) codes
Procedure (ICD procedure) codes
Diagnostic related group (DRG) codes
Patient discharge status code
Organization NPI
Part C/Medicare Advantage benefit package and contract number
Revenue center codes, dates, unit counts
No payment variables are available
Special considerations:
Many Medicare Advantage Plans offer extra coverage in addition to services covered under traditional fee-for-service…
Program:
Medicare
This file includes (variable highlights):
Diagnosis (ICD diagnosis) codes
HCPCS code
Revenue center codes, dates, unit counts
Part C Benefit Package and Contract number
Organization NPI number
No payment information
Special considerations:
Many Medicare Advantage Plans offer extra coverage in addition to services covered under traditional fee-for-service Medicare (e.g., vision, hearing, dental, and/or health and wellness programs). Encounter data may include records for some of these additional items…
Program:
Medicare
This file includes (variable highlights):
Part C Benefit Package and Contract number
Diagnosis (ICD diagnosis)
HCPCS code
Date of service (line date)
NPI for line rendering physician
No payment information
Special considerations:
Many Medicare Advantage Plans offer extra coverage in addition to services covered under traditional fee-for-service Medicare (e.g., vision, hearing, dental, and/or health and wellness programs). Encounter data may include records for some of these additional items and…
Program:
Medicare
This file includes:
Diagnosis codes (ICD diagnosis)
Procedure codes (ICD procedure)
Resource Utilization Group codes (RUGs)
Admission/discharge dates
Organization NPI number only
No payment variables
Part C/Medicare Advantage benefit package and contract number
Special considerations:
Many Medicare Advantage Plans offer extra coverage in addition to services covered under traditional fee-for-service Medicare (e.g., vision, hearing, dental, and/or health and wellness programs). Encounter data may…
Program:
Medicare
This file includes (variable highlights):
Part C Benefit Package and Contract number
Diagnosis (ICD diagnosis)
HCPCS code
Organization NPI
NPI for line supplier
Date of service (line date)
Special considerations:
Many Medicare Advantage Plans offer extra coverage in addition to services covered under traditional fee-for-service Medicare (e.g., vision, hearing, dental, and/or health and wellness programs). Encounter data may include records for some of these additional items and services provided…
Program:
Medicare
This file includes (variable highlights):
Part C Benefit Package and Contract number
Diagnosis (ICD diagnosis) codes
HCPCS code
Revenue center codes, dates, unit counts
Organization NPI
NPI for line rendering physician
Patient discharge status code
No payment variables
Special considerations:
Many Medicare Advantage Plans offer extra coverage in addition to services covered under traditional fee-for-service Medicare (e.g., vision, hearing, dental, and/or health and wellness programs). Encounter…
Program:
Medicare
The PY14 Risk Score Files includes six segments: a base file, four files with outputs from Part C models and one for Part D model outputs. All files can be linked to other CCW files via the Bene_ID.
What does this file include? (variable highlights)
PY14 Base file:
Part C monthly risk payment scores
Part C monthly model segment codes
Part D model risk payment scores
Part D monthly model segment codes
Part C monthly institutional indicators
Part C community and institutional non-monthly model payment…
Program:
Medicare
What does this file include? (variable highlights)
Service date
Product Service ID (NDC code)
Quantity dispensed
Days supply
Cost
Payment
Linkage variables:
Plan Contract ID, Plan Benefit Package ID for linkage to Plan Characteristics file
Product ID (NDC code) used by the CCW to link to the Drug Characteristics data
Beneficiary Id for linkage to MTM and Plan Election characteristics files, CMS utilization, enrollment and assessment data for Medicare and Medicaid
Formulary drug identifier for…
Program:
Medicare
What does this file include? (variable highlights)
Product ID (NDC) used to link Drug Characteristics to PDE file
Brand name
Generic name
Strength
Form of the drug
Why 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 formulation
Studies assessing pharmaceutical treatment that compare strengths and/or formulations of prescription drugs
Studies evaluating drug utilization under the Medicare Part D…
Program:
Medicare
What does this file include? (variable highlights)
CCW Formulary Drug Identifier
Tier ID
Step Therapy Indicator
Quantity Limit
Prior authorization
Linking 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 restrictions
To examine plan differences in formularies
Special considerations
Linking variables provide information for each Part D Drug Event (PDE)…
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 approved by…
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 by plan benefits…
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)
Whether beneficiary met target criteria
Long term care residence
Number of drug-therapy recommendations made
Number of drug-therapy problems resolved
Linking variable
CCW Beneficiary IDs
Why do researchers request this file?
Assess the effect of medication management on prescribing patterns and clinical outcome
Identify cost of illness impact of the Part D MTM program
Special considerations
All beneficiaries in the file were enrolled in MTM at some…
Program:
Medicare
What does this file include? (variable highlights)
Part D Plan enrollment and disenrollment dates
Enrollment type, eg: auto, facilitated, passive, point of sale
Months of LIS subsidy
Beneficiary self-selector indicator
Contract ID
Plan ID
Linking variables:
CCW Beneficiary ID: linkage to the PDE and all other CMS Medicare or Medicaid data files
Contract ID and Plan ID: linkage to the Part D Plan Characteristics file
Why do researchers request this file?
Conduct research that identifies LIS…
Program:
Medicare
What does this file include? (variable highlights)
Eligibility dates
Managed care enrollment
Waiver enrollment
Money Follows the Person program enrollment
Health Home information, including State Plan Option participants, chronic Home Health condition
Long-Term Services and Supports eligiblity
Conception-to-Birth Option eligibility
Disability information
Government Assistance program participation
Third Party Liability coverage
Special considerations
ResDAC provides resources on Medicaid TAF data quality.
A…
Program:
Medicaid
What does this file include? (variable highlights)
Records included based on discharge date within the file calendar year
Active, non-voided, non-denied final action claims
Diagnosis codes
Present on Admission Indicator
Procedure codes
Procedure date
Discharge status
Charges and payments
Provider identifier
Special considerations
Available encounter data may vary by state, year and eligibility group.
CMS continues to work with states to address data quality issues. In addition to preliminary and fully mature…
Program:
Medicaid
What does this file include? (variable highlights)
As appropriate for the type of service on the record:
Diagnosis codes
Procedure code
Charges and payments
Provider identifiers
Special considerations
Encounter data reporting may vary by state, year and eligibility group.
CMS continues to work with states to address data quality issues. In addition to preliminary and fully mature files, CMS may provide updated releases of the files for a given year. CMS has fee information for TAF data pricing.
ResDAC…
Program:
Medicaid
What does this file include? (variable highlights)
Diagnosis codes
Present on Admission indicator
Admission date
Charges and payments
Provider identifier
Patient discharge status or destination
Counts of covered days
Special considerations
Encounter 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 in the TAF OT file.
CMS continues to work with states to address data quality…
Program:
Medicaid
What does this file include? (variable highlights)
National Drug Code (NDC)
Days supply covered by the prescription
Charges and Medicaid payments (FFS only)
National Provider Identifier (NPI) for the billing provider
Special considerations
Encounter data reporting may vary by state, year and eligibility group.
Information on the drug name, dosage and format is not recorded in the TAF RX file. An external source of NDC data will be required if that information is needed.
CMS continues to work with…
Program:
Medicaid
What does this file include (variable highlights)
Managed Care Plan type
Waivers such as 1115
Eligible population indicators such as CHIP coverage
Special considerations
This file does not contain individual service records but contains information about plans that can be linked to individual enrollment information and may help put utilization into context.
CMS continues to work with states to address data quality issues. In addition to preliminary and fully mature files, CMS may provide updated releases…
Program:
Medicaid