V_EHI_AUDIT_TPL_DAY
Description:
Translates DAY_AUDIT_TRAIL.

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_USR_ID VARCHAR No
Stores the user who performed the action.
6 DAY_AUD_USR_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
7 DAY_AUD_UTC_DTTM DATETIME (UTC) No
Stores the UTC instant at which the action was performed.
8 DAY_AUD_OLD_TRT_DAY_STATUS_C INTEGER No
Stores the old day status.
9 DAY_AUD_NEW_TRT_DAY_STATUS_C INTEGER No
Stores the new day status.
10 DAY_AUD_OLD_PLANNED_DATE DATETIME No
Stores the old day planned date.
11 DAY_AUD_NEW_PLANNED_DATE DATETIME No
Stores the new day planned date.
12 DAY_AUD_OLD_DAY_TYPE_C VARCHAR No
Stores the old day type.
13 DAY_AUD_NEW_DAY_TYPE_C VARCHAR No
Stores the new day type.
14 DAY_AUD_OLD_LENGTH INTEGER No
Stores the old day length.
15 DAY_AUD_NEW_LENGTH INTEGER No
Stores the new day length.
16 DAY_AUD_GIVEN_EXTER_RSN_C INTEGER No
Stores the reason for marking a day as given externally.
17 DAY_AUD_DEFER_DAY_RSN_C INTEGER No
Stores the reason for deferring a day.
18 DAY_AUD_CANCEL_DAY_RSN_C INTEGER No
Stores the reason for canceling a day.
19 DAY_AUD_COMMENT VARCHAR No
Stores the comment for performing the action.