resource_journeys_v1
Resource journey refers to the path or route taken by a field service technician from their starting point to their service destination and back, as they perform their assigned tasks/jobs. This journey is tracked and recorded using a tracking device such as a tablet or tracker on their vehicle.
| Column | Data type | Description |
|---|---|---|
| id | NUMBER(38,0) | The unique identifier of the resource journey record. |
| device_model | VARCHAR(100) | This field represents the specific model or version of the device used for tracking a journey. |
| device_type | VARCHAR(100) | This field categorizes the type of device used for tracking a journey. It helps differentiate between different classes or categories of devices, such as Tablets or dedicated GPS trackers. |
| device_description | VARCHAR(100) | This field provides additional details about the journey tracking device that may inform any unique characteristics of the device that is relevant to the journey tracking. The device description helps in identifying and distinguishing different devices within the same model or type. |
| start_at | TIMESTAMP_TZ(9) | The timestamp with the timezone offset of when the resource journey started. |
| stop_at | TIMESTAMP_TZ(9) | The timestamp with the timezone offset of when the resource journey stopped. |
| duration_in_seconds | NUMBER(38,0) | Duration of the journey in seconds. |
| start_address | VARCHAR(200) | The address from where the journey started. |
| stop_address | VARCHAR(200) | The address where the journey ended. |
| distance_km | NUMBER(38,0) | The distance, in kilometres, travelled during the resource journey. |
| distance_mi | NUMBER(38,0) | The distance, in miles, travelled during the resource journey. |
| max_speed_kph | NUMBER(38,0) | Maximum speed reached during the journey in km/h. |
| max_speed_mph | NUMBER(38,0) | Maximum speed reached during the journey in mi/h. |
| over_speed_count | NUMBER(38,0) | Count of instances when the speed limit was exceeded during the resource journey. |
| start_driving_to_job_at | TIMESTAMP_TZ(9) | The timestamp with the timezone offset of when the resource started the journey to the job. |
| start_contact_name | VARCHAR(100) | The name of the contact where the resource journey started. |
| stop_contact_name | VARCHAR(100) | The name of the contact where the resource journey ended. |
| start_geolocation_longitude | NUMBER(38,0) | The longitudinal geographic coordinate of where the journey started. |
| start_geolocation_latitude | NUMBER(38,0) | The latitudinal geographic coordinate of where the journey started. |
| stop_geolocation_longitude | NUMBER(38,0) | The longitudinal geographic coordinate of where the journey ended. |
| stop_geolocation_latitude | NUMBER(38,0) | The latitudinal geographic coordinate of where the journey ended. |
| idling_time_in_seconds | NUMBER(38,0) | Total time the vehicle was idling during the journey in seconds. |
| idling_with_pto_time_in_seconds | NUMBER(38,0) | Total time the vehicle was idling with Power Take Off (PTO) engaged during the journey in seconds. |
| _start_contact_id | NUMBER(38,0) | The identifier of the contact associated with the journey start. |
| _stop_contact_id | NUMBER(38,0) | The identifier of the contact associated with the journey end. |
| _start_job_id | NUMBER(38,0) | The identifier of the job associated with the journey start. |
| _stop_job_id | NUMBER(38,0) | The identifier of the job associated with the journey end. |
| _vehicle_id | NUMBER(38,0) | The identifier of the vehicle associated with the journey. |
| _resource_id | NUMBER(38,0) | The identifier of the resource performing the journey. |
| _last_sync_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the resource journey record was last refreshed. |