Expand All Collapse All
IVR Interval Table

IVR Interval Table

This log contains IVR navigation data that is accumulated and reported on a configurable interval.

Physical Attributes

Log Identifier Log Name Table Name

85

IVR Interval

IVRInterval

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
IVRIntervalId int False No

This column and the column SiteId make up the primary key for the IVRInterval table

 4.0.106.453 4.0 Release
cLevelName nvarchar (50) False Depends on customer usage

Application for which this data is reported. "*" will be used when reporting for all activities in IVR. This will be the concatenation of the Level Names defining the current level separated by '|'. Example 'Profile1|Schedule2|Application3'

 4.0.106.453 4.0 Release
nLevel tinyint False No

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

 4.0.106.453 4.0 Release
ParentLevels nvarchar (200) False Depends on customer usage

Parent levels refer to the Attendant node above the current node. In the case where the current node is the root (nLevel=1), there will be no parent node.

 4.0.106.453 4.0 Release
cExitPath nvarchar (250) False Depends on customer usage

Path for which this data is reported. An "*" will be used when this is a summary row of all activity for the Application and Menu. The path reported is the exit path from the menu. When the exit reason is transfer to a Queue, then the path will be reported as "Transfer WG:{Queue Name}". When the exit reason is a transfer to a user or station queue, the path will be "Transfer User" or "Transfer Station". When the exit reason is an abort of IVR, then the path will be "Abort". "Disconnect" will be used when an interaction disconnects while still in IVR.

 4.0.106.453 4.0 Release
SiteId smallint False No

Site Identifier of site reporting data.

 4.0.106.453 4.0 Release
SubSiteId smallint False No

Not used in the current version. The purpose of this field is to divide use within a site, such as for multiple independent companies on one CIC system. Until CIC has such functionality, this field is zero and is reserved for future use.

 4.0.106.453 4.0 Release
dIntervalStart datetime False No

Starting time of the interval.

 4.0.106.453 4.0 Release
dIntervalStartGMT datetime False No

Starting time of the interval adjusted to GMT.

 4.0.106.453 4.0 Release
nDuration int False No

Duration of reporting interval in seconds starting from the dIntervalStart.

 4.0.106.453 4.0 Release
nEnteredFirst int False No

Number of interactions entering this level / path the first time.

 4.0.106.453 4.0 Release
nEnteredRepeat int False No

Number of interactions repeating an entry to this level / path.

 4.0.106.453 4.0 Release
nDurationFirst int False No

Seconds from entry until exit of level taking path for the first time.

 4.0.106.453 4.0 Release
nDurationRepeat int False No

Seconds from reentry until exit of level or taking path again.

 4.0.106.453 4.0 Release
nExitCode int False No

Code indicating the type of exit associated with the level. 0 = Not an abort, 1 = Abort. This might contain other values in the future as other exit types are added.

 4.0.106.453 4.0 Release
I3TimeStampGMT datetime False No

Timestamp value created at time of data creation used in automated data deletion process.

 4.0.106.453 4.0 Release

Constraints

Primary Key Name Type Column Name (sort order)
PK_IVRInterval Non-clustered IVRIntervalId (Ascending)
SiteId (Ascending)


Index Name Type Column Name (sort order)
cLevelName Non-clustered cLevelName (Ascending)
SiteId (Ascending)
SubSiteId (Ascending)
I3TimeStampGMT Clustered I3TimeStampGMT (Ascending)
SiteId (Ascending)
IEIntervalStart Non-clustered dIntervalStart (Ascending)
cLevelName (Ascending)
SiteId (Ascending)