RX_RXW

Description:

This table contains no add single response data for ambulatory pharmacy work requests. Each work request is associated with a set of fill requests. A fill request is a contact on the order record which contains information about the specific dispense of the attached order. The patient, the order, and the order DAT is stored on the order record of the work request, which also links the work request to its associated fill request. This value lives in table RX_RXW_ORDER_INFO. Each work request is also linked to a patient, for which the work request was originally created. Pickup priority and contact information is also stored in this record to assist in prescription filling and dispensing.

Primary Key

Column Name	Ordinal Position
RECORD_ID	1

Column Information

	Name	Type	Discontinued?
1	RECORD_ID	NUMERIC	No
	Work request ID. This is the primary key for the work request table.
2	MASTER_PATIENT_ID	VARCHAR	No
	The unique identifier for the main patient in a work request. Additional patients attached to the work request are reported in the RXW_ORDER_INFO table in association with the specific fill request for that patient. This column can be linked to the PATIENT table in order to report on any patient noadd information.
3	PLANNED_PICKUP_INST	DATETIME (UTC)	No
	The date and time the patient plans to pick up the fills associated with this work request. Used in conjunction with the fill priority to determine the overall priority of the work request for filling.
4	WAITING_SINCE_DTTM	DATETIME (UTC)	No
	The instant when the work request was marked as waiting.
5	DELIVERY_METHOD_C_NAME	VARCHAR	No
	The prescription delivery method for the work request. Pickup and mail order are two examples of this. May contain organization-specific values: Yes Category Entries: Pickup Mail Courier Room Delivery
6	DELIVERY_HOUSE_NUM	VARCHAR	No
	The house number of the prescription delivery address.
7	DELIVERY_CITY	VARCHAR	No
	The city of the prescription delivery address.
8	DELIVERY_STATE_C_NAME	VARCHAR	No
	The state of the prescription delivery address. May contain organization-specific values: Yes
9	DELIVERY_ZIP	VARCHAR	No
	The ZIP code of the prescription delivery address.
10	DELIVERY_DIST_C_NAME	VARCHAR	No
	The district of the prescription delivery address. May contain organization-specific values: Yes
11	DELIVERY_COUNTY_C_NAME	VARCHAR	No
	The county of the prescription delivery address. May contain organization-specific values: Yes
12	DELIVERY_COUNTRY_C_NAME	VARCHAR	No
	The country of the prescription delivery address. May contain organization-specific values: Yes
13	DELIVERY_ADDRTYP_C_NAME	VARCHAR	No
	The type of address from the patient that is used for the prescription delivery address on the work request. For example, the patient's home address will commonly be used as the ship to address. May contain organization-specific values: No Category Entries: Home Address Temporary Address Other Address Single-Use Address
14	RX_PMT_GUARANTOR_ID	NUMERIC	No
	If Professional Billing integration is enabled, this contains the guarantor account associated with the sale of merchandise products.
15	DELIVERY_PAT_ENC_CSN_ID	NUMERIC	No
	This column contains the CSN of the patient encounter associated with a room delivery work request.
16	DELIVERY_DEPARTMENT_ID_EXTERNAL_NAME	VARCHAR	No
	The external name of the department record. This is often used in patient correspondence such as reminder letters.
17	DELIVERY_ROOM_RECORD_ID_ROOM_NAME	VARCHAR	No
	The name of the Room record.
18	DELIVERY_EXAM_ROOM_NUMBER	VARCHAR	No
	The column contains the free-text room number that represents the exam room the patient occupied at the time of delivery of room delivery work request.
19	DELIVERY_BED_ID	VARCHAR	No
	This column contains the ADT bed (BED) record that represents the physical bed the patient occupied at the time of delivery of a room delivery work request.
20	DELIVERY_BED_ID_BED_LABEL	VARCHAR	No
	The name of the bed.
21	CREATION_USER_ID	VARCHAR	No
	The user that created the work request.
22	CREATION_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
23	DELIVERY_ADDR_NAME	VARCHAR	No
	Stores the name used as part of the shipping address when delivering this medication.
24	RETURN_ADDR_NAME	VARCHAR	No
	Stores the name that gets displayed on the return address when shipping prescriptions.
25	RETURN_HOUSE_NUM	VARCHAR	No
	The house number to put on the return address when shipping prescriptions.
26	RETURN_CITY	VARCHAR	No
	The city part of the return address when shipping prescriptions.
27	RETURN_STATE_C_NAME	VARCHAR	No
	The state part of the return address when shipping prescriptions. The category values for this column were already listed for column: DELIVERY_STATE_C_NAME
28	RETURN_ZIP	VARCHAR	No
	The zip code for the return address when shipping prescriptions.
29	RETURN_DISTRICT_C_NAME	VARCHAR	No
	The district for the return address when shipping prescriptions. The category values for this column were already listed for column: DELIVERY_DIST_C_NAME
30	RETURN_COUNTY_C_NAME	VARCHAR	No
	The county for the return address when shipping prescriptions. The category values for this column were already listed for column: DELIVERY_COUNTY_C_NAME
31	RETURN_COUNTRY_C_NAME	VARCHAR	No
	The country for the return address when shipping prescriptions. The category values for this column were already listed for column: DELIVERY_COUNTRY_C_NAME
32	PACKAGE_WEIGHT	NUMERIC	No
	The weight of the package when shipping prescriptions to patients. The weight is always stored in grams and converted to appropriate units.
33	SHIP_TOTAL_COST	NUMERIC	No
	Stores the total cost of goods in the shipment. Represents the retail price of the goods that it would cost to replace the shipment were it to be lost.
34	SHIP_PCKG_TYPE_C_NAME	VARCHAR	No
	Stores the type of package used for delivering the shipment. May contain organization-specific values: Yes No Entries Defined
35	SHIP_EXTERNAL_IDENTIFIER	VARCHAR	No
	Stores the external Identifier for this shipment so the external system can give us updates at a later point.
36	SHIP_DELIV_DATE	DATETIME	No
	Contains the estimated delivery date for the shipment to arrive.
37	SHIP_DELIV_COST	NUMERIC	No
	Stores the cost of shipping for this package.
38	SHIP_STATUS_C_NAME	VARCHAR	No
	Contains the status of the shipment we are sending. May contain organization-specific values: No Category Entries: Incomplete Waiting to Send Waiting for Tracking Information Complete Canceled Unspecified Error
39	SHIPMENT_WORKFLOW_C_NAME	VARCHAR	No
	Stores the workflow that started this shipment. This is used internally to drive what actions to take when the shipment is completed. May contain organization-specific values: No Category Entries: OP Pharmacy Point of Sale
40	DELIVERY_TIMING_C_NAME	VARCHAR	No
	Describes when the work request should arrive at the patient if the delivery method is similar to mail or courier. May contain organization-specific values: No Category Entries: Deliver By Deliver On
41	RX_DELIVERY_PHONE	VARCHAR	No
	Contains a phone number to call/text to contact the person receiving a shipment.
42	RX_DELIVERY_EMAIL	VARCHAR	No
	Stores the email that should be used to contact the person receiving a shipment.
43	RETURN_ADDR_PHONE	VARCHAR	No
	The phone number added to the return address for a shipping label.
44	RX_DELIVERY_DATE	DATETIME	No
	The date when the shipment is to arrive at the patient's address.
45	OTHER_AMOUNT_TOTAL	NUMERIC	No
	This item contains the total amount due for other items in this dispense transaction.