Fleet Fueling Fields

The fields described below have special functions. For a complete list of available fields, see the Lucity Data Dictionary.

 

Data Dictionary

ID Fields

Fleet ID **

Indicates which Fleet vehicle was fueled. This field links this Fueling record to an existing Fleet Inventory record.

Employee

Specifies which employee fueled the vehicle.

Fueling ID

Serves as an optional, unique identifier for the Fueling record.

* Required field.
* Must form a unique combination with the Current Reading Date/Time.

Fuel Fields

Fuel

Specifies the type of fuel used during the fueling.

Note: The same fuel codes from the Fluids module (1=unleaded, 2=diesel) must be used for this Fuel pick-list.

Fuel Amount

Indicates the amount of fuel, in gallons, that was added at this fueling.

Reading Fields

Previous Reading Date

Indicates the date of the previous Fueling record. (The system automatically displays this data.)

Previous Reading Odometer

Specifies the odometer reading from the previous Fueling record. (The system automatically displays this data.)

Previous Reading Hourmeter

Specifies the hour meter reading from the previous Fueling record. (The system automatically displays this data.)

Previous Reading Other Meter

Specifies the other meter reading from the previous Fueling record. (The system automatically displays this data.)

Current Reading Date **

Indicates the date/time that the reading is taken.

Current Reading Odometer *

Specifies the current odometer reading.

Current Reading Hourmeter *

Specifies the current hour meter reading.

Other Meter *

Specifies the current other meter reading.

* Required field.
* Must form a unique combination with the Fleet ID.

* Recommended: Although these fields are optional, Lucity advises agencies to record meter readings as a part of refueling. The data are used to update the Fleet record's evaluation fields, which dictate preventative maintenance schedules, as well as the warranty status, depreciation, and replacement costs of the vehicle.

* If the new reading is less than the Fleet record's previous odometer, hour meter, or other meter reading, the user is asked whether he or she would like to roll back the meter. If the user chooses to roll back the meter, all PMs related to the vehicle must be updated.

Cost Fields

Cost Per Unit *

Records the cost of the fuel, per gallon, at the time of fueling.

Total Fuel Cost *

Calculates the total price of fuel at this fueling, as:

Fuel Amount x Cost Per Unit

This figure is automatically calculated by the system. If a user manually enters this data, the system will update the Cost Per Unit to correspond to the Total Fuel Cost.

Grand Total

Calculates the total price of all fuel and fluids added at this fueling, as:

Total Fuel Cost + Other Fluids

Other Fluids

Displays the sum of the Total Cost fields for all records entered in this Fueling record's Other Fluids grid. This field is automatically calculated by the system.

* Lucity calculates the Total Fuel Cost using the values in the Fuel Amount and Cost Per Unit fields. If a user manually enters the Total Fuel Cost after the system has calculated the value, a warning message appears that states that the calculation is incorrect. This message prompts the user to indicate whether the Total Fuel Cost is correct.

If the user selects Yes, Lucity updates the Cost Per Unit to validate the calculation. If the user selects No, the Total Fuel Cost is recalculated based on the existing Fuel Amount and Cost Per Unit.

Summary Fields

Date Difference

Specifies the amount of time that passed between fuelings. Automatically calculated as:

Current Reading Date - Previous Reading Date

Cost Per Day

Indicates the cost of fuel per day to drive this vehicle (e.g., $20/day) since the last fueling. Automatically calculated as:

Total Fuel Cost / Difference Date

Days/Amount *

The number of days a gallon lasted since the last fueling. Automatically calculated as:

Difference Date / Fuel Amount

Avg Days/Amount *

The number of days a gallon lasted for the last X number of fuelings. Automatically calculated by averaging the Days/Amount fields for the last X number of fuelings.

  • X - The number of historical fuelings to use is set in the General Options > Number of records used averaging fueling metrics option.
  • Records where the Days/Amount = null are skipped.

 

Odometer Difference

Specifies the distance that was traveled between fuelings. Automatically calculated as:

Current Reading Odometer - Previous Reading Odometer

Cost Per Odometer

Indicates the cost of fuel per mile to drive this vehicle (e.g., $0.15/mile) since the last fueling.

Automatically calculated as:

Total Fuel Cost / Difference Odometer

Miles/Amount *

The number of miles to the gallon since the last fueling. Automatically calculated as:

Odometer Difference / Fuel Amount

Avg Miles/Amount *

The number of miles to the gallon for the last X number of fuelings. Automatically calculated by averaging the Miles/Amount fields for the last X number of fuelings.

  • X - The number of historical fuelings to use is set in the General Options > Number of records used averaging fueling metrics option.
  • Records where the Days/Amount = null are skipped.

 

Hourmeter Difference

Specifies the number of hours the vehicle was used between readings. Automatically calculated as:

Current Reading Hourmeter - Previous Reading Hourmeter

Cost Per Hour

Indicates the cost of fuel per hour to drive this vehicle (e.g., $10/hour) since the last fueling.

Automatically calculated as:

Total Fuel Cost / Difference Hourmeter

Hours/ Amount *

The number of hours to the gallon since the last fueling. Automatically calculated as:

Hourmeter Difference / Fuel Amount

Avg Hours/Amount *

The number of hours to the gallon for the last X number of fuelings. Automatically calculated by averaging the Hours/Amount fields for the last X number of fuelings.

  • X - The number of historical fuelings to use is set in the General Options > Number of records used averaging fueling metrics option.
  • Records where the Days/Amount = null are skipped.

 

Other Meter Difference

Specifies another unit of measurement that passed between fuelings. Automatically calculated as:

Current Reading Other Meter - Previous Reading Other Meter

Cost Per Othermeter

Indicates the cost of fuel per other measurement to drive this vehicle (e.g., $0.55/unit) since the last fueling.

Automatically calculated as:

Total Fuel Cost / Difference Other Meter

Other Meter Amount *

The number of units to the gallon since the last fueling. Automatically calculated as:

Other Meter Difference / Fuel Amount

Avg Miles/Amount *

The number of units to the gallon for the last X number of fuelings. Automatically calculated by averaging the Hours/Amount fields for the last X number of fuelings.

  • X - The number of historical fuelings to use is set in the General Options > Number of records used averaging fueling metrics option.
  • Records where the Days/Amount = null are skipped.

* These fields are only calculated for newly added records.

* These field are only calculated for newly added records. To update historical records run the Calculate Fueling Averages Toolkits in the Fleet inventory grid.

Common Fields

Custom Fields

Lucity Web includes a variety of empty fields that an agency can customize to meet its needs. The number of custom fields available varies by module.

Custom fields can be designed as one of the following types:

Pick-List

Lets users select a value (code/type) from an agency-defined list.

Alphanumeric

Allows users to enter letters or numbers in any combination.

Check-box

Used to indicate yes/no or on/off.

Numerical

Accepts numbers only.

Date

Provides a pop-up calendar to enable the user to select a date.

Last Modified Fields

Last Modified By

The login ID of the last Lucity user to change the record.

Last Modified Date

The date that the record was last updated.

Last Modified Time

The time of day at which the record was last updated.