Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.HealthConcern_Impression
Touchworks 25.2
[dbo].[HealthConcern_Impression]
MS_Description
Health Concern Impression
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Key to the HealthConcern_Impression table.
HealthConcernHeaderID
[dbo].[uniqueid]
9
NOT NULL
Health Concern Header ID. Link to HealthConcern_Header.ID.
EncounterID
[dbo].[uniqueid]
9
NOT NULL
Encounter. Link to Encounter.ID.
ImpressionText
varchar(2000)
2000
NULL allowed
Impression Text
IsCurrentImpressionForEncounter
bit
1
NULL allowed
Is this Impression is the latest impression for the Encounter?
ImpressionByID
[dbo].[uniqueid]
9
NOT NULL
Provider , who added the impression
RecordedDTTM
datetime
8
NOT NULL
Impression recorded date and time