Список полей
Обратите внимание, что некоторые поля отображаются как средние значения, а не как суммы.
Например, HaulageResult.Distances.Total покажет среднее расстояние по времени цикла, а не общее пройденное расстояние.
| Название поля | Единицы | Агрегация | Описание поля |
|---|---|---|---|
| Active Duration (Активная продолжительность | Часы | Сумма | Если агент активен в транзакции, в этом поле устанавливается продолжительность. См. также: Idle Duration (Продолжительность простоя). |
| Activity Type (Тип активности) | Текст | - | Указывает тип активности: Drilling (Бурение), Mining (Добыча) или Idle (Простой) |
| Agent (Агент) | Текст | - | Агент, инициировавший эту транзакцию |
| Agent Calendar Hours (Сумма календарных часов агента) | Часы | Сумма | Сумма календарных часов агента, затраченных в данную транзакцию |
| Agent Groups (Группы агента) | Текст | - | При использовании погрузчиков в качестве агентов или буровых работ:
|
| Agent Quantity Divided by Calendar Time.*** (Количество агентов, поделенное на время по календарю) | По названию | Среднее | При использовании погрузчиков в качестве агентов — отображает целевые тонны/объемы, поделенные на количество часов по календарю. |
| Agent Rate.Drill Meters Per Hour (Скорость агента, расстояние бурения за час) | Метров в час | Среднее | При использовании бурения — отображает скорость проходки |
| Destination Block Type (Тип блока назначения) | Текст | - | Читает поле типа блока (производственный, на косогоре, на съезде, приконтурный и пр.) |
| Destination Full Name (Полное имя назначения) | Текст | - | Полное имя назначения материала |
| Destination Logic Rule (Правило логики назначения) | Текст | - | Правило назначения, используемое для указания пункта назначения для материала. Можно найти в Setup > Destination Logic. |
| Destination Mutex Stockpile.*** (Мьютекс назначения насыпей) | Текст | - | См. 30747400 |
| Destination Parcel (Пакет на назначении) | Текст | - | Тип материала по прибытии в пункт назначения. В режиме ограничения по самосвалам (Truck Constrained) можно настроить насыпи на объединение типов материала по прибытии. |
| Destination Record Num (Номер записи назначения) | Текст | - | Уникальный идентификатор для каждого блока в проекте |
| Destination Type (Тип назначения) | Текст | - | См. 30747400 |
| Destination.*** | Text | - | См. 30747400 |
| Destination.Dumps | Text | - | Destination dump class.
|
| Destination.Name | Text | - | See 30747400. |
| Destination.Name Part *** | Text | - | See 30747400. |
| Destination.Top | Text | - | Destination dump class.
|
| Drill Engine 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 30747400. |
| 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 30747400. |
| 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 30747400. |
| Output>*** | Per Setup > Mining Fields | Per Setup > Mining Fields | See 30747400. |
| 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 30747400. |
| 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 30747400. |
| Source.*** | Text | - | See 30747400. |
| Source.Name Part *** | Text | - | See 30747400. |
| 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. Подмножества переменных.
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.