DAY_AUDIT_TRAIL

Description:

Stores the treatment day audit trail information.

Primary Key

Column Name	Ordinal Position
TREATMENT_PLAN_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	TREATMENT_PLAN_ID	NUMERIC	No
	The unique identifier for the plan 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	DAY_AUD_ACTION_C_NAME	VARCHAR	No
	Stores the action taken on the day. May contain organization-specific values: No Category Entries: Treatment Day Status Changed Treatment Day Planned Date Changed Treatment Day Given Externally Details Modified Treatment Day Deferred Details Modified Treatment Day Canceled Details Modified Treatment Day Reactivated Treatment Day Type Changed Treatment Day Length Changed
4	DAY_AUD_LINE_NUM	VARCHAR	No
	Stores the line number of the day in the treatment plan.
5	DAY_AUD_UTC_DTTM	DATETIME (UTC)	No
	Stores the UTC instant at which the action was performed.
6	DAY_AUD_OLD_VALUE	VARCHAR	No
	Stores the old value for the action.
7	DAY_AUD_NEW_VALUE	VARCHAR	No
	Stores the new value for the action.
8	DAY_AUD_COMMENT	VARCHAR	No
	Stores the comment for performing the action.
9	DAY_AUD_REASON	VARCHAR	No
	Stores the reason for the performing the action.
10	DAY_AUD_USR_ID	VARCHAR	No
	Stores the user who performed the action.
11	DAY_AUD_USR_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.