Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Encounter_Service_Package
Touchworks 25.2
[dbo].[Encounter_Service_Package]
MS_Description
Occupational Medicine Service Package linked to an encounter
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Default
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Key to the Encounter_Service_Package table
EncounterID
[dbo].[uniqueid]
9
NOT NULL
Encounter. Link to Encounter.ID
ServicePackageNumberExt
varchar(20)
20
NOT NULL
Service Package external identifier
ProblemDE
[dbo].[dict_id]
5
NOT NULL
((0))
Problem. Link to Problem_DE.ID
Description
varchar(40)
40
NOT NULL
('')
Service Package description
EncounterEmployerId
[dbo].[uniqueid]
9
NOT NULL
((0))
Employer. Link to Encounter_Employer.ID
ProblemID
[dbo].[uniqueid]
9
NOT NULL
((0))
Problem. Link to Problem_Header.ID