Contents:

Field List

Take care that some fields are reported as averages, not sums.

For example, HaulageResult.Distances.Total will give the average cycle time distance, not the total distance travelled.

Field Name	Units	Aggregation	Field Description
Active Duration	Hours	Sum	If the Agent is active in a transaction, this field is equal to Duration. See also: Idle Duration.
Activity Type	Text	-	Indicates Drilling, Mining, or Idle activities.
Agent	Text	-	The Agent that initiated this transaction.
Agent Calendar Hours	Hours	Sum	Agent Calendar Hours consumed in this transaction.
Agent Groups	Text	-	When using Loaders as Agents or Drill Scheduling: Agent Group returns the Loader Type / Drill Type (i.e. EX3600). Agent returns each loader or drill unit individually (i.e. EX3600.1, EX3600.2, ...).
Agent Quantity Divided by Calendar Time.***	Per Naming	Average	When using Loaders as Agents, displays Agent target tonnes/volume divided by the Calendar hours.
Agent Rate.Drill Meters Per Hour	Meters Per Hour	Average	When using Drill Scheduling, displays the drill penetration rate.
Destination Block Type	Text	-	Reads the block type field (Production, Contour, Ramp, Trim, etc).
Destination Full Name	Text	-	Full name of the material destination.
Destination Logic Rule	Text	-	Destination Rule used to assign the material to the destination. Can be found in Setup > Destination Logic.
Destination Mutex Stockpile.***	Text	-	See 31273166.
Destination Parcel	Text	-	Material type on arrival at destination. (In Truck Constrained mode, stockpiles can be set up to merge material types on arrival.)
Destination Record Num	Text	-	Unique identifier for each block in the project.
Destination Type	Text	-	See 31273166.
Destination.***	Text	-	See 31273166.
Destination.Dumps	Text	-	Destination dump class. Note this level returns "Crushers" or "Stockpiles" or "Dumps"
Destination.Name	Text	-	See 31273166.
Destination.Name Part ***	Text	-	See 31273166.
Destination.Top	Text	-	Destination dump class. Note this level returns "Crushers" or "Stockpiles" or "Dumps"
Drill Engine Hours	Hours	Sum	Engine hours = calendar hours * availability * utilisation.
Drill Hours	Hours	Sum	Direct Hours = calendar hours * availability * utilisation * efficiency * productivity.
Drilling_***	Per Setup > Drilling Fields	Per Setup > Drilling Fields	Any drilling database field is prefixed 'drilling_'.
Duration	Hours	Sum	Calendar hours. Note this does not include any Stockpile Reclaimer hours.
End Date	Date / Time	-	End date of the transaction.
Final Destination.***	Text	-	See 31273166.
FlagCrossed.***	Text	-	'Y' if a truck has crossed a flagged segment 'N' if a truck has not crossed a flagged segment.
FlagState.***	Text	-	'On' if a flag is traversible 'Off' if a flag is not traversible.
Fleet	Text	-	Fleet name.
HaulageResult.Bridgestone TKPH	TKPH	Weighted Average on Number of Trips	Bridgestone TKPH value.
HaulageResult.Destination Terminal	Text	-	Haul Infinity block or node representing the destination.
HaulageResult.Distances.***	Metres	Weighted Average on Number of Trips	Distances corresponding to each cycle time component.
HaulageResult.FuelBurn.***	Litres Per Trip	Weighted Average on Number of Trips	Fuel burn corresponding to each cycle time component.
HaulageResult.Instantaneous Truck Count	#	Weighted Average on Number of Trips	Instantaneous truck count on a given haul cycle.
HaulageResult.Loaded Elevation Changes.***	Metres	Weighted Average on Number of Trips	Absolute, Downhill, and Uphill loaded elevation changes for a given haul cycle.
HaulageResult.Loader Idle Ratio	%	Weighted Average on Number of Trips	Loader hang time as a percentage of truck cycle time.
HaulageResult.Loader Payload	Wet Tonnes	Weighted Average on Number of Trips	Averaged loader bucket payload for the specified truck and material. Can be found in Haul Infinity > Setup > Parameters.
HaulageResult.Loader Production Rate.***	Per Naming	Weighted Average on Number of Trips	Loader production rates in Tonnes/Volume per hour. (Target tonnes/volume divided by actual Loader Hours)
HaulageResult.Material	Text	-	Haul Infinity material type. Can be found in Setup > Haulage Configurations > Haulage Materials.
HaulageResult.Michelin TKPH	TKPH	Weighted Average on Number of Trips	Michelin TKPH value.
HaulageResult.Number Of Passes	Count	Weighted Average on Number of Trips	Number of swings taken by the loader to fill the truck tray.
HaulageResult.Number Of Trips	Count	Sum	Number Of Trips = Mined Wet Tonnes / Truck Payload
HaulageResult.Source Terminal	Text	-	Haul Infinity block or node representing the source.
HaulageResult.Times.***	Minutes	Weighted Average on Number of Trips	Productive time corresponding to each cycle time component.
HaulageResult.Truck Payload	Wet Tonnes	Weighted Average on Number of Trips	Truck payload in Wet Tonnes.
HaulageResult.Truck Rate.***	Per Naming	Weighted Average on Number of Trips	Truck production rates in Wet Tonnes, Dry Tonnes, and Bulk Cubic Metres per hour.
HaulageResult.Unloaded Elevation Changes.***	Metres	Weighted Average on Number of Trips	Absolute, Downhill, and Uphill unloaded elevation changes for a given route.
ID	Text	-	Unique ID for each schedule transaction.
Idle Duration	Hours	Sum	If the Agent is idle in a transaction, this field is equal to Duration. See also: Active Duration.
Loader	Text	-	Loader type.
Loader Engine Hours	Hours	Sum	Engine hours = calendar hours * availability * utilisation.
Loader Hours	Hours	Sum	Direct Hours = calendar hours * availability * utilisation * efficiency * productivity.
Loader.Avails.***	%		Loader Calendar availability, utilisation, efficiency, productivity value Direct Utilisation = availability * utilisation * efficiency * productivity Note these are weighted against Loader Hours, not Calendar Hours, as some stockpile reclaim steps consume loader hours but not calendar hours.
Mining_*	Per Setup > Mining Fields	Per Setup > Mining Fields	Insitu material properties such as feed tonnes and head grade.
Mining_ProcessStreams_*	Per Setup > Mining Fields	Per Setup > Mining Fields	Product material properties such as recovered tonnes and product grade.
Misc_*	Per Setup > Misc Fields	Per Setup > Misc Fields	Block solid properties such as location, surface area, presplit perimeter, etc.
Mutex Parcel.***	Text	-	See 31273166.
Num Loaders	Count	Sum	Num Loaders = Loader Hours / Direct Hours Per Loader.
Num Trucks	Count	Sum	Num Trucks = Truck Hours / Direct Hours Per Truck.
Origin ID	Text	-	Unique ID for each schedule transaction.
Original Source.***	Text	-	See 31273166.
Output>***	Per Setup > Mining Fields	Per Setup > Mining Fields	See 31273166.
Period.***	Per Naming	-	Time period during which this transaction takes place.
Processing Stream	Text	-	If the destination is a crusher, this returns the crusher Processing Stream. Can be found in Setup > Crushers.
Source Block Type	Text	-	Reads the block type field (Production, Contour, Ramp, Trim, etc).
Source Full Name	Text	-	Full name of the material source.
Source Mutex Stockpile.***	Text	-	See 31273166.
Source Parcel	Text	-	Returns material type on mining transactions. Returns hole type on drilling transactions.
Source Record Num	Text	-	Unique identifier for each block in the project.
Source Type	Text	-	See 31273166.
Source.***	Text	-	See 31273166.
Source.Name Part ***	Text	-	See 31273166.
Source.Open Pit	Text	-	Source mine class. Note this level returns "OpenPit" or "Stockpiles" or any top-level reserve table name.
Start Date	Date / Time	-	Start date of the transaction.
Step Logic Rule	Text	-	Step Logic rule used to assign the fleet to the movement. Can be found in Setup > Steps Logic.
Swell Volume	LCM	Sum	Swell factored volume. Can be found in Setup > Swell Factors.
Truck	Text	-	Truck type.
Truck Engine Hours	Hours	Sum	Engine hours = calendar hours * availability * utilisation
Truck Hours	Hours	Sum	Direct Hours = calendar hours * availability * utilisation * efficiency * productivity
Truck Total Fuel Liters	Litres	Sum	Total truck fuel litres.
Truck.Avails.***	%		Truck Calendar availability, utilisation, efficiency, productivity value Direct Utilisation = availability * utilisation * efficiency * productivity Note these are weighted against Truck Hours, not Calendar Hours, as some stockpile reclaim steps consume truck hours but not calendar hours.

