Cisco Cisco IP Contact Center Release 4.6.1 Technische Referenzen
•
•
(via SkillTargetID)
•
(via PeripheralID)
•
•
•
(via SkillTargetID)
•
(via SkillTargetID)
•
(AgentSkillTargetID maps to Agent.SkillTargetID.
SourceAgentSkillTargetID maps to Agent.SkillTargetID)
Table 3: Indexes for Agent Table
index_keys
index_description
index_name
PeripheralID, PersonID
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Agent_Map
PeripheralID, PeripheralNumber
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK2Agent
AgentDeskSettingsID
nonclustered located on PRIMARY
XIE2Agent
ScheduleID
nonclustered located on PRIMARY
XIE3Agent
EnterpriseName
nonclustered located on PRIMARY
XIE4Agent
SkillTargetID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKAgent
Fields in Agent Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
IE-2, FK NULL
DBINT
Identifies the agent desk settings associated with the agent.
AgentDeskSettingsID
NOT NULL
DBCHAR
Indicates whether the software collects agent state trace data for
the agent:
the agent:
AgentStateTrace
• Y = Yes
• N = No
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NULL
varchar(255)
A string of parameters the software sends to the peripheral to
initialize the agent.
initialize the agent.
ConfigParam
NOT NULL
DBCHAR
Deleted Flag. Stored as a character:
Deleted
• Y = Yes
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
16
Chapter 2: All Tables
Agent Table