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