Technical References

Related tables
Galaxy_Overflow Table (page
196) (via SkillTargetID)
Galaxy_Gate_Delayed_Call Table (page 193)
(via SkillTargetID)
Enterprise Service Member (page
175)(via SkillTargetID)
Route (page 277) (via
SkillTargetID)
Peripheral (page 250) (via PeripheralID)Media Routing Domain (page 234)
(via MRDomainID)
Service Five Minute (page 330)
(via SkillTargetID)
Service Array Member (page 329) (SkillTargetID
maps to
Service_Array_Member.ServiceSkillTargetID)
Schedule (page 305) (via ScheduleID)
Service Real Time (page 347) (via
SkillTargetID)
Service Member (page 347) (via SkillTargetID)Service Half Hour (page 334) (via
SkillTargetID)
Termination Call Detail (page
407)(ServiceSkillTargetID maps to
Service.SkillTargetID)
Skill Target (page 406) (via
SkillTargetID)
Table 186: Indexes for Service Table
index_keysindex_descriptionindex_name
EnterpriseNamenonclustered, unique, unique key
located on PRIMARY
XAK1Service
PeripheralID, PeripheralNumbernonclustered, unique, unique key
located on PRIMARY
XAK2Service
ScheduleIDnonclustered located on PRIMARYXIE1Service
SkillTargetIDclustered, unique, primary key
located on PRIMARY
XPKService
Fields in Service Table:
Keys and Null
Option:
Data Type:Description:Field Name:
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NULLvarchar(255)
Incremented when the record is changed in the central database.
ConfigParam
NOT NULLDBCHAR
Deleted Flag. Stored as a character:
Deleted
• Y = Yes
• N = No
NULLDESCRIPTION
Additional information about the service.
Description
AK-1 NOT NULLVNAME32
An enterprise name for the service. This name must be unique
among all the services in the enterprise.
EnterpriseName
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
326
Chapter 2: All Tables
Service Table