Technical References

Keys and Null
Option:
Data Type:Description:Field Name:
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.
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
conguration applications but cannot be directly modied.
NOT NULLDBCHAR
Deleted Flag. Stored as a character:
Deleted
Y = Yes
N = No
NULLDESCRIPTION
Additional information about the group.
Description
AK-1 NOT NULLVNAME32
An enterprise name for the skill group. This name must be unique
among all skill groups in the enterprise.
EnterpriseName
NULLVTELNO10
The extension number for the service (used by Lucent DEFINITY
ECS).
Extension
NOT NULLDBCHAR
Indicates whether or not this is an 'ICM picks the agent (IPTA)' skill
group:
IPTA
Y = Yes, this is an IPTA skill group.
N = No, this is not an IPTA skill group.
FK NOT NULLDBINT
The Media Routing Domain with which this skill group is associated.
The default value is 1.
MRDomainID
AK-2, FK NOT
NULL
DBSMALLINT
Foreign key from Peripheral table.
PeripheralID
NOT NULLVNAME32
Skill group name as known by the peripheral.
PeripheralName
AK-2 NOT NULLDBINT
Skill group number as known by the peripheral.
PeripheralNumber
AK-2 NOT NULLDBSMALLINT
The routing priority of this group for the skill:
Priority
1 = primary
2 = secondary
3= tertiary; etc.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
366
Chapter 2: All Tables
Skill_Group Table