Cisco Cisco IP Contact Center Release 4.6.2 Technical References
2-352
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Service_Real_Time Table
Related tables:
(via SkillTargetID)
ServiceModeIndicator
The current mode of the service:
1 = Day service
2 = Night service
3 = Closed with answer
4 = Closed, no answer
5 = Transition
6 = Open
13 = Pilot Status Other.
2 = Night service
3 = Closed with answer
4 = Closed, no answer
5 = Transition
6 = Open
13 = Pilot Status Other.
Note
This field may also be used to encode
overflow information for a Galaxy ACD.
overflow information for a Galaxy ACD.
DBINT
NULL
SkillTargetID
Foreign key from Service table.
DBINT
PK, FK
NOT NULL
TalkTimeHalf
Total talk time in seconds for calls to the service
ending during the current half-hour interval.
ending during the current half-hour interval.
DBINT
NULL
TalkTimeTo5
Total talk time in seconds for calls to the service
ending during the current five-minute interval.
ending during the current five-minute interval.
DBINT
NULL
TalkTimeToday
Total talk time in seconds for calls to the service
ending since midnight.
ending since midnight.
DBINT
NULL
TransferInCallsHalf
Number of calls transferred into the service during
the current half-hour interval.
the current half-hour interval.
DBINT
NULL
TransferInCallsTo5
Number of calls transferred into the service during
the current five-minute interval.
the current five-minute interval.
DBINT
NULL
TransferInCallsToday
Number of calls transferred into the service since
midnight.
midnight.
DBINT
NULL
TransferOutCallsHalf
Number of calls transferred out of the service
during the current half-hour interval.
during the current half-hour interval.
DBINT
NULL
TransferOutCallsTo5
Number of calls transferred out of the service
during the current five-minute interval.
during the current five-minute interval.
DBINT
NULL
TransferOutCallsToday
Number of calls transferred out of the service
since midnight.
since midnight.
DBINT
NULL
Table 2-352 Service_Real_Time Table (continued)
Field Name
Description
Data Type
Keys and
Null Option
Null Option