Interval Statistics for Lines
This table logs interval statistics for individual lines you have configured in CIC.
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) |