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