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

IVR_ExitEvents Table

IVR Exit Events

This table contains last event for each interaction with ExitPath information.

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

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
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
CompletionType nvarchar (22) False 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
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
LevelName nvarchar2 (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
CompletionType nvarchar2 (22) False No

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

 19.3.0.0 IVR Analytics Feature
Queue nvarchar2 (2000) True No

Target queue. Example Agent Queue or Workgroup Queue

 19.3.0.0 IVR Analytics Feature
Action nvarchar2 (20) True No

Action within the IVR flow(NoInput or NoMatch).

 19.3.0.0 IVR Analytics Feature

Constraints

Primary Key Name Type Column Name (sort order)
PK_IVR_ExitEvents Clustered InteractionUuid (Ascending)

Primary Key Name Column Name (sort order)
PK_IVR_ExitEvents InteractionUuid (Ascending)