MYC_MESG_ALC_QTNS
Description:
This table contains patient answers to alcohol use questions submitted in a history questionnaire.

Primary Key
Column Name Ordinal Position
MESSAGE_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 MESSAGE_ID VARCHAR No
The unique identifier for the message 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 ALC_QUESN_ID VARCHAR No
The ID of the alcohol history question answered by the patient.
4 ALC_QUESN_ID_RECORD_NAME VARCHAR No
The name of the Visit Navigator (VN) History Template Definition (LQH) record.
5 ALC_QUESN_RESP_C_NAME VARCHAR No
The patient's response to the question about alcohol use.
May contain organization-specific values: No
Category Entries:
Yes
No
Not Asked
Defer
Not Currently
Never
6 ALC_QUESN_CMT VARCHAR No
The comment added by the patient when answering the alcohol use question.
7 ALC_QUESN_FILED_YN VARCHAR No
The filed status of the alcohol question--has the provider filed it to the patient's record.
May contain organization-specific values: No
Category Entries:
No
Yes