OUT_MED_ADHERE_INFO_HX

Description: |
This table stores historical medication fill information for the patient. Each row represents a medication.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
REGISTRY_DATA_ID | 1 |
CONTACT_DATE_REAL | 2 |
LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | REGISTRY_DATA_ID | NUMERIC | No |
The unique identifier (.1 item) for the registry data record.
2 | CONTACT_DATE_REAL | FLOAT | No |
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3 | LINE | INTEGER | No |
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4 | OUTCOME_KEY_MED_ADH_HX | INTEGER | No |
The unique outcome key that links medication data to the rest of the outcome data.
5 | OUTCOME_MED_NAME_HX | VARCHAR | No |
The medication name relevant to an adherence measure.
6 | OUTCOME_MED_HX_NDC_ID | VARCHAR | No |
The networked NDC record ID.
7 | OUTCOME_MED_HX_NDC_ID_NDC_CODE | VARCHAR | No |
The external code for the National Drug Code (NDC). An NDC represents packages of medications.
8 | OUTCOME_MED_FIRST_FILL_HX_DATE | DATETIME | No |
The date this medication was first filled.
9 | OUTCOME_MED_LAST_FILL_HX_DATE | DATETIME | No |
The most recent fill date for the medication.
10 | OUTCOME_MED_NEXT_FILL_HX_DATE | DATETIME | No |
The expected next fill date for the medication.
11 | OUTCOME_MED_DAYS_SUPPLY_HX | INTEGER | No |
The number of days that the latest medication fill should last if taken as prescribed.
12 | OUT_HX_MED_ELIG_EXT_DAY_SUP_C_NAME | VARCHAR | No |
Whether the patient is eligible for a larger medication supply.
May contain organization-specific values: Yes
Category Entries:
No
Yes - 90 Day Supply
Yes - 100 Day Supply
13 | OUTCOME_MED_REFILLS_REMAIN_HX | INTEGER | No |
The number of refills a patient can obtain before their provider must authorize more.
14 | OUTCOME_MED_PRESCRIBER_NAME_HX | VARCHAR | No |
The name of the provider who prescribed the medication.
15 | OUTCOME_MED_PRESCRIBER_NPI_HX | VARCHAR | No |
The National Provider Identifier (NPI) of the provider who prescribed the medication.
16 | OUTCOME_MED_PRESCRIBER_PH_HX | VARCHAR | No |
The phone number of the provider who prescribed the medication.
17 | OUTCOME_MED_PHARMACY_NAME_HX | VARCHAR | No |
The name of the pharmacy where the patient obtained the medication.
18 | OUTCOME_MED_PHARMACY_NPI_HX | VARCHAR | No |
The National Provider Identifier (NPI) of the pharmacy where the patient obtained the medication.
19 | OUTCOME_MED_PHARMACY_PHONE_HX | VARCHAR | No |
The phone number of the pharmacy where the patient obtained the medication.
20 | OUTCOME_HX_MED_PHARMACY_SRC_C_NAME | VARCHAR | No |
The method of distribution used by the pharmacy where the patient obtained the medication.
May contain organization-specific values: Yes
Category Entries:
Retail
Mail
21 | OUTCOME_MED_PREF_PHARM_HX_YN | VARCHAR | No |
Whether the pharmacy where the patient obtained the medication is a preferred pharmacy for the payer. Patients often have lower out-of-pocket costs at preferred pharmacies.
May contain organization-specific values: No
Category Entries:
No
Yes
22 | OUTCOME_MED_HX_RAW_NDC | VARCHAR | No |
The raw NDC string for the medication associated with the gap.