Expand All Collapse All
<p>IVR All Events</p>

IVR_AllEvents Table

IVR All Events

This table stores IVR Events generated by Interaction Attendant.

  • Table Type - Historical
  • Last Changed Version - 22.3.0.0
  • Last Changed Reason - IVR Analytics Feature

SQL Column Definitions

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason CX Insights Name CX Insights Type CX Insights Folder Name
InteractionUuid nchar (72) False No

Interaction Uuid (Universal Unique Identifier) is a 128-bit number used to uniquely identify Interaction.

 19.3.0.0 IVR Analytics Feature Interaction UUID Attribute IVR
InteractionId bigint False No

A Globally Unique Identifier(GUID) to uniquely identify an interaction.

 19.3.0.0 IVR Analytics Feature Interaction Id Fact IVR
ANI nvarchar (100) False No

ANI (Automatic Number Identification) is Originating party number or caller ID

 19.3.0.0 IVR Analytics Feature ANI Attribute IVR
DNIS nvarchar (100) False No

DNIS (Dialed Number Identification Service) is number dialed by the calling party. It obtained from the telephone network for any inbound call on DNIS enabled lines.

 19.3.0.0 IVR Analytics Feature DNIS Attribute IVR
LevelName nvarchar (400) False No

This stores IVR call event Level Name. Application for which this data is reported. This will be used when reporting for all activities in IVR.

 22.2.0.0 IVR Analytics Feature Level Name Attribute IVR
LevelNumber tinyint (1) False No

Level of the statistics. Server=0, Profile=1, Schedule=2, Application/Complex Operation=3, Menu=4, Task=5,Exit Path=6

 19.3.0.0 IVR Analytics Feature Level Number Attribute IVR
LevelHierarchy nvarchar (4000) True No

Concatenation of the Level Names from root to the current level separated by '|'. Example 'Profile1|Schedule2|Application3'. In the case where the current node is the root (Level Number=0), there will be no parent node.

 22.2.0.0 IVR Analytics Feature Level Hierarchy IVR IVR
LevelIdHierarchy varchar (4000) True No

Concatenation of the Level Ids from root to the current level separated by '|'. Example '0000001|0000002|000001H'.

 22.2.0.0 IVR Analytics Feature Level Id Hierarchy Attribute IVR
CompletionType nvarchar (22) True No

Either Completed (contained call) or Transferred(non-contained call).

 19.3.0.0 IVR Analytics Feature Completion Type Attribute IVR
Queue nvarchar (2000) True No

Target queue. Example Agent Queue or Workgroup Queue

 19.3.0.0 IVR Analytics Feature Queue Attribute IVR
Action nvarchar (20) True No

Action within the IVR flow(NoInput or NoMatch).

 19.3.0.0 IVR Analytics Feature Action Attribute IVR
EventTime datetime2 (7) False No

IVR call event Time (to millisecond precision) of an event when a particular level is visited.

 19.3.0.0 IVR Analytics Feature Event Time Fact IVR

SQL Constraints



Index Name Type Column Name (sort order)
IX_IdIndex Clustered InteractionId (Ascending)