Tables [dbo].[IDX_Task]
Tasks. These can be created for users or teams. They can be for a patient or not for a patient
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Primary Key PK_IDX_Task_ID: IDIndexes NIX_IDX_task_CurrentStatusChangeDT_INC_ID, XIDXTask_TaskStatusActivationDTID, NIX_IDX_Task_PatientID_IDXTaskStatusDE_ID_INC_TaskActionDE, XIDXTask_ActionStatusOverdueID, Portal_IDX_Task_TaskActionDE_TaskCreatedDT_CoveringIndex, XIDXTask_CreatorStatusID, nix_IDX_Task_TaskOwnerType_TaskOwner_IDXTaskStatusDE_DelegateFLAG, NIX_IDX_Task_WorkObject_PatientID_TaskActionDE_IDXTaskStatusDE_INC_WorkObjectVarChar_ID_TaskOwnerType(8)ID[dbo].[uniqueid]9NOT NULL1 - 1Key to the IDX_Task table.
Indexes TWstat_IDX_Task_IsDefaultSourceFLAG_TaskOwnerCheck Constraints CK_IDX_Task_IsDefaultSourceFLAG_Yes_Or_No : ([IsDefaultSourceFLAG]='N' OR [IsDefaultSourceFLAG]='Y')IsDefaultSourceFLAG[dbo].[BOOL]1NOT NULLNo longer used.
Indexes XIDXTask_ActionStatusOverdueID, XIDXTask_CreatorStatusID, nix_IDX_Task_TaskOwnerType_TaskOwner_IDXTaskStatusDE_DelegateFLAG, NIX_IDX_Task_WorkObject_PatientID_TaskActionDE_IDXTaskStatusDE_INC_WorkObjectVarChar_ID_TaskOwnerType(4)TaskOwnerTypechar(10)10NOT NULL"User" or "Team" for who owns the task
Indexes nix_IDX_Task_TaskOwnerType_TaskOwner_IDXTaskStatusDE_DelegateFLAG, TWstat_IDX_Task_TaskCreatorType_TaskOwner(2)TaskCreatorTypechar(10)10NOT NULLWas it created by a "User" or "System"
Indexes NIX_IDX_task_CurrentStatusChangeDT_INC_ID, XIDXTask_CreatorStatusID, nix_IDX_Task_TaskOwnerType_TaskOwner_IDXTaskStatusDE_DelegateFLAG, TWstat_IDX_Task_CurrentStatusChangeDT_TaskOwner(4)CurrentStatusChangeDTdatetime8NOT NULLDate/time last time task was modified
Indexes Portal_IDX_Task_TaskActionDE_TaskCreatedDT_CoveringIndex, XIDXTask_CreatorStatusID, nix_IDX_Task_TaskOwnerType_TaskOwner_IDXTaskStatusDE_DelegateFLAG, TWstat_IDX_Task_TaskCreatedDT_TaskOwner(4)TaskCreatedDTdatetime8NOT NULLDate/time task was created
Indexes XIDXTask_TaskStatusActivationDTID, TWstat_IDX_Task_ActivationDT_TaskOwner(2)ActivationDTdatetime8NOT NULLDate/time task was made active in system
Indexes XIDXTask_ActionStatusOverdueID, XIDXTask_CreatorStatusID, nix_IDX_Task_TaskOwnerType_TaskOwner_IDXTaskStatusDE_DelegateFLAG, TWstat_IDX_Task_OverdueDT_TaskOwner(4)OverdueDTdatetime8NOT NULLDate/time task will be overdue
Cluster Key XcIDXTask_TaskOwner: TaskOwnerIndexes XIDXTask_ActionStatusOverdueID, Portal_IDX_Task_TaskActionDE_TaskCreatedDT_CoveringIndex, XIDXTask_CreatorStatusID, xIDXTask_OwnerActionPatientStatus, nix_IDX_Task_TaskOwnerType_TaskOwner_IDXTaskStatusDE_DelegateFLAG, TWstat_IDX_Task_ActivationDT_TaskOwner, TWstat_IDX_Task_Comment_TaskOwner, TWstat_IDX_Task_CurrentStatusChangeBy_TaskOwner, TWstat_IDX_Task_CurrentStatusChangeDT_TaskOwner, TWstat_IDX_Task_DelegateFLAG_TaskOwner, TWstat_IDX_Task_IDXTaskStatusDE_TaskOwner, TWstat_IDX_Task_IsDefaultSourceFLAG_TaskOwner, TWstat_IDX_Task_LockCounter_TaskOwner, TWstat_IDX_Task_OrganizationID_TaskOwner, TWstat_IDX_Task_OriginatorTaskID_TaskOwner, TWstat_IDX_Task_OverdueDT_TaskOwner, TWstat_IDX_Task_RemoveReasonDE_TaskOwner, TWstat_IDX_Task_TaskActionDE_TaskOwner, TWstat_IDX_Task_TaskCreatedDT_TaskOwner, TWstat_IDX_Task_TaskCreator_TaskOwner, TWstat_IDX_Task_TaskCreatorType_TaskOwner, TWstat_IDX_Task_TaskFilter1DE_TaskOwner, TWstat_IDX_Task_TaskFilter2DE_TaskOwner, TWstat_IDX_Task_TaskFilter3DE_TaskOwner, TWstat_IDX_Task_TaskFilter4DE_TaskOwner, TWstat_IDX_Task_TaskFilter5DE_TaskOwner, TWstat_IDX_Task_TaskFilter6DE_TaskOwner, TWstat_IDX_Task_TaskFilter7DE_TaskOwner, TWstat_IDX_Task_TaskFilter8DE_TaskOwner, TWstat_IDX_Task_TaskPriorityDE_TaskOwner, TWstat_IDX_Task_VersionCompatibilityMask_TaskOwner, TWstat_IDX_Task_WorkObjectVarChar_TaskOwner(32)TaskOwnernumeric(16,0)9NOT NULLWhen taskownertype is "user" this would be idx_user.id. When taskownertype is "team" this would be team_de.id,
Indexes XIDXTask_TaskStatusActivationDTID, NIX_IDX_Task_PatientID_IDXTaskStatusDE_ID_INC_TaskActionDE, XIDXTask_ActionStatusOverdueID, Portal_IDX_Task_TaskActionDE_TaskCreatedDT_CoveringIndex, XIDXTask_CreatorStatusID, xIDXTask_OwnerActionPatientStatus, nix_IDX_Task_TaskOwnerType_TaskOwner_IDXTaskStatusDE_DelegateFLAG, NIX_IDX_Task_WorkObject_PatientID_TaskActionDE_IDXTaskStatusDE_INC_WorkObjectVarChar_ID_TaskOwnerType, TWstat_IDX_Task_IDXTaskStatusDE_TaskOwner(9)Foreign Keys FK_IDX_Task_IDXTaskStatusDE_IDX_Task_Status_DE_ID: [dbo].[IDX_Task_Status_DE].IDXTaskStatusDEIDXTaskStatusDE[dbo].[dict_id]5NOT NULLTask Status. Key to the IDX_Task_Status_DE table.
Indexes Portal_IDX_Task_TaskActionDE_TaskCreatedDT_CoveringIndex, XIDXTask_CreatorStatusID, nix_IDX_Task_TaskOwnerType_TaskOwner_IDXTaskStatusDE_DelegateFLAG, TWstat_IDX_Task_TaskCreator_TaskOwner(4)TaskCreatornumeric(16,0)9NOT NULLID of user who created the task. 0 Means it was created by system or some 3rd party
Indexes XIDXTask_CreatorStatusID, nix_IDX_Task_TaskOwnerType_TaskOwner_IDXTaskStatusDE_DelegateFLAG, TWstat_IDX_Task_TaskPriorityDE_TaskOwner(3)TaskPriorityDE[dbo].[dict_id]5NOT NULLPriority (routine, ASAP, etc.). Link to Task_priority_DE.ID.
Indexes NIX_IDX_Task_PatientID_IDXTaskStatusDE_ID_INC_TaskActionDE, XIDXTask_ActionStatusOverdueID, Portal_IDX_Task_TaskActionDE_TaskCreatedDT_CoveringIndex, XIDXTask_CreatorStatusID, xIDXTask_OwnerActionPatientStatus, nix_IDX_Task_TaskOwnerType_TaskOwner_IDXTaskStatusDE_DelegateFLAG, NIX_IDX_Task_WorkObject_PatientID_TaskActionDE_IDXTaskStatusDE_INC_WorkObjectVarChar_ID_TaskOwnerType, TWstat_IDX_Task_TaskActionDE_TaskOwner(8)Foreign Keys FK_IDX_Task_TaskActionDe_IDX_Task_Action_DE_ID: [dbo].[IDX_Task_Action_DE].TaskActionDETaskActionDE[dbo].[dict_id]5NOT NULLKey to the IDX_Task_Action_DE table.
Indexes NIX_IDX_Task_WorkObject_PatientID_TaskActionDE_IDXTaskStatusDE_INC_WorkObjectVarChar_ID_TaskOwnerTypeWorkObject[dbo].[uniqueid]9NOT NULLThe 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.
Indexes NIX_IDX_Task_WorkObject_PatientID_TaskActionDE_IDXTaskStatusDE_INC_WorkObjectVarChar_ID_TaskOwnerType, TWstat_IDX_Task_WorkObjectVarChar_TaskOwner(2)WorkObjectVarCharvarchar(255)255NOT NULL(' ')Additional information specific to the task type.
Indexes TWstat_IDX_Task_RemoveReasonDE_TaskOwnerRemoveReasonDE[dbo].[dict_id]5NOT NULLTask removal reason. Link to Remove_Reason_DE.ID
Indexes NIX_IDX_Task_PatientID_IDXTaskStatusDE_ID_INC_TaskActionDE, Portal_IDX_Task_TaskActionDE_TaskCreatedDT_CoveringIndex, XIDXTask_CreatorStatusID, xIDXTask_OwnerActionPatientStatus, nix_IDX_Task_TaskOwnerType_TaskOwner_IDXTaskStatusDE_DelegateFLAG, NIX_IDX_Task_WorkObject_PatientID_TaskActionDE_IDXTaskStatusDE_INC_WorkObjectVarChar_ID_TaskOwnerType(6)Foreign Keys FK_idx_task_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Person.ID.
Indexes TWstat_IDX_Task_CurrentStatusChangeBy_TaskOwnerCurrentStatusChangeBy[dbo].[uniqueid]9NOT NULLUser who last changed the status. Link to IDX_User.ID.
Indexes nix_IDX_Task_TaskOwnerType_TaskOwner_IDXTaskStatusDE_DelegateFLAG, TWstat_IDX_Task_Comment_TaskOwner(2)Commentvarchar(255)255NOT NULLNo longer used. We use idx_task_text table now
Indexes TWstat_IDX_Task_LockCounter_TaskOwnerLockCounterint4NULL allowedUser for optimistic locking. Indicates which version the edit was based on.
Indexes TWstat_IDX_Task_OriginatorTaskID_TaskOwnerOriginatorTaskID[dbo].[uniqueid]9NULL allowedWas this task created from another task being worked? If so prior taskid goes here. For example "Notify Tasks" would have this set.
Indexes Portal_IDX_Task_TaskActionDE_TaskCreatedDT_CoveringIndex, XIDXTask_CreatorStatusID, nix_IDX_Task_TaskOwnerType_TaskOwner_IDXTaskStatusDE_DelegateFLAG, TWstat_IDX_Task_OrganizationID_TaskOwner(4)Foreign Keys FK_IDX_Task_OrganizationID_Organization_ID: [dbo].[Organization].OrganizationIDOrganizationID[dbo].[dict_id]5NOT NULL(0)Organization. Key to the Organization table.
Indexes nix_IDX_Task_TaskOwnerType_TaskOwner_IDXTaskStatusDE_DelegateFLAG, TWstat_IDX_Task_VersionCompatibilityMask_TaskOwner(2)VersionCompatibilityMaskint4NULL allowedBit mask indicating the version of Touchwoks the task applies to (CMS V3, Touchworks V4, etc).
Indexes XIDXTask_ActionStatusOverdueID, XIDXTask_CreatorStatusID, nix_IDX_Task_TaskOwnerType_TaskOwner_IDXTaskStatusDE_DelegateFLAG, TWstat_IDX_Task_TaskFilter1DE_TaskOwner(4)TaskFilter1DE[dbo].[uniqueid]9NOT 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
Indexes XIDXTask_ActionStatusOverdueID, TWstat_IDX_Task_TaskFilter2DE_TaskOwner(2)TaskFilter2DE[dbo].[uniqueid]9NOT 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
Indexes XIDXTask_ActionStatusOverdueID, TWstat_IDX_Task_TaskFilter3DE_TaskOwner(2)TaskFilter3DE[dbo].[uniqueid]9NOT 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
Indexes XIDXTask_ActionStatusOverdueID, TWstat_IDX_Task_TaskFilter4DE_TaskOwner(2)TaskFilter4DE[dbo].[uniqueid]9NOT 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
Indexes XIDXTask_ActionStatusOverdueID, TWstat_IDX_Task_TaskFilter5DE_TaskOwner(2)TaskFilter5DE[dbo].[uniqueid]9NOT 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
Indexes TWstat_IDX_Task_TaskFilter6DE_TaskOwnerTaskFilter6DE[dbo].[uniqueid]9NOT 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
Indexes TWstat_IDX_Task_TaskFilter7DE_TaskOwnerTaskFilter7DE[dbo].[uniqueid]9NOT 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
Indexes TWstat_IDX_Task_TaskFilter8DE_TaskOwnerTaskFilter8DE[dbo].[uniqueid]9NOT 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
Indexes XIDXTask_CreatorStatusID, nix_IDX_Task_TaskOwnerType_TaskOwner_IDXTaskStatusDE_DelegateFLAG, TWstat_IDX_Task_DelegateFLAG_TaskOwner(3)Check Constraints CK_IDX_Task_DelegateFLAG_Yes_Or_No : ([DelegateFLAG]='N' OR [DelegateFLAG]='Y')DelegateFLAG[dbo].[BOOL]1NOT NULL('N')Y/N. If Y it means the task will not show up on the providers "My Active Task" view.