ORDER_DEVIATION_INFO

Description:

This table stores order-level deviation information (in an oncology treatment plan context), including deviation instant, user, and change type.

Primary Key

Column Name	Ordinal Position
OTP_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	OTP_ID	NUMERIC	No
	The unique identifier for the patient order template 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	DEVIATION_UTC_DTTM	DATETIME (UTC)	No
	This is the instant the order deviated within a patient's oncology treatment plan.
4	DEVIATION_USER_ID	VARCHAR	No
	This is the user who caused an order deviation within a patient's oncology treatment plan.
5	DEVIATION_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.