Create a TeleRoute Activity Report

Description

Explains how to generate a report of data from the drivers' TeleRoute mobile app.

Before You Begin

You must have a license for AVS and at least 1 TeleRoute truck. You also need either the Routing or Container Tracking modules, depending on whether your drivers do present trash routes or on-call roll-off work (or both).

Context

Companies use the TeleRoute app in different ways and consequently might need a wide variety different information. This report is meant to be comprehensive, covering all the available data that tablets and phones send back to Trash Flow. It is rare that you would run this report with all available options.

Steps to follow

  1. Use the usual filtering options to choose which customer accounts will be included (Account Type, Billing Group, etc.).
  2. This report has some additional filtering options so if desired you can choose only activities from a given Customer, Driver, Truck, Route, Fuel Station , or Landfill.
  3. Click Show Activities and choose Multiple. The report will include any activities that are checked; you may want to click Clear All and check off only the items you are looking for.
  4. Check Include only w/ picture and/or Include only w/ Note if you are just looking for those driver activities.
  5. Set the Start Date and End Date that you want.
  6. Choose whether you want to Sort by Truck, Driver, Route, Landfill, or Customer.
  7. Check Show Addresses if you want customer addresses to be included in the report.
  8. Choose whether the format should be a standard printout or an Export to CSV. The latter will create a comma-separated value (CSV) file to be opened by a spreadsheet program. (See below for a list of available fields.)
  9. Click OK to review and print.

When you're done

For each activity the PDF will show the date and time, driver, and truck; the route or work order number with the name of the activity; the customer name and account number; the customer address (if that option was selected); and any associated note. If you created a CSV the columns will show the data you selected earlier.

List of TeleRoute activities

Most of these are self-explanatory but in the interest of completeness a list is provided below. Note that most companies do not use all the available activities.

  • Landfill: The truck dumped at a landfill.
  • Pick Up: A customer's trash was picked up as usual.
  • Trash Not Out: Customer's trash was not out to be picked up.
  • Route Start/Stop: The driver started or finished running a route.
  • Extra Trash: The customer left out extra trash.
  • Dumpster Blocked: The driver couldn't get to the container.
  • Stop Skipped: A way for the driver to acknowledge that they are not picking up a customer's trash this week (usually because they were suspended for nonpayment).
  • Route Image: The driver took a picture with their tablet/phone.
  • Fuel Stop: The driver fueled up the truck.
  • Break: The driver took a break.
  • Breakdown: The truck broke down.
  • Log In/Out: The driver logged in or out of the TeleRoute mobile app.
  • WO Start: The driver started to perform an assigned work order.
  • WO Pause: The driver had to pause work on their current job.
  • WO Resume: The driver got back to a work order that had been previously charged.
  • WO Complete: The driver finished a work order.
  • WO Picture: The driver took a picture to be saved with the work order.
  • WO Note: The driver added a note about the work order.
  • WO Cont Changed: The driver swapped a container.
  • WO Reopen: The driver reopened a work order that had previously been marked as complete.
  • WO Pull From Yard: The driver picked up a container.
  • WO Cont Dropped: The driver dropped a container at the customer site.
  • WO Cont Serviced: The driver dumped a container.
  • WO Placed In Yard: The driver dropped a container back in the yard.
  • Move After Prev Stop: The driver wants to move the position of a customer along the route.

List of CSV options

Most of these are self-explanatory but a full list is provided below if needed.

  • Date: The date and timestamp.
  • Driver: The driver who recorded the activity.
  • Truck: The truck that was chosen when the driver logged in.
  • Routes/WOs: Any associated route name OR work order number.
  • Activity: The activity (Picked Up, Trash Not Out, Container Changed, etc.).
  • Customer Info: The customer's name and account number.
  • Landfill Info: The landfill ticket number, price, net weight, unit of measure (usually yards or tons), and location.
  • Fuel Stop Info: The number of gallons, cost, and odometer reading recorded during a fuel stop.
  • Address: The customer address.
  • Note: Any note added by the driver.
  • Activity Moved: Indicates whether someone in the office moved an activity from one account to another.
  • Exception Data: If the activity was included in the exception list this will indicate any notes added and who marked the exception as processed.
  • Stop #: The route stop number, if any.
  • Extra Trash: The driver recorded extra trash at the route stop.
  • Status Columns: When the driver logged in and logged out, work order start and complete, arrived/left the landfill, fuel quantity, and odometer reading.
  • Rates: Descriptions and rates from the customer's Rates tab.

Further resources

Preparing for TeleRoute

Running a Missed Stops Report