Tables [dbo].[Order_Item_Charge]
Charges for orders
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Key CIX_Order_Item_Charge_ItemChildID_ItemType_ChargeCodeDE: ItemChildID\ItemType\ChargeCodeDEIndexes NIX_Order_Item_Charge_ItemChildID_SpecimenChargeFLAGItemChildID[dbo].[uniqueid]9NOT NULLOrder. Links to Plan_Item.ID, Immunization.ID, or Medication.ID based on itemtype.
Cluster Key CIX_Order_Item_Charge_ItemChildID_ItemType_ChargeCodeDE: ItemChildID\ItemType\ChargeCodeDEItemTypechar(2)2NOT NULLME = Medication
PL =  PlanItem
IM = Immunization
Cluster Key CIX_Order_Item_Charge_ItemChildID_ItemType_ChargeCodeDE: ItemChildID\ItemType\ChargeCodeDEIndexes NIX_Order_Item_Charge_ItemChildID_SpecimenChargeFLAGForeign Keys FK_Order_Item_Charge_ChargeCodeDE_Charge_Code_DE_ID: [dbo].[Charge_Code_DE].ChargeCodeDEChargeCodeDE[dbo].[dict_id]5NOT NULLCharge Code. Link to Charge_Code_DE.ID
Indexes TWstat_Order_Item_Charge_WhenToChargeDEWhenToChargeDE[dbo].[dict_id]5NOT NULLWhen to Charge. Link to When_To_Charge_DE.ID.
Unitsint4NOT NULL(0)Number of units to charge for
Check Constraints CK_Order_Item_Charge_AdminChargeFLAG_Yes_Or_No_Or_Other : ([AdminChargeFLAG]='X' OR [AdminChargeFLAG]='N' OR [AdminChargeFLAG]='Y')AdminChargeFLAG[dbo].[XBOOL]1NOT NULL('N')Is this a charge for medication administration?
X - NA
Y - Yes
N - No
Indexes NIX_Order_Item_Charge_ItemChildID_SpecimenChargeFLAGCheck Constraints CK_Order_Item_Charge_SpecimenChargeFLAG_Yes_Or_No : ([SpecimenChargeFLAG]='N' OR [SpecimenChargeFLAG]='Y')SpecimenChargeFLAG[dbo].[BOOL]1NOT NULL('N')Charge is for Specimen Collection (Y/N)
ChargeID[dbo].[uniqueid]9NOT NULL(0)Charge. Link to Charge.ID.
ChargeEncounterID[dbo].[uniqueid]9NOT NULL(0)Encounter for the charge. Link to Encounter.ID
StartDTTMdatetime8NULL allowedStart time for time based charges
EndDTTMdatetime8NULL allowedEnd time for time based charges
Indexes XOrder_Item_Charge_ChargeItemIDChargeItemID[dbo].[uniqueid]9NOT NULL(0)Order. Links to Order_Activity_Header.ID, Item_Medication.ID, or Item_Immunizaton.ID based on Item Type.
DuplicateChargeCount[dbo].[uniqueid]9NOT NULL((1))Sequencing number for duplicate charge codes.