OVERRIDE_TIME_HX

Description:

The OVERRIDE_TIME_HX table contains information about order override time history.

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	IP_OVRD_TM_BY_ID	VARCHAR	No
	The unique ID of the user who adjusted the times or schedule. If the times or schedule are adjusted and then the order is verified, it will contain the ID of the user who verified the order.
4	IP_OVRD_TM_BY_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
5	OVRD_UPD_AT_TM	DATETIME (Local)	No
	This is the instant at which the times for the order were set. If the times were adjusted and then the order was verified, the instant the order was verified will be stored.
6	OVRD_TIMES	VARCHAR	No
	Stores the override scheduled times for the order if the order has a specified frequency.
7	OVRD_INST_NS_TM	DATETIME (Local)	No
	Stores the override schedule time for orders with a non-specified frequency.
8	OVRD_REASON_C_NAME	VARCHAR	No
	Stores the override reason for adjusting the medication administration times. May contain organization-specific values: Yes
9	IP_OVRDTM_SRCDEP_ID_EXTERNAL_NAME	VARCHAR	No
	The external name of the department record. This is often used in patient correspondence such as reminder letters.
10	MLSIG_PERIOD_AND_PART	VARCHAR	No
	Stores multiline sig period and part the override data came from