geoff@hp.com Tue, 11/25/2008 - 18:35
User Badges:
  • Red, 2250 points or more

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


Actions

This Discussion