Cisco Cisco IPCC Web Option Technical References

Page of 620
The Skill Group Explorer maintains the Skill_Target table when you create or delete agents,
skill groups, services, service arrays, or translation routes.
Related tables
 (via SkillTargetID)
 (via SkillTargetID)
 (via SkillTargetID)
 (via SkillTargetID)
 (via SkillTargetID)
 (via SkillTargetID)
Table 200: Indexes for Skill_Target Table
index_keys
index_description
index_name
SkillTargetID
clustered, unique, primary key
located on PRIMARY
XPKSkill_Target
Fields in Skill_Target Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
PK NOT NULL
DBINT
A unique identifier for the skill target.
SkillTargetID
NOT NULL
DBSMALLINT
Type of target:
SkillTargetType
• = Service
• = Skill Group
• = Agent
• = Translation Routes
• 5= Service Array
Termination_Call_Detail Table
This table is in the 
Central database only.
Contains information about how each call was handled at a peripheral.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
407
Chapter 2:  All Tables
Termination_Call_Detail Table