ICM 7.5-how to get individual outbound dialer calls talktime and respective ECC values

Unanswered Question
Aug 4th, 2010
User Badges:


I'm looking for following two items

1. Outbound dialer calls talktime in each call.

2. Each calls respective ECC values.

I have tried to get talktime from TCD table it’s shows zero value.

Please advice how to get above values, it would be much appreciated.




  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Nathan Luk Thu, 08/05/2010 - 23:54
User Badges:
  • Bronze, 100 points or more

Hey Param,

You can use the PeripheralCallType in the TCD table to find dialer calls. Look for calls with:

  • PeripheralCallType IN ('27','28','29','30','31') for reservation calls and
  • PeripheralCallType IN ('32','33','34','35') for the customer calls
  • For duration of reservation calls look at the HoldTime value
  • For duration of the customer call you can look at the HoldTime + TalkTime + WorkTime for a total handle time for the customer leg of the dialer call

If you want to look at the ECC variables that were associated with that call you will have to lookup the Termination_Call_Variable table matching:

  • Termination_Call_Variable.TCDRecoveryKey = Termination_Call_Detail.RecoveryKey




This Discussion