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