Wrap up Report and SQL

[shaijal.allipra]

Hello,

I am trying to build a  report to ' determine the volume of calls with a specific call type that have a specific wrap up code associated with it' using IBM Cognos. However I couldn't able to find SQL query in CUIC and schema document. Can any one provide me the SQL details for Wrap-Up code.

We are using CUIC however, couldn't find any report for Wrap up code.

UCCE  - 9.0.4

Regards,

Sam

[vinodkewate · Accepted solution]

There is no special table for holding wrap-up data itself. However you can Termination_Call_Detail table and field name is WrapupData.

It will provide you the wrap-up-code associated with call.

And you will have build your query accordingly.

[shaijal.allipra]

Many Thanks