Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Service_Package_Component
Touchworks 25.2
[dbo].[Service_Package_Component]
MS_Description
Occupational Medicine Service Package Component (Orderable Item).
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Default
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Key to the Service_Package_Component table
EncounterServicePackageID
[dbo].[uniqueid]
9
NOT NULL
Service Package. Link to Encounter_Service_Package.ID
OIDTYPE
char(1)
1
NOT NULL
Type of Orderable Item (OIDID); valid values: 'I', 'M', 'O'
OIDID
[dbo].[dict_id]
5
NOT NULL
((0))
Orderable Item; Links to either Medication_DE.ID or QO_Classification_DE.ID (depends on OIDTYPE)
ItemID
[dbo].[uniqueid]
9
NOT NULL
((0))
Created Item. Links to the created order (Item_plam.ID, Item_Medication.ID, or Item_Immunization.ID)