Expand All Collapse All
<p>This Sproc will add IVR Event data in IVR_AllEvents table. </p>

spivr_AddIVREvent Stored Procedure

This Sproc will add IVR Event data in IVR_AllEvents table.

This Sproc will add IVR Event data in IVR_AllEvents table along with other IVR details like: Interaction ID, ANI and DNIS etc.

  • Last Changed Version - 19.3.0.0
  • Last Changed Reason - Analytics IVR Events stored procedure.

SQL Parameter Definitions

Column Parameter Direction Data Type (Size) Description
@InteractionUuid INPUT nchar (72)
@InteractionId INPUT char (10)
@ani INPUT nvarchar (100)
@dnis INPUT nvarchar (100)
@LevelName INPUT nvarchar (400)
@LevelNumber INPUT tinyint (1)
@LevelHierarchy INPUT nvarchar (4000)
@LevelIdHierarchy INPUT varchar (4000)
@CompletionType INPUT varchar (22)
@Queue INPUT nvarchar (2000)
@Action INPUT nvarchar (20)
@EventTime INPUT datetime2 (7)