QRY_CONTACT_INFO

Description: |
The QRY_CONTACT_INFO table contains information about the overtime single response data for query records (records in the QRY master file). Each row in the table represents an individual contact for a query record, and each query record itself represents a single query.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
QUERY_CSN_ID | 1 |

Column Information

| 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
20 | USR_WRKFLW_C_NAME | VARCHAR | No |
This item describes what workflow the user responded to the QRY in.
May contain organization-specific values: No
Category Entries:
Point of Care
Pre-Visit Review