Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.HealthConcern_Header
Touchworks 25.2
[dbo].[HealthConcern_Header]
MS_Description
Health Concern Header
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Description
ID
[dbo].[uniqueid]
9
NOT NULL
Key to the HealthConcern_Header table
PatientID
[dbo].[uniqueid]
9
NOT NULL
Patient. Link to Patient_Member.ID.
CurrentHealthConcernID
[dbo].[uniqueid]
9
NOT NULL
Current instance of the Health Concern. Link to HealthConcern.ID.
EncounterID
[dbo].[uniqueid]
9
NOT NULL
Encounter. Link to Encounter.ID.
HealthConcernName
varchar(255)
255
NOT NULL
Name of the Health Concern
HealthConcernSourceDE
[dbo].[dict_id]
5
NOT NULL
Problem_DE.ID OR
QO _DE.ID OR
Medication_Allergy_DE.ID OR
Allergen_DE.ID
ClinicalItemType
varchar(10)
10
NOT NULL
‘PR’ – Problem
‘RI’ – result
‘MED-AL’ – Med Allergy
‘NONMED-AL’ – Non Med Allergy
CreatedByID
[dbo].[uniqueid]
9
NOT NULL
Provider who added the Health Concern into the patient Chart
CreateDTTM
datetime
8
NOT NULL
Date and time of Health Concern added into the patient Chart
LastUpdateDTTM
datetime
8
NOT NULL
Last updated date and time
ClinicalItemHeaderID
[dbo].[uniqueid]
9
NULL allowed
ID of problem/results instance data