vehicles_v1
Vehicle is a mode of transport used by resources to reach job sites. It often stores necessary tools and equipment, and may have tech for communication and navigation.
| Column | Data type | Description |
|---|---|---|
| id | NUMBER(38,0) | The unique identifier of the vehicle. |
| type | VARCHAR(50) | Describes the category of the vehicle. Possible values: 'Motorcycle', 'Car / van < 2T', 'Car / van + trailer', 'Bus / coach', 'Emergency vehicle', 'Goods vehicle < 7.5T', 'Goods vehicle > 7.5T', 'Bus / coach < 12 metres'. |
| make | VARCHAR(100) | The manufacturer or brand of the vehicle. |
| model | VARCHAR(100) | The specific model of the vehicle. |
| manufacture_year | NUMBER(4,0) | The year the vehicle was manufactured. |
| group_name | VARCHAR(100) | The group to which the vehicle belongs. |
| reference | VARCHAR(80) | Free text field for additional vehicle information. |
| registration_number | VARCHAR(100) | The vehicle's registration number. |
| created_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset when the vehicle record was created. |
| deleted_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset when the vehicle record was deleted. |
| is_used_for_jobs | VARCHAR(3) | Indicates whether the vehicle is used for jobs. Possible values: 'Yes', 'No'. |
| odometer_estimated | NUMBER(38,0) | The estimated reading of the vehicle's odometer. |
| odometer | NUMBER(38,0) | The actual reading of the vehicle's odometer. |
| odometer_date | TIMESTAMP_TZ(9) | The timestamp with time zone offset when the odometer reading was recorded. |
| odometer_unit | VARCHAR(10) | The unit of measurement for the odometer. Possible values: 'Miles', 'Kilometres'. |
| fuel_level_percentage | NUMBER(4,1) | The percentage of fuel remaining in the vehicle. |
| max_rpm | NUMBER(38,0) | The maximum revolutions per minute (RPM) the vehicle can achieve. |
| cost_per_day | NUMBER(6,3) | The daily cost associated with operating the vehicle. |
| cost_per_day_currency | VARCHAR(3) | The ISO 4217 currency code of the cost of the vehicle per day currency. |
| cost_per_km | NUMBER(8,5) | The cost of operating the vehicle per kilometre. |
| cost_per_km_currency | VARCHAR(3) | The ISO 4217 currency code of the cost of the vehicle per kilometre currency. |
| idling_fuel_consumption_in_litre_per_minute | NUMBER(4,2) | The amount of fuel consumed when the vehicle is idling, measured in litres per minute. |
| co2_emissions_in_gram_per_km | NUMBER(38,0) | The amount of CO2 the vehicle emits per kilometre. |
| co2_emissions_in_kg_per_litre | NUMBER(4,2) | The amount of CO2 the vehicle emits per litre of fuel consumed. |
| next_service_odometer | NUMBER(38,0) | The odometer reading at which the vehicle's next service is due. |
| next_service_at_date | DATE | The date when the vehicle's next service is due. |
| road_safety_expiry_at_date | DATE | The expiry date of the vehicle's road safety test (e.g. MOT). |
| insurance_expiry_at_date | DATE | The expiry date of the vehicle's insurance. |
| road_tax_expiry_at_date | DATE | The expiry date of the vehicle's road tax. |
| has_fixed_resource | VARCHAR(3) | Indicates whether the vehicle has an assigned fixed resource. If 'Yes' then 'resource_name' field contains the name of the resource assigned for the vehicle. Possible values: 'Yes', 'No'. |
| resource_name | VARCHAR(100) | The name of the resource assigned for the vehicle. |
| _resource_id | NUMBER(38,0) | The identifier of the resource that has been assigned to the vehicle. |
| _last_sync_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the vehicle record was last refreshed. |