|
Name |
Type |
Discontinued? |
|
1 |
QUERY_ID |
NUMERIC |
No |
|
|
|
The unique identifier for the query record. |
|
|
2 |
CONTACT_DATE |
DATETIME |
No |
|
|
|
The date of this contact in calendar format. |
|
|
3 |
QUERY_CSN_ID |
NUMERIC |
No |
|
|
|
The contact serial number (CSN) of the contact. |
|
|
4 |
CONTACT_NUM |
INTEGER |
No |
|
|
|
Contact number to identify the contact in the sequence of contacts. |
|
|
5 |
PRIM_RECIPIENT_USER_ID |
VARCHAR |
No |
|
|
|
The unique ID of the user primarily responsible for the query. |
|
|
6 |
PRIM_RECIPIENT_USER_ID_NAME |
VARCHAR |
No |
|
|
|
The name of the user record. This name may be hidden. |
|
|
7 |
SENDER_USER_ID |
VARCHAR |
No |
|
|
|
The sender of this query. |
|
|
8 |
SENDER_USER_ID_NAME |
VARCHAR |
No |
|
|
|
The name of the user record. This name may be hidden. |
|
|
9 |
RESPONDING_USER_ID |
VARCHAR |
No |
|
|
|
The unique ID of the user that responded to the query. |
|
|
10 |
RESPONDING_USER_ID_NAME |
VARCHAR |
No |
|
|
|
The name of the user record. This name may be hidden. |
|
|
11 |
NLP_STATUS_C_NAME |
VARCHAR |
No |
|
|
|
The category ID of the user's response to the query. |
May contain organization-specific values: No |
Category Entries: |
Not Read |
Read |
Ask Later |
Agree |
Disagree |
Decline |
Clinically Undetermined |
Converted |
Responded |
|
|
12 |
NLP_STATUS_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
Stores the instant when the Natural Language Processing (NLP) status changes in UTC. |
|
|
13 |
EXTERNAL_EVIDENCE |
VARCHAR |
No |
|
|
|
The external evidence reference resource URL of the query. |
|
|
14 |
INSTANT_OF_ENTRY_DTTM |
DATETIME (Attached) |
No |
|
|
|
The instant a query record was edited. |
|
|
15 |
RESOLVE_NOTE_CSN_ID |
NUMERIC |
No |
|
|
|
The note contact serial number (CSN) that resolves this query. |
|
|
16 |
RESOLVE_ATTEST_NOTE_CSN_ID |
NUMERIC |
No |
|
|
|
The attestation line (if any) of the note that resolved the query. |
|
|
17 |
INSTANT_OF_ENTRY_LOC_DTTM |
DATETIME (Attached) |
No |
|
|
|
The instant a contact was created in the patient's local time. |
|
|
18 |
QUERY_SUBJECT |
VARCHAR |
No |
|
|
|
This item stores the subject line of a query. |
|
|
19 |
QRY_CONTACT_TYPE_C_NAME |
VARCHAR |
No |
|
|
|
The type of update to the query. Not currently populated. |
May contain organization-specific values: No |
No Entries Defined |
|
|