Technical References

Table 188: Indexes for Service_Array_Member Table
index_keysindex_descriptionindex_name
ServiceArraySkillTargetIDnonclustered located on PRIMARYXIF122Service_Array_Member
ServiceSkillTargetIDnonclustered located on PRIMARYXIF123Service_Array_Member
ServiceArraySkillTargetID,
ServiceSkillTargetID
clustered, unique, primary key
located on PRIMARY
XPKService_Array_Member
Service_Array_Member TableConstraints:
Field Name:Constraint:
ServiceArraySkillTargetIDPK
ServiceSkillTargetIDPK
ServiceArraySkillTargetIDFK
Fields in Service_Array_Member Table:
Keys and Null Option:Data Type:Description:Field Name:
PK, FK NOT NULLDBINT
Identifies the service array.
ServiceArraySkillTargetID
PK NOT NULLDBINT
Identifies a service that is a member of the service array.
ServiceSkillTargetID
Service_Five_Minute Table
This table is in the Skill Target category (page 456). To see database rules for these tables, click
here (page 510).
Central database only.
Contains statistics about each service during the most recent five-minute interval.
The ICM software generates Service_Five_Minute records for each service.
Use the Service Explorer tool to add, update, and delete Service_Array records.
Related table
Service (page 325) (via SkillTargetID)
Table 189: Indexes for Service_Five_Minute Table
index_keysindex_descriptionindex_name
RecoveryKeynonclustered, unique, unique key
located on PRIMARY
XAK1Service_Five_Minute
DateTime, SkillTargetID, TimeZoneclustered, unique, primary key
located on PRIMARY
XPKService_Five_Minute
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
330
Chapter 2: All Tables
Service_Five_Minute Table