Search Data Variables

Number of months of Part D eligibility during the assignment window for ACOs under preliminary prospective assignment and during the PY for ACOs under prospective assignment. Values from 0-12.

The total of all claim pass through per diem amounts (rounded to whole dollars) for the stay.

What month are we in right now?

This field represents a base rate increase factor for 1.3516 for new patient initial preventive physical examination (IPPE) and annual wellness visit.

Date of birth of the patient as indicated on the event record.

The code used to identify the status of the patient as of the CLM_THRU_DT. 

The code used to identify the status of the patient as of the CLM_THRU_DT.

Gender of the patient as indicated on the event record.

THE TOTAL AMOUNT THAT AN ELIGIBLE IS REQUIRED TO SPEND OUT OF THEIR OWN FUNDS, TOWARD THE COST OF THEIR CARE, BEFORE MEDICAID PAYMENTS ARE MADE.

8 DIGITS (DISPLAY SIGNED NUMERIC) (SAS USERS:ZONED DECIMAL - ZD8)

This variable indicates where the beneficiary lived when the prescription was filled, as reported on the PDE record.

CODE INDICATING THE PATIENT'S DISCHARGE STATUS.

A code indicating the Patients status as of the Claim Line Ending Date of Service (variable in the Line file called LINE_SRVC_END_DT).

Indicate whether the route(s) of transmission of the current reconciled medication list to the patient, family and/or caregiver was an electronic health record.

Indicate whether the route(s) of transmission of the current reconciled medication list to the patient, family and/or caregiver was an electronic health information exchange.

Indicate whether the route(s) of transmission of the current reconciled medication list to the patient, family and/or caregiver was an alternate method.

Indicate whether the route(s) of transmission of the current reconciled medication list to the patient, family and/or caregiver was paper based.

Indicate whether the route(s) of transmission of the current reconciled medication list to the patient, family and/or caregiver was verbal.

Notes on patient's use indwelling or external bowel appliance

The patient visit date.

Patient's baseline atherosclerotic cardiovascular disease (ASCVD) score.

Patient's baseline date.

Patient's baseline group (low, medium, high).

Patient's date of birth (DOB).

Patient's ethnicity.

Patient's gender.

Patient's race.

The field denotes whether the claim payment is made at the header level or the line level.

DATE ON WHICH THE CLAIM OR ENCOUNTER RECORD WAS ADJUDICATED BY THE STATE.

This variable was created by CCW to describe whether the Prescriber ID on the source PDE (variable called PRSCRBR_ID) was an NPI, DEA, or UPIN format based on the length of the Prescriber ID and the combination of alpha and numeric characters.

This variable was only available 2006 - 2013.

Period of performance.

This code specifies whether the enrollee met the chronic condition algorithm criteria, considering both Medicare and Medicaid data, for having Peripheral Vascular Disease. 

This code specifies whether the enrollee met the chronic condition algorithm criteria, considering only Medicaid data, for having Peripheral Vascular Disease.

This code specifies whether the enrollee met the chronic condition algorithm criteria, considering only Medicare data, for having Peripheral Vascular Disease. 

This variable indicates whether a beneficiary met the condition criteria for peripheral vascular disease as of the end of the calendar year.

This variable shows the date when the beneficiary first met the criteria for the peripheral vascular disease indicator. The variable will be blank for beneficiaries that have never had the condition.

This variable indicates whether a beneficiary met the condition criteria for personality disorders as of the end of the calendar year.

This variable shows the date when the beneficiary first met the criteria for the personality disorders indicator. The variable will be blank for beneficiaries that have never had the condition.

This code specifies whether the enrollee met the chronic condition algorithm criteria, considering both Medicare and Medicaid data, for having a Personality Disorder.

This code specifies whether the enrollee met the chronic condition algorithm criteria, considering only Medicaid data, for having a Personality Disorder.

This code specifies whether the enrollee met the chronic condition algorithm criteria, considering only Medicare data, for having a Personality Disorder.

The charge amount (rounded to whole dollars) for pharmaceutical costs related to the beneficiary's stay.

The code indicating whether or not the beneficiary received drugs during the stay. It also specifies the type of drugs.

The encrypted NCPDP identifier for a business entity that has been reported to serve as the headquarters for chains, buying groups or third party contracting organizations. There may be multiple relationship IDs (variable called RELATIONSHIP_ID) that link to a common parent organization.

Number of months the beneficiary was enrolled in a Pharmacy Prepaid Ambulatory Health Plan (PAHP) Managed Care Plan in the calendar year.

This variable describes the type of pharmacy that filled the prescription. NCPDP requires all providers to specify a primary dispenser type.

This is the taxonomy code for the pharmacy. This field allows researchers to better understand the type of pharmacy that dispensed the medication.

The start date of the pharmacy's relationship with a chain or franchise as reported to NCPDP.

Some pharmacies share a relationship with a common organization. For each of these pharmacies, there is a relationship ID (RELATIONSHIP_ID) and type (RELATIONSHIP_TYPE).

An encrypted NCPDP identifier for a chain or franchise organization that the pharmacy has a relationship with.

Some pharmacies share a relationship with a common organization. For each of these pharmacies, there is a maximum of one relationship ID (RELATIONSHIP_ID) and type (RELATIONSHIP_TYPE). When a relationship was not specified, both the relationship ID and relationship type variables are null (missing).