RXA_RESPONSE_DUR

Description:

The Drug Utilization Review (DUR) response section received from the payor.

Primary Key

Column Name	Ordinal Position
RECORD_ID	1
CONTACT_DATE_REAL	2
LINE	3

Column Information

	Name	Type	Discontinued?
1	RECORD_ID	NUMERIC	No
	The unique identifier for the adjudication 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	LINE	INTEGER	No
	The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
5	I_REASON_FOR_SVC_ID	NUMERIC	No
	NCPDP code identifying the type of utilization conflict detected or the reason for the pharmacists professional service.
6	I_REASON_FOR_SVC_ID_EXT_CODE_LST_NAME	VARCHAR	No
	The name of the list value.
7	I_CLIN_SIG_CODE_ID	NUMERIC	No
	NCPDP code identifying the significance or severity level of a clinical event as contained in the originating database.
8	I_CLIN_SIG_CODE_ID_EXT_CODE_LST_NAME	VARCHAR	No
	The name of the list value.
9	I_PHRM_RESP_DUR_ID	NUMERIC	No
	NCPDP code indicating the pharmacy responsible for the previous event involved in the DUR conflict.
10	I_PHRM_RESP_DUR_ID_EXT_CODE_LST_NAME	VARCHAR	No
	The name of the list value.
11	I_QTY_PREV_FILL	NUMERIC	No
	Amount expressed in metric decimal units of the conflicting agent that was previously dispensed.
12	I_DRUG_INFO_SRC_ID	NUMERIC	No
	NCPDP code identifying the source of drug information used for DUR processing or to define the database used for identifying the product.
13	I_DRUG_INFO_SRC_ID_EXT_CODE_LST_NAME	VARCHAR	No
	The name of the list value.
14	I_PRESC_COMP_ID	NUMERIC	No
	NCPDP code comparing the prescriber of the current prescription to the prescriber of the previously filled conflicting prescription.
15	I_PRESC_COMP_ID_EXT_CODE_LST_NAME	VARCHAR	No
	The name of the list value.
16	I_DUR_ALERT_ADDL_TX	VARCHAR	No
	Text that provides additional detail regarding a DUR/DUE conflict.
17	I_PRSC_PREV_FILL_DT	DATETIME	No
	Date prescription was previously dispensed.
18	I_DUR_CNFLT_ADDL_TX	VARCHAR	No
	Descriptive information that further defines the referenced DUR alert.
19	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.
20	I_DUR_COAG_ID_Q_ID	NUMERIC	No
	Code qualifying the value in DUR/DUE Co-Agent ID (476-H6).
21	I_DUR_COAG_ID_Q_ID_EXT_CODE_LST_NAME	VARCHAR	No
	The name of the list value.
22	I_DUR_COAG_ID_S	VARCHAR	No
	Identifies the co-existing agent contributing to the DUR/DUE event (drug or disease conflicting with the prescribed drug or prompting pharmacist professional service) (476-H6).
23	I_DUR_COAG_DESCRIPT	VARCHAR	No
	Description of the co-existing agent contributing to the DUR/DUE event (drug or disease conflicting with the prescribed drug or prompting pharmacist professional service) (E93-ZC).
24	I_OTH_PHR_ID_QL_ID	NUMERIC	No
	Code qualifying the value in 'Other Pharmacy ID' (E96-Z8).
25	I_OTH_PHR_ID_QL_ID_EXT_CODE_LST_NAME	VARCHAR	No
	The name of the list value.
26	I_OTH_PHARMACY_ID_S	VARCHAR	No
	ID assigned to the pharmacy associated to the prescription or previous event contributing to the DUR/DUE conflict (E96-Z8).
27	I_OTH_PHARMACY_NAME	VARCHAR	No
	Name of the pharmacy associated to the prescription or previous event contributing to the DUR/DUE conflict (E97-Z7).
28	I_OTH_PHR_PHONE_NUM	VARCHAR	No
	Telephone number of the pharmacy associated to the prescription or previous event contributing to the DUR/DUE conflict (E98-Z6).
29	I_OTH_PRES_ID_QL_ID	NUMERIC	No
	Code qualifying the value in 'Other Prescriber ID' (F02-Z3).
30	I_OTH_PRES_ID_QL_ID_EXT_CODE_LST_NAME	VARCHAR	No
	The name of the list value.
31	I_OTH_PRESCRBR_ID_S	VARCHAR	No
	ID assigned to the prescriber associated to the prescription or previous event contributing to the DUR/DUE conflict (F02-Z3).
32	I_OTH_PRS_LAST_NAME	VARCHAR	No
	Last name of the prescriber associated to the prescription or previous event contributing to the DUR/DUE conflict (E99-Z5).
33	I_OTH_PRS_PHONE_NUM	VARCHAR	No
	The 10-digit telephone number of the prescriber of the prescription causing the DUR/DUE conflict (F03-Z2).
34	I_DUR_COM_PRD_QL_ID	NUMERIC	No
	Code qualifying the value in 'DUR/DUE Compound Product ID' (F04-Z1).
35	I_DUR_COM_PRD_QL_ID_EXT_CODE_LST_NAME	VARCHAR	No
	The name of the list value.
36	I_DUR_COM_PRD_ID_S	VARCHAR	No
	Identifies the specific compound ingredient within the submitted compound claim, contributing to the DUR/DUE event (F04-Z1).
37	I_MAX_DAY_DOSE_QTY	NUMERIC	No
	Maximum quantity associated to the DUR/DUE daily dose limitation (F06-YO).
38	I_MAX_DY_DSE_UNT_ID	NUMERIC	No
	Code indicating the Unit of Measure associated to the 'DUR/DUE Maximum Daily Dose Quantity' (F06-YO).
39	I_MAX_DY_DSE_UNT_ID_EXT_CODE_LST_NAME	VARCHAR	No
	The name of the list value.
40	I_MIN_DAY_DOSE_QTY	NUMERIC	No
	Minimum quantity associated to the DUR/DUE daily dose limitation (F08-YJ).
41	I_MIN_DY_DSE_UNT_ID	NUMERIC	No
	Code indicating the Unit of Measure associated to the 'DUR/DUE Minimum Daily Dose Quantity' (F08-YJ).
42	I_MIN_DY_DSE_UNT_ID_EXT_CODE_LST_NAME	VARCHAR	No
	The name of the list value.
43	I_UNT_MSR_PR_QTY_ID	NUMERIC	No
	Code indicating the Unit of Measure associated to the 'Quantity of Previous Dispensed' (531-FV).
44	I_UNT_MSR_PR_QTY_ID_EXT_CODE_LST_NAME	VARCHAR	No
	The name of the list value.