Fleet Fueling Fields

The fields described below have special functions. For a complete list of available fields, see the Lucity 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.