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