IP_WORKLIST

Description: |
This table contains data associated with task (LTK) records.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
TASK_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | TASK_ID | VARCHAR | No |
The unique ID for the worklist activity.
2 | TASK | VARCHAR | No |
The task to be performed.
3 | WL_PRIORITY_C_NAME | VARCHAR | No |
This notes the priority of the task.
May contain organization-specific values: Yes
4 | WORK_UNITS | FLOAT | No |
This is the number of work units required to perform a task.
5 | SKILLS_NEEDED_C_NAME | VARCHAR | No |
This is the skill set required to perform a task.
May contain organization-specific values: Yes
6 | WORKLIST_CAT_C_NAME | VARCHAR | No |
The category associated with this task (i.e. meds, education, vitals).
May contain organization-specific values: Yes
7 | LINK_SOURCE | VARCHAR | No |
The master file initials for the record that is the source of this task. This can be LPI, ORD, LGL, FLO, IGL, LDA, SSC, or DM_CSN. If the Source is : Best Practice Alert then LOCATOR_ID has the Alert ID (LGL)
8 | LINK_RECORD | VARCHAR | No |
The ID of the record that is the source of this task.
9 | LOCATOR_ID_LOCATOR_NAME | VARCHAR | No |
The name of the Locator record.
10 | INTERVENTION_ID | VARCHAR | No |
If the task is linked to an intervention (LPI masterfile) the ID of the Care Plan Intervention is stored here.
11 | ORDER_ID | NUMERIC | No |
If the task is linked to an Order (ORD masterfile) the ID of the Order is stored here.
12 | MSTEP_STATUS_C_NAME | VARCHAR | No |
Stores the status of the given multistep order entry task
May contain organization-specific values: Yes
Category Entries:
Active
Discontinued
Completed
13 | TYPE_C_NAME | VARCHAR | No |
The type associated with this task.
May contain organization-specific values: No
Category Entries:
Patient Specific
User Specific
Patient Event
Episode Specific
MyChart Patient Created
14 | LINK_SOURCE_COMP | VARCHAR | No |
The master file initials for the record that is the source of this task. This can be LPI, ORD, LGL, FLO, IGL, LDA, SSC, or DM_CSN. If the Source is : Best Practice Alert then LOCATOR_ID has the Alert ID (LGL)
15 | COMMENTS | VARCHAR | No |
This item stores the comments related to the given worklist activity.
16 | SOURCE_LTR_ID | NUMERIC | No |
This item stores the unique ID of the task record associated with the worklist activity.
17 | SOURCE_LTR_ID_TASK_NAME | VARCHAR | No |
The name of the task record.
18 | AUTO_COMPLETE_COND | VARCHAR | No |
This column stores the task auto complete condition, which is copied from the associated task (LTR) record.
19 | NUM_OCCURRENCES | INTEGER | No |
This column stores the number of occurrences for the associated task.
20 | PRN_START_INST_DTTM | DATETIME (Local) | No |
This column stores the start instant for a scheduled task.
21 | DISCONTINUE_DTTM | DATETIME (Local) | No |
This column stores the instant at which a task was discontinued.
22 | DISCONTINUE_USER_ID | VARCHAR | No |
User who discontinued a task.
23 | DISCONTINUE_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
24 | EPISODE_ID | NUMERIC | No |
The episode ID with which the task is associated.
25 | RESPONSIBLE_USER_ID | VARCHAR | No |
The user responsible to complete the task.
26 | RESPONSIBLE_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
27 | RESPONSIBLE_POOL_ID | NUMERIC | No |
The In Basket Pool responsible for completing the task.
28 | RESPONSIBLE_POOL_ID_REGISTRY_NAME | VARCHAR | No |
The name of the In Basket registry in the HIP master file.
29 | BEDSIDE_USER_ID | VARCHAR | No |
The Initiating Bedside User item holds the ID of the MyChart Bedside User who created an ad hoc task, typically a patient request.
30 | PAT_COMMENTS | VARCHAR | No |
This item stores the Patient entered comments/additional details for requests they place in MyChartBedside.
31 | STEP_C_NAME | VARCHAR | No |
The current step of a multi-step task.
May contain organization-specific values: Yes
Category Entries:
Scheduled
Reviewed
32 | OUTCOME_C_NAME | VARCHAR | No |
The outcome of the task.
May contain organization-specific values: Yes
Category Entries:
Positive
Negative
Not Done
33 | AUTOCOMP_INSTANCE_ID | NUMERIC | No |
The deficiency instance associated with this task. This column will be populate for episode-based tasks that are created from a task record (LTR) with an associated autocompletion template (DEF).
34 | PARENT_TASK_ID | VARCHAR | No |
The parent task (LTK) that this child task was created from. This column will be populated for episode-based tasks that were created automatically based on the completion of another task on the episode.
35 | REQUIRED_DOC_TYPE_C_NAME | VARCHAR | No |
Type of required documentation the task corresponds to.
May contain organization-specific values: No
Category Entries:
Admission
Transfer
Shift
Before Discharge
Admission Quality Measures
Discharge Quality Measures
36 | REQUIRED_DOC_GROUP_C_NAME | VARCHAR | No |
Required documentation group the task corresponds to.
May contain organization-specific values: Yes
Category Entries:
Other
37 | CONTEXT_C_NAME | VARCHAR | No |
The functional context of a 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
38 | ASSIGN_TO_PAT_C | VARCHAR | No |
This item determines whether a task is assigned to the patient.
May contain organization-specific values: No
Category Entries:
No
Yes
39 | PERS_STATUS_C_NAME | VARCHAR | No |
Defines the personalization status of the notification times for the task.
May contain organization-specific values: Yes
Category Entries:
No
Yes
40 | GOAL_ID | VARCHAR | No |
The goal that the task is associated with.
41 | INTERVENTIONS_ID | VARCHAR | No |
The intervention that the task is associated with.
42 | LINKED_TREATMENT_DAY_NAME | VARCHAR | No |
The name of the treatment day linked to the task.
43 | LINKED_TREATMENT_PLAN_ID | NUMERIC | No |
The unique ID of the treatment plan linked to this task.
44 | LINKED_DAY_LINE | INTEGER | No |
The line in the source record that corresponds to a treatment or timeline day.
45 | EST_COMPLETION_START_DATE | DATETIME | No |
An estimated start date that the task will be performed based on the lead days of the day in the treatment plan or timeline.
46 | EST_COMPLETION_END_DATE | DATETIME | No |
An estimated end date that the task will be performed based on the lag days of the day in the treatment plan or timeline.
47 | ENROLL_ID | NUMERIC | No |
The research study-patient association (LAR) record ID linked to this task. This is only populated by tasks created from a billing timeline.
48 | SOURCE_LTT_ID | VARCHAR | No |
This contains a link to the source task template (LTT) record if this task was added by a task template.
49 | SOURCE_LTT_ID_RECORD_NAME | VARCHAR | No |
This column displays the name of the task template record.
50 | IS_PAUSED_YN | VARCHAR | No |
When a task is assigned to the patient, this item determines whether it's is paused. When a task is paused, it will not have future instances and will not displayed to the patient until resumed.
May contain organization-specific values: No
Category Entries:
No
Yes
51 | SCHEDULE_STATUS_C_NAME | VARCHAR | No |
Determines the scheduling status of a patient-assigned task. When a task is created it may not be scheduled right away. The category table is ZC_TASK_SCHEDULE_STATUS_C.
May contain organization-specific values: No
Category Entries:
Scheduled
Not Scheduled
Will Be Scheduled
52 | RESUME_ON_DISCHARGE_YN | VARCHAR | No |
This item determines if a task paused on hospital admission will be resumed on discharge.
The category values for this column were already listed for column: IS_PAUSED_YN
53 | DAYS_AFTER_DISC_NUM | INTEGER | No |
Indicates the number of days after hospital discharge this reminder will start. Value must be larger than or equal to 0.
54 | ANCHOR_EVENT_TYPE_C_NAME | VARCHAR | No |
The type of anchor target this task is configured for.
May contain organization-specific values: No
Category Entries:
Surgery
Pregnancy
Appointment
Hospital Discharge
Rule Defined Date - Encounter Level
Rule Defined Date - Patient Level
55 | SURGICAL_OR_CASE_ID | VARCHAR | No |
If this task is anchored to an anchor target of type Surgery, then this item stores the surgical case associated with the surgery.
56 | PREGNANCY_EPISODE_ID | NUMERIC | No |
If this task is anchored to an anchor target of type Pregnancy, then this item stores the episode associated with the pregnancy.
57 | APPOINTMENT_SERIAL_NUMBER_ID | NUMERIC | No |
If this task is anchored to an anchor target of type Procedural Appointment, then this item stores the appointment serial number associated with the procedural appointment.