This article provides an overview of changes and additional features in the release of the new version of Puzzel Raw data.
Puzzel plans to upgrade all customers' Raw data SQL databases to the new version during week 5 - 2026 (26-30 January).
We expect only a few minutes down-time per customer, and the new version is backwards compatible.
If, during week 5, you would like to confirm whether your database is updated or not, you can look for the new columns in the tables, or use this statement to see the db version:
select convert(varchar(255), value) from ::fn_listextendedproperty('DBVERSION', null, null, null, null, null, null)
The new Raw data version (2.4.3.0) includes new columns in these tables:
Puzzel Contact Centre (PCC)
call_events
| internal_country_src_db | Varchar(10) | Same as we have table ‘agent_events’. For media type ‘phone’, this will be the country code where the call took place. Needed for some of the UTC calculations. |
| dte_start_UTC | Datetime | Same value as we have in ‘dte_start’, but in UTC. |
| dte_updated_UTC | Datetime | Same as ‘dte_updated’, but in UTC |
agent_events
| dte_start_UTC | Datetime | Same as ‘dte_start’, but in UTC. |
| dte_updated_UTC | Datetime | Same as ‘dte_updated’, but in UTC |
enqreg_header
| dte_time_stamp_UTC | Datetime | Same as ‘dte_time_stamp’, but in UTC |
| dte_updated_UTC | Datetime | Same as ‘dte_updated’, but in UTC |
Surveys
| dte_time_UTC | Datetime | Same as ‘dte_time’, but in UTC. NOTE! This column will only have values for customers using our new “Insight” surveys. |
| dte_updated_UTC | Datetime | Same as ‘dte_updated’, but in UTC |
call_variables
dte_updated | Datetime | When this record was last time updated |
dte_updated_UTC | Datetime | When this record was last time updated, in UTC |
queues
dte_updated | Datetime | When this record was added or last time updated |
dte_updated_utc | Datetime | When this record was added or last time updated, in UTC |
rec_id | INT | Primary key |
menues
dte_updated | Datetime | When this record was added or last time updated |
dte_updated_utc | Datetime | When this record was added or last time updated, in UTC |
rec_id | INT | Primary key |
The new UTC columns will not be given values for records inserted prior to upgrading to the new release.
Puzzel Case Management (PCM)
- We will increase the maximum character length of columns ‘form_field_name’ and ‘choice_name’ in the ‘cm_form_field_answers’ table from nvarchar(500) to nvarchar(2500).
- Under normal circumstances, ticket status is already consistent between table 'cm_tickets' and 'cm_reporting_ticket_states'. A nightly validation job now checks for rare inconsistencies (e.g. caused by race conditions) and updates the status_id in cm_tickets only when a newer status is found.