CODING_CLA_NOTES_SUGG
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
NOTE_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 NOTE_ID VARCHAR No
The unique identifier (.1 item) for the note record.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 SUGGESTION_PRIM_DX_ID NUMERIC No
The ICD diagnosis code associated with the suggestion for the primary code set.
4 SUGGESTION_ALT_DX_ID NUMERIC No
The ICD diagnosis code associated with the suggestion for the alternate code set.
5 SUGGESTION_NAME VARCHAR No
The display name of the suggested diagnosis code of the query.