Tables [dbo].[Problem_Type_DE]
Problem Type Dictionary (Simple Dictionary)
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Primary Key PK_Problem_Type_DE_ID: IDCluster Key XAK1Problem_Type_DE: EntryName\IsCurrentFLAG\IDIndexes XAK2Problem_Type_DE, XAK3Problem_Type_DE, TWstat_Problem_Type_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID(3)ID[dbo].[dict_id]5NOT NULL1 - 1Key to the Problem_Type_DE table
EnterpriseEntryID[dbo].[uniqueid]9NOT NULLKey to the dictionary_Entry table. This is a unique identifier across all dictionaries.
DefinitionSetID[dbo].[dict_id]5NOT NULLDictionary Subset as defined in the Dict_Definition_Set table.
Entry[dbo].[dict_id]5NOT NULLEntry number within the Definition Set
Indexes XAK2Problem_Type_DEEntryCode[dbo].[code]10NOT NULLEntry Code.
Cluster Key XAK1Problem_Type_DE: EntryName\IsCurrentFLAG\IDIndexes TWstat_Problem_Type_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_IDEntryName[dbo].[name]255NOT NULLEntry Name
Indexes XAK3Problem_Type_DEEntryMnemonic[dbo].[code]10NOT NULLEntry Mnemonic
Indexes TWstat_Problem_Type_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_IDCheck Constraints CK_Problem_Type_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')IsInactiveFLAG[dbo].[BOOL]1NOT NULLIs the entry inactive (Y/N)?
Check Constraints CK_Problem_Type_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')IsEnforcedFLAG[dbo].[BOOL]1NOT NULLIs the entry Enforced (Y/N)? Enforced entries can not be modified by the application.
Cluster Key XAK1Problem_Type_DE: EntryName\IsCurrentFLAG\IDIndexes XAK2Problem_Type_DE, XAK3Problem_Type_DE, TWstat_Problem_Type_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID(3)Check Constraints CK_Problem_Type_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y')IsCurrentFLAG[dbo].[BOOL]1NOT NULLIs the entry Current (Y/N)?
EffectiveDTdatetime8NULL allowedEffective Date. This is the last edited date.