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!

Building Your Equipment Records and Asset Hierarchy

SwainSmith’s equipment master development service has four parts: Asset Data Modeling & Standards Development, Asset Data Collection & Preparation, Equipment Master Database Development, and Equipment Master Data Management.

Master Data Development

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

PUMP, VACUUM, DRY AIR, 1.4 US GPM, 3500 RPM, LIQUID RING, BN 139010

PUMP, VACUUM, DRY AIR, 1.5 US GPM, 3500 RPM, 2 HP MOTOR, LIQUID RING

PUMP, VACUUM, DRY AIR, 1.5 US GPM, 3500 RPM, 3 HP MOTOR

MOTOR, ELECTRIC, AC, 30 HP, 208 TO 230/460 V, 3PH, 60 HZ, 182TC FRAME

MOTOR, ELECTRIC, AC, 25 HP, 208 TO 230/460 V, 3PH, 60 HZ, 184T FRAME

MOTOR, ELECTRIC, AC, 25 HP, 208 TO 230/460 V, 3PH, 60 HZ, 182T FRAME

We clean and standardize asset descriptions.

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
Plant Flow
We organize assets into a hierarchy that benefits accounting as well as maintenance.

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
Equipment Master Process
Basic overview of an MDM process for managing asset master data.

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.

Get a complimentary data evaluation.

We’ll take a look at your equipment master data and give you some ideas for improving it. No charge or obligation—just a quick and friendly assessment.

EVALUATE MY DATA

Get a complimentary data evaluation.

We’ll take a look at your equipment master data and give you some ideas for improving it. No charge or obligation—just a quick and friendly assessment.

Use the email form or call 828-215-9471

9 Reasons EAM Implementations Fail
(And How To Fix Them)

Why do so many CMMS and EAM software implementations fail to deliver useful information?

Read More

When it comes to implementing EAM and CMMS software systems, the prevailing school of thought…

Read More

You wouldn’t use a wrench to drive a nail. So why manage your assets with a software system that’s…

Read More

Lack of alignment is guaranteed to derail your EAM software implementation.

Read More

Master data and coding structures are critical to EAM software performance.

Read More

Documented practices are critical to standardizing physical asset management and achieving success.

Read More

Like tailoring a suit, you should configure your CMMS or EAM system environment to ensure…

Read More

If you’re not measuring success, you’re guessing. Find out how to use performance measures…

Read More

Do you have the CMMS and EAM reports you need? Learn about the tools that turn raw data…

Read More

If you don’t audit your EAM/CMMS implementation, it’s hard to ensure ROI….

Read More