Raw data details (PCC)

Articles in this section describes Raw data for Puzzel Contact Centre.

Release notes for v2.3 can be found here.

The Raw data documentation can be divided into two main parts:

  1. General information and details about what data records that are generated for different call/email/chat scenarios. 
  2. A technical part


To see what db version you have, please try this SQL statement:
select convert(varchar(255), value) from ::fn_listextendedproperty('DBVERSION', null, null, null, null, null, null)

The tables for Puzzel Case Management Raw data, all having names starting with "CM_" (Case Management), are shown in the Raw data sql db for all customers, but these tables will only have content for the Puzzel customers that have ordered PCM Raw data.    

It’s very important that part 1 (especially Call and agent detailed records) is read and understood before making queries and analysing the results.


Last updated