Tables [dbo].[Education_Session]
Education Session details. (versioned table)
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Primary Key PK_Education_Session_ID: IDID[dbo].[uniqueid]9NOT NULLKey to the Education_Session table
Cluster Key cix_Education_Session_EducationSessionHeaderID: EducationSessionHeaderIDForeign Keys FK_Education_Session_EducationSessionHeaderID: [dbo].[Education_Session_Header].EducationSessionHeaderIDEducationSessionHeaderID[dbo].[uniqueid]9NOT NULLKey to the Education_Session_Header table
EncounterID[dbo].[uniqueid]9NOT NULLEncounter. Link to Encounter.ID
RecordedDTTMdatetime8NULL allowedRecorded time
Check Constraints CK_Education_Session_InterpreterUsedFLAG_Yes_Or_No : ([InterpreterUsedFLAG]='N' OR [InterpreterUsedFLAG]='Y')InterpreterUsedFLAG[dbo].[BOOL]1NOT NULL('N')Was an interpteter used (Y/N)?
InterpretersNamevarchar(50)50NOT NULL('')Name of interpreter
Foreign Keys FK_Education_Session_LanguageDE: [dbo].[Language_DE].LanguageDELanguageDE[dbo].[dict_id]5NOT NULL((0))Language. Link to Language_DE.ID
Foreign Keys FK_Education_Session_RelationShipDE: [dbo].[Relationship_DE].RelationShipDERelationShipDE[dbo].[dict_id]5NOT NULL((0))Relationship. Link  to Relationship_DE.ID
Check Constraints CK_Education_Session_CulturalSpirutualFLAG_Yes_Or_No : ([CulturalSpirutualFLAG]='N' OR [CulturalSpirutualFLAG]='Y')CulturalSpirutualFLAG[dbo].[BOOL]1NOT NULL('N')Cultural Or Spiritual (Y/N)? Will only be Y when CulturalComments are entered.
CulturalCommentsvarchar(250)250NULL allowedCultural comments
WhoDiditID[dbo].[uniqueid]9NOT NULLUser who entered
Foreign Keys FK_Education_Session_SiteDE: [dbo].[Site_DE].SiteDESiteDE[dbo].[dict_id]5NOT NULLSite. Link to the Site_DE.ID