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_SNOMED_ID	NUMERIC	No
	The SNOMED CT code associated with the suggestion.
6	SUGGESTION_PRIM_DX_ID	NUMERIC	No
	The ICD diagnosis code associated with the suggestion for the primary code set.
7	SUGGESTION_ALT_DX_ID	NUMERIC	No
	The ICD diagnosis code associated with the suggestion for the alternate code set.
8	SUGGESTION_TEXT	VARCHAR	No
	The text prompt of the suggestion.
9	SUGGESTION_SELECT_YN	VARCHAR	No
	Whether the suggestion has been selected by the physician. May contain organization-specific values: No Category Entries: No Yes
10	QUERY_CSN_ID	NUMERIC	No
	The contact serial number (CSN) of the contact.