Data Model > Data Dictionary > S > SPM Scheduling Technician Utilization
SPM Scheduling Technician Utilization
Holds the Technician Utilization computed from Scheduling Engine on a daily basis.
API Label: SVMXC__SM_Scheduling_Technician_Utilization__c
No. of Fields: 21
Field Label
Field Name
Data Type
Description
Custom Relationship Fields
Dispatch Process Id
SVMXC__Dispatch_Process_Id__c
Lookup(ServiceMax Process)
Lookup to Servicemax Process.
JobId
SVMXC__JobId__c
Lookup(ServiceMax Job)
Lookup to Servicemax Jobs.
SPM Schedule Tech Utilization Constraints
SVMXC__SPM_Schedul_Tech_Utilization_Constraints__c
Master-Detail(SPM Schedul Tech Utilization Constraints)
Master-Details Relationship to SPM Schedul Tech Utilization Constraints table.
Technician
SVMXC__Technician__c
Lookup(Technician/Equipment)
Lookup to Technician.
Standard Fields
Record Number
Name
Auto Number
The auto-generated record number.
Custom Fields
Available Time
SVMXC__Available_Time__c
Number(4,0)
Holds the available time of the technician.
Break Minutes
SVMXC__Break_Minutes__c
Number(4,0)
Time during which the technician takes a Break.
Dispatch Process Name
SVMXC__Dispatch_Process_Name__c
Text(80)
Name of the Dispatch Process holding the scheduling configuration.
Drive Time
SVMXC__Drive_Time__c
Number(4,0)
Holds the sum of driven time before and driven time after values.
Horizon Date
SVMXC__Horizon_Date__c
Date
Date for which the utilization is computed.
Idle Time
SVMXC__Idle_Time__c
Formula (Number)
Holds the Idle time of the technician (blank spaces on the calendar).
Formula - (Available Time - Productive Time)
Job Execution Start Time
SVMXC__Job_Execution_Start_Time__c
Date/Time
Holds the start time of the scheduling job.
Non Productive Time Value
SVMXC__Non_Productive_Time_Value__c
Number(4,0)
Holds the Non-Productive Time of the technician.
Non Work Order Events Time
SVMXC__Non_Work_Order_Events_Time__c
Number(4,0)
Sum of duration of non work-order events.
Overhead Time
SVMXC__Overhead_Time__c
Number(4,0)
Holds the overhead time taken before and after the work is performed.
Productive Time
SVMXC__Productive_Time__c
Number(4,0)
Holds the sum of productive time.
Service Team
SVMXC__Service_Team__c
Text(80)
Technician Team.
Service Time
SVMXC__Service_Time__c
Number(4,0)
Holds the sum of differences of event duration with drive time.
Territory
SVMXC__Territory__c
Text(80)
Technician's Territory.
Utilization %
SVMXC__Utilization__c
Formula (Number)
Holds the utilization of the technician for the day.
Working Minutes
SVMXC__Working_Minutes__c
Number(4,0)
This is computed from Technician's Working Hours Field. If empty then we consider Territory Business Hours. If Territory Business Hours is also empty then we consider Company's Business Hours.
Was this helpful?