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
Demographic Data Invalid
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 a response is filed based on data stored in the LME 300 group. The value stored here is calculated after considering any PA flag overrides configured for the medication.
May contain organization-specific values: No
Category Entries:
Yes
No
Unknown
15 | PA_REQ_ACCURACY_C_NAME | VARCHAR | No |
This item tracks the accuracy of the prior authorization flag (I LME 203). Accuracy is determined by looking at the prior authorization status on the linked order. This item will not be populated if Medication Prior Authorization is not enabled for the encounter department (I DEP 17260) or system (I LSD 6670). This item will not be updated for orders if the PA request is started more than 30 days after signing, since the information stored in this record may no longer be accurate. In that case, this item will be set to 3-Unknown. The accuracy flag is calculated using the line where I LME 319-Primary Coverage is set to 1-Yes, and does not consider any PA overrides configured for the medication.
The category values for this column were already listed for column: ORIG_MED_PA_REQ_C_NAME
16 | SIGN_QUERY_TIMEOUT_YN | VARCHAR | No |
If a query was initiated during signing of this order, but results came back after the signing timeout (I LPR 58025 - Patient Estimate Query Signing Timeout), this item will be set to 1-Yes.
The category values for this column were already listed for column: RESP_EXACT_MATCH_YN