Mileage and TCR Map

Modified on Mon, Feb 26 at 3:59 AM

TABLE OF CONTENTS


Mileages

Mileages are a new feature in Time Keeping. This tool illustrates mileage that Employees have driven in a working day, moving between locations and sites.




Mileage in Time Card

You can see summary mileage information on the main tab of the Time Card.


Administrator Tools

Mileage usage is set in the system constant “TOCalculateMileage”. “True” value of the constant switches on mileage calculation during Time Keeping Processing and displaying mileage tools in TCR Interface map. 

“TKCalculateMileage” script
 is Administrator’s tool to calculate mileage in Time Cards on selected period.






How we calculate mileage

As we mention before, mileage is a drive between 2 stop points. But you will remember, stops can occur in the different places: on Sites, at Locations, stops in unknown place. We use only stops in the following points to simplify logic of mileage calculation:

  1. On Site, that is Time Entry with filled Site.
  2. At Location. It is Time Entry with filled Location and empty Site.
  3. GEO points we have taken with clock-in/clock-out. There are several types of clock in/out GEO point. 
    1. Clock in/out coordinates (LAT, LNG).
    2. Last known GEO point after clock-in or before clock-out (Closest LAT, Closest LNG).

We store coordinates of these points in Time Entries Reference. Requisites LAN, LNG, Closest LAT, etc. are not shown on the TE Card, they are available only through the list of reference records.

      4. Coordinates of Time Entry with Event “Stop” and Cost Type “On Site”, but with empty Location and Site.


Hereafter, we name these stop points as defining points. Defining points are the distance reference point (starting points in mileage).

Every day, the FCX System runs Time Keeping Processing to manage Time Cards data. During this process, the system creates Time Entries. Time Entries illustrate the Employee's daily activity in chronological sequence, where the employee was during that time. That way, basing on Time Entry details, we can count mileage:

Значок 1We iterate over Time Entries from the start of the day one by one.

ЗначокTake location coordinates of the first stop point.

Значок 3Take location coordinates of the next defining point.

Значок 4If time gap between points (TEs) is more than 1 minute, and they are not at the same place, then calculate mileage between these 2 location coordinates of TEs. Otherwise, if the time gap is less than 1 minute, then go to the 3rd step.

Значок 5Find coordinates of next defining point (third) and count mileage between second and third point.

Значок 6And so on until the last point is obtained.


Mileage for overnight Dispatches. We calculate and add overnight mileage on the map for the current day:

  1. Capture coordinates of last known defining point for the previous day
  2. Take location coordinates of the first defining point for the current day
  3. Calculate mileage between these points. 

We use MapQuest tools for counting mileage. It means, that MapQuest mechanism lays the fastest route from one point to another point.


Let see how we calculate mileage.





TCR Interface Map

The map functionality is presented in the pictures below. We display all Time Entries in the time bar: Lunch, Check In, No Data, etc.





MAP





GPS Timeline


TIPS
To open a large image right-click on the image and select “Open image in new tab”.





Adjustments 

TC Adjustment tool integrated into the TC Review map — a quick way to review the employee's day log on the map and adjust it. Read more about this tool here.


 

 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article