ORDER_HOLD_INFO

Description: |
This table contains hold related information for orders that were held/unheld.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ORDER_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ORDER_ID | NUMERIC | No |
The unique identifier 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 | ACTION_C_NAME | VARCHAR | No |
The hold information category ID for an order record, which indicates a type of change to an order's hold status. Holding an order indicates that a medication should not have any doses administered for a specific or indefinite period of time.
May contain organization-specific values: No
Category Entries:
Init Hold
Unhold
Edit Hold
Cancel Hold
4 | SOURCE_C_NAME | VARCHAR | No |
The order source category ID, indicating where in the EHR the order was held or unheld.
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
5 | MAR_SCHD_TIME_SOURCE_C_NAME | VARCHAR | No |
The scheduled time source category ID for the order record that was used when the order was held or unheld.
May contain organization-specific values: No
Category Entries:
After Signing
MAR
After Pharmacy Edit
After Adjust Times
End of Day Rescheduling
Edit Infusion Rate on Live Order
Edit Ending Information on a Live Order
Scheduled from Triggered Fills
Anesthesia
Nursing Narrator
Infusion Verify
Surgery Intra-op Navigator
Invasive Labs Narrator
Schedule Reset After Modify
Stop Infusion From Narrator
Orthopaedic
Leave of Absence Auto-hold
Discontinue Auto-unhold
Transfer Auto-hold Unreviewed
Transfer Auto-hold/unhold
Other Auto/Bulk Hold/Unhold
Manual Hold/Unhold
From Treatment Plan Hold/Unhold
Provider Hold/Unhold
Create CAM
Order Transmittal Hold/Unhold
Pump Start - MAR
BCA Web
Unfiled Infusion Verify
Assign Responsibility Hold/Unhold
Hold/Unhold CAM on Reconciliation
Order End Time
Pumps Auto File
6 | MAR_ACTION_C_NAME | VARCHAR | No |
The result category ID for the order record, indicating the action shown in the medication administration record when holding or unholding the order.
May contain organization-specific values: Yes
Category Entries:
Given
Missed
Refused
Canceled Entry
Held
New Bag
Restarted
Stopped
Rate Change
MAR Hold
MAR Unhold
Bolus
Push
Rate Verify
See Alternative
Paused
Prepared
Pending
Automatically Held
Due
7 | USER_ID | VARCHAR | No |
The unique identifier of the user specified when holding (marking doses that should temporarily not be administered) or this order.
8 | USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
9 | RECORDED_INSTANT_DTTM | DATETIME (Local) | No |
This column stores the current local instant when the order was held (marking doses that should temporarily not be administered)/unheld.
10 | HOLD_DURATION | INTEGER | No |
The numeric amount of the duration specified for holding an order.
11 | HOLD_DURATION_UNIT_C_NAME | VARCHAR | No |
The hold duration unit category ID for the order record.
May contain organization-specific values: No
Category Entries:
Doses
Minutes
Hours
Days
Until manually unheld
12 | REASON_C_NAME | VARCHAR | No |
This column stores the reason specified when holding (marking doses that should temporarily not be administered)/unholding an order.
May contain organization-specific values: Yes
13 | COMMENTS | VARCHAR | No |
The comments entered when holding or unholding an order.
14 | 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.
15 | ORDER_SIGN_ACTION_C_NAME | VARCHAR | No |
The sign action category ID for the order.
May contain organization-specific values: No
Category Entries:
Sign
Sign & Hold
Sign & Hold (Suppress Reason Popup)
Release Signed & Held
Pend / Save Work
16 | HOLD_START_UTC_DTTM | DATETIME (UTC) | No |
Stores the UTC instant at which this holding action should start.
17 | HOLD_END_UTC_DTTM | DATETIME (UTC) | No |
Stores the UTC instant at which this holding action should end.
18 | STOP_TAKING_DATE | DATETIME | No |
The date on which the patient should temporarily stop taking this med - that is, the date of the first dose to skip.
19 | STOP_TAKING_TIME_OF_DAY_C_NAME | VARCHAR | No |
The category ID for the time of day (morning, bedtime, etc.) when the patient should temporarily stop taking this med - that is, the time of the first dose to skip.
May contain organization-specific values: Yes
Category Entries:
Morning
Around Noon
Afternoon
Evening
Bedtime
As Needed
Anytime
Late Morning
None
Other
20 | RESTART_TAKING_DATE | DATETIME | No |
The date on which the patient should restart taking this med - that is, the date of the first dose to take after the pause.
21 | RESTART_TAKING_TIME_OF_DAY_C_NAME | VARCHAR | No |
The category ID for the time of day (morning, bedtime, etc.) when the patient should restart taking this med - that is, the time of the first dose to take after the pause.
The category values for this column were already listed for column: STOP_TAKING_TIME_OF_DAY_C_NAME
22 | PAT_COMMENTS | VARCHAR | No |
Comments directed to the patient about an instruction to pause taking this medication.
23 | HOLD_PAT_ENC_CSN_ID | NUMERIC | No |
This stores the CSN of the encounter where this hold action was taken.
24 | HOLD_START_STATUS_C_NAME | VARCHAR | No |
Determines how the hold start instant should be interpreted. If this is blank or set to 0 then HOLD_START_UTC_DTTM should be interpreted as is. If this is anything else, HOLD_START_UTC_DTTM will be interpreted differently.
May contain organization-specific values: No
Category Entries:
Normal
Unknown
Date Only