MYC_MESG_DRG_QTNS

Description:

This table contains patient answers to drug 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	DRG_QUESN_ID	VARCHAR	No
	The ID of the drug use history question answered by the patient.
4	DRG_QUESN_ID_RECORD_NAME	VARCHAR	No
	The name of the Visit Navigator (VN) History Template Definition (LQH) record.
5	DRG_QUESN_RESP_C_NAME	VARCHAR	No
	The patient's response to the question about drug use. May contain organization-specific values: No Category Entries: Yes No Not Asked Defer Not Currently Never
6	DRG_QUESN_FREQ	VARCHAR	No
	The patient's response to the drug use frequency question.
7	DRG_QUESN_CMT	VARCHAR	No
	The comment added by the patient when answering the drug use question.
8	DRG_QUESN_FILED_YN	VARCHAR	No
	The filed status of the drug use question--has the provider filed it to the patient's record. May contain organization-specific values: No Category Entries: No Yes
9	DRG_QUESN_FILED_USER_ID	VARCHAR	No
	Stores the ID of the user who reconciled this drug use history data.
10	DRG_QUESN_FILED_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
11	DRG_QUESN_FILED_LOCAL_DTTM	DATETIME (Local)	No
	Stores the instant (in local time) this drug use history data was filed.