Tables [dbo].[Instruction_Variable_DE]
Codes / replacement text used during Variable replacement in Text Strings. Example in the QO_Class_Instruction_Lang.FirstString when it is put in the Plan_Item.FirstString (i.e {dur1}, {temp1}, {count1} etc.)
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Primary Key PK_Instruction_Variable_DE_ID: IDID[dbo].[dict_id]5NOT NULL1 - 1Key to the Instruction_Variable_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 XAK2InstructionVariableDEEntryCode[dbo].[code]10NOT NULLUnique alphanumeric code.  Brief but cryptic.
Cluster Key XAK1InstructionVariableDE: EntryName\IsCurrentFLAGEntryName[dbo].[name]255NOT NULLUnique alphanumeric "friendly" display name
Indexes XAK3InstructionVariableDEEntryMnemonic[dbo].[code]10NOT NULLTypically the same as the Code value, but can be blank.  If present, it must be unique
Check Constraints CK_Instruction_Variable_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_Instruction_Variable_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')IsEnforcedFLAG[dbo].[BOOL]1NOT NULLY=row is readonly;  N=row is modifiable
Cluster Key XAK1InstructionVariableDE: EntryName\IsCurrentFLAGIndexes XAK2InstructionVariableDE, XAK3InstructionVariableDE, TWstat_Instruction_Variable_DE_IsCurrentFLAG(3)Check Constraints CK_Instruction_Variable_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.
EffectiveDTdatetime8NULL allowedTime of last modification  (not "when this row goes into effect")
ReplacementTextvarchar(255)255NULL allowedText that will be replaced in the String (i.e {dur1}, {temp1}, {count1} etc.)
Foreign Keys FK_Instruction_Variable_DE_Instruction_Variable_Type_DE: [dbo].[Instruction_Variable_Type_DE].InstructionVariableTypeDEInstructionVariableTypeDE[dbo].[dict_id]5NULL allowedInstruction Variable Type. Link to Instruction_Variable_Type_DE.ID
Indexes TWstat_Instruction_Variable_DE_DictionaryIDForeign Keys FK_Instruction_Variable_DE_DictionaryID: [dbo].[Dictionary].DictionaryIDDictionaryID[dbo].[dict_id]5NULL allowedDictionary. Link to Dictionary.ID.
Indexes TWstat_Instruction_Variable_DE_PickListIDForeign Keys FK_Instruction_Variable_DE_PickListID: [dbo].[Picklist].PickListIDPickListID[dbo].[dict_id]5NULL allowedPicklist. Link to Picklist.ID.