Technical References
•
Schedule (page 305) (via ScheduleID)
•
Service Array (page 328) (via SkillTargetID)
•
Service Member (page 347) (via SkillTargetID)
•
Skill Group Five Minute (page 368) (via SkillTargetID)
•
Skill Group Half Hour (page 371) (via SkillTargetID)
•
Skill Group Member (page 392) (via SkillTargetID)
•
Skill Group Real Time (page 392) (via SkillTargetID)
•
Skill Target (page 406) (via SkillTargetID)
•
Termination Call Detail (page 407)(SkillGroupSkillTargetID maps to
Skill_Group.SkillTargetID)
Table 195: Indexes for Skill_Group Table
index_keysindex_descriptionindex_name
EnterpriseNamenonclustered, unique, unique key
located on PRIMARY
XAK1Skill_Group
PeripheralID, PeripheralNumber, Prioritynonclustered, unique, unique key
located on PRIMARY
XAK2Skill_Group
ScheduleIDnonclustered located on PRIMARYXIE1Skill_Group
BaseSkillTargetIDnonclustered located on PRIMARYXIE2Skill_Group
SkillTargetIDclustered, unique, primary key
located on PRIMARY
XPKSkill_Group
Fields in Skill_Group Table:
Keys and Null
Option:
Data Type:Description:Field Name:
NOT NULLDBSMALLINT
Number of seconds before an agent becomes available after a call
terminates. If this value is 0xFFFF, then the default value from the
Peripheral record is used.
AvailableHoldoffDelay
FK, IE-2 NULLDBINT
If Priority is not 0, indicates the base group for the skill. If this record
is for the base group, Priority is 0 and this field is NULL.
BaseSkillTargetID
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NULLvarchar(255)
A string of parameters the ICM software sends to the peripheral to
initialize the skill group.
ConfigParam
NOT NULLDBINT
Normal entries are 0 (zero). Any records with DefaultEntry value >
(greater than) 0 will be considered a default skill group for
DefaultEntry
configuration purposes. Records having a DefaultEntry value of 1
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
365
Chapter 2: All Tables
Skill_Group Table