V_EHI_AUDIT_DCS

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

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
DOC_INFO_ID | 1 |
CHANGE_TIME | 2 |
CHANGED_DATA_ELEMENT | 3 |
LINE | 4 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | DOC_INFO_ID | VARCHAR | No |
The unique ID of the document information record.
2 | PAT_ID | VARCHAR | No |
The unique ID of the patient associated with the document record.
3 | CHANGE_TIME | DATETIME (Local) | No |
The instant when the value was changed.
4 | LINE | INTEGER | No |
Audit of the line number that changed
5 | NEW_VALUE_EXTERNAL | VARCHAR | No |
The value after the audited change in external format. This column shows the translated external value as of when the column was last extracted.
6 | OLD_VALUE_EXTERNAL | VARCHAR | No |
The value before the audited change in external format. This column shows the translated external value as of when the column was last extracted.
7 | NEW_VALUE_INTERNAL | VARCHAR | No |
The value of the item after it was changed in internal format.
8 | OLD_VALUE_INTERNAL | VARCHAR | No |
The value of the item before it was changed in internal format.
9 | CHANGED_DATA_ELEMENT | VARCHAR | No |
The name of the Clarity table and column corresponding to the changed data.
10 | USER_ID | VARCHAR | No |
The ID of the employee who changed the item.
11 | USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.