ERX_EVENT
Description:
This table holds information about e-prescribing event and e-prescribing error resolution for Inpatient E-Prescribing.
Starting in the May 23 version, it will also hold information about e-prescribing error resolution for Ambulatory E-Prescribing.

Primary Key
Column Name Ordinal Position
ORDER_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 ORDER_ID NUMERIC No
The unique identifier (.1 item) for the order record.
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 ERX_EVENT_C_NAME VARCHAR No
This item stores the type of e-prescribing event.
May contain organization-specific values: No
Category Entries:
New Prescription
Discontinue Prescription
Insignificant Change
Resupply
Adjust Time
Pharmacy Replace
4 ERX_STATUS_C_NAME VARCHAR No
This item stores the status of an e-prescribing event.
May contain organization-specific values: No
Category Entries:
Succeeded
Manual Follow Up Needed
Manual Follow Up Completed
Not Needed
Faxed
In Progress
Printed
Done From IB
Not Responsible
5 ERX_UTC_DTTM DATETIME (UTC) No
This item stores the instant of an e-prescribing event.
6 ERX_USER_ID VARCHAR No
This item stores the user who initiated an e-prescribing event. If no user is listed, then the event was initiated by a background job (interface, order transmittal, etc.).
7 ERX_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.