10-19-2016 01:52 PM - edited 03-15-2019 06:24 AM
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
10-20-2016 01:14 AM
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
10-20-2016 05:45 AM
Thanks Manish, will do!
10-25-2016 08:01 AM
Does anyone have any thoughts on this?
thx
10-25-2016 08:13 AM
Can you join RCD and TCD and see if the call legs have any correlation?
10-25-2016 08:43 AM
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
10-25-2016 08:45 AM
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide