CIC generates Interval line and line group statistics for each line and reporting line group configured and stores the statistics in the IlineStats table and the IlineGroupStats table.
The source of this data is Interval generated summary information about activity on lines and line groups.
The types of information in the Interval Line and Line Groups Data is the length of interval, the sum of seconds the lines were active, the sum of seconds all lines were busy, the number of interactions, the total time for all traffic and outbound traffic (subtract outbound from all to get inbound), and the number of outbound interactions that were blocked from making a interaction.
The Line Group report types use line and line group information for both reports and charts.
This table logs interval statistics for individual lines you have configured in CIC.
| Log Identifier | Log Name | Table Name |
|---|---|---|
|
82 |
Interval Line Statistics |
ILineStats |
| 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 |
|---|---|---|---|---|---|---|---|---|---|
| LineId | nvarchar (50) | False | Depends on customer usage | Line name or identifier as configured in CIC. |
4.0.106.453 | 4.0 Release | |||
| dIntervalStart | datetime | False | No | Starting date/time of the interval. The interval is a server parameter value setup in IA. The default interval is 1800 seconds (30 minutes) and is always relative to the hour. In some cases, the interval start times might not be exactly on the hour. This is usually due to stopping and starting CIC. These odd interval start times might be visible in the reports. |
4.0.106.453 | 4.0 Release | |||
| nDuration | smallint | False | No | Duration in seconds of the interval. If dIntervalStart is an odd start time, the duration of the interval will have a nonstandard length. |
4.0.106.453 | 4.0 Release | |||
| nEntered | int | False | No | Number of interactions that entered or appeared on this line. |
4.0.106.453 | 4.0 Release | |||
| tSeized | int | False | No | Sum of time that the line was busy or seized for the interval. |
4.0.106.453 | 4.0 Release | |||
| nEnteredOutbound | int | False | No | Number of interactions that entered the line for outbound use. |
4.0.106.453 | 4.0 Release | |||
| nOutboundBlocked | int | False | No |
Number of interactions that were blocked because the line was busy when they tried to enter the line for outbound use. Note: nOutboundBlocked is not currently implemented and the value of zero (0) is displayed for this column. |
4.0.106.453 | 4.0 Release | |||
| tResourceAvailable | int | False | No | Sum of time the line was available for service. The system may take a line out of service because of detected signaling problems. |
4.0.106.453 | 4.0 Release | |||
| I3TimeStampGMT | datetime | False | No | System supplied date time when the row was sent to the IC Logging server for insertion into the table. |
4.0.106.453 | 4.0 Release | |||
| SiteId | smallint | False | No | Site identifier of the source of this interaction row. Used in multi-site rollup to distinguish the origin of 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 |
| 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 |
|---|---|---|---|---|---|---|---|---|---|
| LineId | nvarchar2 (50) | False | Depends on customer usage | Line name or identifier as configured in CIC. |
4.0.106.453 | 4.0 Release | |||
| dIntervalStart | date | False | No | Starting date/time of the interval. The interval is a server parameter value setup in IA. The default interval is 1800 seconds (30 minutes) and is always relative to the hour. In some cases, the interval start times might not be exactly on the hour. This is usually due to stopping and starting CIC. These odd interval start times might be visible in the reports. |
4.0.106.453 | 4.0 Release | |||
| nDuration | number | False | No | Duration in seconds of the interval. If dIntervalStart is an odd start time, the duration of the interval will have a nonstandard length. |
4.0.106.453 | 4.0 Release | |||
| nEntered | number | False | No | Number of interactions that entered or appeared on this line. |
4.0.106.453 | 4.0 Release | |||
| tSeized | number | False | No | Sum of time that the line was busy or seized for the interval. |
4.0.106.453 | 4.0 Release | |||
| nEnteredOutbound | number | False | No | Number of interactions that entered the line for outbound use. |
4.0.106.453 | 4.0 Release | |||
| nOutboundBlocked | number | False | No |
Number of interactions that were blocked because the line was busy when they tried to enter the line for outbound use. Note: nOutboundBlocked is not currently implemented and the value of zero (0) is displayed for this column. |
4.0.106.453 | 4.0 Release | |||
| tResourceAvailable | number | False | No | Sum of time the line was available for service. The system may take a line out of service because of detected signaling problems. |
4.0.106.453 | 4.0 Release | |||
| I3TimeStampGMT | date | False | No | System supplied date time when the row was sent to the IC Logging server for insertion into the table. |
4.0.106.453 | 4.0 Release | |||
| SiteId | number | False | No | Site identifier of the source of this interaction row. Used in multi-site rollup to distinguish the origin of data. |
4.0.106.453 | 4.0 Release | |||
| SubSiteId | number | 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 |
| Primary Key Name | Type | Column Name (sort order) |
|---|---|---|
| PK_ILineStats | Non-clustered | dIntervalStart (Ascending) SiteId (Ascending) LineId (Ascending) I3TimeStampGMT (Ascending) |
| Primary Key Name | Column Name (sort order) |
|---|---|
| PK_ILineStats | dIntervalStart (Ascending) SiteId (Ascending) LineId (Ascending) I3TimeStampGMT (Ascending) |
| Index Name | Type | Column Name (sort order) |
|---|---|---|
| I3TimeStampGMT | Clustered | I3TimeStampGMT (Ascending) SiteId (Ascending) |
| Index Name | Column Name (sort order) |
|---|---|
| i3timestampgmt82 | I3TimeStampGMT (Ascending) SiteId (Ascending) |
This table logs interval statistics for line groups you have configured for reporting in CIC. Reporting line groups are line groups that have their Reporting attribute activated. This attribute is configured in Interaction Administrator. CIC does not create line groups by default. The reporting line groups must be created before CIC creates any meaningful data for the line group reports.
Note that the line group information is summary data about the lines in the group collected during the interval. Because of this, it is possible that someone could have added or removed lines from the configuration during the interval. This does not cause any computation problems, because CIC does not record the number of lines, but instead records the total number of seconds the lines were in the configuration. If you divide this total by the seconds in the duration, you compute a fractional number of lines for this interval.
| Log Identifier | Log Name | Table Name |
|---|---|---|
|
81 |
Interval Line Group Statistics |
ILineGroupStats |
| 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 |
|---|---|---|---|---|---|---|---|---|---|
| GroupId | nvarchar (50) | False | Depends on customer usage | Group Identifier as configured in CIC. The line group must have the ReportFlag set true (in IA) for this data to be generated. |
4.0.106.453 | 4.0 Release | |||
| dIntervalStart | datetime | False | No | Starting date/time of the interval. The interval is a server parameter value setup in IA. The default interval is 1800 seconds (30 minutes) and is always relative to the hour. In some cases, the interval start times might not be exactly on the hour. This is usually due to stopping and starting CIC. These odd interval start times might be visible in the reports. |
4.0.106.453 | 4.0 Release | |||
| nDuration | smallint | False | No | Duration in seconds of the interval. If dIntervalStart is an odd start time, the duration of the interval will have a non-standard length. |
4.0.106.453 | 4.0 Release | |||
| nEntered | int | False | No | Number of interactions that entered or appeared on lines in this group. |
4.0.106.453 | 4.0 Release | |||
| mEntered | int | False | No | The maximum number of concurrent calls that were active on the line group within the interval. |
4.0.106.453 | 4.0 Release | |||
| tActiveLines | int | False | No | The Sum of time, in seconds, each line in the group was active during this interval. For most intervals this would be N (for each line) * nDuration. Since lines might be activated or deactivated during the interval, this number might contain a portion of time that a line was active. tActiveLines / nDuration equals the average number of active lines that were in this line group for the interval. If there were no changes to the line group in the interval, the number will be whole. |
4.0.106.453 | 4.0 Release | |||
| tAllBusy | int | False | No | Sum of time, in seconds, ALL lines in this group were busy or seized during this interval. |
4.0.106.453 | 4.0 Release | |||
| tSeized | int | False | No | Sum of time, in seconds, lines in this group were busy or seized for interval. |
4.0.106.453 | 4.0 Release | |||
| nEnteredOutbound | int | False | No | Number of interactions that entered the line group for outbound use. |
4.0.106.453 | 4.0 Release | |||
| nOutboundBlocked | int | False | No |
Number of interactions that tried to enter the line group for outbound use, but were blocked because of ALL lines being busy. Note: nOutboundBlocked is not currently implemented and the value of zero (0) is displayed for this column. |
4.0.106.453 | 4.0 Release | |||
| tResourceAvailable | int | False | No | Sum of time, in seconds, lines active in this group were available for service. This should not exceed tActiveLines, but can be less if the system takes a line out of service because of detected signaling problems. |
4.0.106.453 | 4.0 Release | |||
| I3TimeStampGMT | datetime | False | No | System supplied date time when the row was sent to the IC Logging server for insertion into the table. |
4.0.106.453 | 4.0 Release | |||
| SiteId | smallint | False | No | Site identifier of the source of this interaction row. Used in multi-site rollup to distinguish the origin of 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 |
| 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 |
|---|---|---|---|---|---|---|---|---|---|
| GroupId | nvarchar2 (50) | False | Depends on customer usage | Group Identifier as configured in CIC. The line group must have the ReportFlag set true (in IA) for this data to be generated. |
4.0.106.453 | 4.0 Release | |||
| dIntervalStart | date | False | No | Starting date/time of the interval. The interval is a server parameter value setup in IA. The default interval is 1800 seconds (30 minutes) and is always relative to the hour. In some cases, the interval start times might not be exactly on the hour. This is usually due to stopping and starting CIC. These odd interval start times might be visible in the reports. |
4.0.106.453 | 4.0 Release | |||
| nDuration | number | False | No | Duration in seconds of the interval. If dIntervalStart is an odd start time, the duration of the interval will have a non-standard length. |
4.0.106.453 | 4.0 Release | |||
| nEntered | number | False | No | Number of interactions that entered or appeared on lines in this group. |
4.0.106.453 | 4.0 Release | |||
| mEntered | number | False | No | The maximum number of concurrent calls that were active on the line group within the interval. |
4.0.106.453 | 4.0 Release | |||
| tActiveLines | number | False | No | The Sum of time, in seconds, each line in the group was active during this interval. For most intervals this would be N (for each line) * nDuration. Since lines might be activated or deactivated during the interval, this number might contain a portion of time that a line was active. tActiveLines / nDuration equals the average number of active lines that were in this line group for the interval. If there were no changes to the line group in the interval, the number will be whole. |
4.0.106.453 | 4.0 Release | |||
| tAllBusy | number | False | No | Sum of time, in seconds, ALL lines in this group were busy or seized during this interval. |
4.0.106.453 | 4.0 Release | |||
| tSeized | number | False | No | Sum of time, in seconds, lines in this group were busy or seized for interval. |
4.0.106.453 | 4.0 Release | |||
| nEnteredOutbound | number | False | No | Number of interactions that entered the line group for outbound use. |
4.0.106.453 | 4.0 Release | |||
| nOutboundBlocked | number | False | No |
Number of interactions that tried to enter the line group for outbound use, but were blocked because of ALL lines being busy. Note: nOutboundBlocked is not currently implemented and the value of zero (0) is displayed for this column. |
4.0.106.453 | 4.0 Release | |||
| tResourceAvailable | number | False | No | Sum of time, in seconds, lines active in this group were available for service. This should not exceed tActiveLines, but can be less if the system takes a line out of service because of detected signaling problems. |
4.0.106.453 | 4.0 Release | |||
| I3TimeStampGMT | date | False | No | System supplied date time when the row was sent to the IC Logging server for insertion into the table. |
4.0.106.453 | 4.0 Release | |||
| SiteId | number | False | No | Site identifier of the source of this interaction row. Used in multi-site rollup to distinguish the origin of data. |
4.0.106.453 | 4.0 Release | |||
| SubSiteId | number | 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 |
| Primary Key Name | Type | Column Name (sort order) |
|---|---|---|
| PK_ILineGroupStats | Non-clustered | dIntervalStart (Ascending) SiteId (Ascending) GroupId (Ascending) I3TimeStampGMT (Ascending) nDuration (Ascending) |
| Primary Key Name | Column Name (sort order) |
|---|---|
| PK_ILineGroupStats | dIntervalStart (Ascending) SiteId (Ascending) GroupId (Ascending) I3TimeStampGMT (Ascending) nDuration (Ascending) |
| Index Name | Type | Column Name (sort order) |
|---|---|---|
| I3TimeStampGMT | Clustered | I3TimeStampGMT (Ascending) SiteId (Ascending) |
| Index Name | Column Name (sort order) |
|---|---|
| i3timestampgmt81 | I3TimeStampGMT (Ascending) SiteId (Ascending) |