Search Data Variables

The end 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).

The pharmacy relationship type indicates whether or not the pharmacy has a chain or franchise relationship with another entity.

This variable describes the secondary type of pharmacy that filled the prescription, if applicable.

Providers are not required by NCPDP to specify a secondary dispenser type.

This is the secondary taxonomy code for the pharmacy, if applicable. This field allows researchers to better understand the type of pharmacy that dispensed the medication. Pharmacies are not required by NCPDP to specify a secondary dispenser type.

The type of pharmacy used. This variable indicates the type of pharmacy that dispensed the prescription, as recorded on the PDE.  

CMS requires Part D plans to maintain pharmacy networks that are sufficient to ensure access to Medicare beneficiaries – including retail, home infusion, and long-term care pharmacies.  Plan sponsors have contracts with pharmacies to provide “in-network” services.

Indicates whether the provider’s taxonomy value maps to the other pharmacy provider category; ever in the calendar year.

This variable describes the tertiary type of pharmacy that filled the prescriptionm, if applicable.

Providers are not required by NCPDP to specify a tertiary dispenser type.

This is the tertiary taxonomy code for the pharmacy, if applicable. This field allows researchers to better understand the type of pharmacy that dispensed the medication. Pharmacies are not required by NCPDP to specify a tertiary dispenser type.

If either E1a2 or E1b2 is coded 2 or 3, CONTINUE asking the questions below. If not, END the PHQ interview and SKIP to E-TIME.
PHQ-2 TOTAL: Add values from E1a2 and E1b2

PHQ-9 depression classification based on the total score

PHQ-9 OV depression classification based on PHQ-9 OV total score

Over the last 2 weeks, how often have you been bothered by a poor appetite or overeating?

Over the last 2 weeks, how often have you been bothered by thoughts that you would be better off dead, or hurting yourself in some way?

Over the last 2 weeks, how often have you been bothered by having trouble falling or staying asleep, or sleeping too much?

Over the last 2 weeks, how often have you been bothered by trouble concentrating on things, such as reading the newspaper or watching television?

Over the last 2 weeks, how often have you been bothered by feeling down, depressed, or hopeless?

Over the last 2 weeks, how often have you been bothered by feeling bad about yourself – or that you are a failure or have let yourself or your family down?

Over the last 2 weeks, how often have you been bothered by having little interest or pleasure in doing things?

Over the last 2 weeks, how often have you been bothered by moving or speaking so slowly that other people could have noticed. Or the opposite - being so fidgety or restless that you have been moving around a lot more than usual?

Over the last 2 weeks, how often have you been bothered by feeling tired or having little energy?

PHQ© Section  Notes

Over the last 2 weeks, have you been bothered by feeling tired or having little energy?

Over the last 2 weeks, have you been bothered by feeling bad about yourself – or that you are a failure or have let yourself or your family down?

Over the last 2 weeks, have you been bothered by feeling down, depressed, or hopeless?

Over the last 2 weeks, have you been bothered by little interest or pleasure in doing things?

Over the last 2 weeks, have you been bothered by moving or speaking so slowly that other people could have noticed. Or the opposite - being so fidgety or restless that you have been moving around a lot more than usual?

Over the last 2 weeks, have you been bothered by a poor appetite or overeating?

Over the last 2 weeks, have you been bothered by thoughts that you would be better off dead, or hurting yourself in some way?

Over the last 2 weeks, have you been bothered by trouble falling or staying asleep, or sleeping too much?

Over the last 2 weeks, have you been bothered by trouble concentrating on things, such as reading the newspaper or watching television?

Physical behavioral symptoms directed toward others
(e.g., hitting, kicking, pushing, scratching, grabbing, abusing others sexually)

The last day of business for the pharmacy at this location, as reported to NCPDP. This variable is populated with dates only for stores that have closed or are planning to close. The date may not correspond with the year of the data file.

The date the pharmacy opened at this location, as reported by the pharmacy to NCPDP.

The state where the pharmacy is physically located, using the standard two-character postal state code.

The charge amount (rounded to whole dollars) for physical therapy services provided during the beneficiary's stay.

NOTE: Effective with MEDPAR2000 expansion, all amount fields were expanded from S9(7) to S9(9).

Indicates whether the provider’s taxonomy value maps to the physician assistant (PA) and advanced practice nursing provider (APN) category; ever in the calendar year.

CODE INDICATING THE PLACE WHERE THE SERVICE WAS PERFORMED.

A code indicating where the service was performed. CMS 1500 values are used for this data element.

This variable is the unique plan benefit package (PBP) identifier for the beneficiary’s Part D plan of record for the year.  CMS assigns an identifier to each PBP within a contract that a Part D plan sponsor has with CMS.

If the beneficiary was enrolled in more than one plan during the year, this is the plan benefit package identifier for the plan in which the beneficiary was enrolled at the end of the year. 

This variable is the unique plan benefit package (PBP) number for the plan sponsor's contract. CMS assigns an identifier to each PBP within a contract that a plan sponsor has with CMS.

This field is a key that links the plan sponsor's contract and plan identifiers.

This variable is the unique plan benefit package (PBP) number for the plan sponsor's contract. CMS assigns an identifier to each PBP within a contract that a plan sponsor has with CMS. This was the Plan ID for the plan in 2014. It may or may not be the same as the Plan ID in the reference year (2015).

This field is a key that links the plan sponsor's contract and plan identifiers.

This variable is the unique plan benefit package (PBP) number for the plan sponsor's contract. CMS assigns an identifier to each PBP within a contract that a plan sponsor has with CMS. This was the Plan ID for the plan in 2015. It may or may not be the same as the Plan ID in the reference year (2016).

This field is a key that links the plan sponsor's contract and plan identifiers.

This variable is the unique plan benefit package (PBP) number for the plan sponsor's contract. CMS assigns an identifier to each PBP within a contract that a plan sponsor has with CMS. This was the Plan ID for the plan in 2016. It may or may not be the same as the Plan ID in the reference year (2017).

This field is a key that links the plan sponsor's contract and plan identifiers.

This variable is the unique plan benefit package (PBP) number for the plan sponsor's contract. CMS assigns an identifier to each PBP within a contract that a plan sponsor has with CMS. This was the Plan ID for the plan in 2015 (the reference year). It may or may not be the same as the Plan ID in the prior year (2014).

This field is a key that links the plan sponsor's contract and plan identifiers.

This variable is the unique plan benefit package (PBP) number for the plan sponsor's contract. CMS assigns an identifier to each PBP within a contract that a plan sponsor has with CMS. This was the Plan ID for the plan in 2016 (the reference year). It may or may not be the same as the Plan ID in the prior year (2015).

This field is a key that links the plan sponsor's contract and plan identifiers.

This variable is the unique plan benefit package (PBP) number for the plan sponsor's contract. CMS assigns an identifier to each PBP within a contract that a plan sponsor has with CMS. This was the Plan ID for the plan in 2017 (the reference year). It may or may not be the same as the Plan ID in the prior year (2016).

This field is a key that links the plan sponsor's contract and plan identifiers.

This variable is the name of the plan benefit package (PBP) for the plan sponsor's contract.

This variable is the unique Part D contract identifier for the beneficiary’s Part D plan of record for the year. CMS assigns an identifier to each contract that a Part D plan has with CMS.

If the beneficiary was enrolled in more than one plan during the year, this is the contract number for the Part D plan in which the beneficiary was enrolled at the end of the year.

The first character of the plan contract ID is a letter representing the type of plan.

This variable indicates whether any excluded drugs are part of the Part D plan's supplemental coverage (e.g., benzodiapines, barbiturates).