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.