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