" /> Info Mart 8 CONTACT_ATTEMPT_FACT - Genesys CTI User Forum
« previous next »
Pages: [1]   Go Down

Author Topic: Info Mart 8 CONTACT_ATTEMPT_FACT  (Read 2978 times)

Offline Adam_W

  • Full Member
  • ***
  • Posts: 171
  • Karma: 0
Info Mart 8 CONTACT_ATTEMPT_FACT
« on: October 13, 2011, 01:53:18 PM »
Advertisement
I see that several useful duration-related columns have been removed from the CONTACT_ATTEMPT_FACT table in GIM 8 (talk_duration, hold_duration, etc).

So how do we now find out the durations for those calls?  I thought I would be able to join with the INTERACTION_RESOURCE_FACT table using the CALLID column but this does not appear in IRF...
Logged

Offline fnunezsa

  • Full Member
  • ***
  • Posts: 213
  • Karma: 5
Re: Info Mart 8 CONTACT_ATTEMPT_FACT
« Reply #1 on: October 13, 2011, 05:44:59 PM »
In CONTACT_ATTEMPT_FACT you have CALLID, in INTERACTION_FACT you have MEDIA_SERVER_IXN_GUID and INTERACTION_ID, finally in IRF you also have INTERACTION_ID. I believe that's the way you may link those tables.
Logged

Offline Adam_W

  • Full Member
  • ***
  • Posts: 171
  • Karma: 0
Re: Info Mart 8 CONTACT_ATTEMPT_FACT
« Reply #2 on: October 14, 2011, 07:35:40 AM »
I think you're right.  I did check that before, but found that I had CALLIDs in CONTACT_ATTEMPT_FACT that didn't appear in INTERACTION_FACT.

Thinking back, this is probably because I switched my ICON_VOICE application on after ICON_OCS.  I was probably searching against old calls when I saw this discrepancy.
Logged
Pages: [1]   Go Up
« previous next »