QRY_EVIDENCE

Description:

This table extracts evidence-related information (such as vitals, medication, results) tied to a query.

Primary Key

Column Name	Ordinal Position
QUERY_CSN_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	QUERY_ID	NUMERIC	No
	The unique identifier for the query record.
2	LINE	INTEGER	No
	The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
4	EVIDENCE_NAME	VARCHAR	No
	The display name of the evidence.
5	EVIDENCE_TYPE_C_NAME	VARCHAR	No
	The type of evidence used to create a query. May contain organization-specific values: No Category Entries: Problem Medication Result Vital Other
6	QUERY_CSN_ID	NUMERIC	No
	The contact serial number (CSN) of the contact.