Upcoming changes to DAP data model 19.12.23

We are performing improvments to the DAP data model, aligning names and column structure. The aim of this work is to improve readability and usability the model.

These changes may break automatic data extractions on your side, please investigate and update naming/structure on your side if this is the case.

Tuesday 19.12.2023 between 12:00 and 14:00 the following changes are planned to be releases in production

Changes in column name for table Module

• FROM: Module.snapshotdate and Module.lockeddate

• TO: Module.snapshot_date and Module.locked_date

Change in column name for table f_shipmentbooking and f_parcelbooking

• FROM: f_parcelbooking.shipment_id and f_parcelbooking.shipment_id

• TO: f_parcelbooking.shipment_number and f_parcelbooking.shipment_number

Changes in column name for table f_adenclosure

• FROM: f_adenclosure.total_distribution

• TO: f_adenclosure.all_households_distribution

Remove columns from f_planneddelivery

• REMOVE: f_planneddelivery.x_coordinate, f_planneddelivery.y_coordinate, f_planneddelivery.address_lat and f_planneddelivery.address_lon

• ALTERNATIVES FOR THIS DATA: module.x_coordinate, module.x_coordinate, address.x_coordinate, address.y_coordinate, address.address_lat and address.address_lat

  • Suggestion to join with table module (on module_id), table DistributionPoint (on module_id, delivery_point_id) and table address (on delivery_point_id)

Remove column from f_productionsystemandpackaging

• REMOVE: f_productionsystemandpackaging.parcel_nr

  • This column has not been available in the official documentation, but is visible in the actual data model. The column has never been populated correctly