Interval Statistics for Line Groups
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.
| 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) |