A complete, accurate, structured equipment master (i.e., asset registry or master equipment list) is the starting point for collecting good work order transaction data and generating insightful performance analyses. Because it’s so fundamental, it’s important that you get it right. Bad equipment master data can wreak havoc with reporting, delay maintenance activities, and make it difficult to use the EAM software system.
SwainSmith helps organizations develop clean and accurate asset master records. We bring deep domain expertise, industry-accepted data conventions, and rich proprietary data libraries to every client engagement.
- Can machine operators find assets easily in the EAM database when creating work requests?
- Can you predict mean time between failures (MTBF)?
- Can you report at a system level? (For example, do you know how much your wastewater treatment system is costing you?)
If the answer to any of those questions is “no,” you need to improve your equipment master database!
Asset Data Modeling & Standards Development
Before cataloging your equipment, we work with you to establish models and standards for your asset data. This step makes the data collection process go more smoothly and ensures that your asset data will be standardized across the enterprise. We use industry-proven naming conventions, classification structures, nomenclature standards, taxonomies, and data libraries, including:
- Noun, modifier, attribute, value (noun–modifier) naming.
- ISO 14224 standards for reliability and maintenance data.
- Vehicle maintenance reporting standards (VMRS).
- SwainSmith’s proprietary equipment coding libraries.
Asset Data Collection & Preparation
After establishing asset data standards, we’re ready to catalog your equipment. We can do a full plant walk-down to identify assets and gather data. Or, if you have an existing spreadsheet or database of assets, we can import that data into your current EAM software system. In either case, we will validate the information and put it through our rigorous data preparation process, which includes cleansing, deduplication, standardization, and enrichment.
- Site Walk-Down & Identification
- Data Migration
- Data Cleansing, Normalization, Deduplication
- Data Enrichment
EAM Database Development
Once we’ve collected and cleansed the raw asset data, we develop it into a robust EAM/CMMS database. We analyze and assign criticality rankings. We create a structured equipment hierarchy that rolls up costs and allows users to find assets easily. We develop bills of materials (BOM) and associate piping and instrumentation diagrams (P&IDs) with equipment records. We walk through the plant again and label assets with barcodes. Finally, to jump-start your reliability program, we develop preventative and predictive maintenance (PM and PdM) schemes and build detailed problem and failure coding structures for each equipment class.
- Asset Configuration / Equipment Setup
- Criticality Assignment
- Hierarchy Development
- BOM Development
- P&ID Association
- Barcode Tagging
- PM and PdM Development
- Problem & Failure Codes
Equipment Master Data Management
Developing the equipment master is only half the battle. You have to maintain it, or the information will quickly become corrupt and out-of-date. SwainSmith helps organizations establish an asset master data management (MDM) process to control how asset records are managed and who has the authority to edit them. Implementing an MDM process will ensure that your equipment master stays clean, accurate, and up-to-date.
- MDM Process Development
- EAM/CMMS User Groups & Security Controls
Build a world-class equipment master with SwainSmith.
We can build your organization a complete and structured equipment master from the ground up. Our service includes:
- Standards development.
- Data collection or migration.
- Data cleansing and optimization.
- Database development.
- Failure code development.
- Equipment master data management (MDM) process development.
Some clients engage us only to establish asset data standards, and then they take over the task of building the equipment master. If you choose this option, we will develop a small section of your equipment master—e.g., for a single system of assets—and show you how we do it. Then you can use that as a template for what your equipment data should look like across the rest of the plant or enterprise.