Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Order_Item_Charge
Touchworks 25.2
[dbo].[Order_Item_Charge]
MS_Description
Charges for orders
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Default
Description
ItemChildID
[dbo].[uniqueid]
9
NOT NULL
Order. Links to Plan_Item.ID, Immunization.ID, or Medication.ID based on itemtype.
ItemType
char(2)
2
NOT NULL
ME = Medication
PL = PlanItem
IM = Immunization
ChargeCodeDE
[dbo].[dict_id]
5
NOT NULL
Charge Code. Link to Charge_Code_DE.ID
WhenToChargeDE
[dbo].[dict_id]
5
NOT NULL
When to Charge. Link to When_To_Charge_DE.ID.
Units
int
4
NOT NULL
(0)
Number of units to charge for
AdminChargeFLAG
[dbo].[XBOOL]
1
NOT NULL
('N')
Is this a charge for medication administration?
X - NA
Y - Yes
N - No
SpecimenChargeFLAG
[dbo].[BOOL]
1
NOT NULL
('N')
Charge is for Specimen Collection (Y/N)
ChargeID
[dbo].[uniqueid]
9
NOT NULL
(0)
Charge. Link to Charge.ID.
ChargeEncounterID
[dbo].[uniqueid]
9
NOT NULL
(0)
Encounter for the charge. Link to Encounter.ID
StartDTTM
datetime
8
NULL allowed
Start time for time based charges
EndDTTM
datetime
8
NULL allowed
End time for time based charges
ChargeItemID
[dbo].[uniqueid]
9
NOT NULL
(0)
Order. Links to Order_Activity_Header.ID, Item_Medication.ID, or Item_Immunizaton.ID based on Item Type.
DuplicateChargeCount
[dbo].[uniqueid]
9
NOT NULL
((1))
Sequencing number for duplicate charge codes.