Agent_Skill_Group_Half_Hour and Termination_Call_Detail tables in IPCC

Version 1
    This document was generated from CDN thread

    Created by: OOCL ISD on 04-01-2010 02:22:48 PM
    We have a question regarding on Agent_Skill_Group_Half_Hour and Termination_Call_Detail tables in IPCC Enterprise:
     
    We are trying to obtain the number of calls handled by a skill group in half hour interval using the Termination_Call_Detail table.
    However, the figures we obtained are different from those we got when querying the Agent_Skill+Group_Half_Hour table. Attached our SQL script for getting this.

    Could you advise why there are discrepancies?
    Is there any difference between data logging mechanisms of these two tables? Or our SQL script is incorrect?

    Remarks: we are using Cisco IPCC Enterprise 7.0 version

    Subject: RE: Agent_Skill_Group_Half_Hour and Termination_Call_Detail tables in IPCC
    Replied by: Nathan Luk on 06-01-2010 05:51:13 AM
    I usually include in my where clause CallDispositionFlag='1' to ensure you are only counting handled calls as from my understanding your TCD query would also count short calls etc

    Subject: RE: Agent_Skill_Group_Half_Hour and Termination_Call_Detail tables in IPCC
    Replied by: OOCL ISD on 20-01-2010 10:19:28 AM
    we've tried to include the CallDispositionFlag='1' in our where clause, but this cannot solve the problem.
    Does anybody has another solution to our problem?

    Subject: RE: Agent_Skill_Group_Half_Hour and Termination_Call_Detail tables in IPCC
    Replied by: Brandon McDowall on 20-04-2010 07:18:20 PM
    Were you able to box out these two tables? I am going through the same process and find that for every one call in the Half_Hour table there are 3 records in the termination call detail table. I would be very interested in your findings if you were successful.
     
    Brandon McDowall

    Subject: RE: Agent_Skill_Group_Half_Hour and Termination_Call_Detail tables in IPCC
    Replied by: Vijay Marimuthu on 29-07-2010 05:05:52 AM
    Consistent data amongst various cisco tables seems to be a nightmare. This is not just with ICM data, i've seen the same across CVP, Call Manager, Trunk Groups.