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.