Cisco Cisco IP Contact Center Release 4.6.2 Technical References

Page of 548
   
2-224
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2      Table Details
Peripheral Table
Peripheral Table
Each row corresponds to an ACD or PBX at a call center.
Use the PG Explorer to add, update, and delete Peripheral records.
Table 2-238 Peripheral Table Constraints
Constraint
Field Name(s)
PK
PeripheralID
AK-1
EnterpriseName
FK
AgentDeskSettingsID
LogicalControllerID
NetworkTargetID
IE-1
PeripheralName
IE-2
LogicalControllerID
IE-3
AgentDeskSettingsID
Table 2-239 Peripheral Table
Field Name
Description
Data Type
Keys and 
Null Option
AbandonedCallWaitTime
Minimum time in seconds an incoming call must 
be queued before being considered an abandoned 
call if the caller hangs up.
DBSMALLINT
NOT NULL
AgentAutoConfig
Specifies whether agent auto- configuration is 
enabled for the peripheral. Stored as a character:
Y = Yes
N = No
DBCHAR
NULL
AgentDeskSettingsID
Optionally, indicates an Agent Desk Settings 
record associated with the peripheral.
DBINT
FK, IE-3
NULL
AgentEventDetail
Specifies whether or not Agent  Event Detail 
reporting is enabled for a peripheral.
Default value is:
Y for an IPCC Enterprise peripherals
N for non-IPCC Enterprise peripherals
DBCHAR
NOT NULL
AgentReporting
Specifies whether agent reporting is enabled for 
the peripheral. Stored as a character:
Y = Yes
N = No
DBCHAR
NULL
AnsweredShortCallsThreshold
Maximum duration, in seconds, for a short call. 
Any calls with a duration below the threshold are 
considered short. You might then choose to factor 
out short calls from handle times you calculate.
DBINT
NULL