DAP - Improvements to the route and route summary tables

On Monday, March 10th, we plan to deploy changes to the route table.

The following columns will be modified:

active

status

in_ebudbok

The active column will be replaced with a new column named active_electronic_delivery_guide. The reason for this change is that the original column name was imprecise and could be misinterpreted as indicating whether the route was active or not, rather than specifying whether the route was active in an electronic delivery guide, which is more accurate. The new column will contain values of 1 or 0. The active column will remain in the table for a few weeks after March 10th, but all rows will have NULL values in this column.

The status column, which indicates whether the route has been deleted in DI Main or not, will be replaced with a new column named deleted. We will also change the values stored in this column from the current active/inactive format to 1 and 0. The status column will remain in the table for a few weeks after March 10th, but all rows will have NULL values in this column.

The in_ebudbok column will be removed.

Please note that these changes may require adjustments on your side, particularly regarding automatic data extractions. Since we are adding and modifying columns, we kindly request that you review your existing queries and procedures to accommodate these changes effectively. Any JOINs you have may be affected.

On Monday, March 3rd, we will improve the data quality for the f_routesummary, f_routesummary2, and f_routesummarymetric tables. The columns route_download_time, route_stop_time (not present in f_routesummary2), route_time_start, and route_time_end were previously not populated for distr_dates older than approximately 12 months. We have now reintroduced timestamps for the older data.

Do not hesitate to contact us if you have any questions.