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
8	ALC_QUESN_FILED_USER_ID	VARCHAR	No
	Stores the ID of the user who reconciled this alcohol history data.
9	ALC_QUESN_FILED_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
10	ALC_QUESN_FILED_LOCAL_DTTM	DATETIME (Local)	No
	Stores the instant (in local time) this alcohol history data was filed.