This article provides an overview of changes and additional features included in the Puzzel Raw data SQL db v1.7 release, which is available on request from February 2021.

If you want us to upgrade your Puzzel Raw data SQL db from today’s v1.6 to the new v1.7, please contact Puzzel.

The main changes in Puzzel Raw data v1.7: 

1. General support for call_variables records for media type chat and email (scheduled tasks). For each Scheduled task created in the agent application (media type = email) there will be several records in call_variables.
2. The pre-initiation events (event type = ‘p’) for Scheduled tasks (email) now include scheduled time (as dte_scheduled_callback) and the reserved agent’s agent_id (if the request had a reserved agent).
3. Support for call_relations records for email/chat: If the agent reschedules an already accepted Scheduled task, makes an outbound call from an open Scheduled task, or creates a scheduled task from a call tab, a record will be created in table call_relations so that the 2 requests are linked.
4. Added column related_session_id and dte_updated in table call_relations. 
5. Added column request_id in table call_events. request_id will have a value only for event_type=’i’ and ‘p’

Customers that have not asked for the upgrade to v1.7 by the end of Q1-2021, will probably be upgraded to v1.7 on a date in Q2-2021. A new announcement will be made about this when the date is set.

The complete detailed documentation for Raw data v1.6. and v1.7 can be found here: 
Raw data details