Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Plan_Item_Instruction_Variable
Touchworks 25.2
[dbo].[Plan_Item_Instruction_Variable]
MS_Description
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
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Description
PlanItemID
[dbo].[uniqueid]
9
NOT NULL
Order. Link to Plan_Item.ID.
InstructionVariableDE
[dbo].[dict_id]
5
NOT NULL
Instruction variable. Link to Instruction_Variable_DE.ID
Value
nvarchar(255)
510
NOT NULL
Value to replace the Instruction_Variable_DE.ReplacementText in the Plan_Item.FirstString
DictEntryID
[dbo].[dict_id]
5
NOT NULL
Value of the Dictionary.ID associated to the Instruction_Variable_DE.DictionaryID