Tables [dbo].[IDX_Task_Status_DE]
Task Statuses
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Primary Key PK_IDX_Task_Status_DE_ID: IDCluster Key XAK1IDX_Task_Status_DE: EntryName\IsCurrentFLAG\IDIndexes XAK2IDX_Task_Status_DE, XAK3IDX_Task_Status_DE, TWstat_IDX_Task_Status_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_IDX_Task_Status_DE_Entry_EntryName_IsCurrentFLAG_ID(4)ID[dbo].[dict_id]5NOT NULL1 - 1Key to the IDX_Task_Status_DE table.
Check Constraints CK_IDX_Task_Status_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_Status_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')IsEnforcedFLAG[dbo].[BOOL]1NOT NULLY=row is readonly;  N=row is modifiable
Cluster Key XAK1IDX_Task_Status_DE: EntryName\IsCurrentFLAG\IDIndexes XAK2IDX_Task_Status_DE, XAK3IDX_Task_Status_DE, TWstat_IDX_Task_Status_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_IDX_Task_Status_DE_Entry_EntryName_IsCurrentFLAG_ID(4)Check Constraints CK_IDX_Task_Status_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.
Indexes XAK2IDX_Task_Status_DEEntryCode[dbo].[code]10NOT NULLUnique alphanumeric code.  Brief but cryptic.
Indexes XAK3IDX_Task_Status_DEEntryMnemonic[dbo].[code]10NOT NULLTypically the same as the Code value, but can be blank.  If present, it must be unique.
EffectiveDTdatetime8NULL allowedTime of last modification  (not "when this row goes into effect")
Indexes TWstat_IDX_Task_Status_DE_DefinitionSetID_EntryName_IsCurrentFLAG_IDDefinitionSetID[dbo].[dict_id]5NOT NULLPoints to Dict_Definition_Set.DefinitionSetID but is typically zero.
Indexes TWstat_IDX_Task_Status_DE_Entry_EntryName_IsCurrentFLAG_IDEntry[dbo].[dict_id]5NOT NULLCalculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set
Cluster Key XAK1IDX_Task_Status_DE: EntryName\IsCurrentFLAG\IDIndexes TWstat_IDX_Task_Status_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_IDX_Task_Status_DE_Entry_EntryName_IsCurrentFLAG_ID(2)EntryName[dbo].[name]255NOT NULLUnique alphanumeric "friendly" display name
EnterpriseEntryID[dbo].[uniqueid]9NOT NULLMaster (enterprise) dictionary surrogate key.  Points to Dictionary_Entry.EnterpriseEntryID