Pinpoint Excursions data model (WIP)
The Pinpoint Excursions data model contains information about soft spots in ongoing and finished shipments - e.g. origin, destination, configuration, excursion threshold and inspection status.
Data type | Description |
|---|---|
bigint | Big integer, large number. |
decimal | Number with decimal point, in |
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 |
Pinpoint Excursions data model Table 1 (WIP)
THE CONTENTS OF THIS PAGE ARE COPIED FROM THE DATA FOUNDATION DATA MODEL
The Shipments table contains information about ongoing and finished shipments - e.g. origin, destination, configuration, excursion threshold and inspection status.
Data type | Description |
|---|---|
bigint | Big integer, large number. |
decimal | Number with decimal point, in |
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 |
Data source: sca_sandbox.dwh.shipments_gold
Item | Data type | Description |
|---|---|---|
shipment_status | string | Current status of shipment:
|
shipment_inspection_status | string | The status of the shipment inspection process after arriving at destination:
Primary key. |
controlant_live_auditlog | string | Description |
shipment_open_type | ts | Description |
shipment_closure_type | string | Description |
shipment_common_properties | Description | |
shipment_clients | Description | |
shipments | Description | |
controlant_live_users | Description | |
country_codes | Description | |
shipment_boundaries | Description | |
shipment_inspection_quality | Description | |
controlant_live_users | Description | |
controlant_live_auditlog | Description |