Australia Post fields in every export
Tracking output carries the tracking number, the raw status text as published, the normalised status, the event timestamp with time zone, the event location and the facility identifier where given.
Time zones need naming rather than assuming. The country spans several, some observing daylight saving and some not, which means a naive timestamp produces delivery duration analyses that are wrong by hours for a large share of shipments and wrong inconsistently across the year. We store the zone explicitly and compute durations in UTC.
Shipment fields cover origin and destination postcode, the destination classified as metropolitan, regional or remote, service level, expected delivery window where published, actual delivery, attempt count, delivery outcome including collection point holds, and the exception reason.
Rate records carry service level, origin and destination zone, weight band, dimensional limits, base price, surcharges where published and the effective date of the price table.
Location records carry the outlet or locker name, type, address, postcode, coordinates where published, opening hours structured by day and the services offered.