Reminder: DUA and VRDC access needs to be extended or renewed annually. Read more.
Data File Search
This file includes (variable highlights)
- Diagnosis (ICD diagnosis),
- Procedure (ICD procedure code)
- Admission, discharge dates or end date of covered benefits
- Charge amounts, total and assigned to specific departments
- FFS reimbursement amount
- Hospital provider identification number
- Some dummy records for Medicare managed care coverage of IP stays
What does this file include? (variable highlights)
- Diagnosis codes (ICD diagnosis)
- Procedure codes (ICD procedure)
- Admission/discharge dates
- FFS Reimbursement amount
- SNF provider number
What does this file include? (variable highlights)
- Diagnosis, (ICD diagnosis code)
- Services provided (CMS Common Procedure Coding System (HCPCS) codes)
- Dates of service
- Charge
- Reimbursement amounts
- Supplier provider number
- Supplier NPI
What does this file include? (variable highlights)
- Type of visit (eg: skilled care, home health aide, physical therapy)
- Quantity of services
- Diagnosis (ICD diagnosis),
- Dates of service
- Reimbursement amount
- Home health agency provider number
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 service
- Submitted charges
- Reimbursement amounts
- Hospice provider number
This file includes (variable highlights):
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., …
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…
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…
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,…
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…
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…
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…
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…
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
Why do researchers request this file?
- Assess the effect of medication management on…
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…
What does this file include? (variable highlights)
- Resource Utilization Group (RUG) code
- Clinical status measures
- Physical functioning assessment
- Psychological status measures
- Psycho-social functioning measure
- End-of-life care decisions
What does this file include? (variable highlights)
- HIPPS code
- Socio-demographic variables
- Information on patient home environment and informal caregivers
- Health status, including diagnosis codes
- Functional status
- Psychosocial status
- Health service utilization
- Emergent care
- Hospital admission
Special considerations
- The…
What does this file include? (variable highlights)
- Pre-hospitalization living situation
- Co-morbid conditions
- Communication status
- Functional status