Daily Travel Time

As a second step, the scheduled job “Process Employee location Track” groups employee travel time records based on user, screen_name, equipment_type and date, consolidates and writes to Daily 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 in a day
• Screen Name: WMS Screen that was used by employee during this travel
• Mode of Travel: Equipment that was used during travel
• Total Travel Time: The total time traveled by the employee for a specific transaction in a day (Note: If travel time on all transactions in a set is 0 in Employee Travel Time, total travel time for that transaction is 0)
• Total Nbr of Traveled Locations: Total nbr of locations scanned by the employee while using a specific transaction in a day