Cisco Cisco Unified Intelligent Contact Management Software Technical References
Table 187: Indexes for Service_Array Table
index_keys
index_description
index_name
EnterpriseName
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Service_Array
SkillTargetID
nonclustered located on PRIMARY
XIF110Service_Array
LogicalControllerID
nonclustered located on PRIMARY
XIF120Service_Array
ScheduleID
nonclustered located on PRIMARY
XIF121Service_Array
SkillTargetID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKService_Array
Fields in Service_Array Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NULL
DESCRIPTION
Additional information about the service array.
Description
AK-1 NOT NULL
VNAME32
An enterprise name for the service array. This name must be
unique among all service arrays in the enterprise.
unique among all service arrays in the enterprise.
EnterpriseName
FK NOT NULL
DBSMALLINT
Identifies the Peripheral Gateway associated with the service
array.
array.
LogicalControllerID
FK NULL
DBINT
Identifies a schedule associated with the service array.
ScheduleID
PK NOT NULL
DBINT
An identifier that is unique among all skill targets in the enterprise.
SkillTargetID
Service_Array_Member Table
This table is one of the
. For database rules click
It maps individual services to a service array. The member services in a service array must all
be associated with the same Peripheral Gateway (PG), but may be associated with different
peripherals.
be associated with the same Peripheral Gateway (PG), but may be associated with different
peripherals.
Use the Service Explorer tool to add and delete Service_Array_Member records.
Use the Service Explorer tool to add, update, and delete Service_Array records.
Related tables
(ServiceArraySkillTargetID maps to Service_Array.SkillTargetID)
(ServiceSkillTargetID maps to Service.SkillTargetID)
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
329
Chapter 2: All Tables
Service_Array_Member Table