resources_v1
Resource is a skilled individual who performs jobs to provide on-site support to their clients.
| Column | Data type | Description |
|---|---|---|
| id | NUMBER(38,0) | The unique identifier of the resource. |
| created_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of resource creation. |
| deleted_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of resource record soft deletion. |
| name | VARCHAR(100) | The full name of the resource. |
| phone | VARCHAR(40) | The telephone number of the resource. |
| license_type | VARCHAR(50) | The JobWatch license type that has been applied to this resource. Possible values: 'Not Active', 'Active', 'Subcontractor', 'Only Visible on Schedule'. |
| reference | VARCHAR(80) | The internal textual reference used for the resource. |
| time_zone | VARCHAR(80) | The ISO 8601 time zone in which the resource operates in. |
| average_rating | NUMBER(2,1) | The average rating that customers have submitted for this resource. |
| number_of_ratings | NUMBER(38,0) | The number of ratings that customers have submitted for this resource. |
| rate_currency_code | VARCHAR(7) | The ISO 4217 currency code that the resources rates are applied in. |
| rate_currency | VARCHAR(200) | The currency that the resources rates are applied in. |
| rate_default | NUMBER(6,2) | The default rate that applies to this resource. |
| group_name | VARCHAR(100) | The group name of the resource. |
| resource_owner_name | VARCHAR(200) | The owner name of the resource. |
| has_assistant | VARCHAR(7) | A flag indicating whether this resource usually works with an assistant. |
| payroll_number | VARCHAR(20) | The payroll number associated to the resource. |
| max_travel_distance_km | NUMBER(38,0) | The maximum distance in kilometers that this resource can travel for a job. |
| max_travel_distance_miles | NUMBER(38,2) | The maximum distance in miles that this resource can travel for a job. |
| is_tracked | VARCHAR(3) | A flag indicating whether this resource's movements are tracked. |
| fuel_card_reference | VARCHAR(40) | The reference of the fuel card that this resource possesses. |
| tacho_card_reference | VARCHAR(40) | The reference of the tacho card associated to this resource. |
| personal_vehicle_key | VARCHAR(40) | ID of the personal key that is assigned to the resource to class journey as 'private'. |
| business_vehicle_key | VARCHAR(40) | ID of the business key assigned to the resource to class the journey as 'business'. |
| out_of_hours_tracking_is_private | VARCHAR(3) | A flag indicating whether this resource's movements are tracked out of hours. |
| holiday_allocation_renews_at | DATE | The date when the resources holiday allocation renews. |
| _last_sync_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the resource record was last refreshed. |