Cisco Cisco IPCC Web Option Technical References

Page of 620
Keys and
Null
Option:
Data Type:
Description:
Field Name:
NULL
DBINT
Number of calls transferred out of the service during the rolling
five-minute interval.
TransferOutCallsTo5
NULL
DBINT
Number of calls transferred out of the service since midnight.
TransferOutCallsToday
Shift Table
Provides the name, start time, and end time of the current shift.
Table 194: Indexes for Shift Table
index_keys
index_description
index_name
ShiftName
nonclustered, unique, primary key
located on PRIMARY
XPKShift
Fields in Shift Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
PK NOT NULL
VNAME32
Name of the Shift scheduled.
ShiftName
NOT NULL
SMALLDATETIME
Shift start time.
StartTime
NOT NULL
SMALLDATETIME
Shift end time.
StopTime
Skill_Group Table
To see database rules for these tables, click
Each row describes a skill group associated with a peripheral. A skill group is a collection of
agents who have common skills.
Use the Skill Group Explorer tool to add, update, and delete Skill_Group records.
Related tables
 (via SkillTargetID)
 (via SkillTargetID)
 (via PeripheralID)
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
364
Chapter 2:  All Tables
Shift Table