Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Problem_Impression
Touchworks 25.2
[dbo].[Problem_Impression]
MS_Description
New table created to store Impressions added for each Patient's problem. This is Encounter specific. Impressions are added on the problem details screen.
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Description
ProblemHeaderID
[dbo].[uniqueid]
9
NOT NULL
Key to the Problem_Header table
ProblemID
[dbo].[uniqueid]
9
NOT NULL
Key to the Problem table. Problem version the impression was entered under.
EncounterID
[dbo].[uniqueid]
9
NOT NULL
Key to the Encounter table.
ImpressionText
varchar(2000)
2000
NOT NULL
Impression text
ImpressionByID
[dbo].[uniqueid]
9
NOT NULL
UserID of the user who entered the impression
RecordedDTTM
datetime
8
NOT NULL
Recorded time