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