Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
NULL
VTELNO10
The extension number for the skill group (used
by the Definity ECS ACD).
by the Definity ECS ACD).
Extension
FK NOT NULL
DBINT
The Media Routing Domain associated with this
service.
service.
MRDomainID
AK-2, FK NOT
NULL
NULL
DBSMALLINT
Foreign key from the Peripheral table.
PeripheralID
NOT NULL
VNAME32
Service name as known at the peripheral.
PeripheralName
AK-2 NOT
NULL
NULL
DBINT
Service number as known at the peripheral. This
fi
fi
eld together with PeripheralID form an alternate
unique key.
PeripheralNumber
NOT NULL
DBSMALLINT
If this field is 0 for a service, the ICM software
assumes the default specified for the associated
peripheral.
assumes the default specified for the associated
peripheral.
PeripheralServiceLevelType
If the peripheral is not an Aspect ACD, the type
must be 4 (calculated by the peripheral)
must be 4 (calculated by the peripheral)
FK, IE-1 NULL
DBINT
Identifies an imported schedule associated with
the service.
the service.
ScheduleID
NOT NULL
DBINT
The service level threshold, in seconds, for the
ICM service level. If this field is negative, the
ICM service level. If this field is negative, the
ServiceLevelThreshold
value of the ServiceLevelThreshold field in the
Peripheral table is used.
Peripheral table is used.
NOT NULL
DBSMALLINT
For Non-IPCC Enterprise
, indicates how the
ICM software calculates the service level for the
service:
service:
ServiceLevelType
For IPCC Enterprise
the value of this field is
always 1 (ignore abandoned calls) for services
associated with CallManager peripherals. This
is because calls to a CallManager peripheral have
no service associated with them while they are
queued, and therefore calls abandoned while
queued cannot affect the computation of service
level for a CallManager service.
associated with CallManager peripherals. This
is because calls to a CallManager peripheral have
no service associated with them while they are
queued, and therefore calls abandoned while
queued cannot affect the computation of service
level for a CallManager service.
PK, FK NOT
NULL
NULL
DBINT
An identifier that is unique among all skill targets
in the enterprise.
in the enterprise.
SkillTargetID
NOT NULL
DBCHAR
Indicates if the record can by deleted by a user.
Default is Y.
Default is Y.
UserDeletable
Service_Array Table
This table is one of the
. For database rules click
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
281
Chapter 2: All Tables
Service_Array Table