CL_QANSWER

Description:

This table contains general information about questionnaire answer records. For example, the questionnaire the answer record is for, the date it was answered, and whether the answer record is closed.

Primary Key

Column Name	Ordinal Position
ANSWER_ID	1

Column Information

	Name	Type	Discontinued?
1	ANSWER_ID	VARCHAR	No
	The unique ID of the questionnaire answer record.
2	REC_CREATE_USER_ID	VARCHAR	No
	The unique ID of the user who created this record.
3	REC_CREATE_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
4	PE_HX_REVIEWED_YN	VARCHAR	No
	This records whether a provider has viewed the history data in this record in the MyChart\Welcome patient history visit navigator section. It is assumed that if the provider has had a chance to look at the submitted history data, they have filed or reviewed the data. After the provider review, MyChart and Welcome will start pre-loading answers from the history section rather than the patient's previous responses. May contain organization-specific values: No Category Entries: No Yes
5	PE_HX_DONE_YN	VARCHAR	No
	This records whether a provider has completed review of the history data in this record in the MyChart\Welcome patient history visit navigator section. After the provider review, MyChart and Welcome will start pre-loading answers from the history section rather than the patient's previous responses. The category values for this column were already listed for column: PE_HX_REVIEWED_YN
6	ENROLL_ID	NUMERIC	No
	The unique identifier of the research study-patient association for the questionnaire.
7	IMG_PROC_ORDER_ID	NUMERIC	No
	Virtual item that returns the record ID for the ORD that points to the given Questionnaire Answer
8	WORKFLOW_DURATION	INTEGER	No
	The amount of time (in seconds) that was spent answering the patient-entered questionnaire.
9	FURTHEST_QUESTION_ID	VARCHAR	No
	The furthest question in the questionnaire that was answered by the user. This is only populated for Patient-Entered Questionnaires.
10	PARENT_ANSWER_ID	VARCHAR	No
	The parent questionnaire response that was branched from to get to this questionnaire.
11	CONFIDENTIAL_YN	VARCHAR	No
	The confidential status for the questionnaire answers. The category values for this column were already listed for column: PE_HX_REVIEWED_YN