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 Medication Comment 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