Technical References

•
Dialer Detail (page 163) (via PeripheralNumber)
•
Galaxy Agent Performance (page 185) (via SkillTargetID)
•
Peripheral (page 250) (via PeripheralID)
•
Person (page 263) (via PersonID)
•
Schedule (page 305) (via ScheduleID)
•
Skill Group Member (page 392) (via SkillTargetID)
•
Skill Target (page 406) (via SkillTargetID)
•
Termination Call Detail (page 407)(AgentSkillTargetID maps to Agent.SkillTargetID.
SourceAgentSkillTargetID maps to Agent.SkillTargetID)
Table 3: Indexes for Agent Table
index_keysindex_descriptionindex_name
PeripheralID, PersonIDnonclustered, unique, unique key
located on PRIMARY
XAK1Agent_Map
PeripheralID, PeripheralNumbernonclustered, unique, unique key
located on PRIMARY
XAK2Agent
AgentDeskSettingsIDnonclustered located on PRIMARYXIE2Agent
ScheduleIDnonclustered located on PRIMARYXIE3Agent
EnterpriseNamenonclustered located on PRIMARYXIE4Agent
SkillTargetIDclustered, unique, primary key
located on PRIMARY
XPKAgent
Fields in Agent Table:
Keys and Null Option:Data Type:Description:Field Name:
IE-2, FK NULLDBINT
Identifies the agent desk settings associated with the agent.
AgentDeskSettingsID
NOT NULLDBCHAR
Indicates whether the software collects agent state trace data for
the agent:
AgentStateTrace
• Y = Yes
• N = No
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NULLvarchar(255)
A string of parameters the software sends to the peripheral to
initialize the agent.
ConfigParam
NOT NULLDBCHAR
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