Cisco Cisco IP Contact Center Release 4.6.2 Technical References
2-355
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Skill_Group Table
DefaultEntry
Normal entries are 0 (zero). Any records with
DefaultEntry value > (greater than) 0 will be
considered a default skill group for configuration
purposes. Records having a DefaultEntry value of
1 are used by OPC as the default target skill group.
DefaultEntry value > (greater than) 0 will be
considered a default skill group for configuration
purposes. Records having a DefaultEntry value of
1 are used by OPC as the default target skill group.
Where only a base default is created, it has a
DefaultEntry value of 1. If sub-skill group records
are created, the primary sub-group has a
DefaultEntry value of 1, while the others have a
DefaultEntry value of 2.
DefaultEntry value of 1. If sub-skill group records
are created, the primary sub-group has a
DefaultEntry value of 1, while the others have a
DefaultEntry value of 2.
Note
An automatic DefaultEntry is created with
each possible combination of Peripheral
and MRDomain (PeripheralID and
MRDOmainID) in the system. These
entries are visible to configuration
applications but cannot be directly
modified.
each possible combination of Peripheral
and MRDomain (PeripheralID and
MRDOmainID) in the system. These
entries are visible to configuration
applications but cannot be directly
modified.
DBINT
NOT NULL
Deleted
Deleted Flag. Stored as a character:
Y = Yes
N = No
N = No
DBCHAR
NOT NULL
Description
Additional information about the group.
DESCRIPTION
NULL
EnterpriseName
An enterprise name for the skill group. This name
must be unique among all skill groups in the
enterprise.
must be unique among all skill groups in the
enterprise.
VNAME32
AK-1
NOT NULL
Extension
The extension number for the service (used by
Lucent DEFINITY ECS).
Lucent DEFINITY ECS).
VTELNO10
NULL
IPTA
Indicates whether or not this is an 'ICM picks the
agent (IPTA)' skill group:
agent (IPTA)' skill group:
Y = Yes, this is an IPTA skill group.
N = No, this is not an IPTA skill group.
N = No, this is not an IPTA skill group.
DBCHAR
NOT NULL
MRDomainID
The Media Routing Domain with which this skill
group is associated. The default value is 1.
group is associated. The default value is 1.
DBINT
FK
NOT NULL
PeripheralID
Foreign key from Peripheral table.
DBSMALLINT
AK-2, FK
NOT NULL
PeripheralName
Skill group name as known by the peripheral.
VNAME32
NOT NULL
PeripheralNumber
Skill group number as known by the peripheral.
DBINT
AK-2
NOT NULL
Table 2-356 Skill_Group Table (continued)
Field Name
Description
Data Type
Keys and
Null Option
Null Option