MYC_MESG_ADL_QTNS

Description:

This table contains patient answers to activities of daily living (ADL) 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	ADL_QUESN_ID	VARCHAR	No
	The ID of the ADL history question answered by the patient.
4	ADL_QUESN_ID_RECORD_NAME	VARCHAR	No
	The name of the Visit Navigator (VN) History Template Definition (LQH) record.
5	ADL_QUESN_RESP_C_NAME	VARCHAR	No
	The patient's response to the ADL question. May contain organization-specific values: No Category Entries: Yes No No Response
6	ADL_QUESN_CMT	VARCHAR	No
	The comment added by the patient when answering an ADL (Activities of Daily Living) question.
7	ADL_QUESN_FILED_YN	VARCHAR	No
	Whether a provider has filed to the patient's chart the patient's response to the ADL question. May contain organization-specific values: No Category Entries: No Yes
8	ADL_QUESN_FILED_USER_ID	VARCHAR	No
	Stores the ID of the user who reconciled this ADL history data.
9	ADL_QUESN_FILED_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
10	ADL_QUESN_FILED_LOCAL_DTTM	DATETIME (Local)	No
	Stores the instant (in local time) this ADL history data was filed.