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_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
24 | RX_DELIVERY_DATE | DATETIME | No |
The date when the shipment is to arrive at the patient's address.
25 | OTHER_AMOUNT_TOTAL | NUMERIC | No |
This item contains the total amount due for other items in this dispense transaction.