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
Med Access
Research Charge Group
Research Study
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.