SPM Scheduling Technician Utilization

Analytics and Dashboards > Schedule Optimization Metrics > Drive Time > Metrics Calculation > SPM Scheduling Technician Utilization

SPM Scheduling Technician Utilization records are created from Scheduling Event Summary records associated with the selected / latest Schedule Optimization job(s).

One SPM Scheduling Technician Utilization record is created per technician per day for a specific job run, with JobId, Technician, and Horizon Date fields as the composite primary key. Important mapping details related to total Drive Time metric per technician per day, apart from the other technician utilization metrics are as follows:

Target Field	Value Derived From
Dispatch Process Id	JobId > SVMX Process > Process Number
Dispatch Process Name	JobId > SVMX Process > Name
Drive Time	Sum of technicians’ drive time including the before and after drive time
Horizon Date	Calculated based on JobId > SVMX Process > Planning Time Horizon configuration, as processed by the Schedule Optimization engine
Territory	JobId > Territory > Name

Once a target record is created, there are no overrides and no re-examination. This means that if a target record exists for a job already, it is not updated and that job is not processed again.