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