CL_QANSWER_AUDIT
Description:
This column stores audit items which detail how patient-entered questionnaire responses were submitted.

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 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 ANSWER_METHOD_C_NAME VARCHAR No
This column stores the method/application by which patient-entered questionnaire responses were saved or updated (e.g. MyChart and/or Welcome).
May contain organization-specific values: No
Category Entries:
MyChart
Welcome
EpicCare
MyChart Bedside
FHIR
Bedside in MyChart Mobile
4 ANSWER_DTTM_DTTM DATETIME (Local) No
This column stores the instant at which patient-entered questionnaire responses were saved or updated.
5 ANSWER_USER_ID VARCHAR No
When applicable, this column stores EpicCare users who saved or updated patient-entered questionnaire responses on behalf of patients.
6 ANSWER_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
7 ANSWER_MYPT_ID VARCHAR No
Stores the MyChart user ID who last updated the questionnaire answers.
8 ANSWER_PAT_REL_C_NAME VARCHAR No
Stores the relationship to the patient of the user who last updated the questionnaire answers on behalf of the patient.
May contain organization-specific values: Yes
9 ANSWER_BY_KIOSK_PAT_YN VARCHAR No
Indicates whether a questionnaire that was answered in Welcome was answered by the patient or a patient representative. 'Y' indicates that the questionnaire was answered by the patient. 'N' indicates that the questionnaire was answered by a patient representative. NULL indicates that the questionnaire was not answered in Welcome.
May contain organization-specific values: No
Category Entries:
No
Yes