On Time Arrival Metric

The On Time Arrival metric tracks how often a vendor is onsite for a work order within the set SLA of their Purchase Order. 

Purpose / Metric Definition:

Measures whether the first trip’s scheduled on-site date occurs on or before the priority expected first trip date (per the Purchase Order).

Category:

Performance

Logic / Formula:

CASE WHEN Trips.FirstOnsiteDate <= PO.priority_firsttripdate
      THEN 1
      ELSE 0
END AS Performance_OnTimeArrival

Scoring Rules:

• 100% → First On-Site Date is on or before expected priority date.

• 0% → First On-Site Date is after expected priority date.

• Not Scored → No completed trips tied to the Purchase Order.

Links to Dashboards/Reports that use this metric:

• Vendor Scorecard