OUTCOME_MED_ADHERE_INFO
Description:
This table will hold med adherence information around the medications associated with an outcome.

Primary Key
Column Name Ordinal Position
REGISTRY_DATA_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 REGISTRY_DATA_ID NUMERIC No
The unique identifier (.1 item) for the registry data record.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 OUTCOME_KEY_MED_ADH INTEGER No
This item stores the outcome's key. This key is unique for an outcome on a particular RDI record. This item is used to link the current outcomes group (I RDI 42010) with the med adherence data stored here.
4 OUTCOME_MED_NAME VARCHAR No
The medication name relevant to an adherence measure.
5 OUTCOME_MED_NDC_ID VARCHAR No
The NDC record ID for the medication listed.
6 OUTCOME_MED_NDC_ID_NDC_CODE VARCHAR No
The external code for the National Drug Code (NDC). An NDC represents packages of medications.
7 OUTCOME_MED_FIRST_FILL_DATE DATETIME No
The date this medication was first filled.
8 OUTCOME_MED_LAST_FILL_DATE DATETIME No
The most recent fill date for the medication.
9 OUTCOME_MED_NEXT_FILL_DATE DATETIME No
The expected next fill date for the medication. This is based on last fill date + days supplied.
10 OUTCOME_MED_DAYS_SUPPLY INTEGER No
The number of days that the latest medication fill should last if taken as prescribed.
11 OUTCOME_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
12 OUTCOME_MED_REFILLS_REMAINING INTEGER No
The number of refills a patient can obtain before their provider must authorize more.
13 OUTCOME_MED_PRESCRIBER_NAME VARCHAR No
The name of the provider who prescribed the medication.
14 OUTCOME_MED_PRESCRIBER_NPI VARCHAR No
The National Provider Identifier (NPI) of the provider who prescribed the medication.
15 OUTCOME_MED_PRESCRIBER_PHONE VARCHAR No
The phone number of the provider who prescribed the medication.
16 OUTCOME_MED_PHARMACY_NAME VARCHAR No
The name of the pharmacy where the patient obtained the medication.
17 OUTCOME_MED_PHARMACY_NPI VARCHAR No
The National Provider Identifier (NPI) of the pharmacy where the patient obtained the medication.
18 OUTCOME_MED_PHARMACY_PHONE VARCHAR No
The phone number of the pharmacy where the patient obtained the medication.
19 OUTCOME_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
20 OUTCOME_MED_PREF_PHARMACY_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
21 OUTCOME_MED_IS_REVERSED_YN VARCHAR No
Whether the medication on this line is reversed - meaning it was not picked up by the patient. This is a calculation by comparing the "most recent medication" on historical contacts to those on subsequent contacts to determine if a specific medication has been reversed.
The category values for this column were already listed for column: OUTCOME_MED_PREF_PHARMACY_YN