RX_RXW_ORDER_INFO

Description:

Each work request can have any number of fill requests attached signifying the dispenses that should be grouped together. This table includes the patient, order, and order DAT for each fill request attached to the work request. The primary key for this table is RECORD_ID and LINE. The RECORD_ID column can be linked to the RX_RXW table in order to include general work request information in the report.

Primary Key

Column Name	Ordinal Position
RECORD_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	RECORD_ID	NUMERIC	No
	Record ID of the work request.
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	FILL_REQ_ORDER_ID	NUMERIC	No
	Each work request can be attached to a fill request contact on any number of orders. This column links this work request with a given order. It can be linked to any order related table to include order related information in the report.
4	FILL_REQ_ORDER_DAT	VARCHAR	No
	A fill request is a contact on the order record documenting a dispense of that order to the patient. This field specifies which fill request (or contact) on the order is associated with this work request. Each fill request on an order will be linked to a separate work request documenting that set of dispenses to the patient.
5	ADV_PREP_ORD_ID	NUMERIC	No
	This is the order ID of a cross-encounter signed and held inpatient e-prescription that has been sent to the pharmacy for advance prep.