CREDENTIALING_TASKS
Description:
Each row in this table represents one task record used in the credentialing review process. This table stores the review, application, and navigator context that drives credentialing task creation.

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 NUMERIC 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
ERP Workforce
3 TASK_TYPE_C_NAME NUMERIC 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 associated with this task. This column is frequently used to link to the TASK_INFO table.
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 associated with this task. This column is frequently used to link to the TASK_LTR table.
7 SOURCE_TASK_ID_TASK_NAME VARCHAR No
The name of the task record.
8 START_INSTANT_LOCAL_DTTM DATETIME (Local) No
The start instant for a task in local format.
9 TASK_NAME VARCHAR No
The name of the task to be performed.