Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Keys
and Null
Option:
and Null
Option:
Data Type:
Description:
Field Name:
PK, FK
NOT
NULL
NOT
NULL
DBINT
Foreign key from Service table.
SkillTargetID
NULL
DBINT
Total talk time in seconds for calls to the service ending
during the current half-hour interval.
during the current half-hour interval.
TalkTimeHalf
NULL
DBINT
Total talk time in seconds for calls to the service ending
during the rolling five-minute interval.
during the rolling five-minute interval.
TalkTimeTo5
NULL
DBINT
Total talk time in seconds for calls to the service ending
since midnight.
since midnight.
TalkTimeToday
NULL
DBINT
Number of calls transferred into the service during the
current half-hour interval.
current half-hour interval.
TransferInCallsHalf
NULL
DBINT
Number of calls transferred into the service during the
rolling five-minute interval.
rolling five-minute interval.
TransferInCallsTo5
NULL
DBINT
Number of calls transferred into the service since
midnight.
midnight.
TransferInCallsToday
NULL
DBINT
Number of calls transferred out of the service during
the current half-hour interval.
the current half-hour interval.
TransferOutCallsHalf
NULL
DBINT
Number of calls transferred out of the service during
the rolling five-minute interval.
the rolling five-minute interval.
TransferOutCallsTo5
NULL
DBINT
Number of calls transferred out of the service since
midnight.
midnight.
TransferOutCallsToday
Shift Table
Provides the name, start time, and end time of the current shift.
Table 193: Indexes for Shift Table
index_keys
index_description
index_name
ShiftName
nonclustered, unique, primary key
located on PRIMARY
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
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
313
Chapter 2: All Tables
Shift Table