Tables [dbo].[Encounter_ItemChild]
Links Clinical Item events with and Encounter
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Indexes NIX_EncID, nix_Encounter_ItemChild_ItemChildID_ItemType, nix_Encounters_ItemChild_ItemChildID(3)Foreign Keys FK_Encounter_ItemChild_EncounterID_Encounter_ID: [dbo].[Encounter].EncounterIDEncounterID[dbo].[uniqueid]9NOT NULLEncounter. Link to Encounter.ID
Cluster Primary Key PK_CIX_Encounter_ItemChild_ItemID_ItemChildID_ItemType: ItemID\ItemChildID\ItemTypeIndexes nix_Encounters_ItemChild_ItemChildIDItemID[dbo].[uniqueid]9NOT NULLItem. Link to the ID column of one of the item tables (Item_plan, Item_medication, etc.)
Cluster Primary Key PK_CIX_Encounter_ItemChild_ItemID_ItemChildID_ItemType: ItemID\ItemChildID\ItemTypeIndexes nix_Encounter_ItemChild_ItemChildID_ItemType, nix_Encounters_ItemChild_ItemChildID(2)ItemChildID[dbo].[uniqueid]9NOT NULLVersion identifier of the clinical item. Link to the ID column one of the item child tables (Plan_Item, Medication, Immunization, Result, etc.)
Cluster Primary Key PK_CIX_Encounter_ItemChild_ItemID_ItemChildID_ItemType: ItemID\ItemChildID\ItemTypeIndexes nix_Encounter_ItemChild_ItemChildID_ItemType, nix_Encounters_ItemChild_ItemChildID(2)ItemTypechar(2)2NOT NULLItem Type. (ME - Medication, PL - Non medication order, AL - Allergy, etc.)
Indexes nix_Encounters_ItemChild_ItemChildID, TWstat_Encounter_ItemChild_EncounterDTTM(2)EncounterDTTMdatetime8NOT NULLEncounter date and time
Indexes NIX_EncID, nix_Encounter_ItemChild_ItemChildID_ItemType, nix_Encounters_ItemChild_ItemChildID(3)VerbListvarchar(255)255NOT NULLList of actions that occured on this encounter for this item