Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Order_Item_Charge_Modifier
Touchworks 25.2
[dbo].[Order_Item_Charge_Modifier]
MS_Description
CPT4 modifiers in separate rows/records, when Charge codes with 0-5 Modifier are selected after commit of order edit workflow
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Default
Description
ItemChildID
[dbo].[uniqueid]
9
NOT NULL
Current version of the item (eg. plan_item.ID)
ItemType
char(2)
2
NOT NULL
Item Type (eg. PL)
CPT4ModifierDE
[dbo].[dict_id]
5
NOT NULL
Modifier. Link to CPT4_Modifier_DE.ID
ChargeCodeDE
[dbo].[dict_id]
5
NOT NULL
ChargeCode to identify Modifiers mapped against each ChargeCode. Link to Charge_Code_DE.ID
DuplicateChargeCount
[dbo].[uniqueid]
9
NOT NULL
((1))
Sequencing number for duplicate charge codes