Canada Post fields in every export
Tracking output carries the tracking number, the raw status text with the language it was collected in, the normalised status, the event timestamp with time zone, the event location and the retail or depot identifier where given.
Time zones deserve specific attention on this carrier. The country spans six of them, and a timestamp without a zone produces delivery time analyses that are wrong by several hours for a large share of shipments. We store the zone explicitly on every event and compute durations in UTC.
Shipment fields cover origin and destination postal code, the forward sortation area parsed out for regional analysis, service level, expected delivery date where published, actual delivery, attempt count, delivery outcome including community mailbox and post office pickup, and the exception reason.
Rate records carry service level, origin and destination zone, weight band, dimensional limits, base price, fuel and remote area surcharges where published, and the effective date of the price table.
Outlet records carry name, type, full address, postal code, coordinates where published, opening hours structured by day, and the services offered. Every row carries the language it was collected in and the collection timestamp.