OTP_REVIEW_HISTORY

Description:

This table contains the review history for a given patient order template. The review history consists of the review action, the reviewing user, and the instant of review.

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	ORD_REVIEW_STATUS_C_NAME	VARCHAR	No
	The review status category ID of an order in the treatment plan manager. An order can be unreviewed, reviewed, or changed since it was last reviewed. May contain organization-specific values: No Category Entries: Unreviewed Reviewed Changed
4	ORD_REV_UPDT_USR_ID	VARCHAR	No
	The unique ID of the user who changed the review status for the patient order template record.
5	ORD_REV_UPDT_USR_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
6	ORD_REVIEW_UPDT_TM	DATETIME (Local)	No
	The date and time the review status stored in the related line in the patient order template was updated.