Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 (8) | ID | [dbo].[uniqueid] | 9 | NOT NULL | 1 - 1 | | Key to the IDX_Task table. |
 ![Check Constraints CK_IDX_Task_IsDefaultSourceFLAG_Yes_Or_No : ([IsDefaultSourceFLAG]='N' OR [IsDefaultSourceFLAG]='Y') Check Constraints CK_IDX_Task_IsDefaultSourceFLAG_Yes_Or_No : ([IsDefaultSourceFLAG]='N' OR [IsDefaultSourceFLAG]='Y')](../../../../Images/c-constraint.png) | IsDefaultSourceFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | No longer used. |
(4) | TaskOwnerType | char(10) | 10 | NOT NULL | | | "User" or "Team" for who owns the task |
(2) | TaskCreatorType | char(10) | 10 | NOT NULL | | | Was it created by a "User" or "System" |
(4) | CurrentStatusChangeDT | datetime | 8 | NOT NULL | | | Date/time last time task was modified |
(4) | TaskCreatedDT | datetime | 8 | NOT NULL | | | Date/time task was created |
(2) | ActivationDT | datetime | 8 | NOT NULL | | | Date/time task was made active in system |
(4) | OverdueDT | datetime | 8 | NOT NULL | | | Date/time task will be overdue |
 (32) | TaskOwner | numeric(16,0) | 9 | NOT NULL | | | When taskownertype is "user" this would be idx_user.id. When taskownertype is "team" this would be team_de.id, |
(9)![Foreign Keys FK_IDX_Task_IDXTaskStatusDE_IDX_Task_Status_DE_ID: [dbo].[IDX_Task_Status_DE].IDXTaskStatusDE Foreign Keys FK_IDX_Task_IDXTaskStatusDE_IDX_Task_Status_DE_ID: [dbo].[IDX_Task_Status_DE].IDXTaskStatusDE](../../../../Images/fk.png) | IDXTaskStatusDE | [dbo].[dict_id] | 5 | NOT NULL | | | Task Status. Key to the IDX_Task_Status_DE table. |
(4) | TaskCreator | numeric(16,0) | 9 | NOT NULL | | | ID of user who created the task. 0 Means it was created by system or some 3rd party |
(3) | TaskPriorityDE | [dbo].[dict_id] | 5 | NOT NULL | | | Priority (routine, ASAP, etc.). Link to Task_priority_DE.ID. |
(8)![Foreign Keys FK_IDX_Task_TaskActionDe_IDX_Task_Action_DE_ID: [dbo].[IDX_Task_Action_DE].TaskActionDE Foreign Keys FK_IDX_Task_TaskActionDe_IDX_Task_Action_DE_ID: [dbo].[IDX_Task_Action_DE].TaskActionDE](../../../../Images/fk.png) | TaskActionDE | [dbo].[dict_id] | 5 | NOT NULL | | | Key to the IDX_Task_Action_DE table. |
 | WorkObject | [dbo].[uniqueid] | 9 | NOT NULL | | | The work object. This is an identifier to a object (table). Which one is dependent on the task action. For example a "Go to Encounter" task the workobject would map to encounter.ID. Any kind of note related task the workobject would map to document.documentid. For Worklist tasks like "Verify Results" the ID would map to idx_user.ID. This tells the code to go to the providers worklist. |
(2) | WorkObjectVarChar | varchar(255) | 255 | NOT NULL | | (' ') | Additional information specific to the task type. |
 | RemoveReasonDE | [dbo].[dict_id] | 5 | NOT NULL | | | Task removal reason. Link to Remove_Reason_DE.ID |
(6)![Foreign Keys FK_idx_task_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID Foreign Keys FK_idx_task_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID](../../../../Images/fk.png) | PatientID | [dbo].[uniqueid] | 9 | NOT NULL | | | Patient. Link to Person.ID. |
 | CurrentStatusChangeBy | [dbo].[uniqueid] | 9 | NOT NULL | | | User who last changed the status. Link to IDX_User.ID. |
(2) | Comment | varchar(255) | 255 | NOT NULL | | | No longer used. We use idx_task_text table now |
 | LockCounter | int | 4 | NULL allowed | | | User for optimistic locking. Indicates which version the edit was based on. |
 | OriginatorTaskID | [dbo].[uniqueid] | 9 | NULL allowed | | | Was this task created from another task being worked? If so prior taskid goes here. For example "Notify Tasks" would have this set. |
(4)![Foreign Keys FK_IDX_Task_OrganizationID_Organization_ID: [dbo].[Organization].OrganizationID Foreign Keys FK_IDX_Task_OrganizationID_Organization_ID: [dbo].[Organization].OrganizationID](../../../../Images/fk.png) | OrganizationID | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Organization. Key to the Organization table. |
(2) | VersionCompatibilityMask | int | 4 | NULL allowed | | | Bit mask indicating the version of Touchwoks the task applies to (CMS V3, Touchworks V4, etc). |
(4) | TaskFilter1DE | [dbo].[uniqueid] | 9 | NOT NULL | | (0) | Used for Miscallaneous task types and custom task filters. You are allowed to have 8 filters defined in TWAdmin->Task Admin->Custom Filters |
(2) | TaskFilter2DE | [dbo].[uniqueid] | 9 | NOT NULL | | (0) | Used for Miscallaneous task types and custom task filters. You are allowed to have 8 filters defined in TWAdmin->Task Admin->Custom Filters |
(2) | TaskFilter3DE | [dbo].[uniqueid] | 9 | NOT NULL | | (0) | Used for Miscallaneous task types and custom task filters. You are allowed to have 8 filters defined in TWAdmin->Task Admin->Custom Filters |
(2) | TaskFilter4DE | [dbo].[uniqueid] | 9 | NOT NULL | | (0) | Used for Miscallaneous task types and custom task filters. You are allowed to have 8 filters defined in TWAdmin->Task Admin->Custom Filters |
(2) | TaskFilter5DE | [dbo].[uniqueid] | 9 | NOT NULL | | (0) | Used for Miscallaneous task types and custom task filters. You are allowed to have 8 filters defined in TWAdmin->Task Admin->Custom Filters |
 | TaskFilter6DE | [dbo].[uniqueid] | 9 | NOT NULL | | (0) | Used for Miscallaneous task types and custom task filters. You are allowed to have 8 filters defined in TWAdmin->Task Admin->Custom Filters |
 | TaskFilter7DE | [dbo].[uniqueid] | 9 | NOT NULL | | (0) | Used for Miscallaneous task types and custom task filters. You are allowed to have 8 filters defined in TWAdmin->Task Admin->Custom Filters |
 | TaskFilter8DE | [dbo].[uniqueid] | 9 | NOT NULL | | (0) | Used for Miscallaneous task types and custom task filters. You are allowed to have 8 filters defined in TWAdmin->Task Admin->Custom Filters |
(3)![Check Constraints CK_IDX_Task_DelegateFLAG_Yes_Or_No : ([DelegateFLAG]='N' OR [DelegateFLAG]='Y') Check Constraints CK_IDX_Task_DelegateFLAG_Yes_Or_No : ([DelegateFLAG]='N' OR [DelegateFLAG]='Y')](../../../../Images/c-constraint.png) | DelegateFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Y/N. If Y it means the task will not show up on the providers "My Active Task" view. |