MYC_MESG_SURG_QTNS

Description:

This table contains patient answers to sexual activity 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	SURG_QUESN_ID	VARCHAR	No
	The ID of the surgical history question answered by the patient.
4	SURG_QUESN_ID_RECORD_NAME	VARCHAR	No
	The name of the Visit Navigator (VN) History Template Definition (LQH) record.
5	SURG_QUESN_RESP_C_NAME	VARCHAR	No
	The patient's response to the surgical history question. May contain organization-specific values: No Category Entries: Yes No No Response
6	SURG_QUESN_DT	VARCHAR	No
	The date entered by the patient for the surgical history question.
7	SURG_QUESN_CMT	VARCHAR	No
	The comment entered by the patient for the surgical history question.
8	SURG_QUESN_FILED_YN	VARCHAR	No
	The filed status of the surgical history question--has the provider filed it to the patient's record. May contain organization-specific values: No Category Entries: No Yes