140 likes | 234 Views
ECCMA Coding. Concept Explanation & Value Proposition. What is ECCMA Coding?. A standardised, structured coding system that will uniquely identify items by their specific properties. How Does it Work?. Current Catalogues consist of a list of numbers (stock code) and descriptions
E N D
ECCMA Coding Concept Explanation & Value Proposition
What is ECCMA Coding? A standardised, structured coding system that will uniquely identify items by their specific properties
How Does it Work? • Current Catalogues consist of a list of numbers (stock code) and descriptions • ECCMA coding converts the existing catalogue into a database • Converting the existing catalogue into such a format involves 4 Steps: • Classification • Identification Guide Selection and Commercialization • Value Extraction • Content Enrichment
Step 1 - Classification What is the item in question? ECCMA identifies items based on the principle of a noun and a qualifier (to more accurately describe the noun). In this case: Bearing: Ball; Annular ECCMA Concept Identifier: 0161-1-01-006687
Step 2 – Identification Guide Commercialization What do I need to know about this bearing in order to buy it? • Bearing: Ball; Annular • Inner Diameter • Outer Diameter • Width • # Rows • Sealing Type • Load Rating • Speed Rating Commercialized Template
External Diameter Brand & Part # Internal Diameter Width # of Rows Sealed/Non Sealed Step 3 – Value Extraction What do I already know about this item from my current catalogue/code? Current Description BEARING SKF 6317 85MM BORE 180MM O/D 41MM W.REF.SKF 6317 BALL BEARINGS RADIAL RIGID TO BS 292 PART 1 1982 SINGLE ROW OPEN TYPE MEDIUM SERIES WITH
Step 3 – Value Extraction What do I already know about this item from my current catalogue/code? Missing Properties Partially Populated Commercialized Template
Step 4 – Content Enrichment Populating the missing properties to complete the coding process. www.skf.com
The Result 56408913 - BEARING SKF6317 2RSH Business Unit 1 52368965412 - BEARING SKF 6317 85MM BORE 180MM O/D 41MM W.REF.SKF 6317 BALL BEARINGS RADIAL RIGID TO BS 292 PART 1 1982 SINGLE ROW OPEN TYPE MEDIUM SERIES WITH Business Unit 2 56329845 - MECHANICAL PLANT SPARES BEARING BALL SINGLE ROW DEEP GROOVE BEARING, 12 MM I.D. X 28 MM O.D. X 8 MM WIDE PART NUMBER: 6001 2 Z SKF Business Unit 3 Bearing: Ball; Annular Inner Diameter 85mm Outer Diameter 180mm Width 41mm Number of Rows 1 Sealing Type Open Load Rating 3.5KN Speed Rating 5000rpm Business Unit 4 965123465 - BEARING, 6001 ZZ DOUBLE STEEL SEAL, SINGLE ROW BALL. SUPPLIER: BEARING MAN. Bearing: Ball; An ID 85mm OD 180mm W 41mm One Common Number - 12345678
In Summary BEARING SKF 6317 85MM BORE 180MM O/D 41MM W.REF.SKF 6317 BALL BEARINGS RADIAL RIGID TO BS 292 PART 1 1982 SINGLE ROW OPEN TYPE MEDIUM SERIES WITH • From this: • Largely “free text” based system: • In order to compare 2 items you would have to read the description ACW • To this: • Structured, Disciplined Database with: • Numeric Fields • UOM • Property Level Search Capability
From This Item Description Stock Code Imagine a list like this for over 200,000 items!!!
To This Pivot Table & Data Base Drill Down Capability
Coding Detail Are two items the same, when do we have a common item? Same Item!
Coding Detail Are two items the same, when do we have a common item? Additional Properties Different Item!