Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-203
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Service_Array Table
Service Five Minute (via SkillTargetID)
Service Half Hour (via SkillTargetID)
Service Member (via SkillTargetID)
Service Real Time (via SkillTargetID)
Skill Target (via SkillTargetID)
Service_Array Table
A service array is a collection of service which might be associated with different peripherals, but are
all associated with the same Peripheral Gateway (PG). You can route calls to a service array and let the
PG choose among the member services.
all associated with the same Peripheral Gateway (PG). You can route calls to a service array and let the
PG choose among the member services.
Use the Service Explorer tool to add, update, and delete Service_Array records.
Related tables:
Schedule (via ScheduleID)
Service Array Member (via SkillTargetID)
Logical Interface Controller (via LogicalControllerID)
Table 2-167 Service_Array Table
Field Name
Description
Data Type
Keys and Null
Option
Option
SkillTargetID
An identifier that is unique among all skill targets in the
enterprise.
enterprise.
int
PK, FK, NOT
NULL
NULL
EnterpriseName
An enterprise name for the service array. This name must
be unique among all service arrays in the enterprise.
be unique among all service arrays in the enterprise.
varchar(32)
AK1, NOT
NULL
NULL
Description
Additional information about the service array.
varchar(255)
NULL
ScheduleID
Identifies a schedule associated with the service array.
int
FK, NULL
LogicalControllerID
Identifies the Peripheral Gateway associated with the
service array.
service array.
smallint
FK, NOT NULL
ChangeStamp
Incremented when the record is changed in the central
database.
database.
int
NOT NULL