cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
Walkthrough Wednesdays
296
Views
0
Helpful
6
Replies
Keith Abbott
Beginner

UCCE RCD.RequestType=39 ??

Hi,

I am extracting some call information from the Route_Call_Detail view and one of the fields I'm returning is RequestType.

 

While most of the returned data is the typical 1,2, or 6, I am seeing the occaisional 39.

 

I can find 1-6 in the schema for 11.5, and construct the following:

,   case CAST(RCD.RequestType as varchar(11))
    when '1' then ' 1: PRE_ROUTE'
    when '2' then ' 2: BLIND_XFER'
    when '3' then ' 3: ANNOUNCE_XFER'
    when '4' then ' 4: OVRFLOW'
    when '5' then ' 5: RE_ROUTE'
    when '6' then ' 6: POST_RTE_REQ'
    else CAST(RCD.RequestType as varchar(7))
    end as 'Type'

but I cant find what RequestType 39 means.

 

Can anyone enlighten me?

 

Thanks

 

6 REPLIES 6
Manish Gogna
Cisco Employee

You are right, the available documentation does not have info about this , however you can try posting this query under the Contact Center community below where the Contact Center experts should be able to assist better on this

https://supportforums.cisco.com/community/5926/contact-center

Manish

Thanks Manish, will do!

Keith Abbott
Beginner

Does anyone have any thoughts on this?

thx

Can you join RCD and TCD and see if the call legs have any correlation? 

Thanks for the suggestion Omar. Actually the query does join RCD and TCD.

A snip of the results are attached.

Also Ive attached the query so you can make sense of the results. I can see a few things:

First 'playAgentGreeting' is listed in the 'dialednum'ber field of a true number

all of the duration fields are 0

and the call disposition is 7, short.

 

I have had limited experience translating these, thus far, and so Im not sure what I am looking at.

 

Could it be that its attempting to play an agent greeting, but there isn't one recorded, and 39 indicates that condition?

 

Thanks

k

 

 

 

 

looks like the snip didnt make it - heres the second try.

Content for Community-Ad

Spotlight Awards 2021