Tables [dbo].[Form_DE]
Unused dictionary
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Cluster Primary Key PK_Form_DE_ID: IDID[dbo].[dict_id]5NOT NULL1 - 1Key to the Form_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_Form_DE_EntryCode_WithIncludeColumns, NIX_Form_DE_EntryMnemonic_WithIncludeColumns, NIX_Form_DE_EntryName_WithIncludeColumns(3)EntryCode[dbo].[code]10NOT NULLEntry Code - Unique alphanumeric code
Indexes NIX_Form_DE_EntryCode_WithIncludeColumns, NIX_Form_DE_EntryMnemonic_WithIncludeColumns, NIX_Form_DE_EntryName_WithIncludeColumns(3)EntryName[dbo].[name]255NOT NULLEntry Name -  Unique alphanumeric "friendly" display name
Indexes NIX_Form_DE_EntryCode_WithIncludeColumns, NIX_Form_DE_EntryMnemonic_WithIncludeColumns, NIX_Form_DE_EntryName_WithIncludeColumns(3)EntryMnemonic[dbo].[code]10NOT NULLEntry Mnemonic
Indexes NIX_Form_DE_EntryCode_WithIncludeColumns, NIX_Form_DE_EntryMnemonic_WithIncludeColumns, NIX_Form_DE_EntryName_WithIncludeColumns(3)Check Constraints CK_Form_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')IsInactiveFLAG[dbo].[BOOL]1NOT NULLIs the entry inactive (Y/N)?
Check Constraints CK_Form_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.
Indexes NIX_Form_DE_EntryCode_WithIncludeColumns, NIX_Form_DE_EntryMnemonic_WithIncludeColumns, NIX_Form_DE_EntryName_WithIncludeColumns(3)Check Constraints CK_Form_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y')IsCurrentFLAG[dbo].[BOOL]1NOT NULLIs the entry Current (Y/N)?
EffectiveDTdatetime8NULL allowedEffective Date is the last edited date.
ServerNamevarchar(128)128NOT NULLServer Name
DocumentNamevarchar(128)128NOT NULLDocument Name
Foreign Keys FK_Form_DE_ActivityTypeDE_Activity_Type_DE_ID: [dbo].[Activity_Type_DE].ActivityTypeDEActivityTypeDE[dbo].[dict_id]5NOT NULLActivity Type. Link to Activity_Type_DE.ID