OTP_AUDIT_TRAIL

Description:

Stores the audit trail information.

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	UPDATED_BY_ID	VARCHAR	No
	User who updated the order.
4	UPDATED_BY_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
5	UPDATE_DTTM	DATETIME (Local)	No
	Time instant at which the order was updated.
6	UPDATE_ACTION_C_NAME	VARCHAR	No
	Action taken on the order. May contain organization-specific values: Yes Category Entries: Added Deleted Post-release modify Pre-release start time change Free text sig changed Unsigned External order added Dose change Other order change AUC - Target AUC change AUC - GFR source change AUC - CrCl formula change AUC - GFR order-specific value change AUC - sCr source change AUC - sCr order-specific value change ERX replaced by Medication Replacer Maximum BSA Change AUC - Use AUC Dose Conversion Status - Set to Unspecified Conversion Status - Set to Kept Conversion Status - Set to Removed Conversion Status - Set to Replaced Conversion Status - Set to Replacement Pharmacy Changed Sig Type Changed Scheduling Evaluated PBS - Script number change
7	UPDATE_REASON_C_NAME	VARCHAR	No
	Reason for updating the order. May contain organization-specific values: Yes Category Entries: Order created with treatment plan Initial Value Deferred Order created for plan conversion Build updated
8	UPDATE_COMMENT	VARCHAR	No
	Any additional comment for the updating the order.
9	UPDATE_VALUE	VARCHAR	No
	Stores the value of the item that changed (e.g. free text sig, start time) in the order.
10	UPDATE_ORDER_ID	NUMERIC	No
	This item contains the ID of the order that this action refers to.
11	SOURCE_OTP_ID	NUMERIC	No
	Holds the order template ID that is the source for this audit line.