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 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 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 Ambient
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
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.