VISIT_SET_HX_CHANGE

Description:

The VISIT_SET_HX_CHANGE table contains details of what items were modified in a revision of a visit set. Information about the user modifying the visit set and the time of modification can be found in VISIT_SET_HX_REVISION.

Primary Key

Column Name	Ordinal Position
VISIT_SET_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	VISIT_SET_ID	NUMERIC	No
	The unique identifier (.1 item) for the visit set 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	AUDIT_TRAIL_REVISION	INTEGER	No
	The revision in which this update was made. Corresponds with a line of VISIT_SET_HX_REVISION.
4	AUDIT_TRAIL_ITEM	VARCHAR	No
	The number of the item that was updated
5	AUDIT_TRAIL_LINE	INTEGER	No
	The line of the item in AUDIT_TRAIL_ITEM being updated. 1 for single response items.
6	AUDIT_TRAIL_NEW_VALUE	VARCHAR	No
	The new value of the item in AUDIT_TRAIL_ITEM at the line in AUDIT_TRAIL_LINE, after the update is made.