Tables [dbo].[QO_Class_Instruction]
This table contains instructions that pertain to orders. It gets populated via the CareGuide installer.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Cluster Primary Key PK_QO_Class_Instruction: IDID[dbo].[dict_id]5NOT NULL1 - 1Key to the dbo.QO_Class_Instruction table
Indexes Unique_QO_Lang, NIX_QO_Class_Instruction_QOClassificationDE_LanguageDE_WithIncludeColumns(2)Foreign Keys FK_QO_Class_Instruction_QO_Classification_DE: [dbo].[QO_Classification_DE].QOClassificationDEQOClassificationDE[dbo].[dict_id]5NOT NULLOrderable item. Link to dbo.QO_Classification_De.id
Indexes Unique_QO_Lang, NIX_QO_Class_Instruction_QOClassificationDE_LanguageDE_WithIncludeColumns(2)Foreign Keys FK_QO_Class_Instruction_Language_DE: [dbo].[Language_DE].LanguageDELanguageDE[dbo].[dict_id]5NOT NULLLanguage. Link to Language_DE.ID
Indexes NIX_QO_Class_Instruction_CurrentQOClassInstructionLangID, NIX_QO_Class_Instruction_QOClassificationDE_LanguageDE_WithIncludeColumns(2)Foreign Keys FK_QO_Class_Instruction_QO_Class_Instruction_Lang: [dbo].[QO_Class_Instruction_Lang].CurrentQOClassInstructionLangIDCurrentQOClassInstructionLangID[dbo].[dict_id]5NOT NULLLink to the cuurent version in the QO_Class_Instruction_Lang table.
Indexes NIX_QO_Class_Instruction_QOClassificationDE_LanguageDE_WithIncludeColumnsAHSID[dbo].[uniqueid]9NOT NULLAllscri[ts ID. When this vlaue is 0 it means it is not an instruction we deliver. When > 0 it means it's an instruction we (AHS) deliver via Careguie Install.