SNAPSHOT_ORD_INFO_VALUE

Description:

This table has the values for individual data elements that were stored at the time of discharge or when the patient's After Visit Summary was printed. The keys identifying the elements are in the SNAPSHOT_ORDER_DATA table.

Primary Key

Column Name	Ordinal Position
EVENT_ID	1
GROUP_LINE	2
VALUE_LINE	3

Column Information

	Name	Type	Discontinued?
1	EVENT_ID	VARCHAR	No
	The unique identifier (.1 item) for the discharge reconciliation event record.
2	GROUP_LINE	INTEGER	No
	The line number of the associated snapshot data key for this value. Together with EVENT_ID, this forms the foreign key to the SNAPSHOT_ORDER_DATA table.
3	VALUE_LINE	INTEGER	No
	The line number of one of the parts of the value that was stored in the snapshot.
4	SNAPSHOT_ORD_VALUE	VARCHAR	No
	One line of the value that was stored in the snapshot. All lines of this data element (that is, all lines with the same EVENT_ID and GROUP_LINE values) should be concatenated to get the full value.