Cisco Cisco IP Contact Center Release 4.6.2 Technical References
2-260
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Skill_Target Table
Related tables:
Skill Group (via SkillTargetID)
Skill_Target Table
Establishes a unique identifier for every agent, skill group, service, service array, and translation route
in the enterprise.
in the enterprise.
The Skill Group Explorer maintains the Skill_Target table when you create or delete agents, skill groups,
services, service arrays, or translation routes.
services, service arrays, or translation routes.
Related tables:
Agent (via SkillTargetID)
Route (via SkillTargetID)
Service (via SkillTargetID)
Service Array (via SkillTargetID)
Skill Group (via SkillTargetID)
Translation Route (via SkillTargetID)
IcmAvailable
The number of agents belonging to this skill
group who are currently ICMAvailable with
respect to the MRD to which the skill group
belongs.
group who are currently ICMAvailable with
respect to the MRD to which the skill group
belongs.
int
NULL
ApplicationAvailable
The number of agents belonging to this skill
group who are currently ApplicationAvailable
with respect to the MRD to which the skill group
belongs.
group who are currently ApplicationAvailable
with respect to the MRD to which the skill group
belongs.
int
NULL
Table 2-178 Skill_Group_Real_Time Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option
Table 2-179 Skill_Target Table
Field Name
Description
Data Type
Keys and Null
Option
Option
SkillTargetID
A unique identifier for the skill target.
int
PK, NOT NULL
SkillTargetType
Type of target:
1 = Service
2 = Skill Group
3 = Agent
4 = Translation Routes
5 = Service Array
2 = Skill Group
3 = Agent
4 = Translation Routes
5 = Service Array
smallint
NOT NULL