...
...
...
...
...
...
Data Direct Urgent Communication |
|
Hello!
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.
...
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.
Should you have questions, please contact SC Customer Support team or your respective CSM.
Best,
...