Tables [dbo].[Rx_Dispense_Transaction]
Transaction sent to Inventory Mgmt System when a Medication/Immunization is dispensed
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Indexes NIX_Rx_Dispense_Transaction_IDID[dbo].[uniqueid]9NOT NULL1 - 1Surrogate auto-generated unique primary key value
Cluster Primary Key CIX_Rx_Dispense_Transaction_ItemID_OrigItemChildID_ItemType: ItemID\OrigItemChildID\ItemTypeItemID[dbo].[uniqueid]9NOT NULLItem_Medication.ID or Item_Immunization.ID
Cluster Primary Key CIX_Rx_Dispense_Transaction_ItemID_OrigItemChildID_ItemType: ItemID\OrigItemChildID\ItemTypeOrigItemChildID[dbo].[uniqueid]9NOT NULLMedication.ID or Immunization.ID when entry was created
Cluster Primary Key CIX_Rx_Dispense_Transaction_ItemID_OrigItemChildID_ItemType: ItemID\OrigItemChildID\ItemTypeItemTypechar(2)2NOT NULLItem Type - Medication, Med Admin, Immunization
CurrentID[dbo].[uniqueid]9NOT NULLMedication.ID or Immunization.ID
CreatedByID[dbo].[uniqueid]9NOT NULLLogged in User ID. Link to IDX_User.ID
CreatedDTTMdatetime8NULL allowedDate/time record was created
ModifiedByID[dbo].[uniqueid]9NOT NULLLogged in User ID. Link to IDX_User.ID
ModifiedDTTMdatetime8NULL allowedDate/time record last updated
GetInventoryResponsevarchar(max)maxNULL allowedResponse from Inventory System (json)
PostInventoryRequestvarchar(max)maxNULL allowedMessage sent to Inventory System when med was dispensed (json)
DispenseStatusint4NULL allowedStatus of Rx Dispense transaction
InventorySystemvarchar(24)24NULL allowedRx Inventory system integration name
InventoryDispenseInfovarchar(500)500NULL allowedJSON document containing information required to post the dispense transaction to the Rx inventory system