Tables [dbo].[Encounter_ItemChild_Verb]
Links individual actions for a clinical item to and encounter
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Indexes NIX_EncIDForeign Keys FK_Encounter_ItemChild_Verb_EncounterID_Encounter_ID: [dbo].[Encounter].EncounterIDEncounterID[dbo].[uniqueid]9NOT NULLEncounter. Link to Encounter.ID
Cluster Primary Key PK_CIX_Encounter_ItemChild_Verb_ItemID_ItemChildID_ItemType_Verb: ItemID\ItemChildID\ItemType\VerbItemID[dbo].[uniqueid]9NOT NULLItem. Links to the ID columm on one of the item tables (Item_plan, Item_Medication, etc)
Cluster Primary Key PK_CIX_Encounter_ItemChild_Verb_ItemID_ItemChildID_ItemType_Verb: ItemID\ItemChildID\ItemType\VerbIndexes nix_Encounter_ItemChildVerb_Verb_ItemChildIDItemChildID[dbo].[uniqueid]9NOT NULLVersion Identifier for the clinical item. Links to the ID column in one of the child tables (Plan_item, Mdication, Immunization, etc)
Cluster Primary Key PK_CIX_Encounter_ItemChild_Verb_ItemID_ItemChildID_ItemType_Verb: ItemID\ItemChildID\ItemType\VerbIndexes nix_Encounter_ItemChildVerb_Verb_ItemChildIDVerbvarchar(255)255NOT NULLAction taken
Cluster Primary Key PK_CIX_Encounter_ItemChild_Verb_ItemID_ItemChildID_ItemType_Verb: ItemID\ItemChildID\ItemType\VerbItemTypechar(2)2NOT NULLItem type. (ME - Medication, PL - Non medication order, IM - Immunization, etc)