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.