| Service Information |
|
Work Order Number
|
Unique tracking number for this specific dispatch job.
|
|
Service Date
|
Scheduled calendar date the service was processed.
|
|
Year Month
|
Format YYYY-MM derived from the service date for easy monthly sorting.
|
|
Route Name
|
Name or operational designation of the collection route.
|
|
Route Status
|
The state of the overall route.
|
|
Downtime Incident
|
Flags ’Yes’ if an incident or delay occurred on this route.
|
|
Service Code Name
|
The text identifier of the operational activity being performed.
|
|
Driver ID
|
The system's unique identification number for the driver.
|
|
Driver Name
|
Full name of the vehicle operator.
|
|
Hours Worked
|
Total calculated payroll hours for the day.
|
|
Status In Progress User ID
|
User ID who marked the work order as "In Progress."
|
|
Status In Progress User
|
Name of the user who moved the order to "In Progress."
|
|
Status In Progress Timestamp
|
System date and time when route work commenced.
|
|
Status Completed User Id
|
User ID who finalized the work order status.
|
|
Status Completed Timestamp
|
System date and time when the stop was submitted completed.
|
|
Truck Name
|
The truck identifier/unit number used to complete the route.
|
|
Truck Type
|
The classification group of the vehicle.
|
|
Equipment Id
|
ID of the container or device assigned to the work order.
|
|
Equipment Name
|
Description of the equipment type.
|
| Account and Site Information |
|
Account ID
|
Unique ID for the customer account.
|
|
Account Name
|
Name of the customer account associated with the service or disposal activity.
|
|
Site ID
|
Unique ID for the location where service occurred.
|
|
Site Name
|
Name of the location where service occurred.
|
|
Service Address Line1
|
Street address block 1 of the service site.
|
|
Service Address Line2
|
Suite, unit, or auxiliary descriptor.
|
|
Service City
|
City associated with the physical service site.
|
|
Service State
|
State or province code.
|
|
Service Postalcode
|
ZIP or postal code.
|
|
Site Latitude
|
Latitude of the site.
|
|
Site Longitude
|
Longitude of the site.
|
|
Service Point Latitude
|
Latitude of the service area.
|
|
Service Point Longitude
|
Longitude of the service area.
|
|
Service Completion Datetime
|
Timestamp when the driver pressed complete.
|
|
Service Completion Latitude
|
Latitude at the moment of completion.
|
|
Service Completion Longitude
|
Longitude at the moment of completion.
|
| Incentive Calculation Factors |
|
Helper Used
|
Displays “Yes” if an assistant or helper was linked to the route record.
|
|
Incentive Effective Date
|
The date matching the active multipliers, as specified in the Driver Incentive Factor Setup table.
|
|
Service Level Factor
|
Multiplier assigned to the service code.
|
|
Truck Type Factor
|
Multiplier associated with operating that vehicle class.
|
|
Helper Factor
|
Multiplier applied when a helper shares the workload.
|
|
Distance Ft
|
Distance (in feet) between target location and driver GPS completion coordinates.
|
|
Distance Bucket
|
Categorization based on stop accuracy:
- B1 = ≤ 250ft
- B2 = ≤ 500ft
- B3 = ≤ 1000ft
- B4 = > 1000ft or missing coordinates
|
|
Distance Grade Pct
|
Performance ratio
- 1.00 for exactness
- 0.00 for missing/distant stops
|
|
Incentive Score
|
Calculated performance metric computed as:
Distance Grade Pct x Service Level Factor x Truck Type Factor x Helper Factor (if applicable)
|
