2021 - October Release
- SC Release Notes (Unlicensed)
- Viktoryia Halukhina (Deactivated)
In September 2021, ServiceChannel Provider application implemented a change in the backend table to switch from using datetime data type (UTC) to datetimeoffset(7) type (DTO) when storing date fields. This impacted the Data Direct feed.
As a reference, a DTO will have the datetime offset value that can be used to convert to local time.
We are reflecting this change in Data Direct by introducing a new DTO column for each UTC column in the affected tables. For example, [technician_assigned_accepted].[UpdatedTechnicianDateUtc] column is replaced with [technician_assigned_accepted].[UpdatedTechnicianDateDto] column.
Starting with this release, all new DTO columns which are listed below will contain the most up-to-date and accurate data for all new and historical records. We are keeping existing UTC date fields for backward compatibility and they will be populated with the DTO values minus the offset.
Below is the list of changes going live next week.
Features and improvements
Additional DTO Fields in the following tables: We highly recommend to start using the new DTO fields instead of the existing UTC columns.
- technician_assigned_accepted.UpdatedTechnicianDateDto
- technician_availability_log.unavailableUntilDateDto
- technician_availability_log.createdDateDto
- technician_time_tracking_history.OriginalStartTimeDto
- technician_time_tracking_history.OriginalEndTimeDto
- technician_time_tracking_history.NewStartTimeDto
- technician_time_tracking_history.NewEndTimeDto
- technician_time_tracking_history.LogTimeDto
The above changes will also be updated in the latest ERD diagram and on our Data Direct page.