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.