MYC_FEEDBACK_QNR_DATA

Description: |
This table stores data about feedback questionnaires attached to appointments.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PAT_ENC_CSN_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | PAT_ENC_CSN_ID | NUMERIC | No |
The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
2 | LINE | INTEGER | No |
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3 | PAT_ID | VARCHAR | No |
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
4 | CONTACT_DATE | DATETIME | No |
The date of this contact in calendar format.
5 | CM_CT_OWNER_ID | VARCHAR | No |
The Community ID (CID) of the instance that owns this contact. This is only populated if you use IntraConnect.
6 | MYC_FEEDBACK_QNR_ID | VARCHAR | No |
This item defines a patient feedback questionnaire to be asked for this appointment.
7 | MYC_FEEDBACK_QNR_ID_FORM_NAME | VARCHAR | No |
The name of the form associated with the questionnaire.
8 | MYC_FDBCK_QNR_SRC_C_NAME | VARCHAR | No |
This item stores how the related feedback questionnaire was assigned to the appointment.
May contain organization-specific values: No
Category Entries:
Automatic Assigned - MyChart
Automatic Assigned - Welcome
Manually Assigned
Copied from Surgery
Automatic Assigned - OPA
Assigned from Procedure Pass workflow
Assigned by Vendor
9 | MYC_FDBK_QNR_STAT_C_NAME | VARCHAR | No |
The status of the related patient-entered feedback appointment questionnaire.
May contain organization-specific values: No
Category Entries:
Assigned
Started at home
Started in facility
Reviewable
Completed
Incomplete
Hidden
Temporarily hidden