Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Service_Package_Comment
Touchworks 25.2
[dbo].[Service_Package_Comment]
MS_Description
Occupational Medicine Service Package Comments
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Key to the Service_Package_Comment table
EncounterServicePackageID
[dbo].[uniqueid]
9
NOT NULL
Service Package. Link to Encounter_Service_Package.ID
CommentNumberExt
varchar(60)
60
NOT NULL
External identifier for Comment Number
CommentCategory
char(1)
1
NOT NULL
'C' for clinical; 'N' for non-clinical
Comment
varchar(max)
max
NOT NULL
Actual comments