1. WFM User Guide
  2. Employee Travel Time

Employee Travel Time

As a first step, the scheduled job “Process Employee location Track” checks the validity of each record in employee location track. If a record has invalid location barcode (not configured in WMS) OR if the both the location barcode and XYZ co-ordinates are missing on the record, such records are marked as "Ignored" and not processed.

Rest of the valid records are grouped by user, screen_name, and equipment_type ensuring that there is no other user activity in between the tracked timestamp of the records. Each group is consolidated and written to Employee Travel Time with the First Tracked Timestamp corresponding to the first record in the consolidated set and the Last Tracked Timestamp corresponding to the last record in the consolidated set.

Records that have been successfully consolidated and written to Employee Travel Time are marked as processed in Employee Location Track.

Note that the last set of consecutive records in Employee Location Track are not processed until 24 hours have passed. This is to ensure that no new records that belong to this set are written after the scheduled job has been run.

Other User Activity

An employee is said to have other activity between two consecutive location track records with same screen name and equipment type, if there is any of the following record for the employee between the tracked timestamp of the two records:

  • Clock in or clock out activities
  • Login or log out of handheld transactions or WMS browser app
  • A transaction performed in handheld that is different than the transaction (screen_name) on the employee location track records

Employee Travel Time

Some of the key fields in this view are listed below:

  • User: Employee whose travel time has been calculated for a specific transaction
  • Screen Name: WMS Screen that was used by employee during this travel
  • Mode of Travel: Equipment that was used during travel
  • First Tracked Timestamp: Timestamp when the first location was scanned during transaction
  • Last Tracked Timestamp: Timestamp when the last location was scanned during transaction
  • Travel Time: Total travel time by the employee based on first and last location scan during transaction (Note: If nbr of traveled locations is 1, travel time is 0)
  • Nbr of Traveled Locations: Nbr of locations scanned by the employee during the transaction