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 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