Cisco Cisco IP Contact Center Release 4.6.2 Technical References
2-335
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Service_Real_Time Table
Related tables:
(SkillGroupSkillTargetID maps to Skill_Group.SkillTargetID)
Service_Real_Time Table
Local database only.
Contains real time information about each service.
The ICM software automatically generates a Service_Real_Time record for each service.
Table 2-350 Service_Member Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
Priority
The priority level of the specified service for the
specified skill group:
specified skill group:
1 = Primary
2 = Secondary
2 = Secondary
Any number of skill entries can be of any
priority—not all need to be entered.
priority—not all need to be entered.
DBSMALLINT
NOT NULL
ServiceSkillTargetID
SkillTargetID of the service.
DBINT
PK, FK
NOT NULL
SkillGroupSkillTargetID
SkillTargetID of the skill group that is associated
with the service.
with the service.
DBINT
PK, FK
NOT NULL
Table 2-351 Service_Real_Time Table Constraints
Constraint
Field Name(s)
PK
SkillTargetID
FK
SkillTargetID
Table 2-352 Service_Real_Time Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
AgentsTalking
Number of service agents currently in the talking
state.
state.
DBINT
NULL
AnswerWaitTimeHalf
Sum of answer wait time in seconds for all
incoming calls to the service during the current
half-hour interval.
incoming calls to the service during the current
half-hour interval.
DBINT
NULL