Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Education_Session
Touchworks 25.2
[dbo].[Education_Session]
MS_Description
Education Session details. (versioned table)
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Default
Description
ID
[dbo].[uniqueid]
9
NOT NULL
Key to the Education_Session table
EducationSessionHeaderID
[dbo].[uniqueid]
9
NOT NULL
Key to the Education_Session_Header table
EncounterID
[dbo].[uniqueid]
9
NOT NULL
Encounter. Link to Encounter.ID
RecordedDTTM
datetime
8
NULL allowed
Recorded time
InterpreterUsedFLAG
[dbo].[BOOL]
1
NOT NULL
('N')
Was an interpteter used (Y/N)?
InterpretersName
varchar(50)
50
NOT NULL
('')
Name of interpreter
LanguageDE
[dbo].[dict_id]
5
NOT NULL
((0))
Language. Link to Language_DE.ID
RelationShipDE
[dbo].[dict_id]
5
NOT NULL
((0))
Relationship. Link to Relationship_DE.ID
CulturalSpirutualFLAG
[dbo].[BOOL]
1
NOT NULL
('N')
Cultural Or Spiritual (Y/N)? Will only be Y when CulturalComments are entered.
CulturalComments
varchar(250)
250
NULL allowed
Cultural comments
WhoDiditID
[dbo].[uniqueid]
9
NOT NULL
User who entered
SiteDE
[dbo].[dict_id]
5
NOT NULL
Site. Link to the Site_DE.ID