Technical References

Keys and
Null
Option:
Data Type:Description:Field Name:
NULLDBINT
Number of calls transferred out of the service during the rolling
five-minute interval.
TransferOutCallsTo5
NULLDBINT
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_keysindex_descriptionindex_name
ShiftNamenonclustered, unique, primary key
located on PRIMARY
XPKShift
Fields in Shift Table:
Keys and Null Option:Data Type:Description:Field Name:
PK NOT NULLVNAME32
Name of the Shift scheduled.
ShiftName
NOT NULLSMALLDATETIME
Shift start time.
StartTime
NOT NULLSMALLDATETIME
Shift end time.
StopTime
Skill_Group Table
This table is in the Skill Target category (page 456). To see database rules for these tables, click
here (page 510).
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
•
Dialer Detail (page 163) (via SkillTargetID)
•
Enterprise Skill Group Member (page 176) (via SkillTargetID)
•
Media Routing Domain (page 234) (via MRDomainID)
•
Peripheral (page 250) (via PeripheralID)
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
364
Chapter 2: All Tables
Shift Table