Table “Clients”:

Field name Description

Table “enums”:
Field name Description
shiftdate Date of shift for which this enum entry was loaded
shiftindex Index of shift for which this enum entry was loaded
cliID Numeric client identifier
enumname Name of enumeration group. Matches the name of the
enumeration in Dispatch. For example, the enum LOAD in
Dispatch lists all the material types. This field contains the
text “LOAD” for all material type enumerations
num Number of this enumeration entry
name Full name of this enumeration entry
abbrev Abbreviated name of this enumeration entry
flags Flags associated with this enumeration entry

Table “hist_dumps”:
Field name Description
shiftindex Index of shift within which this dump occurred
cliID Numeric client identifier
ddbkey Unique dump record identifier within export database
truck Name of truck that dumped
loc Name of location where dump occurred
grade Name of material grade that was dumped
excav Name of excavator that loaded the truck
blast Name of location from which material was taken
bay Name of the bay that received the material
measureton Amount of material as measured by the truck weigh system
timearrive Time of arrive at the dump (seconds into the shift)
timedump Time of the start of dump (seconds into the shift)
timeempty Time of end of dump (seconds into the shift)
timedigest Crusher digest time
calctravti Expected (calculated) traveltime to the dump
load Material type
extraload Non zero if dump was added manually
lift_up Uphill lift distance traveling to dump
lift_down Downhill lift distance traveling to dump
liftdist_u Uphill distance traveling to dump
liftdist_d Downhill distance traveling to dump
dist Total distance traveled to dump
efh Equivalent flat haul distance to dump
loadtype Non zero if this was a trammed dump
dumptons Amount of material based on load factor configuration
shiftlink Dispatch dump record identifier within shift database
dumpid Sequential number of dump within shift
oper Name of truck operator
eoper Name of excav operator
idletime Time truck was queued at dump
loadnumber Sequential number of associated load within shift
dumpingtim Time truck was actually dumping
val_dmp Non zero if the dumping time falls within the valid range
idmp Non zero if this dump was interrupted by a status change
hos The hour of shift within which this dump falls. Starts at ‘0’
intvl The interval identifier within the hour in “00:nn:00” format

Table “hist_eqmtlist”:
Field name Description
shiftindex Index of shift with which this entry is associated
cliID Numeric client identifier
ddbkey Unique record identifier within the export database
eqmtid Equipment name
pit The optional pit with which this equipment is associated
size Haul capacity of this equipment
unit# Numeric unit type of equipment. Unit types are listed in the
UNIT enumeration
unit String unit type of equipment.
eqmttype# Numeric equipment type. Equipment types are listed in the
QUALIF enumeration
eqmttype String unit type of equipment
extraload# Non zero if equipment manually added to shift
extraload Non zero if equipment manually added to shift
trammer Non zero if this equipment has trammed a load during this
shift

Table “hist_eqtmcat”:
Field name Description
shiftindex Index of shift with which this record is associated
cliID Numeric client identifier
ddbkey Unique record identifier within export database
eqmtid Name of equipment this entry is associated with
unit Numeric unit type as enumerated in UNIT enum
hos Hour into the shift for which this entry applies
intvl Interval identifier for which this entry applies
tmcat00 Total time in this interval period
tmcat01 Total time spent in time category 1 in this interval period
tmcat02 Total time spent in time category 2 in this interval period
tmcat03 Total time spent in time category 3 in this interval period
tmcat04 Total time spent in time category 4 in this interval period
tmcat05 Total time spent in time category 5 in this interval period
tmcat06 Total time spent in time category 6 in this interval period
tmcat07 Total time spent in time category 7 in this interval period
tmcat08 Total time spent in time category 8 in this interval period
tmcat09 Total time spent in time category 9 in this interval period
tmcat10 Total time spent in time category 10 in this interval period
tmcat11 Total time spent in time category 11 in this interval period
tmcat12 Total time spent in time category 12 in this interval period
tmcat13 Total time spent in time category 13 in this interval period
tmcat14 Total time spent in time category 14 in this interval period
tmcat15 Total time spent in time category 15 in this interval period
tmcat16 Total time spent in time category 16 in this interval period
tmcat17 Total time spent in time category 17 in this interval period
tmcat18 Total time spent in time category 18 in this interval period
tmcat19 Total time spent in time category 19 in this interval period

