NAV_ACTORD_AUD_TRL
Description:
Table for inpatient navigator active orders audit trail.

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 IP_NAV_AUDIT_USR_ID VARCHAR No
The unique identifier of the user who viewed or took an action on the order.
4 IP_NAV_AUDIT_USR_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
5 IP_NAV_AUDIT_DTTM DATETIME (Local) No
The instant an action was taken on an order record.
6 IP_NAV_AUDIT_ACTN_C_NAME VARCHAR No
The action category ID for the order record, indicating the action taken in an inpatient navigator.
May contain organization-specific values: No
Category Entries:
Active
Discontinue
Modify
Review
Renew
Let Expire
Reorder
Confirm Auto DC
Undo Let Expire
Init Hold
Unhold
Edit Hold
Cancel Hold
Second Sign Reject
Second Sign Accept
Second Sign Modify
Second Sign Review and Accept
Replace
Unknown
7 IP_NAV_AUDIT_CTXT_C_NAME VARCHAR No
The context category ID for the order record, indicating the type of navigator in which an action was taken.
May contain organization-specific values: No
Category Entries:
Admission Navigator
Transfer Navigator
Discharge Navigator
Clinician Orders
Order Entry
OrderSet
CUSTOM
Web
Order Review Reorder
Rx Orders
Medication Reorder
Rounding Navigator
Ancillary Orders
OutReach
Pre-Transfer Navigator
Departure Navigator
Arrival Navigator
Treatment Plan Pre-Verify
Results Console
Case/Log Study Auto-generation
Created by Referral
Lab Requisition Entry
Order Review Resulting Agency Modify
Ultrasounds
Specialty Back Office Navigator
Link Health Maintenance
Ord Rec Admission Review PTA
Ord Rec Admission Reorder PTA
Ord Rec Admission New Orders
Ord Rec PreTransfer Review Current
Ord Rec PreTransfer Details
Ord Rec PreTransfer Restart
Ord Rec PreTransfer Reorder
Ord Rec PreTransfer New Orders
Ord Rec Arrival Release
Ord Rec Arrival New Orders
Ord Rec Discharge Review Orders
Ord Rec Discharge New Orders
Anesthesia Intra-op
NoteWriter
Invasive Labs Narrator
Medication List
Nursing Narrator
Problem List
SmartSet
Ord Rec Interfacility-Transfer Review
Ord Rec Interfacility-Transfer New Orders
Releaser
Anticoagulation tracking section entry
ED Discharge
Ord Rec Admission Restart Previous
Ord Rec Interfacility-Transfer Reorder PTA
Modify from Medications Activity
Modify from Order Review
Modify from Rounding Navigator
Modify from Report
Modify from Rx Sidebar
Modify from Treatment Plan
Modify from Manage Orders
ED Single Screen Disposition
Historical Cervical Cytology
Modify from SxS Admission
HH Remote Client Lab Result
Unlinked Procedure Note Auto-Generation
Rx Refill Request
Anesthesia Ord Rec
Anesthesia Ord Rec New Orders
External Order
OP Visit Taskbar
Surgery Navigator
Surgery Processed
Verify Orders
Surgery Intra-op Navigator
Specimen Collection
Surgery Pick List
Haiku
Haiku for Android
Canto
Canto SmartSet
Rover
Mobile Mass Immunization
Rover for Android
On-the-fly
Manage Orders
OP Orders in Managed Orders
Bulk Orders
Orthopaedic Injection
Interface
Donor Organ Editor
Central Medication Database
ProcDoc Injection
FMK Side by Side
Anticoag Navigator Reorder and Sync
Imm On-the-fly Order
Imaging Protocol Work List
Appointment Entry
Appointment Check In
Cadence Decision Tree
RxFill Dispense Review
Automatically Reconciled Lab Result
External Medication Order
Automatically Reconciled MyChart Titer
Automatically Reconciled Imaging Result
Medication Automatic Conversion Utility
Dermatology Exam
Campaigns Orders
MyChart Self-Triage
Social Care Application
HH/HSPC Remote Client Medication
HH/HSPC Remote Client Med Admin
HH/HSPC In Basket Med Reconciliation
BCA Web
Health Maintenance Single Care Gap Closure
Rapid Transfuse
Converted from Case
Dental
Dental Visit
Orders and Results Anywhere Network Interface
Instant Order OPA
TDR Printing Workflow Simulation
Imaging and Procedures - One Step Medications
Imaging and Procedures - Performed
Facility Administered Medications
Create CAM
Lab Downtime Specimen Linking
Lab Specimen Update
Haiku iOS Voice Assistant
8 IP_NAV_AUDIT_PROV_ID VARCHAR No
The item saves the provider (or the authorizing provider) who viewed or took an action on the order.