V_EHI_AUDIT_RT_HSB_ITEMS

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

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
SUMMARY_BLOCK_ID | 1 |
LINE | 2 |
RAD_THERAPY_AUD_INST_UTC_DTTM | 3 |
CHANGED_DATA_ELEMENT | 4 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | SUMMARY_BLOCK_ID | NUMERIC | No |
The unique ID of the episode of care 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 | RAD_THERAPY_AUDIT_ITEM_NUM | VARCHAR | No |
Stores the updated item.
4 | RAD_THERAPY_AUD_ITEM_LINE_NUM | VARCHAR | No |
This item stores the item line that was updated.
5 | RAD_THERAPY_AUDIT_USER_ID | VARCHAR | No |
Stores the user responsible for item update.
6 | RAD_THERAPY_AUDIT_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
7 | OLD_VALUE_INTERNAL | VARCHAR | No |
Contains the old value of the item in internal chronicles format.
8 | NEW_VALUE_INTERNAL | VARCHAR | No |
Contains the new value of the item in internal chronicles format.
9 | OLD_VALUE_EXTERNAL | VARCHAR | No |
Contains the old value of the item in external format.
10 | NEW_VALUE_EXTERNAL | VARCHAR | No |
Contains the new value of the item in external format.
11 | CHANGED_DATA_ELEMENT | VARCHAR | No |
The table and column descriptor associated with the item in the ITEM_NUMBER column.
12 | RAD_THERAPY_AUD_INST_UTC_DTTM | DATETIME (UTC) | No |
Stores the instant at which the item was updated.