IP_WORKLIST_2

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 identifier for the task record.
2 | DESC_FOR_PAT_OVRIDE | VARCHAR | No |
A descriptive name for instances of this task that is written specifically for a given patient.
3 | NAME_FOR_PAT_OVRIDE | VARCHAR | No |
A descriptive name for instances of this task at LTK level that is written specifically for patients.
4 | START_OFFSET_DAYS | INTEGER | No |
Number of days to offset the start date from the task assignment or the anchor event date.
5 | START_OFFSET_TYPE_C_NAME | VARCHAR | No |
The type of start date offset (e.g., before/after).
May contain organization-specific values: No
Category Entries:
Before
After
6 | SOURCE_LTT_UTC_DTTM | DATETIME (Local) | No |
Stores the instant the task template (LTT) was assigned which resulted in tasks (LTK) being created.
7 | CALCULATED_RESUME_UTC_DTTM | DATETIME (UTC) | No |
When resuming a paused task, this will be its start instant if no start date is specified.
8 | FLO_THRESHOLD_VALUE | NUMERIC | No |
Threshold value for flowsheet based task completion.
9 | TSK_DISCONTINUE_REASON_C_NAME | VARCHAR | No |
Describe the reason of the discontinued patient-assigned task.
May contain organization-specific values: No
Category Entries:
Discontinued by Provider
Finished
Discontinued through OPA
Resolved by Provider
Discontinued by Patient
Discontinued by Chart Correction
Patient Deceased
Discontinued by Medication Reminder Pause Anchor Event Action
Discontinued by Unanchor Behavior
Discontinued by Past Start Date Behavior
Discontinued by Admission
10 | ENSURE_DELIVERY_C_NAME | VARCHAR | No |
Determines the scheduling behavior of this anchored task when its start date falls in the past.
May contain organization-specific values: No
Category Entries:
Start immediately
Skip in-between occurrences
Don't start
Resolve task as discontinued
11 | EFQ_OVRIDE_CYL_LEN | INTEGER | No |
If there is a frequency override specified, this item will contain the length of a relative specified type cycle. For all other specified types this value will be ignored (and should be empty).
12 | EFQ_OVRIDE_DAY_TYP | INTEGER | No |
Specifies what the numeric values in the frequency override days columns represent. If it is 1 then the listed days are relative days. If it is 2 then the listed days are weekdays. Any other value has no meaning.
13 | DURATION | INTEGER | No |
Determines the number of days this recurring task should go on for relative to its start date.
14 | TASK_NOTE_ID | VARCHAR | No |
The note (HNO) ID that is attached to the task (LTK) record.
15 | DECISION_TRACKER_ID | NUMERIC | No |
Stores the linked decision, if one exists, for this task
16 | REQ_DOC_NOT_ATTRIBUTED_RSN_C_NAME | VARCHAR | No |
The did not attribute reason category ID for the required documentation task. This indicates the reason that the task was not attributed to any users.
May contain organization-specific values: No
Category Entries:
Could Not Find Any Appropriate Users
Already Completed Before Evaluation
17 | USED_FOR_OUTREACH_YN | VARCHAR | No |
Indicates whether a checklist task is used for outreach or not. 'Y' indicates that the checklist task is used for outreach. 'N' or NULL indicates that the checklist task is not used for outreach.
May contain organization-specific values: No
Category Entries:
No
Yes
18 | PAT_ASGN_TASK_PAT_ENC_CSN_ID | NUMERIC | No |
If this task is anchored to an anchor target of type Hospital Discharge, then this item stores the contact serial number associated with the admission.
19 | SC_SUPPORT_TYPE_C_NAME | VARCHAR | No |
The category value of the support & service type that triggered the generation of this task
May contain organization-specific values: Yes
20 | SC_SUPPORT_TYPE_START_DATE | DATETIME | No |
The start date of the support & service type that triggered the generation of this task
21 | REFERRAL_ID | NUMERIC | No |
The referral that this target is tracking.
22 | USED_FOR_C_NAME | VARCHAR | No |
The category number which identifies the purpose for which the task is used.
May contain organization-specific values: No
Category Entries:
Target
Outpatient Care Plan
Outreach
Case Review
Checklist
Medication Therapy Problem
23 | CREATE_INST_LOCAL_DTTM | DATETIME (Local) | No |
The instant at which the task was created, in local time. This item is the local equivalent of the CREATION_UTC_DTTM column, which is in UTC.
24 | LINKED_PAT_ID | VARCHAR | No |
This column contains the patient linked directly or indirectly to the task record. This differs from column PAT_ID in table IP_WORKLIST in that this column also contains patients linked indirectly to a task, through a patient CSN (I LTK 215) or an episode (HSB) (I LTK 53100 or I LTK 81110). To find only patients linked directly to a task, use column PAT_ID in table IP_WORKLIST.
25 | CREATE_USER_ID | VARCHAR | No |
User that created the task.
26 | CREATE_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
27 | OUTREACH_OUTCOME_C_NAME | VARCHAR | No |
Outcome of an outreach task
May contain organization-specific values: Yes
Category Entries:
Completed Successfully
Unable to Reach
Skipped
28 | CLAIM_ID | NUMERIC | No |
The claim that triggered this task's creation.
29 | CARE_PLAN_TYPE_C_NAME | VARCHAR | No |
Mark subtype of care plan task. Primarily used to mark if this care plan task instance is a note review task, for the suggested note workflow.
May contain organization-specific values: No
Category Entries:
Care Plan Note Review
Care Plan Goal Selection
30 | MEDAC_LTK_STS_C_NAME | VARCHAR | No |
The current status for the task.
May contain organization-specific values: No
Category Entries:
Not Started
Ready To Start
In Progress
Waiting
Done
Not Needed
31 | MED_ACCESS_LTK_USER_ID | VARCHAR | No |
The current responsible user for the task.
32 | MED_ACCESS_LTK_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
33 | MED_ACCESS_LTK_IB_POOL_ID | NUMERIC | No |
The current responsible pool for the task.
34 | MED_ACCESS_LTK_IB_POOL_ID_REGISTRY_NAME | VARCHAR | No |
The name of the In Basket registry in the HIP master file.
35 | MEDAC_LTK_WAITRSN_C_NAME | VARCHAR | No |
The reason the task's overall status is set to waiting.
May contain organization-specific values: No
Category Entries:
Other
Insurer
Patient
Provider
36 | MEDAC_LTK_AUTOMATION_ORDER | INTEGER | No |
This item stores this task's order in the investigation's Automation Order (I HBD 76703) table. Tasks are set to Ready to Start based on the completion of preceding tasks in the investigation's Automation Order table. For example, if the user sets all tasks with an automation order of 1 as either Done or Not Needed, tasks with an automation order of 2 are automatically updated from Not Started to Ready to Start.
37 | EPISODE_COMPLEXITY_C_NAME | VARCHAR | No |
The category value of the episode complexity that triggered generation of this task
May contain organization-specific values: Yes
Category Entries:
High
Moderate
Low
38 | UNTIMED_HOURS | NUMERIC | No |
This item determines how long untimed occurrences of this task are considered relevant. This item has no effect unless I LTK 382 Show as Untimed is set to 2-For a Number of Hours.
39 | SHOW_AS_UNTIMED_C_NAME | VARCHAR | No |
This item determines if occurrences of this task will be considered untimed when initially scheduled. Untimed tasks are scheduled for specific instants based on the task's frequency, but are considered relevant and continue to display to clinicians for a range of time starting at the initial scheduled instant and ending at a later instant determined by the value set here. If left blank, the task is not considered untimed.
May contain organization-specific values: No
Category Entries:
Until Completed
For a Number of Hours
40 | RESEARCH_ACTION_TYPE_C_NAME | VARCHAR | No |
The research action type for the task. Used to determine checklist links and autocompletion for research workflows.
May contain organization-specific values: No
Category Entries:
Adverse Events
Consents
Eligibility
41 | LINKED_DOC_TMPLT_ID_TEMPLT_DISPLAY_NAME | VARCHAR | No |
A name for the template designed for display purposes.
42 | LINKED_DOCUMENT_ID | VARCHAR | No |
The E-Signature document linked to this task.
43 | COMPLETING_ORDER_ID | NUMERIC | No |
The order (ORD) that caused this task to be completed.
44 | COMPLETING_DOCUMENT_ID | VARCHAR | No |
The consent document that completed this task.
45 | CVG_EFF_DATE | DATETIME | No |
The coverage effective date from which the task's due date was calculated, set on tasks that use the coverage effective date due date mnemonic (I LTR 53101).
46 | CVG_WAIVER_EFF_DATE | DATETIME | No |
The coverage waiver effective date that was used to calculate this task's due date. Only used if task is using "Coverage Waiver Effective Date" mnemonic.
47 | CVG_WAIVER_TYPE_C_NAME | NUMERIC | No |
The type of the coverage waiver that was used to calculate this task's due date.Only used if task is using "Coverage Waiver Effective Date" mnemonic.
May contain organization-specific values: Yes
No Entries Defined