Custom Report Dataviews

Overview

You may want to know which category and dataview you need to select when creating a custom report to retrieve specific data (e.g, workers and alerts, gps and stops, etc.). 


 

Information

All the available categories and dataviews, including the columns that can be selected, are described below. Some categories have only one dataview (with the same name), other categories have more than 10 dataviews. 

Here is a short list of categories and dataviews. Use Ctrl+F to find all dataviews containing data for the required feature (e.g., job, form, alert, etc.; only high-level features are searchable in this article) and review available columns in the Dataview Details section.

  • Company
  • Devices
  • Forms
    • Public Forms Responses
  • Geofence
  • Jobs
    • Jobs
    • Jobs and Jobs Details
    • Jobs, Job Details, Job Actions, and Job Forms
    • Jobs, Job Details and Job Actions
    • Jobs Summary by Worker
    • Job Details
    • Invoice Report
  • Location Types
  • Locations
    • Location average stop duration
    • Locations
  • Login Timesheet Shifts and Breaks
  • Mileage
    • Mileage Trip Summary
    • Mileage Trip Details
  • Stops
    • Stops
    • GPS and Stops
    • Location Stop Report
    • Stops & Travel
    • Timesheet Detail with Stops Summary
  • Timesheets
    • Timesheet Daily Summary
    • Timesheet Detail
    • Timesheet Weekly with Stops Summary
    • Timesheets Weekly Summary
    • Worker Daily Timesheet
    • Timesheet Detail Location
    • Timesheet & Forms
    • Closed Shift Summary
  • Workers
    • Alert Report
    • Customer Report Card
    • Fleet Trip Report
    • GPS and Activity
    • Mission Control Login Report
    • Worker Activity Log Report
    • Worker and Ad Hoc Forms
    • Worker Detail Report
    • Workers
    • Workers and Alerts
    • Workers and Devices
    • Workers and Errors
    • Workers and GPS
    • Workers and Job Forms
    • Workers and Stops/Travel
    • Workers and User Actions
    • Workers, Stops/Travel and User Actions
  • Workers and Jobs
    • Workers and Jobs
    • Workers, Jobs, and Job Details
    • Workers, Jobs, Job Details and Job Actions
    • Jobs and Shifts

Dataview Details

  • Company dataview includes the following columns:

    mceclip7.png

  • Devices dataview includes the following columns:

    mceclip8.png

  • Forms > Public Forms Responses dataview includes the following columns:

    mceclip9.png

  • Geofence includes the following columns:

    mceclip10.png

  • Jobs
    • Jobs dataview includes the following columns:

      mceclip2.png

    • Jobs and Jobs Details dataview includes the following columns:

      mceclip1.png

    • Jobs, Job Details, Job Actions, and Job Forms dataview includes the columns from the above dataview plus the following columns:

      mceclip3.png

    • Jobs, Job Details and Job Actions dataview includes the same columns as the Jobs and Jobs Details dataview plus the following columns:

      mceclip4.png

    • Jobs Summary by Worker dataview includes the following columns:

      mceclip5.png

    • Job Details dataview includes the following columns:

      job_details.png

    • Invoice Report dataview includes the following columns:

      mceclip6.png

  • Location Types dataview includes the following columns:

    mceclip11.png

  • Locations
    • Location average stop duration dataview includes the following columns:

      mceclip12.png

    • Locations dataview includes the following columns:

      mceclip13.png

  • Login Timesheet Shifts and Breaks dataview includes the following columns:

    mceclip14.png

  • Mileage
    • Mileage Trip Summary dataview includes the following columns:

      mceclip15.png

    • Mileage Trip Details dataview includes the following columns:

      mceclip16.png

  • Stops
    • Stops dataview includes the following columns:

      mceclip17.png

    • GPS and Stops dataview includes the following columns:

      mceclip18.png

    • Location Stop Report dataview includes the following columns:

      mceclip19.png

    • Stops & Travel dataview includes the following columns:

      mceclip20.png

    • Timesheet Detail with Stops Summary dataview includes the following columns:

      mceclip21.png

  • Timesheets
    • Timesheet Daily Summary dataview includes the following columns:

      mceclip22.png

    • Timesheet Detail dataview includes the following columns:

      mceclip23.png

    • Timesheet Weekly with Stops Summary dataview includes the following columns:

      mceclip24.png

    • Timesheets Weekly Summary dataview includes the following columns:

      mceclip25.png

    • Worker Daily Timesheet dataview includes the following columns:

      mceclip26.png

    • Timesheet Detail Location dataview includes the following columns:

      mceclip27.png

    • Timesheet & Forms dataview includes the following columns:

      mceclip28.png

    • Closed Shift Summary dataview includes the following columns:

      mceclip29.png

  • Workers
    • Alert Report dataview includes the following columns:

      mceclip34.png

    • Customer Report Card dataview includes the following columns:

      mceclip35.png

    • Fleet Trip Report dataview includes the following columns:

      mceclip36.png

    • GPS and Activity dataview includes the following columns:

      mceclip37.png

    • Mission Control Login Report dataview includes the following columns:

      mceclip38.png

    • Worker Activity Log Report dataview includes the following columns:

      mceclip39.png

    • Worker and Ad Hoc Forms dataview includes the following columns:

      mceclip40.png

    • Worker Detail Report dataview includes the following columns:

      mceclip41.png

    • Workers dataview includes the following columns:

      mceclip42.png

    • Workers and Alerts dataview includes the following columns:

      mceclip43.png

    • Workers and Devices dataview includes the following columns:

      mceclip44.png

    • Workers and Errors dataview includes the following columns:

      mceclip45.png

    • Workers and GPS dataview includes the following columns:

      mceclip46.png

    • Workers and Job Forms dataview includes the following columns:

      mceclip47.png

    • Workers and Stops/Travel dataview includes the following columns:

      mceclip48.png

    • Workers and User Actions dataview includes the following columns:

      mceclip50.png

    • Workers, Stops/Travel and User Actions dataview includes the following columns:

      mceclip51.png

  • Workers and Jobs
    • Workers and Jobs dataview includes the following columns:

      mceclip30.png

    • Workers, Jobs, and Job Details dataview includes the columns from the above data view plus the following columns:

      mceclip31.png

    • Workers, Jobs, Job Details and Job Actions dataview includes the columns from the two previous dataviews plus the following columns:

      mceclip32.png

    • Jobs and Shifts dataview includes the following columns:

      mceclip33.png

 

Back to top

Comments

0 comments

Article is closed for comments.