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.