SNAPSHOT_ORDER_DATA
Description:
This table has the identifiers for individual data elements that were stored at the time of discharge or when the patient's After Visit Summary was printed. The actual snapshot data is in the SNAPSHOT_ORD_INFO_VALUE table.

Primary Key
Column Name Ordinal Position
EVENT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 EVENT_ID VARCHAR No
The unique identifier (.1 item) for the discharge reconciliation event 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 SNAPSHOT_ORDERS_LINE INTEGER No
The line number of the associated snapshot information for this order. Together with EVENT_ID, this forms the foreign key to the SNAPSHOT_ORDERS table.
4 SNAPSHOT_ORD_KEY_C_NAME VARCHAR No
The category ID for the orders' individual data element that was stored.
May contain organization-specific values: No
Category Entries:
Quantity
Refills
Note to Pharmacy
Diagnosis Associations
Dose
Future Start Date
End Date
Generic Name
Authorizing Provider
Instructions
Order ID
Order Name
Indications of Use
What Changed
Discontinue Date
Common Names
Amount and time last given
Time last given
Non-adherence Warning
Replaces order
Replaced by order
Ask reason
Partial-stop warning
Multi-stop warning
Criticality Reason
Translated Sig
Translated Sig Language
Start of Med Name
End of Med Name
Past or Future Start Date
Duration
Rx Reference Number
Anticoagulation Episode Warfarin Instructions
Abbreviated Dosage
Assistance Eligibility Indication
Partial-pause warning
Pause reason (Provider)
Pause comment (Provider)
Criticality warning
Name Conflict Warning