Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Patient_Education_Provided
Touchworks 25.2
[dbo].[Patient_Education_Provided]
MS_Description
Audit of when patient education was provided
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Default
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Key to the Patient_Education_Provided table.
EncounterID
[dbo].[uniqueid]
9
NOT NULL
Encounter. Key to the Encounter table
PatientID
[dbo].[uniqueid]
9
NOT NULL
Patient. Key to the Person Table
ItemID
[dbo].[uniqueid]
9
NOT NULL
Item identifier
UserID
[dbo].[uniqueid]
9
NULL allowed
User. Key to the Person Table
EducationTypeDE
[dbo].[dict_id]
5
NOT NULL
Education Type. Key to the Education_Type_DE table
PatientCommunicationDE
[dbo].[dict_id]
5
NOT NULL
Patient Communication type. Key to the PatientCommunication_DE table.
ItemType
char(2)
2
NOT NULL
Item Type (PL, ME, IM, etc.)
OrderType
char(2)
2
NOT NULL
Order Type
ProvidedDTTM
datetime
8
NOT NULL
Time Education Provided
CreatedDTTM
datetime
8
NOT NULL
(getdate())
Creation Time