Skip to main content

Controlant Support Center

Shipment_logger_events table

In this section:

The Shipment_logger_events table contains the event history of a logger; type of event, and date and time the event occurred.

Note

Excursion events are stored in the Shipment_logger_excursions table.

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.

int

Integer, whole number.

string

String, text.

ts

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

Table 5. Shipment_logger_events

Item

Data type

Description

shipment_reference

string

Primary key. Foreign key.

logger_id

string

Primary key.

timestamp

ts

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

Primary key.

event_type

string

Type of event:

  • ButtonPressed

  • Delivered

  • Light

  • Sent

  • Status

  • DataUpload

Primary key.

event_value

string

Detailed information about the event, where applicable. Depending on the type of event in event_type, one of the following values:

  • ButtonPressed:

    • Start

    • Stop

  • Delivered:

    • N/A

  • Light:

    • Lights on

    • Lights off

  • Sent:

    • N/A

  • Status:

    • At Destination

    • At Origin

    • EnRoute

    • Unknown Location

  • DataUpload:

    • N/A