V_EHI_AUDIT_ORG_RT_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_THP_VOLUME_AUDIT should be used instead.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ORG_RECORD_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ORG_RECORD_ID | NUMERIC | No |
The unique identifier (.1 item) for the radiotherapy volume record.
2 | LINE | INTEGER | No |
The line number for the information associated with this contact.
3 | AUDIT_USER_ID | VARCHAR | No |
This item contains the user ID associated with the data changed on this line of the audit trail.
4 | AUDIT_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
5 | ITEM_LINE | INTEGER | No |
Stores the line number of the old value in the associated item.
6 | INSTANT_UTC_DTTM | DATETIME (UTC) | No |
Stores the instant the change being audited was applied to the record.
7 | RT_VOL_AUD_ITEM | NUMERIC | No |
Stores the changed item number for an audit trail entry.
8 | CHANGED_DATA_ELEMENT | VARCHAR | No |
The table and column descriptor associated with the item in the RT_VOL_AUD_ITEM column.
9 | OLD_VALUE_INTERNAL | VARCHAR | No |
Contains the old value of the item in internal chronicles format.
10 | NEW_VALUE_INTERNAL | VARCHAR | No |
Contains the new value of the item in internal chronicles format.
11 | OLD_VALUE_EXTERNAL | VARCHAR | No |
Contains the old value of the item in external format.
12 | NEW_VALUE_EXTERNAL | VARCHAR | No |
Contains the new value of the item in external format.
13 | VERSION_NUMBER | VARCHAR | No |
Contains the version ID of the resource that this audit entry originated from.