|
Field Name
|
Data Type
|
|---|---|
|
Dispatch Process Name
|
STRING
|
|
Horizon End Date
|
DATE
|
|
Horizon Start Date
|
DATE
|
|
JobId
|
LOOKUP
|
|
Overall Drive Time
|
NUMBER(3,0)
|
|
Overhead time
|
NUMBER(3,0)
|
|
Preferred Technician
|
NUMBER(3,0)
|
|
Priority1
|
STRING
|
|
Priority2
|
STRING
|
|
Priority3
|
STRING
|
|
Priority4
|
STRING
|
|
Processed Work Orders Count
|
NUMBER(5,0)
|
|
Product Specialization
|
NUMBER(3,0)
|
|
Qualified Technician
|
NUMBER(3,0)
|
|
Record Number
|
STRING
|
|
Skill Match
|
NUMBER(3,0)
|
|
SLA
|
NUMBER(3,0)
|
|
Submitted Work Orders Count
|
NUMBER(5,0)
|
|
Technician Eligibility
|
NUMBER(3,0)
|
|
Technicians Count
|
NUMBER(5,0)
|
|
Total Events Count
|
NUMBER(5,0)
|
|
Travel Cost
|
NUMBER(3,0)
|
|
Utilization %
|
FORMULA
|
|
Utilization Count
|
ROLL-UP SUMMARY
|
|
Utilization Sum
|
ROLL-UP SUMMARY
|