Cisco Cisco IP Contact Center Release 4.6.1 Referencia técnica
(via SkillTargetID)
(via SkillTargetID)
(via SkillTargetID)
(via
SkillTargetID)
(via MRDomainID)
(via SkillTargetID)
maps to
Service_Array_Member.ServiceSkillTargetID)
Service_Array_Member.ServiceSkillTargetID)
(via ScheduleID)
SkillTargetID)
(via SkillTargetID)
SkillTargetID)
(ServiceSkillTargetID maps to
Service.SkillTargetID)
(via
SkillTargetID)
Table 185: Indexes for Service Table
index_keys
index_description
index_name
EnterpriseName
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Service
PeripheralID, PeripheralNumber
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK2Service
ScheduleID
nonclustered located on PRIMARY
XIE1Service
SkillTargetID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKService
Fields in Service Table:
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the
central database.
central database.
ChangeStamp
NULL
varchar(255)
Incremented when the record is changed in the
central database.
central database.
ConfigParam
NOT NULL
DBCHAR
Deleted Flag. Stored as a character:
Deleted
• Y = Yes
• N = No
NULL
DESCRIPTION
Additional information about the service.
Description
AK-1 NOT
NULL
NULL
VNAME32
An enterprise name for the service. This name
must be unique among all the services in the
enterprise.
must be unique among all the services in the
enterprise.
EnterpriseName
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
280
Chapter 2: - All Tables
Service Table