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