Original Source / Final Destination

A single schedule transaction (Source + Destination) may be one step in a series of transactions generated by the Steps Logic. Original Source and Final Destination refer to where the material originated at the beginning of the period and rested at the end of the period, outside of the current transaction.

Example:

Destination Logic		Steps Logic
Original Source	Final Destination	Step	Source	Destination
Pit	Crusher	1	Pit	ROM
Pit	Crusher	2	ROM	Crusher
Pit	Crusher	3	Pit	Crusher

Demonstration of how "Pit to Crusher" can be broken down into 3 steps via the Steps Logic.

Be extremely wary of double-counting when using Original Source / Final Destination fields.

Observe from the above image that filtering by "Final Destination = Crusher" would double-count tonnes passing through the ROM.

Source Type / Destination Type

A single schedule transaction (Source + Destination) may be one step in a series of transactions generated by the Steps Logic.

Field	Value	Condition
Source Type	True	Source = Original Source
Source Type	Mock	Source <> Original Source
Destination Type	True	Destination = Final Destination
Destination Type	Mock	Destination <> Final Destination

The 'Type' fields can be used to quickly differentiate between Direct (single-step logic) and Auto-Rehandle (multi-step logic) type movements.

Output Fields

Output fields display the final products grades when a parcel is dumped in the crusher. Any reporting on final product should be done using the Output fields.

