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.