Cisco Cisco IP Contact Center Release 4.6.2 Technical References

Page of 548
   
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. 
Note
This field may also be used to encode 
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.
DBINT
NULL
TalkTimeTo5
Total talk time in seconds for calls to the service 
ending during the current five-minute interval.
DBINT
NULL
TalkTimeToday
Total talk time in seconds for calls to the service 
ending since midnight.
DBINT
NULL
TransferInCallsHalf
Number of calls transferred into the service during 
the current half-hour interval.
DBINT
NULL
TransferInCallsTo5
Number of calls transferred into the service during 
the current five-minute interval.
DBINT
NULL
TransferInCallsToday
Number of calls transferred into the service since 
midnight.
DBINT
NULL
TransferOutCallsHalf
Number of calls transferred out of the service 
during the current half-hour interval.
DBINT
NULL
TransferOutCallsTo5
Number of calls transferred out of the service 
during the current five-minute interval.
DBINT
NULL
TransferOutCallsToday
Number of calls transferred out of the service 
since midnight.
DBINT
NULL
Table 2-352 Service_Real_Time Table (continued)
Field Name
Description
Data Type
Keys and 
Null Option