Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 557
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.
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)
Table 187: Indexes for Service_Array_Member Table
index_keys
index_description
index_name
ServiceArraySkillTargetID
nonclustered located on PRIMARY
XIF122Service_Array_Member
ServiceSkillTargetID
nonclustered located on PRIMARY
XIF123Service_Array_Member
ServiceArraySkillTargetID,
ServiceSkillTargetID
clustered, unique, primary key
located on PRIMARY
XPKService_Array_Member
Service_Array_Member Table Constraints:
Field Name:
Constraint:
ServiceArraySkillTargetID
PK
ServiceSkillTargetID
PK
ServiceArraySkillTargetID
FK
Fields in Service_Array_Member Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
PK, FK NOT NULL
DBINT
Identifies the service array.
ServiceArraySkillTargetID
PK NOT NULL
DBINT
Identifies a service that is a member of the
service array.
ServiceSkillTargetID
Service_Five_Minute Table
To see database rules for these tables, click
Central database only.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
283
Chapter 2:  All Tables
Service_Array_Member Table