RADIOTHERAPY_AUDIT_TRAIL

Description:

This table contains audit information for each contact of an ERT record.

Primary Key

Column Name	Ordinal Position
RT_SUMMARY_ID	1
CONTACT_DATE_REAL	2
LINE	3

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	CONTACT_OLD_VERSION_NUMBER	INTEGER	No
	Stores the FHIR version ID the old value was associated with.
5	ITEM_NUMBER	INTEGER	No
	Stores the changed item number for an audit trail entry.
6	INSTANT_UTC_DTTM	DATETIME (UTC)	No
	Stores the instant the change being audited was applied to the contact.
7	ITEM_LINE	INTEGER	No
	Stores the line number of the old value in the associated item.
8	ITEM_PIECE	INTEGER	No
	For related-multi items, stores the piece number of the old value in the associated item on the associated line.
9	OLD_VALUE	VARCHAR	No
	Stores the old value for the associated item on the associated line and piece number.
10	NEW_VALUE	VARCHAR	No
	This item contains the new value of the item stored in related item 5001 when the value changes.