MED_CVG_RESPONSE_RSLT
Description:
This table holds information about medication coverage responses.

Primary Key
Column Name Ordinal Position
MED_ESTIMATE_ID 1
CONTACT_DATE_REAL 2

Column Information
Name Type Discontinued?
1 MED_ESTIMATE_ID NUMERIC No
The unique identifier (.1 item) for the medication estimate 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 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
4 CONTACT_SERIAL_NUM NUMERIC No
The contact serial number (CSN) of the contact.
5 CONTACT_NUM INTEGER No
Stores contact number.
6 CM_CT_OWNER_ID VARCHAR No
The Community ID (CID) of the instance that owns this contact. This is only populated if you use IntraConnect.
7 RESP_RESULT_C_NAME VARCHAR No
Category value indicating the coverage response result.
May contain organization-specific values: No
Category Entries:
Processed
Not Processed
Processed, Alternatives Available
Pharmacy ID Missing/Invalid
PBM Member ID Missing/Invalid
System Error
Unmatched Quantity Unit
Drug Not Found
Discontinued NDC
Patient Not Found
Missing/Invalid Date of Birth
Missing/Invalid Quantity
Missing/Invalid Gender Code
Missing/Invalid Prescriber ID
Patient Not Covered
Missing/Invalid Days Supply
Validation Error
8 INSTANT_OF_ENTRY_DTTM DATETIME (Attached) No
Stores the instant of entry when a record is edited.
9 TRIG_UTC_DTTM DATETIME (UTC) No
Holds the instant when the interface message was triggered.
10 RESP_UTC_DTTM DATETIME (UTC) No
Holds the instant an interface response was received.
11 STATUS_C_NAME VARCHAR No
Holds the category value indicating the interface message status.
May contain organization-specific values: No
Category Entries:
Message Sent
Response Filed
Error Occurred
Query Triggered
12 RESP_MSG_ID VARCHAR No
Holds the message ID of the response interface message.
13 RESP_EXACT_MATCH_YN VARCHAR No
This item records if the payer sent back coverage information that exactly matched the order details that were sent in the Real-Time Prescription Benefit request.
May contain organization-specific values: No
Category Entries:
No
Yes
14 ORIG_MED_PA_REQ_C_NAME VARCHAR No
This item holds a category value indicating if prior authorization is required for the medication that was originally ordered. It is calculated when data a response is filed based on data stored in the LME 300 group.
May contain organization-specific values: No
Category Entries:
Yes
No
Unknown