Table “hist_exproot”:
Field name Description
shiftdate Date stamp of this shift
cliID Numeric client identifier
ddbkey Unique record identifier within export database
shiftindex Numeric index of this shift
name Verbose name of this shift in the standard client specific
format and language
year Last 2 digits of the year
month# Numeric month as enumerated in the MONTH enum
month Abbreviated name of month as enumerated in the MONTH
enum
day Day of the month
shift# Numeric shift as enumerated in the SHIFT enum
shift Name of shift
date Start of shift in seconds since 1970
start Start of shift relative to the start of the shift day
crew# Numeric crew as enumerated in the CREW enum
crew Name of crew
len Length of this shift in seconds
disptime Time into the shift. Can be less than the shift length if the
shift was not finished when the upload to Powerview
occurred
holiday Non zero if this shift was not a holiday as defined in
Dispatch configuration for the client
ddmmyy Another representation of shift date
finyear Financial year or other reporting period the client may
choose to use
finquarter Financial quarter or other reporting period the client may
choose to use
finmonth Financial month or other reporting period the client may
choose to use
finweek Financial week or other reporting period the client may
choose to use

Table “hist_fuelings”:
Field name Description
shiftindex Index of shift this record is associated with
cliID Numeric client identifier
ddbkey Unique record identifier in export database
fuelid Dispatch fuel event identifier within shift. Uses the time of
event and the equipment name
eqmt Equipment name
unit Equipment numeric unit type as enumerated in the UNIT
enum
timestart Start of this fueling event (seconds into shift)
timeend End of this fueling event as detected by Dispatch (seconds
into shift). Can be the same as “timestart” depending on
client practices and configuration
fuel00 Amount of fuel of type 0 taken. Fuel types are enumerated
in the FUEL enum
fuel01 Amount of fuel of type 1 taken
fuel02 Amount of fuel of type 2 taken
fuel03 Amount of fuel of type 3 taken
fuel04 Amount of fuel of type 4 taken
fuel05 Amount of fuel of type 5 taken
fuel06 Amount of fuel of type 6 taken
fuel07 Amount of fuel of type 7 taken
fuel08 Amount of fuel of type 8 taken
fuel09 Amount of fuel of type 9 taken
fuel10 Amount of fuel of type 10 taken
fuel11 Amount of fuel of type 11 taken
fuel12 Amount of fuel of type 12 taken
fuel13 Amount of fuel of type 13 taken
fuel14 Amount of fuel of type 14 taken
fuel15 Amount of fuel of type 15 taken
fuel16 Amount of fuel of type 16 taken
fuel17 Amount of fuel of type 17 taken
fuel18 Amount of fuel of type 18 taken
fuel19 Amount of fuel of type 19 taken

Table “hist_gradelist”:
Field name Description
shiftindex Index of shift for with which this entry is associated
cliID Numeric client identifier
ddbkey Unique record identifier in export database
gradeid Name of grade
loc Name of digging location this grade is associated with
dump Name of dump location this grade is associated with
inv Remaining tonnage at of this grade type
grade00 Value for material grade type 0. Material grades are
enumerated in the GRADE enum
grade01 Value for material grade type 1
grade02 Value for material grade type 2
grade03 Value for material grade type 3
grade04 Value for material grade type 4
grade05 Value for material grade type 5
grade06 Value for material grade type 6
grade07 Value for material grade type 7
grade08 Value for material grade type 8
grade09 Value for material grade type 9
grade10 Value for material grade type 10
grade11 Value for material grade type 11
grade12 Value for material grade type 12
grade13 Value for material grade type 13
grade14 Value for material grade type 14
grade15 Value for material grade type 15
grade16 Value for material grade type 16
grade17 Value for material grade type 17
grade18 Value for material grade type 18
grade19 Value for material grade type 19
grade20 Value for material grade type 20
grade21 Value for material grade type 21
grade22 Value for material grade type 22
grade23 Value for material grade type 23
grade24 Value for material grade type 24
spgr Specific gravity of material of this grade
load# Numeric material type as enumerated in LOAD enum
load Material type name
blend# Numeric blend type as enumerated in BLEND enum
blend Blend type name

Table “hist_gradelist_by_gradeparam”:
Field name Description
shiftindex Index of shift this record is associated with
cliID Numeric client identifier
gradeid Name of grade
gradeparam Numeric grade type as enumerated in GRADE enum
grade Value of material grade for this type

