CNTRCT_MEAS_OUTCOMES
Description:
This table will hold measurement contract 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 PRIMSRC_QUALITY_MEAS_OUTCOME_C_NAME VARCHAR No
The outcome as calculated by the primary sources. This will be a single value that says whether the patient is in the numerator for the measure, in the denominator only, or excluded from the measure.
May contain organization-specific values: No
Category Entries:
In Numerator
In Denominator Only
Required Exclusion
Optional Exclusion
4 SUPPSRC_QUALITY_MEAS_OUTCOME_C_NAME VARCHAR No
The outcome as calculated by the supplemental sources. This will be a single value that says whether the patient is in the numerator for the measure, in the denominator only, or excluded from the measure.
The category values for this column were already listed for column: PRIMSRC_QUALITY_MEAS_OUTCOME_C_NAME
5 ATTR_PROV_ID VARCHAR No
The attributed provider for the calculated contract measure outcome.
6 ATTR_DEPARTMENT_ID NUMERIC No
The attributed department for the calculated contract measure outcome.
7 ATTR_LOC_ID NUMERIC No
The attributed primary location for the calculated contract measure outcome.
8 ATTR_SERV_AREA_ID NUMERIC No
The attributed service area for the calculated contract measure outcome.
9 OUTCOME_IS_VALID_YN VARCHAR No
Indicates whether or not the calculated measure outcome is valid. For example, if the outcome was deleted from the source database, the relevant outcome would be considered invalid (0-No).
May contain organization-specific values: No
Category Entries:
No
Yes
10 QM_EVENT_DATE DATETIME No
For event-based measures, this is the date the qualifying event occurred for the measure outcome.
11 LAST_REL_SERV_DATE DATETIME No
The last date the service that satisfies the quality measure was performed.
12 CLINICAL_DUE_DATE DATETIME No
The next date that a clinical service that satisfies a quality measure is due. This due date is based on the frequency with which the service needs to be completed and the last date that it was completed.
13 PROP_DAYS_COVERED NUMERIC No
The current Proportion of Days Covered (PDC) for the associated outcome. The expected range of values are 0-1 with decimal values allowed.
14 IMPACTABLE_YN VARCHAR No
Indicates if there are enough days left in the measurement year that a fill today could move the patient to meet the adherence threshold.
The category values for this column were already listed for column: OUTCOME_IS_VALID_YN
15 FIRST_FILL_YN VARCHAR No
Is this outcome in the First Fill status? This status is where the patient has filled the medication once, but has not filled it a second time. During this timeframe the patient is not technically in the denominator yet, but once they pick up that second fill they will be.
The category values for this column were already listed for column: OUTCOME_IS_VALID_YN
16 ATTR_PROV_GROUP_ID NUMERIC No
The attributed provider group for the calculated contract measure outcome.
17 ATTR_PROV_GROUP_ID_PROV_GROUP_NAME VARCHAR No
Record name
18 INDEX_RX_START_DATE DATETIME No
The prescription start date during the measurement period for a medication adherence measure. This is the start date to use when calculating a Proportion of Days Covered (PDC) value.