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