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
BMI
Note
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.
8 | EVIDENCE_COMMON_NAME | VARCHAR | No |
The common name of a lab evidence.
9 | EVIDENCE_ORDER_ID | NUMERIC | No |
The ID of the order associated with a piece of evidence.
10 | EVIDENCE_ORDER_DAT | NUMERIC | No |
The contact of the order associated with a piece of evidence.
11 | EVIDENCE_NUM_VALUE | NUMERIC | No |
The numeric value of a piece of evidence.
12 | EVIDENCE_INSTANT_UTC_DTTM | DATETIME (UTC) | No |
The UTC instant for a piece of evidence.