Tables [dbo].[Plan_Item_Instruction_Variable]
Mapping between the Plan_Item and the Instruction_Variable_DE tables for the variable value replacement in the FirstString value. FirstString based on the Item_Plan.QOClassificationDE -> QO_Classification_DE.QOClassInstructionID
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Primary Key PK_Plan_Item_Instruction_Variable: PlanItemID\InstructionVariableDEForeign Keys FK_Plan_Item_Instruction_Variable_PlanItemID: [dbo].[Plan_Item].PlanItemIDPlanItemID[dbo].[uniqueid]9NOT NULLOrder. Link to Plan_Item.ID.
Cluster Primary Key PK_Plan_Item_Instruction_Variable: PlanItemID\InstructionVariableDEForeign Keys FK_Plan_Item_Instruction_Variable_Instruction_Variable_DE: [dbo].[Instruction_Variable_DE].InstructionVariableDEInstructionVariableDE[dbo].[dict_id]5NOT NULLInstruction variable. Link to Instruction_Variable_DE.ID
Valuenvarchar(255)510NOT NULLValue to replace the Instruction_Variable_DE.ReplacementText in the Plan_Item.FirstString
DictEntryID[dbo].[dict_id]5NOT NULLValue of the Dictionary.ID associated to the Instruction_Variable_DE.DictionaryID