GPS Track Fields
This section provides a list of Global Positioning System (GPS) track fields.
Field |
Label |
Data Type |
Description |
---|---|---|---|
Activity ID |
gps_tracks.aid |
INTEGER |
The ID of the activity started at the moment of the data collection or if there were no started activities at the moment of the next activity in the resource' route |
Distance |
gps_tracks.distance |
INTEGER |
Distance from the resource's location to the activity |
Idle Time |
gps_tracks.idle |
INTEGER |
Number of seconds the resource spent in the point. |
Latitude |
gps_tracks.latitude |
FLOAT |
The Y coordinate of the position. |
Longitude |
gps_tracks.longitude |
FLOAT |
The X coordinate of the position. |
Resource External ID |
provider.external_id |
VARCHAR2 |
External identifier for the resource. |
Status |
gps_tracks.status |
INTEGER |
Location status. Possible values are:0 - a position without warnings 1 - a position has the alert "Started outside the location" (Started at driving) 2 - a position has the alert "Completed outside the location" (Finish at driving) 4 - a position has the alert "Resource left the activity location" (Driving at working time) 8 - an 'idling' position (See Business rules to understand what position is considered as 'Idle' ) |
TIme |
gps_tracks.time |
DATE |
Timestamp received along with the GPS data. |
Track Route ID |
gps_tracks.queue_id |
INTEGER |
The ID of the route for which the geolocation data has been received. |