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.