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