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.
7 | EVIDENCE_QUESTION_ID_QUEST_NAME | VARCHAR | No |
The name of the question record.