|
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. |
|
|
