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

Primary Key
Column Name Ordinal Position
NOTE_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 NOTE_ID VARCHAR No
The unique identifier (.1 item) for the note 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 QRY_EVIDENCE_TYPE_C_NAME VARCHAR No
The type of evidence that support the suggestion of the query.
May contain organization-specific values: No
Category Entries:
Problem
Medication
Result
Vital
Other
BMI
Note
Scanned Document
4 EVIDENCE_NAME VARCHAR No
The display name of the evidence to support the suggestion of the query. This can range from the lab result to an excerpt from a clinical note.
5 EVIDENCE_SOURCE_C_NAME VARCHAR No
The source of evidence that support the suggestion of the query.
May contain organization-specific values: No
Category Entries:
Note
6 EVID_MENTIONED_YN VARCHAR No
List of 0's and 1's indicating which of the AI-generated evidence the user chose to include in the query.
May contain organization-specific values: No
Category Entries:
No
Yes
7 EVIDENCE_COMMON_NAME VARCHAR No
The common name of a lab evidence.
8 EVIDENCE_ORDER_ID NUMERIC No
The ID of the order associated with a piece of evidence.
9 EVIDENCE_NUMERIC_VALUE NUMERIC No
The numeric value of a piece of evidence.
10 EVIDENCE_INSTANT_UTC_DTTM DATETIME (UTC) No
The UTC instant for a piece of evidence.