I am trying to write a custom IPCC report that pulls only external calls (inbound and outbound). I need the external phone number, call time, talk time, direction (in/out), and what extension the call finished on. I've been looking through the IPCC data as well as the stored procedures and historical report examples. What I'm confused on is the data. I'm expecting to see more phone numbers that are at least 7 digits or greater (external numbers) but I'm not seeing that. Shouldn't I see that in the CalledPartyNumber, destinationDN, or originatorDN in the ContactCallDetail table?
Can you recommend an already existing historical report that is similar to what I'm needing?
One other question - Are there call records in the CDR database that correlate to the IPCC call records. Is every leg of an IPCC call recorded in the CDR data?