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

Unanswered Question
Aug 4th, 2010

Hello,

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.

Thanks

Regards,

Param

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Nathan Luk Thu, 08/05/2010 - 23:54

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

Cheers,

Nathan

Actions

This Discussion