Documentation

Struktive Documentation — Mining

Field definitions, quality score formula, equipment categories, mine hierarchy parsing, and EAM export specifications.

Getting Started Field Definitions Quality Score Equipment Categories Mine Hierarchy EAM Export Formats MRO Parts Privacy Policy Terms of Service

Getting Started — Mining

Struktive for Mining accepts any CSV or Excel file containing mine-site equipment register data. You don't need to rename your columns or reformat your data before uploading.

1. Upload your equipment register

Go to the Upload page and drag-and-drop or select your CSV or XLSX file. Optionally set a site default (applied to records without an explicit site in the location field) and a job name. Select 'Mining' as your sector if prompted.

2. Processing — 7-stage pipeline

The pipeline runs automatically: OEM Name Resolution → Mine Hierarchy Parsing → 12-category Equipment Classification → EAM Enrichment (1,200+ equipment models) → Duplicate Detection → Quality Scoring → Export Generation. Processing typically takes 30–90 seconds.

3. Review results

The Results page shows the normalised equipment register with quality scores, category badges, suggested Maximo FLOC / SAP FL codes, and flagged issues. Use the filters to focus on exceptions and low-confidence records.

4. Download EAM export

Click Download and choose your EAM target platform (Maximo, SAP PM, Pronto Xi, Infor EAM, or Ellipse). A pre-flight summary panel shows suggested Functional Location codes and any records requiring manual review before import.

Output Field Definitions

All mining output formats include these normalised fields. The Struktive Native CSV includes all fields. EAM export profiles map a subset to platform-specific field names (e.g. Maximo ASSETNUM, SAP EQUNR).

FieldTypeDescription

normOEMstringCanonical OEM name after alias resolution. E.g. 'Caterpillar', 'Komatsu', 'Atlas Copco', 'Sandvik'.

normModelstringModel designation normalised. E.g. 'CAT 793F', '930E-4', 'PC5500-6'. Minor whitespace/punctuation normalisation applied.

equipmentTagstringEquipment tag / asset number as provided. Not normalised.

normSerialstringSerial number with whitespace and punctuation normalised. Original preserved in rawSerial.

normSitestringMine site name extracted from location string, or the upload-time site default.

normPitstringPit or open-cut area identifier. E.g. 'PIT-NORTH', 'PIT-SOUTH'. Null if not resolved.

normLevelstringUnderground level or elevation. E.g. 'L850', 'L920'. Null if not applicable.

normAreastringFunctional area within the site. E.g. 'ROM PAD', 'CRUSHER', 'WORKSHOP', 'PORTAL'.

equipmentCategoryenumOne of 12 categories: Earthmoving, Drilling, Blasting, Loading, Hauling, Processing, Conveying, Pumping, Ventilation, Power Generation, Ancillary, Out of Scope.

classificationConfidencenumber0.0–1.0. Confidence of the equipment classification. ≥0.85 = High, 0.65–0.84 = Medium, <0.65 = Low.

classificationMethodenumkeyword | llm | out_of_scope. How the classification was determined.

qualityScorenumber0–100. See Quality Score documentation for the mining-specific scoring formula.

issuesstring[]Pipe-delimited list of quality issues. E.g. 'missing_serial|low_confidence|no_site'.

normStatusstringNormalised status. One of: Active, Standby, Decommissioned, Under Repair, Planned, Unknown.

fleetNumberstringFleet number as provided. Not normalised.

isDuplicatebooleanTrue if this record was flagged as a likely duplicate by any detection method.

duplicateOfstringRow index of the record this is a duplicate of, if isDuplicate is true.

maximoFLOCstringSuggested IBM Maximo Functional Location code derived from mine hierarchy. Null if hierarchy not resolved.

sapFunctionalLocationstringSuggested SAP PM Functional Location code. Null if hierarchy not resolved.

unspscCodestringUNSPSC commodity code matched to the equipment category. Null if not matched.

processedAttimestampUTC timestamp (ms since epoch) when this record was processed.

jobIdstringUUID of the normalisation job that produced this record.

Quality Score — Mining

Each equipment record receives a quality score from 0 to 100. The mining scoring formula weights OEM resolution and mine hierarchy more heavily than the DC formula, reflecting EAM import requirements.

FactorPoints

Equipment tag / asset number present+10

Serial number present+15

OEM name resolved (canonical match)+15

Model designation present+10

Mine site resolved+10

Functional area resolved (pit / level / area)+10

Classification confidence ≥0.85 (High)+15

Classification confidence 0.65–0.84 (Medium)+8

Fleet number present+5

Maximo FLOC / SAP FL suggested+10

Duplicate flagged−15

Out of scope0 (excluded from scoring)

≥85: EAM import-ready

70–84: Minor review needed

50–69: Significant gaps

<50: Critical — manual intervention required

Equipment Categories

Equipment is classified into one of 12 mining-specific categories (plus Out of Scope) using a two-tier engine. Keyword rules handle approximately 75% of equipment deterministically. LLM inference resolves the remaining 25% with confidence scoring.

