Technical References

Table 187: Indexes for Service_Array Table
index_keysindex_descriptionindex_name
EnterpriseNamenonclustered, unique, unique key
located on PRIMARY
XAK1Service_Array
SkillTargetIDnonclustered located on PRIMARYXIF110Service_Array
LogicalControllerIDnonclustered located on PRIMARYXIF120Service_Array
ScheduleIDnonclustered located on PRIMARYXIF121Service_Array
SkillTargetIDclustered, unique, primary key
located on PRIMARY
XPKService_Array
Fields in Service_Array Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NULLDESCRIPTION
Additional information about the service array.
Description
AK-1 NOT NULLVNAME32
An enterprise name for the service array. This name must be
unique among all service arrays in the enterprise.
EnterpriseName
FK NOT NULLDBSMALLINT
Identifies the Peripheral Gateway associated with the service
array.
LogicalControllerID
FK NULLDBINT
Identifies a schedule associated with the service array.
ScheduleID
PK NOT NULLDBINT
An identifier that is unique among all skill targets in the enterprise.
SkillTargetID
Service_Array_Member Table
This table is one of the Enterprise tables (page 443). For database rules click here (page 506).
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.
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
Service Array (page 328) (ServiceArraySkillTargetID maps to Service_Array.SkillTargetID)
Service (page 325) (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