Tables [dbo].[Order_Item_Charge_Modifier]
CPT4 modifiers in separate rows/records, when Charge codes with 0-5 Modifier are selected after commit of order edit workflow
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_Order_Item_Charge_Modifier_ItemChildID_ItemType_CPT4ModifierDE_ChargeCodeDE_DuplicateChargeCount: ItemChildID\ItemType\CPT4ModifierDE\ChargeCodeDE\DuplicateChargeCountItemChildID[dbo].[uniqueid]9NOT NULLCurrent version of the item (eg. plan_item.ID)
Cluster Primary Key PK_Order_Item_Charge_Modifier_ItemChildID_ItemType_CPT4ModifierDE_ChargeCodeDE_DuplicateChargeCount: ItemChildID\ItemType\CPT4ModifierDE\ChargeCodeDE\DuplicateChargeCountItemTypechar(2)2NOT NULLItem Type (eg. PL)
Cluster Primary Key PK_Order_Item_Charge_Modifier_ItemChildID_ItemType_CPT4ModifierDE_ChargeCodeDE_DuplicateChargeCount: ItemChildID\ItemType\CPT4ModifierDE\ChargeCodeDE\DuplicateChargeCountForeign Keys FK_Order_Item_Charge_Modifier_CPT4ModifierDE_CPT4_Modifier_DE_ID: [dbo].[CPT4_Modifier_DE].CPT4ModifierDECPT4ModifierDE[dbo].[dict_id]5NOT NULLModifier. Link to CPT4_Modifier_DE.ID
Cluster Primary Key PK_Order_Item_Charge_Modifier_ItemChildID_ItemType_CPT4ModifierDE_ChargeCodeDE_DuplicateChargeCount: ItemChildID\ItemType\CPT4ModifierDE\ChargeCodeDE\DuplicateChargeCountForeign Keys FK_Order_Item_Charge_Modifier_ChargeCodeDE_Charge_Code_DE_ID: [dbo].[Charge_Code_DE].ChargeCodeDEChargeCodeDE[dbo].[dict_id]5NOT NULLChargeCode to identify Modifiers mapped against each ChargeCode. Link to Charge_Code_DE.ID
Cluster Primary Key PK_Order_Item_Charge_Modifier_ItemChildID_ItemType_CPT4ModifierDE_ChargeCodeDE_DuplicateChargeCount: ItemChildID\ItemType\CPT4ModifierDE\ChargeCodeDE\DuplicateChargeCountDuplicateChargeCount[dbo].[uniqueid]9NOT NULL((1))Sequencing number for duplicate charge codes