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.