Expand All Collapse All
<p>IVR Attendant Settings</p>

IVR_AttendantSettings Table

IVR Attendant Settings

This table contains all the nodes of Interaction Attendant

  • 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
NodeId char (7) False No

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

 19.3.0.0 IVR Analytics Feature Node Id Attribute IVR
ServerName nvarchar (60) False No

PureConnect Server name

 19.3.0.0 IVR Analytics Feature Server Name Attribute IVR
ParentNodeId char (7) True No

This is a unique identifier of parent node

 19.3.0.0 IVR Analytics Feature Parent Node Id 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 Fact 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'.

 22.2.0.0 IVR Analytics Feature Attribute Level Hierarchy Attribute IVR
AttLevelIdHierarchy 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 Attribute Level Id Hierarchy Attribute IVR
LevelType nvarchar (50) True No

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

 19.3.0.0 IVR Analytics Feature Level Type Attribute IVR

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_IVR_AttendantSetting Clustered NodeId (Ascending)
ServerName (Ascending)