Cisco Cisco IP Contact Center Release 4.6.1 Referências técnicas
(via SkillTargetID)
(via SkillTargetID)
(via SkillTargetID)
Table 199: Indexes for Skill_Target Table
index_keys
index_description
index_name
SkillTargetID
clustered, unique, primary key
located on PRIMARY
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
• 1 = Service
• 2 = Skill Group
• 3 = Agent
• 4 = Translation Routes
• 5= Service Array
Termination_Call_Detail Table
Central database only.
Contains information about how each call was handled at a peripheral.
The ICM software generates a Termination_Call_Detail record for each call that arrives at the
peripheral.
peripheral.
This table can become very large. Running custom reporting queries against it while it is on the
HDS can degrade performance. To optimize performance, extract the data from the HDS into
your own custom database on a separate server (one that is not used for other ICM/IPCC
components). Use only DBDateTime (date and time of the record that was written to the HDS
database) to perform the extraction. The table on the custom database can be indexed according
to the custom reporting needs.
HDS can degrade performance. To optimize performance, extract the data from the HDS into
your own custom database on a separate server (one that is not used for other ICM/IPCC
components). Use only DBDateTime (date and time of the record that was written to the HDS
database) to perform the extraction. The table on the custom database can be indexed according
to the custom reporting needs.
Related Tables
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
344
Chapter 2: - All Tables
Termination_Call_Detail Table