Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.HealthConcern_ClinicalItem_Link
Touchworks 25.2
[dbo].[HealthConcern_ClinicalItem_Link]
MS_Description
Linked Clinical items for the Health Concern
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Key to the HealthConcern_ClinicalItem_Link table.
HealthConcernHeaderID
[dbo].[uniqueid]
9
NOT NULL
Health Concern Header ID. Link to HealthConcern_Header.ID.
ClinicalItemType
varchar(10)
10
NOT NULL
‘PR’ – Problem
‘RI’ – result
‘MED-AL’ – Med Allergy
‘NONMED-AL’ – Non Med Allergy
ClinicalItemDE
[dbo].[dict_id]
5
NOT NULL
Problem_DE.ID OR
QO _DE.ID OR
Medication_Allergy_DE.ID OR
Allergen_DE.ID
CreateDTTM
datetime
8
NOT NULL
Created date and time
ClinicalItemHeaderID
[dbo].[uniqueid]
9
NULL allowed
ID of problem/results instance data