TS Report Fields (Glossary)
- Daniel Narayan (Unlicensed)
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 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 31139148. |
| 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 31139148. |
| Destination.*** | Text | - | See 31139148. |
| Destination.Dumps | Text | - | Destination dump class.
|
| Destination.Name | Text | - | See 31139148. |
| Destination.Name Part *** | Text | - | See 31139148. |
| Destination.Top | Text | - | Destination dump class.
|
| 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 31139148. |
| 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 31139148. |
| 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 31139148. |
| Output>*** | Per Setup > Mining Fields | Per Setup > Mining Fields | See 31139148. |
| 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 31139148. |
| 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 31139148. |
| Source.*** | Text | - | See 31139148. |
| Source.Name Part *** | Text | - | See 31139148. |
| Source.Open Pit | Text | - | Source mine class.
|
| 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.