cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
974
Views
0
Helpful
1
Replies

Wrap up codes Report in Webview

gonzalezel
Level 1
Level 1

Is there any way to run a report on what Wrap up code was used at the end of a call? We are using Contact Center Enterprise 7.2. Thanks

1 Reply 1

geoff
Level 10
Level 10

From WebView? In short - no.

Your first "mistake" is to think of it as a "wrap up" code. It's not a code.

I refer you to the 7.2(2) schema guide, page 357.

In the Termination_Call_Detail record there is a column called "WrapupData". This is of type varchar(40).

It's just a string. There is no associated code and no index (foreign key) to another table.

It's not as if what's recorded in the TCD is a number and this is a key to a table of "wrapup codes and associated data".

You may think it's like that, because you can configure these things at the GUI (CTIOS, CAD). But all you have at the end of the day is a free-form string in a very large table.

You could write custom SQL functions to dig this info out. As you can imagine, if you are trying to get counts on different wrapup data strings, this is going to be a very inefficient query. Cisco caution you about querying the TCDs on your HDS. You really need to offload to another DB.

Regards,

Geoff

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: