V_EHI_AUDIT_ERT_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, RADIOTHERAPY_AUDIT_TRAIL should be used instead.

Primary Key
Column Name Ordinal Position
RT_SUMMARY_ID 1

Column Information
Name Type Discontinued?
1 RT_SUMMARY_ID NUMERIC No
The unique identifier (.1 item) for the radiotherapy summary record.
2 CONTACT_DATE_REAL FLOAT No
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3 LINE INTEGER No
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4 ITEM_LINE INTEGER No
Stores the line number of the old value in the associated item.
5 ITEM_PIECE INTEGER No
For related-multi items, stores the piece number of the old value in the associated item on the associated line.
6 AUDIT_USER_ID VARCHAR No
This item contains the user ID associated with the data changed on this line of the audit trail.
7 AUDIT_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
8 OLD_VALUE_INTERNAL VARCHAR No
Contains the old value of the item in internal chronicles format.
9 NEW_VALUE_INTERNAL VARCHAR No
Contains the new value of the item in internal chronicles format.
10 OLD_VALUE_EXTERNAL VARCHAR No
Contains the old value of the item in external format.
11 NEW_VALUE_EXTERNAL VARCHAR No
Contains the new value of the item in external format.
12 ITEM_NUMBER NUMERIC No
Stores the changed item number for an audit trail entry.
13 INSTANT_UTC_DTTM DATETIME (UTC) No
Stores the instant the change being audited was applied to the contact.
14 CHANGED_DATA_ELEMENT VARCHAR No
The table and column descriptor associated with the item in the ITEM_NUMBER column.
15 VERSION_NUMBER INTEGER No
Contains the version ID of the resource that this audit entry originated from.