CategoryExample equipment

EarthmovingBulldozers, graders, scrapers, compactors, excavators

DrillingBlast hole drills, rotary drills, DTH drills, raise borers

BlastingEmulsion trucks, detonator systems, blast monitoring units

LoadingRope shovels, hydraulic excavators, front-end loaders, LHDs

HaulingHaul trucks (rigid & articulated), underground trucks, rail haulage

ProcessingCrushers, mills, screens, cyclones, flotation cells, thickeners

ConveyingBelt conveyors, stackers, reclaimers, shiploaders

PumpingSlurry pumps, dewatering pumps, water cannons, paste pumps

VentilationMain fans, auxiliary fans, ventilation on demand (VOD) systems

Power GenerationDiesel generators, substations, switchgear, transformers

AncillaryService vehicles, fuel trucks, lube trucks, light vehicles, cranes

Out of ScopeOffice equipment, IT hardware, furniture, consumables

Mine Hierarchy Parsing

Struktive parses free-text location strings into a structured mine hierarchy. The hierarchy maps directly to Maximo Functional Location (FLOC) and SAP PM Functional Location structures, enabling automated FLOC code generation.

LevelDescription

EnterpriseTop-level grouping. E.g. 'ACME Mining Corp'.

SiteMine site or operation. E.g. 'NORTHSTAR-MINE', 'PILBARA-EAST'.

Area / ZoneFunctional zone within the site. E.g. 'PIT-NORTH', 'UNDERGROUND', 'PROCESSING PLANT', 'ROM PAD'.

Level / ElevationUnderground level or surface elevation. E.g. 'L850', 'L920', 'SURFACE'.

System / DisciplineEngineering discipline or system. E.g. 'ELECTRICAL', 'MECHANICAL', 'INSTRUMENTATION'.

EquipmentIndividual asset. Linked to OEM, model, serial, fleet number, and status.

Example: Maximo FLOC generation

Input location:"North Pit, Level 850, Mechanical Workshop"

normSite:NORTHSTAR-MINE

normArea:PIT-NORTH

normLevel:L850

maximoFLOC:NORTHSTAR-MINE-PIT-NORTH-L850-MECH

EAM Export Formats

See the Mining EAM Migration page for detailed field mapping tables for each EAM platform.

IBM Maximo Equipment CSV

Asset, Functional Location, and Classification records ready for Maximo bulk import

SAP PM Equipment CSV

Equipment master data CSV mapped to SAP PM field names (EQUNR, EQTYP, HEQUI, IWERK)

Pronto Xi Equipment CSV

Equipment register CSV for Pronto Xi EAM import

Infor EAM CSV

Equipment and location hierarchy CSV for Infor EAM

Ellipse CSV

Equipment register CSV for Mincom Ellipse EAM

Struktive Native CSV

Flat 35-column CSV with all normalised fields including FLOC suggestions

Equipment Register XLSX

Formatted Excel workbook with quality heat map and category breakdown

EAM Migration Audit Pack

6-tab XLSX: Cover, Equipment Register, OEM Resolution Log, Duplicates, Exceptions, Methodology

MRO Parts Catalog Normalisation

Struktive also normalises MRO parts catalogues for SAP MM, Maximo Item Master, and Pronto Xi. See the MRO Parts page for full documentation.

Parts Description Normalisation

Standardises free-text descriptions to structured noun-modifier format per UNSPSC taxonomy

UOM Variant Resolution

Resolves 'EA', 'EACH', 'Each', 'ea' → canonical 'EA'. 200+ UOM alias rules.

Duplicate Detection

Flags exact and fuzzy duplicate part numbers and descriptions across the catalogue

UNSPSC Code Assignment

Assigns 8-digit UNSPSC commodity codes to each parts line item

SAP MM Material Master CSV

Field-mapped CSV for SAP MM bulk upload (MARA, MAKT, MARM tables)

Maximo Item Master CSV

Field-mapped CSV for Maximo Item Master and Storeroom bulk import

Privacy Policy

Struktive is an independent data normalisation platform. Uploaded CSV files are processed in-memory and stored temporarily for the duration of the normalisation job. Processed results are stored in our database associated with the job ID.

If you are not logged in, your job is anonymous and accessible only via the direct job URL. If you are logged in, your jobs are associated with your account and accessible via the History page.

We do not share uploaded data with third parties. LLM classification calls are made to our internal API and do not include personally identifiable information from your asset records.

For questions about data retention or deletion, contact us at [email protected].

Terms of Service

By using Struktive, you agree that you have the right to upload the data you provide and that you will not upload data containing personally identifiable information about individuals without appropriate consent.

Struktive is provided as-is. Struktive makes no warranty about the accuracy of normalisation, classification, or enrichment results. You are responsible for validating output before importing into production systems.

The free tier is provided without SLA. Paid tiers include SLA terms as specified in the relevant service agreement.

For questions, contact [email protected].