Tables [dbo].[Signature_Purpose_DE]
Signature Purpose Dictionary
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Primary Key PK_Signature_Purpose_DE_ID: IDCluster Key XAK1Signature_Purpose_DE: EntryName\IsCurrentFLAG\IDIndexes XAK2Signature_Purpose_DE, XAK3Signature_Purpose_DE, Nix_Signature_Purpose_DE_CoverIndex, TWstat_Signature_Purpose_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Signature_Purpose_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID(5)ID[dbo].[dict_id]5NOT NULL1 - 1Key to the Signature_Purpose_DE table
EnterpriseEntryID[dbo].[uniqueid]9NOT NULLMaster (enterprise) dictionary surrogate key.  Points to Dictionary_Entry.EnterpriseEntryID
Indexes TWstat_Signature_Purpose_DE_DefinitionSetID_EntryName_IsCurrentFLAG_IDDefinitionSetID[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 XAK2Signature_Purpose_DE, Nix_Signature_Purpose_DE_CoverIndex(2)EntryCode[dbo].[code]10NOT NULLEntry Code
Cluster Key XAK1Signature_Purpose_DE: EntryName\IsCurrentFLAG\IDIndexes Nix_Signature_Purpose_DE_CoverIndex, TWstat_Signature_Purpose_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Signature_Purpose_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID(3)EntryName[dbo].[name]255NOT NULLEntry Name
Indexes XAK3Signature_Purpose_DE, Nix_Signature_Purpose_DE_CoverIndex(2)EntryMnemonic[dbo].[code]10NOT NULLEntry Mnemonic
Indexes Nix_Signature_Purpose_DE_CoverIndex, TWstat_Signature_Purpose_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID(2)Check Constraints CK_Signature_Purpose_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')IsInactiveFLAG[dbo].[BOOL]1NOT NULLIs the entry inactive (Y/N)?
Check Constraints CK_Signature_Purpose_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 XAK1Signature_Purpose_DE: EntryName\IsCurrentFLAG\IDIndexes XAK2Signature_Purpose_DE, XAK3Signature_Purpose_DE, TWstat_Signature_Purpose_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Signature_Purpose_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID(4)Check Constraints CK_Signature_Purpose_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.