V_EHI_AUDIT_TPL

Description: |
This view contains audit information for document records for the purpose of Electronic Health Information (EHI) export. If not in the EHI context, TPL_AUDIT_TRAIL should be used instead.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
TREATMENT_PLAN_ID | 1 |
LINE | 2 |
AUD_UPDATE_LOCAL_DTTM | 3 |
CHANGED_DATA_ELEMENT | 4 |

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 | AUD_ITM_NUM | INTEGER | No |
Stores the item number that was updated.
4 | AUD_ITM_ASSOCIATED_LINE_NUM | INTEGER | No |
If the item in the AUD_ITM_NUM column is related response or multiple response, this column (AUD_ITM_ASSOCIATED_LINE_NUM) stores the line number of the value that was updated.
5 | AUD_USER_ID | VARCHAR | No |
Stores the user who modified the item.
6 | AUD_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
7 | OLD_VALUE_INTERNAL | VARCHAR | No |
Stores the old value of the item that was changed in internal format.
8 | NEW_VALUE_INTERNAL | VARCHAR | No |
Stores the new value of the item that was changed in internal format.
9 | OLD_VALUE_EXTERNAL | VARCHAR | No |
Stores the old value of the item that was changed in external format.
10 | NEW_VALUE_EXTERNAL | VARCHAR | No |
Stores the new value of the item that was changed in external format.
11 | CHANGED_DATA_ELEMENT | VARCHAR | No |
The name of the Clarity table and column corresponding to the changed data.
12 | AUD_UPDATE_LOCAL_DTTM | DATETIME (Local) | No |
Stores the instant at which the item was updated.