Expand All Collapse All
<p>IVR Node Attributes</p>

IVR_NodeAttributes Table

IVR Node Attributes

This table contains each level's detail information including level Duration.

  • Table Type - Historical
  • Last Changed Version - 19.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
NodeId char (7) True No

This is a unique identifier of the IVR node(level name).

 19.3.0.0 IVR Analytics Feature Node Id Attribute IVR
PreviousLevelId char (7) True No

This is a unique identifier of the previously visited IVR node.

 19.3.0.0 IVR Analytics Feature Previous Level Id Attribute IVR
PreviousLevelName nvarchar (400) True No

This is a level name of the previously visited IVR node.

 22.2.0.0 IVR Analytics Feature Previous Level Name 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 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 Attribute 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
AttLevelHierarchy nvarchar (4000) True No

Concatenation of the Level Names from root to the current level separated by '|' as configured in Interaction Attendant. Example 'Profile1|Schedule2|Application3'.

 19.3.0.0 IVR Analytics Feature Attribute Level Hierarchy 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
LevelDuration float False No

Level duration (next node entry time - current node entry time) in seconds..

 19.3.0.0 IVR Analytics Feature Level Duration Fact IVR
EventTime datetime2 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_TimeInterIndex Clustered InteractionUuid (Ascending)
EventTime (Ascending)