t_Termination_Call_Detail table and PeripheralCallType field

Voiceops SSC · ‎08-30-2010

Hi,

We recently upgraded from UCCE 6 (with IP IVR) to UCCE 7.5 with CVP 7.

I usually run a query against the t_termination_call_detail table and search for the different PeripheralCallType results (i.e. 1 fro inbound, 9 for outbound, and 7 for out dialer)

I've noticed that when I run the same query on the 7 version I don't have any PeripheralCallType of tyep 9.

Are the dialer calls registered in this table?

thanks

TouchbaseParam · ‎08-30-2010

Hi

Please try from Dialer Detail table . below sample sql

select PeripheralCallKey from Dialer_Detail
where DateTime >= '2010-08-04 00:00:00.000'
AND DateTime <= '2010-08-04 23:59:00.000'

AND CallResult in (10)

--10-Customer answered and was connected to agent

use "PeripheralCallKey" to link with TCD.

Hope this will help.

Thanks

Regards,

Param