AUDIT_ORD_RXNOADD
Description:
This table provides general information on changes to specified no-add items in the order (ORD) master file. The detail item information is saved in AUDIT_ORD_RXITEMS table.

Primary Key
Column Name Ordinal Position
ORDER_MED_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 ORDER_MED_ID NUMERIC No
The unique ID of the medication order (prescription) record. NOTE: This is an internal unique identifier for ORD master file records in this table and cannot be used to link to CLARITY_MEDICATION.
2 LINE INTEGER No
The line number for each change.
3 AUDIT_EMP_USER_ID VARCHAR No
The unique user ID who made the change.
4 AUDIT_EMP_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
5 AUDIT_UPDATE_INST DATETIME (Local) No
The instant of change.
6 AUDIT_UPD_COMMENT VARCHAR No
The comment for the change.
7 AUDIT_ACTION_C_NAME VARCHAR No
The action category to cause the change.
May contain organization-specific values: No
Category Entries:
Rx Verify
Admin Instruction Change
Rate Change
Order Duration Change
Order Modified
Multistep
Orders Correction Utility
Adjust Times for Linked Orders
Patient Transfer
Pharmacy Review
Prescription Transfer
Prescription Refill
Deferred
Signed & Held Modification
Rx FAM Autoverify
Order Transmittal
RIS Change Order
Automated adjustment due to Inventory
Adjust Times
Rx Autoverify
Notification Requests Modified
Automatic End Time Adjustment on Administration
SmartForm Change
Original Provider Change
Administration Responsibility Change
Prescription Transfer Canceled
Sign Order
Order Released
Automatic Adjustment on Prescription Fill
Provider Hold Action
Automatic Order Substitution
Provisional Verify
Automatic Prescription Expiration Date Update
Dispensing Verify
Prevent Dispensing By Pharmacy
Order Transcribed
Automatic End Date Adjustment on Scheduling
Advance Prep Canceled
Product Change
Provisional Defer
Revert Provisional Verify
Canceled Dispensing Action
Canceled Autoverify Action
INR Control Date Change
8 AUDIT_OTX_PASS_NUM INTEGER No
This item records the number of the order transmittal pass.