Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco IPCC Web Option
  5. Technical References

Cisco Cisco IPCC Web Option Technical References

Download
Page of 548
   
2-314
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2      Table Details
Service Table
Service Table
Each row describes a service available at a peripheral.
Use the Service Explorer tool to add, update, and delete Service records.
Table 2-337 Service Table Constraints
Constraint
Field Name(s)
PK
SkillTargetID
AK-1
EnterpriseName
AK-2
PeripheralID
PeripheralNumber
FK
MRDomainID
PeripheralID
ScheduleID
SkillTargetID
IE-1
ScheduleID
Table 2-338 Service Table
Field Name
Description
Data Type
Keys and 
Null Option
ChangeStamp
Incremented when the record is changed in the 
central database.
CHANGESTAMP
NOT NULL
ConfigParam
A string of parameters the ICM software sends to 
the peripheral to initialize the service.
varchar(255)
NULL
Deleted
Deleted Flag. Stored as a character:
Y = Yes
N = No
DBCHAR
NOT NULL
Description
Additional information about the service.
DESCRIPTION
NULL
EnterpriseName
An enterprise name for the service. This name 
must be unique among all the services in the 
enterprise.
VNAME32
AK-1
NOT NULL
Extension
The extension number for the skill group (used by 
the Definity ECS ACD).
VTELNO10
NULL
MRDomainID
The Media Routing Domain associated with this 
service.
DBINT
FK 
NOT NULL
PeripheralID
Foreign key from the Peripheral table.
DBSMALLINT
AK-2, FK
NOT NULL
PeripheralName
Service name as known at the peripheral.
VNAME32
NOT NULL
PeripheralNumber
Service number as known at the peripheral. This 
field together with PeripheralID form an alternate 
unique key.
DBINT
AK-2
NOT NULL