Table “hist_loads”:
Field name Description
shiftindex Index of shift this load record is associated with
cliID Numeric client identifier
ddbkey Unique record identifier in export database
truck Name of truck
excav Name of excavator
grade Name of grade of material
loc Name of location at which truck was loaded
dumprec Unique associated dump record identifier in dispatch shift
database
measureton Amount of material loaded as measured by weigh system
timearrive Time of arrive at the excavator (seconds into shift)
timeload Time of load start (seconds into shift)
timefull Time of load end (seconds into shift)
ctrteh Calculated (expected) travel time to loading location
(seconds)
ctrtfh Calculated (expected) travel time to dumping location
(seconds)
atrteh Actual travel time to loading location (seconds)
atrtfh Actual travel time to dumping location (seconds)
load Numeric material type as enumerated in LOAD enum
extraload Non-zero if this load was added manually
lift_up Total change in elevation going uphill to load location
lift_down Total change in elevation going downhill to load location
liftdist_u Total distance traveled going uphill to the load location
liftdist_d Total distance traveled going downhill to load location
disteh Total distance traveled from previous dump to load location
distfh Toal distance traveled from load location to dump
efheh Equivalent flat haul for empty haul travel
efhfh Equivalent flat haul for full haul travel
loadtype Non-zero if trammed load
loadtons Amount of material hauled, based on load factor
configuration for client
shiftlink Unique identifier for load record in dispatch shift database
oper Name of truck operator
eoper Name of excavator operator
beginspot Time of start of spot (seconds into shift)
queuetime Operating time truck spent queuing (seconds)
spottime Operating time spent spotting (seconds)
loadingtim Operating time spent loading the truck (seconds)
fullhaul Operating time spent traveling full to dump
dumptime Operating time spent dumping
emptyhaul Operating time spent traveling from previous dump to load
location
hangtime Operating time excavator was waiting for truck
excavnextl Number of next load for excavator
excavprevl Number of previous load for excavator
loadnumber This load number. Unique within this shift
val_sp Non-zero if spot time is within range
val_ld Non-zero if load time is within range
val_mt Non-zero if measured payload is within range
val_spld Non-zero if spot and load times are within range
val_spldmt Non-zero if spot, load times and payload is within range
val_ehaul Non-zero if empty travel time is within allowable deviation
from expected time
val_fhaul Non-zero if full haul time is within allowable deviation from
expected time
ot Non-zero if truck had to queue at excavator. This represents
an over-trucked situation
ut Non-zero fi excavator was waiting for truck. This represents
an under-trucked situation
isp Non-zero if spot time was interrupted by a status change of
either truck or excavator
ild Non-zero if loading time was interrupted by a status change
 of either truck of excavator
ifh Non-zero if full haul time was interrupted by a status change
of the truck
ieh Non-zero if empty travel time was interrupted by a status
change of the truck
dmp Non-zero if there is an associated dump record
tk_tmcat00 Total cycle time for truck, associated with this load. A truck
cycle starts at the previous dump when the truck becomes
available (e.g. gets assigned to an excavator) and ends
when the truck finishes dumping
tk_tmcat01 Total time within this current cycle truck spent in time
category 1. Time categories are enumerated in the
TIMECAT enum
tk_tmcat02 Total time within this current cycle truck spent in time
category 2
tk_tmcat03 Total time within this current cycle truck spent in time
category 3
tk_tmcat04 Total time within this current cycle truck spent in time
category 4
tk_tmcat05 Total time within this current cycle truck spent in time
category 5
tk_tmcat06 Total time within this current cycle truck spent in time
category 6
tk_tmcat07 Total time within this current cycle truck spent in time
category 7
tk_tmcat08 Total time within this current cycle truck spent in time
category 8
tk_tmcat09 Total time within this current cycle truck spent in time
category 9
tk_tmcat10 Total time within this current cycle truck spent in time
category 10
tk_tmcat11 Total time within this current cycle truck spent in time
category 11
tk_tmcat12 Total time within this current cycle truck spent in time
category 12
tk_tmcat13 Total time within this current cycle truck spent in time
category 13
tk_tmcat14 Total time within this current cycle truck spent in time
category 14
tk_tmcat15 Total time within this current cycle truck spent in time
category 15
tk_tmcat16 Total time within this current cycle truck spent in time
category 16
tk_tmcat17 Total time within this current cycle truck spent in time
category 17
tk_tmcat18 Total time within this current cycle truck spent in time
category 18
tk_tmcat19 Total time within this current cycle truck spent in time
category 19
ex_tmcat00 Total cycle time for excavator associated with this load. The
cycle for an excavator starts when the previous truck is
kicked out and ends with the kicking out of the current truck
ex_tmcat01 Total time within this current cycle excavator spent in time
category 1
ex_tmcat02 Total time within this current cycle excavator spent in time
category 2
ex_tmcat03 Total time within this current cycle excavator spent in time
category 3
ex_tmcat04 Total time within this current cycle excavator spent in time
category 4
ex_tmcat05 Total time within this current cycle excavator spent in time
 category 5
