QRY_SUGGESTION_INFO
Description:
This table extracts the suggested diagnosis code and the text description of the diagnosis suggestion for a query.

Primary Key
Column Name Ordinal Position
QUERY_CSN_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 QUERY_ID NUMERIC No
The unique identifier for the query record.
2 LINE INTEGER No
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
4 SUGGESTION_NAME VARCHAR No
The display name of the suggested code.
5 SUGGESTION_PRIM_DX_ID_DX_NAME VARCHAR No
The name of the diagnosis.
6 SUGGESTION_ALT_DX_ID_DX_NAME VARCHAR No
The name of the diagnosis.
7 SUGGESTION_TEXT VARCHAR No
The text prompt of the suggestion.
8 SUGGESTION_SELECT_YN VARCHAR No
Whether the suggestion has been selected by the physician.
May contain organization-specific values: No
Category Entries:
No
Yes
9 QUERY_CSN_ID NUMERIC No
The contact serial number (CSN) of the contact.