IVR Node Attributes
This table contains each level's detail information including level Duration.
| 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 |
| 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 | nvarchar2 (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 | |||
| NodeId | char (7) | True | No | This is a unique identifier of the IVR node(level name). |
19.3.0.0 | IVR Analytics Feature | |||
| PreviousLevelId | char (7) | True | No | This is a unique identifier of the previously visited IVR node. |
19.3.0.0 | IVR Analytics Feature | |||
| PreviousLevelName | nvarchar2 (400) | True | No | This is a level name of the previously visited IVR node. |
22.2.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 | |||
| 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 | |||
| LevelHierarchy | nvarchar2 (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 | |||
| LevelIdHierarchy | varchar2 (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 | |||
| AttLevelHierarchy | nvarchar2 (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 | |||
| Action | nvarchar2 (20) | True | No | Action within the IVR flow(NoInput or NoMatch). |
19.3.0.0 | IVR Analytics Feature | |||
| LevelDuration | float | False | No | Level duration (next node entry time - current node entry time) in seconds.. |
19.3.0.0 | IVR Analytics Feature | |||
| EventTime | timestamp | 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 |