ex_tmcat06 Total time within this current cycle excavator spent in time
category 6
ex_tmcat07 Total time within this current cycle excavator spent in time
category 7
ex_tmcat08 Total time within this current cycle excavator spent in time
category 8
ex_tmcat09 Total time within this current cycle excavator spent in time
category 9
ex_tmcat10 Total time within this current cycle excavator spent in time
category 10
ex_tmcat11 Total time within this current cycle excavator spent in time
category 11
ex_tmcat12 Total time within this current cycle excavator spent in time
category 12
ex_tmcat13 Total time within this current cycle excavator spent in time
category 13
ex_tmcat14 Total time within this current cycle excavator spent in time
category 14
ex_tmcat15 Total time within this current cycle excavator spent in time
category 15
ex_tmcat16 Total time within this current cycle excavator spent in time
category 16
ex_tmcat17 Total time within this current cycle excavator spent in time
category 17
ex_tmcat18 Total time within this current cycle excavator spent in time
category 18
ex_tmcat19 Total time within this current cycle excavator spent in time
category 19
hos Hour into the shift that this load occurred at. The time used
to determine this is the time that the truck was kicked out
intvl Interval into the hour that this load should be associated
with, formatted as “00:mm:00:

Table “hist_loclist”:
Field name Description
shiftindex Index of shift this record is associated with
cliID Numeric client identifier
ddbkey Unique record identifier in export database
locid Name of this location
pit Name of the pit this location is associated with
region Name of region this location is associated with
elev Elevation of this location
unit# Numeric unit type of location. Unit type is enumerated in the
UNIT enum
unit Name of location unit type

Table “hist_operlist”:
Field name Description
shiftindex Index of shift this record is associated with
cliID Numeric client identifier
ddbkey Unique record identifier in export database
operid Operator identifier
name Full operator name
crew# Numeric crew as enumerated in the CREW enum
crew Name of crew this operator is a member of

Table “hist_opertot”:
Field name Description
shiftindex Index of shift this record is associated with
cliID Numeric client identifier
ddbkey Unique record identifier in export database
eqmtid Equipment name
logintime Time of operator login (seconds into shift)
locid Name of location the operator logged in at
operid Operator login id
name Operator name
totaltime Total time spent logged in
pit Pit associated with the location the operator logged in at
unit# Numeric equipment unit type as enumerated in the UNIT
enum
unit Equipment unit name
totalloads Total number of loads done by this operator during this
logon period
totaltons Total loadfactor tons produced by this operator during this
logon period
loadtime Total operating time spent loading
idletime Total idle time accumulated during this logon period
spottime Total spotting time accumulated during this logon period
loadcnt Same as “totalloads”
tmcat00 Total time spent in time category 0 during this logon period.
Time categories are enumerated in the TIMECAT enum.
The value of this field is the same as that of “totaltime”
tmcat01 Total time spent in time category 1
tmcat02 Total time spent in time category 2
tmcat03 Total time spent in time category 3
tmcat04 Total time spent in time category 4
tmcat05 Total time spent in time category 5
tmcat06 Total time spent in time category 6
tmcat07 Total time spent in time category 7
tmcat08 Total time spent in time category 8
tmcat09 Total time spent in time category 9
tmcat10 Total time spent in time category 10
tmcat11 Total time spent in time category 11
tmcat12 Total time spent in time category 12
tmcat13 Total time spent in time category 13
tmcat14 Total time spent in time category 14
tmcat15 Total time spent in time category 15
tmcat16 Total time spent in time category 16
tmcat17 Total time spent in time category 17
tmcat18 Total time spent in time category 18
tmcat19 Total time spent in time category 19

Table “hist_reasontable”:
Field name Description
shiftindex Index of shift this record is associated with
cliID Numeric client identifier
ddbkey Unique record identifier in export database
name Descriptive name of reason code
reason Numeric reason code
status Numeric status that this reason code can be used for.
Statuses are enumerated in the STATUS enum
delaytime Expected delay time for this reason code
category Time category that any time spent in this reason code is
accumulated into
mainttime Expected maintenance time for this reason code

Table “hist_statusevents”:
Field name Description
shiftindex Index of shift that this record is associated with
cliID Numeric client identifier
ddbkey Unique record identifier in export database
eqmt Equipment name
unit Numeric equipment unit type as enumerated in the UNIT
enum
operid Operator login id
starttime Start time of this event (seconds into the shift)
endtime End time of this event (seconds into the shift)
duration Duration of this event (seconds)
reason Reason code for this event
status Numeric status code for this event. Statuses are
enumerated in the STATUS enum
category Numeric time category for this event. Time categories are
enumerated in the TIMECAT enum
comment Free form associated comment for this event
vEvent Non-zero if this event caused a change in time category
from the previous event. This is for example very useful to
distinguish real down events from just changes to the down
status for a piece of equipment.