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
Resume/Pause
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
OP Follow-up
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
Non-Procedural Narrator One-step Med
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
Mobile POCT Duplicate
Mobile POCT On-The-Fly
On-the-fly
Manage Orders
Ord Rec Admission in 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
Imaging Meds Admin Navigator Section
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
Reconcile Outside Information
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
Automatically Reordered on Discharge-Readmit
Quick Orders
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
Ambient
Reorder from Chart Review
Recall
8 | IP_NAV_AUDIT_PROV_ID_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.