|
Field Name
|
Data Type
|
|---|---|
|
Available Time
|
NUMBER(4,0)
|
|
Break Minutes
|
NUMBER(4,0)
|
|
Dispatch Process Id
|
LOOKUP
|
|
Dispatch Process Name
|
STRING
|
|
Drive Time
|
NUMBER(4,0)
|
|
Horizon Date
|
DATE
|
|
Idle Time
|
FORMULA
|
|
Job Execution Start Time
|
DATETIME
|
|
JobId
|
LOOKUP
|
|
Non Productive Time Value
|
NUMBER(4,0)
|
|
Non Work Order Events Time
|
NUMBER(4,0)
|
|
Overhead Time
|
NUMBER(4,0)
|
|
Productive Time
|
NUMBER(4,0)
|
|
SPM Schedule Tech Utilization Constraints
|
MASTER-DETAIL
|
|
Record Number
|
STRING
|
|
Service Team
|
STRING
|
|
Service Time
|
NUMBER(4,0)
|
|
Technician
|
LOOKUP
|
|
Territory
|
STRING
|
|
Utilization %
|
FORMULA
|
|
Working Minutes
|
NUMBER(4,0)
|