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_QUEST_NAME VARCHAR No
The name of the question record.
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