Tables [dbo].[IDX_Suprt_Task_Action_DE]
Support Task Actions Dictionary
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_IDX_Suprt_Task_Action_DE_ID: IDIndexes TWstat_IDX_Suprt_Task_Action_DE_NavigateFlag_EntryName_IsCurrentFLAG_IDID[dbo].[dict_id]5NOT NULL1 - 1Key to the IDX_Suprt_Task_Action_DE table.
EnterpriseEntryID[dbo].[uniqueid]9NOT NULLMaster (enterprise) dictionary surrogate key.  Points to Dictionary_Entry.EnterpriseEntryID
DefinitionSetID[dbo].[dict_id]5NOT NULLPoints to Dict_Definition_Set.DefinitionSetID but is typically zero.
Entry[dbo].[dict_id]5NOT NULLCalculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set
Indexes NIX_IDX_Suprt_Task_Action_DE_EntryCode_WithIncludeColumns, NIX_IDX_Suprt_Task_Action_DE_EntryMnemonic_WithIncludeColumns, NIX_IDX_Suprt_Task_Action_DE_EntryName_WithIncludeColumns(3)EntryCode[dbo].[code]10NOT NULLUnique alphanumeric code.  Brief but cryptic.
Indexes NIX_IDX_Suprt_Task_Action_DE_EntryCode_WithIncludeColumns, NIX_IDX_Suprt_Task_Action_DE_EntryMnemonic_WithIncludeColumns, NIX_IDX_Suprt_Task_Action_DE_EntryName_WithIncludeColumns, TWstat_IDX_Suprt_Task_Action_DE_NavigateFlag_EntryName_IsCurrentFLAG_ID(4)EntryName[dbo].[name]255NOT NULLUnique alphanumeric "friendly" display name
Indexes NIX_IDX_Suprt_Task_Action_DE_EntryCode_WithIncludeColumns, NIX_IDX_Suprt_Task_Action_DE_EntryMnemonic_WithIncludeColumns, NIX_IDX_Suprt_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_Suprt_Task_Action_DE_EntryCode_WithIncludeColumns, NIX_IDX_Suprt_Task_Action_DE_EntryMnemonic_WithIncludeColumns, NIX_IDX_Suprt_Task_Action_DE_EntryName_WithIncludeColumns(3)Check Constraints CK_IDX_Suprt_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_Suprt_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_Suprt_Task_Action_DE_EntryCode_WithIncludeColumns, NIX_IDX_Suprt_Task_Action_DE_EntryMnemonic_WithIncludeColumns, NIX_IDX_Suprt_Task_Action_DE_EntryName_WithIncludeColumns, TWstat_IDX_Suprt_Task_Action_DE_NavigateFlag_EntryName_IsCurrentFLAG_ID(4)Check Constraints CK_IDX_Suprt_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.
Check Constraints CK_IDX_Suprt_Task_Action_DE_IsSystemGeneratedOnlyFLAG_Yes_Or_No : ([IsSystemGeneratedOnlyFLAG]='N' OR [IsSystemGeneratedOnlyFLAG]='Y')IsSystemGeneratedOnlyFLAG[dbo].[BOOL]1NOT NULLIndicates whether the task is generated only by System (Y/N)?
Indexes TWstat_IDX_Suprt_Task_Action_DE_NavigateFlag_EntryName_IsCurrentFLAG_IDCheck Constraints CK_IDX_Suprt_Task_Action_DE_NavigateFlag_Yes_Or_No : ([NavigateFlag]='N' OR [NavigateFlag]='Y')NavigateFlag[dbo].[BOOL]1NOT NULLCan user open the respective modules (Rx renewal, Note etc) from this task(Y/N)?
Check Constraints CK_IDX_Suprt_Task_Action_DE_ManualCompleteFlag_Yes_Or_No : ([ManualCompleteFlag]='N' OR [ManualCompleteFlag]='Y')ManualCompleteFlag[dbo].[BOOL]1NOT NULLCan complete the task manually(Y/N)?
EffectiveDTdatetime8NOT NULLTime of last modification  (not "when this row goes into effect")
IDXSupportingApplicationID[dbo].[dict_id]5NOT NULLApplication. Link to Application_DE.ID
DefaultTeamDE[dbo].[dict_id]5NOT NULLDefault Team . Link to Team_DE.ID
TaskTypevarchar(30)30NOT NULLTask Type. Notify, Administer, Sign etc.
WorkTypevarchar(30)30NOT NULLModule. Order, Result, Note, Immunization etc.
DocumentProductIDvarchar(30)30NULL allowedFrame work Product Name
DocumentApplicationIDvarchar(30)30NULL allowedFrame work Application name
DocumentIDvarchar(30)30NULL allowedWorkspace to navigate this task.
URLvarchar(2000)2000NULL allowedTask Navigation URL
VersionCompatibilityMaskint4NULL allowed(16)Version Compatibility.
8 - Version 3
16 - Version 4
32 - Version 11