Tables [dbo].[IDX_Task_Action_DE]
Task Actions Dictionary
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_IDX_Task_Action_DE_ID: IDIndexes TWstat_IDX_Task_Action_DE_DefinitionSetID_EntryName_IsCurrentFlag_ID, TWstat_IDX_Task_Action_DE_Entry_EntryName_IsCurrentFlag_ID, TWstat_IDX_Task_Action_DE_IsInactiveFlag_EntryName_IsCurrentFlag_ID, TWstat_IDX_Task_Action_DE_SecurityCodeDE_EntryName_IsCurrentFlag_ID(4)ID[dbo].[dict_id]5NOT NULL1 - 1Key to the IDX_Task_Action_DE table.
EnterpriseEntryID[dbo].[uniqueid]9NOT NULLMaster (enterprise) dictionary surrogate key.  Points to Dictionary_Entry.EnterpriseEntryID
Indexes TWstat_IDX_Task_Action_DE_DefinitionSetID_EntryName_IsCurrentFlag_IDDefinitionSetID[dbo].[dict_id]5NOT NULLPoints to Dict_Definition_Set.DefinitionSetID but is typically zero.
Indexes NIX_IDX_Task_Action_DE_EntryCode_WithIncludeColumns, NIX_IDX_Task_Action_DE_EntryMnemonic_WithIncludeColumns, NIX_IDX_Task_Action_DE_EntryName_WithIncludeColumns, TWstat_IDX_Task_Action_DE_DefinitionSetID_EntryName_IsCurrentFlag_ID, TWstat_IDX_Task_Action_DE_Entry_EntryName_IsCurrentFlag_ID, TWstat_IDX_Task_Action_DE_IsInactiveFlag_EntryName_IsCurrentFlag_ID, TWstat_IDX_Task_Action_DE_SecurityCodeDE_EntryName_IsCurrentFlag_ID(7)EntryName[dbo].[name]255NOT NULLUnique alphanumeric "friendly" display name
Indexes NIX_IDX_Task_Action_DE_EntryCode_WithIncludeColumns, NIX_IDX_Task_Action_DE_EntryMnemonic_WithIncludeColumns, NIX_IDX_Task_Action_DE_EntryName_WithIncludeColumns(3)EntryMnemonic[dbo].[code]10NOT NULLTypically the same as the Code value, but can be blank.  If present, it must be unique
Indexes NIX_IDX_Task_Action_DE_EntryCode_WithIncludeColumns, NIX_IDX_Task_Action_DE_EntryMnemonic_WithIncludeColumns, NIX_IDX_Task_Action_DE_EntryName_WithIncludeColumns(3)EntryCode[dbo].[code]10NOT NULLUnique alphanumeric code.  Brief but cryptic.
Indexes TWstat_IDX_Task_Action_DE_Entry_EntryName_IsCurrentFlag_IDEntry[dbo].[dict_id]5NOT NULLCalculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set
Indexes NIX_IDX_Task_Action_DE_EntryCode_WithIncludeColumns, NIX_IDX_Task_Action_DE_EntryMnemonic_WithIncludeColumns, NIX_IDX_Task_Action_DE_EntryName_WithIncludeColumns, TWstat_IDX_Task_Action_DE_IsInactiveFlag_EntryName_IsCurrentFlag_ID(4)Check Constraints CK_IDX_Task_Action_DE_IsInactiveFlag_Yes_Or_No : ([IsInactiveFlag]='N' OR [IsInactiveFlag]='Y')IsInactiveFlag[dbo].[BOOL]1NOT NULLY=row is not active; N=row is active.  (Rows are inactivated rather than deleted for history)
Check Constraints CK_IDX_Task_Action_DE_IsEnforcedFlag_Yes_Or_No : ([IsEnforcedFlag]='N' OR [IsEnforcedFlag]='Y')IsEnforcedFlag[dbo].[BOOL]1NOT NULLY=row is readonly;  N=row is modifiable
Indexes NIX_IDX_Task_Action_DE_EntryCode_WithIncludeColumns, NIX_IDX_Task_Action_DE_EntryMnemonic_WithIncludeColumns, NIX_IDX_Task_Action_DE_EntryName_WithIncludeColumns, TWstat_IDX_Task_Action_DE_DefinitionSetID_EntryName_IsCurrentFlag_ID, TWstat_IDX_Task_Action_DE_Entry_EntryName_IsCurrentFlag_ID, TWstat_IDX_Task_Action_DE_IsInactiveFlag_EntryName_IsCurrentFlag_ID, TWstat_IDX_Task_Action_DE_SecurityCodeDE_EntryName_IsCurrentFlag_ID(7)Check Constraints CK_IDX_Task_Action_DE_IsCurrentFlag_Yes_Or_No : ([IsCurrentFlag]='N' OR [IsCurrentFlag]='Y')IsCurrentFlag[dbo].[BOOL]1NOT NULLUsually 'Y' but occasionally used to subordinate rows.  Not exposed to the end user.
EffectiveDTdatetime8NOT NULLTime of last modification  (not "when this row goes into effect")
Indexes TWstat_IDX_Task_Action_DE_SecurityCodeDE_EntryName_IsCurrentFlag_IDSecurityCodeDE[dbo].[dict_id]5NOT NULLSecurity Code.
Foreign Keys FK_IDX_Task_Action_DE_IDXSuprtTaskActionDE_IDX_Suprt_Task_Action_DE_ID: [dbo].[IDX_Suprt_Task_Action_DE].IDXSuprtTaskActionDEIDXSuprtTaskActionDE[dbo].[dict_id]5NOT NULLTask Action. Link to IDX_Suprt_Task_Action_DE.ID
URLvarchar(2000)2000NULL allowedTask Navigation URL
Check Constraints CK_IDX_Task_Action_DE_ExpiringTaskFLAG_Yes_Or_No : ([ExpiringTaskFLAG]='N' OR [ExpiringTaskFLAG]='Y')ExpiringTaskFLAG[dbo].[BOOL]1NOT NULL('N')Auto complete the overdue tasks (Y/N)?
Check Constraints CK_IDX_Task_Action_DE_DelegateFLAG_Yes_Or_No : ([DelegateFLAG]='N' OR [DelegateFLAG]='Y')DelegateFLAG[dbo].[BOOL]1NOT NULL('N')Can delegate the Task (Y/N)?
UrgentDueDateDefaultsmallint2NOT NULL(0)Default Urgent Overdue days
UrgentDueTimeDefaultsmallint2NOT NULL(360)Default Urgent Overdue time in minutes
ASAPDueDateDefaultsmallint2NOT NULL(2)Default ASAP Overdue days
ASAPDueTimeDefaultsmallint2NOT NULL(0)Default ASAP Overdue time in minutes
RoutineDueDateDefaultsmallint2NOT NULL(7)Default Routine Overdue days
RoutineDueTimeDefaultsmallint2NOT NULL(0)Default Routine Overdue time in minutes
Check Constraints CK_IDX_Task_Action_DE_CompleteWhenCopyToNoteFLAG_Yes_Or_No : ([CompleteWhenCopyToNoteFLAG]='N' OR [CompleteWhenCopyToNoteFLAG]='Y')CompleteWhenCopyToNoteFLAG[dbo].[BOOL]1NOT NULL('N')Complete the Task when copy to Note
Foreign Keys FK_IDX_Task_Action_DE_DefaultEncounterTypeDE: [dbo].[Encounter_Type_DE].DefaultEncounterTypeDEDefaultEncounterTypeDE[dbo].[dict_id]5NOT NULL(0)Default Encounter type. Link to Encounter_Type_DE.ID
Foreign Keys FK_IDX_Task_Action_DE_DefaultDocumentTypeDE: [dbo].[Document_Type_de].DefaultDocumentTypeDEDefaultDocumentTypeDE[dbo].[dict_id]5NOT NULL(0)Default Note type. Link to Document_Type_DE.ID
SequenceNumbersmallint2NULL allowedDisplay sequence number for task name.
NotActiveUntilOverdueFLAG[dbo].[BOOL]1NOT NULL('N')Task becomes active when overdue