MYC_MESG_TASK
Description:
Message tasks are discrete activities that can be attached to a message sent from an system user to a patient. The task contains an action item for the patient to complete, such as filling out a questionnaire or scheduling an appointment. This table stores data regarding tasks that have been attached to Patient Access Message (WMG) records, such as what type of a task it was and when the task was completed by a patient.

Primary Key
Column Name Ordinal Position
MESSAGE_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 MESSAGE_ID VARCHAR No
The unique ID used to identify a web based chart system message record.
2 LINE INTEGER No
The line number used to identify each row of read data associated with an individual web based chart system message record.
3 TASK_TYPE_C_NAME VARCHAR No
A category value corresponding to the type of the current message task. Example types are Appointment and Questionnaire. Link to the ZC_MYC_TASK_TYPE table to get the task names.
May contain organization-specific values: No
Category Entries:
Appointment
Questionnaire
Hx Questionnaire
E-Visit Payment Request
4 TASK_TYPE_ORD_NUM INTEGER No
This is the message task type ordinal number. It is used in conjunction with TASK_TYPE_C and indicates if a given message task is the first, second, third etc., of a given message type to be attached to the message. For example, if there were three Appointment tasks and two Questionnaire tasks attached to a given web based chart system message, the first Appointment would have a TASK_TYPE_ORD_NUM of 1, the second Appointment would have a TASK_TYPE_ORD_NUM of 2, and the third Appointment would have a TASK_TYPE_ORD_NUM of 3. Similarly, the first Questionnaire task would have a TASK_TYPE_ORD_NUM of 1 and the second Questionnaire task would have a TASK_TYPE_ORD_NUM of 2.
5 TASK_DISPLAY_NAME VARCHAR No
This is the display name of the task (what the patient will see in web based chart system).
6 TASK_COMP_DATE DATETIME (Attached) No
This stores the instant the message task was completed. If the task has not been completed, this item is blank.
7 TASK_COMP_WPR_ID VARCHAR No
The ID of the person who completed the task.
8 TASK_SCHED_APPT_REQUEST_ID NUMERIC No
The appointment request order IDs linked to this message as a scheduling task for the patient