Maybe you can try using the field "Peripheral Call Type"in the TCD table.
Generally, if agent does a off-hook or made a call it would be 9 or 10.
Below are list of thing which we could see in the Database Schema Guide
https://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/ipcc_enterprise/ippcenterprise10_0_1/reference/UCCE_BK_D3D5FB15_00_1001-database-schema-guide-for-ucce/UCCE_BK_D3D5FB15_00_10-0-1-database-schema-guide-for-ucce_chapter_0...
7 = Auto Out In Outbound option, indicates a Predictive /Progressive customer call.
9 = Out In Unified CCE, indicates call was placed outside the Unified CM cluster or that a network reached event was received
10 = Agent Inside
17 = Preview In Outbound Option indicates a Preview/Callback customer call
18 = Reserved In Outbound Option indicates a Reservation call.
27 = Reservation Preview Call type for Outbound Option Reservation calls for Preview mode.
28 = Reservation Preview Direct Call type for Outbound Option Reservation calls for Direct Preview mode.
29 = Reservation Predictive Call type for Outbound Option Reservation calls for Predictive mode and Progressive mode.
30 = Reservation Callback Call type for Outbound Option Reservation calls for Callback calls.
31 = Reservation Personal Callback Call type for Outbound Option Reservation calls for Personal Callback calls.
32 = Customer Preview Call type for Outbound Option Customer calls for Preview mode.
33 = Customer Preview Direct Call type for Outbound Option Customer calls for Direct Preview mode.
34 = Customer Predictive Call type for Outbound Option Customer calls for Predictive mode and Progreassive mode for agent-based campaigns.
35 = Customer Callback Call type for Outbound Option Customer calls for callback calls.
36 = Customer Personal Callback Call type for Outbound Option Customer calls for personal callback calls.
37 = Customer IVR Call type for Outbound Option Customer calls for Transfer to IVR campaigns.
Regards,
Senthil Kumar
