CL_QANSWER_ATTEMPT
Description:
This table contains attempts at answering a patient-entered questionnaire.

Primary Key
Column Name Ordinal Position
ANSWER_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 ANSWER_ID VARCHAR No
The unique identifier for the questionnaire answer 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 ATTEMPT_START_DTTM DATETIME (Local) No
The instant at which the patient-entered questionnaire attempt started.   An attempt begins when the questionnaire is started, resumed, or traversed to from another questionnaire. This includes navigating forwards, backwards, and jumping to a question from the review page.
4 ATTEMPT_END_DTTM DATETIME (Local) No
The instant at which the patient-entered questionnaire attempt ended. The end of the attempt is updated when the user takes an action during the attempt.   For branched questionnaires, the end instant does not include actions taken on its parent.
5 ATTEMPT_STATUS_C_NAME VARCHAR No
The status of the patient-entered questionnaire attempt. This column can be joined to the ZC_ST_WKFL_STATUS table.
May contain organization-specific values: No
Category Entries:
Started
Abandoned
Completed
6 ATTEMPT_ANSWER_METHOD_C_NAME VARCHAR No
The method used when attempting to answer the patient-entered questionnaire.
May contain organization-specific values: No
Category Entries:
MyChart
Welcome
EpicCare
MyChart Bedside
FHIR
Bedside in MyChart Mobile
7 ATTEMPT_USER_ID VARCHAR No
The user who updated the patient-entered questionnaire answers on behalf of the patient if answering from Hyperspace.
8 ATTEMPT_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
9 ATTEMPT_MYPT_ID VARCHAR No
The MyChart user who updated the patient-entered questionnaire answers.
10 ATTEMPT_SESSION_NUM NUMERIC No
The session number for a MyChart user for the MyChart user access audit trail.
11 ATTEMPT_FURTHEST_QUESTION_ID VARCHAR No
The furthest question in the questionnaire that was answered by the user during the attempt.