MYC_MESG_SEX_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	SEX_QUESN_ID	VARCHAR	No
	The ID of the sexual activity history question answered by the patient.
4	SEX_QUESN_ID_RECORD_NAME	VARCHAR	No
	The name of the Visit Navigator (VN) History Template Definition (LQH) record.
5	SEX_QUESN_RESP_C_NAME	VARCHAR	No
	The patient's response to the sexual history question. May contain organization-specific values: No Category Entries: Yes Never Not Asked Not Currently Defer
6	SEX_QUESN_CMT	VARCHAR	No
	The comment entered by the patient for the sexual history question.
7	SEX_QUESN_FILED_YN	VARCHAR	No
	The filed status of the sexual activity question--has the provider filed it to the patient's record. May contain organization-specific values: No Category Entries: No Yes
8	SEX_QUESN_FILED_USER_ID	VARCHAR	No
	Stores the ID of the user who reconciled this sexual actiovity history data.
9	SEX_QUESN_FILED_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
10	SEX_QUESN_FILED_LOCAL_DTTM	DATETIME (Local)	No
	Stores the instant (in local time) this sexual activity history data was filed.