MYC_MESG_QUESR_ANS

Description: |
This table stores information on questionnaire answers that have been attached to web based chart system (WMG) messages. When a patient fills out a message with an attached questionnaire, the resulting message back to the provider will have Questionnaire Answer (HQA) records attached. This table shows those HQA records.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
MESSAGE_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | MESSAGE_ID | VARCHAR | No |
The unique ID used to identify a web based chart system message record.
2 | LINE | INTEGER | No |
The line number used to identify each row of read data associated with an individual web based chart system message record.
3 | QUESR_ANS_ID | VARCHAR | No |
This stores the IDs of the questionnaire answers associated with this message.