To prevent double-counting, always filter by Destination.Dumps = Crushers when reading the Output fields.

Output grades are displayed on any transaction where the Final Destination is a crusher (even if the Destination is only the ROM, per Steps Logic).

Mutex Fields

Mutex fields (Mutually Exclusive categories) are classification fields that have been created in Tactical Scheduler,

in Reserves tab > Data panel > Parcel Subsets > Mutex Parcel Groups, and
in Setup > Stockpiles > Stockpile Mutex Subsets.

These are useful for answering questions such as "how many tonnes on all ROM stockpiles", or "how many tonnes of rock type X went to crusher". Under the Mutex groups we can classify different ROM stockpiles together, or different rock types together, and so on.

See also: TS Subset Variables.

Level Names

Tactical Scheduler uses Level Names to refer to the hierarchy of locations in pits, dumps, stockpiles and crushers. By default, the level name fields are drawn from the table levels in Setup > Create Tables.

This can be a source of confusion, since Dumps, Stockpiles and Crushers store different information at different levels in their names.

Destination Level	Destination Name Part	Level Number	Dumps	Stockpiles	Crushers
Destination.Dumps	Destination.NamePart1	0	"Dumps"	"Stockpiles"	"Crushers"
Destination.Mine	Destination.NamePart2	1	"Mine1"	"ROM1"	"CR1"
Destination.Dump	Destination.NamePart3	2	"Dump1"	"WtAvg"	-
Destination.Lift	Destination.NamePart4	3	"600"	-	-
Destination.Block	Destination.NamePart5	4	"001"	-	-
Destination.Top	Destination.NamePart1	0	"Dumps"	"Stockpiles"	"Crushers"
Destination.Name	Destination.NamePart2	1	"Mine1"	"ROM1"	"CR1"

Pits

Destination.<Level> returns that level name from the OpenPit database table.

Dumps

Destination.<Level> returns that level name from the Dumps database table.

Stockpiles

Destination.Top returns "Stockpiles" from Level 0.
Destination.Name returns the stockpile name from Level 1.
Destination.NamePart3 returns
- the finger number on FIFO/LIFO stockpiles.
- "WtAvg" on weight-averaged stockpiles.

Crushers

Destination.Top returns "Crushers" from Level 0.
Destination.Name returns the crusher name from Level 1.

Equivalent Flat Haul

Contact Alastri support to add Equivalent Flat Haul (EFH) as a custom report field to your organisation's specification.

Since there is no industry standard defined calculation for EFH, it is not included in the default reporting fields.

Browser not supported