MRO Material Master Data Cleansing, Enrichment and Classification

SoftNis has over 10 years of robust experience in providing MRO Material Master Data Cleansing and Classification Services. Our data management services are success driven to match every customer’s specific business requirements, to enhance operational performance while maintaining regulatory compliance.

Service Levels

Existing Part Description: DP Bal Brg 6006 2z/C3 30mm, Skf

Level 1: Priority Cleansing

Standardize Manufacturer's Name and Part Number, Product Identification by defining Noun and Modifier, Classification, and Duplicate records Identification. Example:

BEARING, BALL, DEEP GROOVE, 30mm, SKF, 6006-2Z/C3

Level 2: Standardize and Validate Existing Information

Standardize Manufacturer's Name and Part Number, Product Identification by defining Noun and Modifier, Classification, Duplicate records Identification, UoM normalization, and Standardize and Validate Existing Part Description. Example:

BEARING, BALL, DEEP GROOVE, 30 MM ID, C3 CLEARANCE, SKF, 6006-2Z/C3

Level 3: Enrichment

Standardize Manufacturer's Name and Part Number, Product Identification by defining Noun and Modifier, Classification, Duplicate records Identification, UoM normalization, Standardize and Validate Existing Part Description, and, Enhance Description with Additional Attribute Information. Example:

BEARING, BALL, DEEP GROOVE, 30 MM ID, 55 MM OD, 13 MM WD, STEEL CAGE, DOUBLE SHIELDED, SINGLE ROW, C3 CLEARANCE, 8.3 KN STATIC, 13.8 KN DYNAMIC, 28000 RPM

Material Data Standards

SoftNis’s Standard Noun Modifier Dictionary (SMD)

Currently SoftNis has more than 4,000 unique Noun modifier combination in the dictionary. The Noun modifier dictionary is a two-tiered classification schema with consistent naming convention. Each Schema consists of Noun/Class and Modifier/Sub-Class with associated characteristics that describes the general part attributes.

Each noun modifier is having minimum of 8 attributes and maximum of 27 attributes with attribute type, descriptions, sample values, Unit of Modifiers and attribute priority. As per each client's requirement, the Noun-Modifier Dictionary can be modified and/or rearranged as needed.



Base Unit of Measure (UoM)

Several standard units of measure were considered in establishing the standard UoM list. The standard UoM list is developed with the consideration of following UoM standards in the industry. They are:

  • United Nations Economic Commission for Commerce (UNECE),
  • American National Standards Institute (ANSI),
  • International Organization for Standardization (ISO) and
  • International System of Units (SI). Example:
Inch – Inch, Millimetre – MM

Data Abbreviation Standards

The abbreviations are the standard short form representations of the Noun, Modifier, attribute name and values. The abbreviated names are used to generate the short description with the intention of accommodation of more values. Example:

BEARING - BRG, CLAMP - CLMP

Data Capture

Complete specification of material is captured as per the schema from the manufacturer’s website or catalog.



Material Descriptions (Driven by SMD standard)

Long Descriptions

Long Descriptions are generated with the combination of Noun, Modifier, and Specification Name Value Pairs. Long Descriptions are non-abbreviated, and length of the descriptions vary depending on the specification values.

Short Description (Abbreviated)

Short Descriptions are generated with the combination of Noun, Modifier, and Specification Values. The specification values are the priority values of the product. The short description is a 40-character in length generated using the Abbreviated form of noun, modifier and specification values.

Data Classification - United Nations Standard Products and Services Codes (UNSPSC)

The UNSPSC is a global reference taxonomy or classification framework for all products and services. The UNSPSC is a hierarchical classification, having four levels namely, Segment, Family, Class and Commodity. Each level contains a two-character numerical value and a textual description.

UNSPSC classification for Pressure Gauge.
Segment Family Class Commodity
41000000 - Laboratory and Measuring and Observing and Testing Equipment 41110000 - Measuring and observing and testing instruments 41112400 - Pressure measuring and control instruments 41112412 - Pressure gauge

Duplicate Identification

Product Data Deduplication is a process of identifying and eliminating redundant items. Duplicate Items are identified based on same manufacturer and part numbers, or may be different manufacturer but same functionality.

  • Exact Match: Exact match duplicates are identified by comparing the manufacturer's name and part number.
  • Potential Match: Also called as Functionally Same/Interchangeable products. Potential duplicates are identified by comparing the product descriptions.


Contact Us to get your Data Samples done.