Skip to main content

Shipment_logger_excursions table

In this section:

The Shipment_logger_excursions table contains the excursion history of a logger, information about excursion events, the time they took place, and details about the excursion that was raised (boundary type, value, and allowed time period).

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.
int	Integer, whole number.
string	String, text.
ts	Timestamp, in `YYYY-MM-DDTHH:MM:SSZ` format.

Table 6. Shipment_logger_excursions

Item	Data type	Description
shipment_reference	string	Unique identifier for shipment, as provided by customer when shipment was created. Primary key. Foreign key.
logger_id	string	Unique identifier of logger. This is the bar code value assigned to this logger from Controlant. The bar code value is printed on one side of the logger along with the bar code. Primary key.
timestamp	ts	Date and time event happened, in `YYYY-MM-DDTHH:MM:SSZ` format. Primary key.
boundary_type	string	Type of boundary being monitored: `UpperBounds` - upper bounds of temperature are being monitored. `LowerBounds` - lower bounds of temperature are being monitored. `DualBounds` - upper and lower bounds of temperature are being monitored. Primary key.
severity	string	Severity of alert that will be sent if temperature specified in `threshold_value_lower` or `threshold_value_upper` is exceeded for longer than the time specified in `accumulative_time_limit`: Notification Level1 Level2 Level3 Primary key.
accumulative_time_limit	int	Time after which the alert threshold should trigger an alert, in seconds. If the temperature specified in `threshold_value_lower` or `threshold_value_upper` is exceeded for longer than the time specified here, the logger will trigger an alert. Primary key.
threshold_value_lower	double	Value of lower alert threshold. If temperature exceeds this threshold, for longer than specified in `accumulative_time_limit`, the logger will trigger an alert. Blank if item `boundary_type` is set to `UpperBounds`. Primary key.
threshold_value_upper	double	Value of upper alert threshold. If temperature exceeds this threshold, for longer than specified in `accumulative_time_limit`, the logger will trigger an alert. Blank if item `boundary_type` is set to `LowerBounds`. Primary key.

Would you like to provide feedback? Just click here to suggest edits.