Cisco Cisco IP Contact Center Release 4.6.2 Technical References
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
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
Null Option
AbandonedCallWaitTime
Minimum time in seconds an incoming call must
be queued before being considered an abandoned
call if the caller hangs up.
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:
enabled for the peripheral. Stored as a character:
Y = Yes
N = No
N = No
DBCHAR
NULL
AgentDeskSettingsID
Optionally, indicates an Agent Desk Settings
record associated with the peripheral.
record associated with the peripheral.
DBINT
FK, IE-3
NULL
AgentEventDetail
Specifies whether or not Agent Event Detail
reporting is enabled for a peripheral.
reporting is enabled for a peripheral.
Default value is:
Y for an IPCC Enterprise peripherals
N for non-IPCC Enterprise peripherals
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:
the peripheral. Stored as a character:
Y = Yes
N = No
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.
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