Skip to main content

Shipment_status_events table

In this section:

The Shipment_status_events table contains information about status changes for ongoing and finished shipments, the type of status transition, and the date and time the transition took place.

Data type legend

Data type

Description

bigint

Big integer, large number.

decimal

Number with decimal point, in 11,7 format: 11 digits before decimal point, 7 digits after decimal point.

double

Double; 8-byte double-precision floating point numbers.

hex

Hexadecimal value. See more. Hidden as it was only used for logger_id, which now uses string

int

Integer, whole number.

string

String, text.

ts

Timestamp, in YYYY-MM-DDTHH:MM:SSZ format.

Table 7. Shipment_status_events

Item

Data type

Description

shipment_reference

  • n/a

string

Primary key. Foreign key.

effective_timestamp

  • n/a

ts

Date and time status change happened, in YYYY-MM-DDTHH:MM:SSZ format.

Primary key.

status

  • n/a

string

Status of the shipment in Controlant's system:

Primary key.

transition_type

  • n/a

string

Type of status change in the shipment. Indicates whether the status change happened automatically because the logger met a configured condition, or manually via button press.

  • Automatic

  • Manual