Cisco Cisco Unified Intelligent Contact Management Software Technical References

Agent (AgentSkillTargetID maps to Agent.SkillTargetID; SourceAgentSkillTargetID maps to 
Agent.SkillTargetID)

Media Routing Domain (via MRDomainID)

Peripheral (via PeripheralID)

Route (via RouteID)

Route Call Detail (via Day + RouterCallKey)

Service (ServiceSkillTargetID maps to Service.SkillTargetID)

Skill Group (SkillGroupSkillTargetID maps to Skill_Group.SkillTargetID)

Termination_Call_Variable (RecoveryKey maps to Termination_Call_Variable.TCDRecoveryKey)

RouterCallKeySequenceNumber

A sequence number used for ordering rows for 
cradle-to-grave call tracking. This number 
defines the order in which the calls were 
created. This is not the order in which the 
Termination_Call_Detail records were created. 
(This field also exists in the Route_Call_Detail 
table, where it defines the order in which the 
route requests were created.)

int

NULL

CED

The Caller Entered Digits (CED) associated 
with the call.

varchar(30)

NULL

CallTypeID

Indicates which call type, and therefore which 
routing script, was used to route this call.

This field contains a value only if the 
call was translation-routed, post-routed 
to/from an ACD, or sent to an IPCC 
agent.

int

NULL

BadCallTag

Indicates whether the call was marked as bad 
by the agent. Stored as a character:

Y = the call was marked “bad”
N = the call was not marked “bad” 

char(1)

NULL

ApplicationTaskDisposition

A field passed in the End Task message for this 
task. This is an application-specific code that 
indicates why the task was ended. For example, 
E-Mail Manager might use the 
ApplicationTaskDisposition field to indicate 
that the task ended because an agent closed an 
e-mail without responding to it.

int

NULL

ApplicationData

Additional data passed in the End Task 
message for this task.

varchar(100)

NULL