MC_MEMBER_TASKS

Description:

This table contains information about health plan member tasks.

Primary Key

Column Name	Ordinal Position
TASK_ID	1

Column Information

	Name	Type	Discontinued?
1	TASK_ID	VARCHAR	No
	The unique identifier (.1 item) for the task record.
2	TASK_CONTEXT_C_NAME	VARCHAR	No
	The task context category ID for the task. May contain organization-specific values: No Category Entries: General Checklist Willow Inventory Shortage Staff Activity Homecare Patient Encounter Health Plan
3	TASK_TYPE_C_NAME	VARCHAR	No
	The task type category ID for the task. May contain organization-specific values: No Category Entries: Patient Specific User Specific Patient Event Episode Specific MyChart Patient Created
4	SOURCE_TEMPLATE_RECORD_ID	VARCHAR	No
	The unique ID of the task template record (LTT) associated with this task.
5	SOURCE_TEMPLATE_RECORD_ID_RECORD_NAME	VARCHAR	No
	This column displays the name of the task template record.
6	SOURCE_TASK_ID	NUMERIC	No
	The unique ID of the source task record (LTR) associated with this task.
7	SOURCE_TASK_ID_TASK_NAME	VARCHAR	No
	The name of the task record.
8	TASK	VARCHAR	No
	The task to be performed.
9	START_INSTANT_LOCAL_DTTM	DATETIME (Local)	No
	The start instant for a task in local format.
10	END_DATE	DATETIME	No
	The date when the task is marked as completed.