If you want to produce rich and reliable information with your EAM/CMMS software, you have to start with a foundation of good data. This means that the content you pre-load into the EAM software system must be clean and accurate. If this foundation is corrupt, it will wreak havoc with your reporting and make the software frustrating to use.

Understanding the EAM Data Foundation

Layers of data in an EAM software system.

EAM system content is the most often overlooked element of an EAM implementation, yet it’s also one of the most vital. Content undergirds everything that happens in the EAM software system. Transaction records (e.g., work orders and purchase orders), reporting, KPIs, analysis, you name it—content plays a role in each.

For example, when you request a spare part, the system has to pull information from that part’s record in the MRO materials catalog. When you generate a report on work orders in progress, the system uses work status codes to filter the data. Every task performed in the EAM software system depends in some way on pre-loaded content.

Common Challenges with EAM Master Data and Codes

Despite the crucial role that content plays in generating EAM information, we see bad content all the time. Equipment in the plant is not identified in the system. Equipment records have inconsistent naming conventions or lack classification structures. Inventory in the storeroom is not set up in the system. Quantity-on-hand information is inaccurate. Failure codes are too broad to produce useful information. And the list keeps going.

When your master data is incomplete or inconsistent, or when your coding structures are imprecise or confusing, it has a direct impact on the quality of the information that you extract from the EAM software system. Thus, it’s essential to develop good content at an early stage in your EAM implementation.

EAM Master Data Best Practices

Good content meets certain criteria. Master data, such as the equipment master and MRO materials catalog, must be:

Complete. (Every item has an entry in the database and no critical information is missing.)

Structured. (Assets are organized into a hierarchy so that costs “roll up” from child assets to parent systems.)

A structured asset hierarchy makes it easy to find the asset you want in the database.

Developing master data that meets these standards takes work. It can require multiple plant walk-downs and extensive knowledge of industry taxonomies and naming conventions. The process can be expedited by working with an experienced data development partner who can help you collect, cleanse, and standardize your data.

EAM Coding Best Practices

Codes are used to identify, sort, and filter data. To do their job right, coding structures must be clear and comprehensive. Detailed coding sets should exist for bucketing types and classes of work orders, equipment failures, MRO materials, and so on. All of these asset management coding sets should be:

Comprehensive. (Codes exist for all common needs, from work order delays to vendor service types.)

As with master data, developing good coding structures can take significant effort and knowledge of industry standards. Rather than building your codes from scratch, a better option is often to start with a library of industry-accepted EAM coding structures and then expand or modify those codes as needed.

Generating Reliable EAM and CMMS Data

If your master data and coding structures don’t meet the standards for data integrity outlined above, you’re going to have problems. A corrupt data foundation makes the EAM system harder to use, compromises reporting, and discourages users from buying in. On the other hand, a solid foundation of pre-loaded content will make your EAM or CMMS software system easier to use and help it to deliver useful information.

Are you building on a corrupt data foundation? SwainSmith can help. We help clients develop world-class EAM master data and coding structures using our proprietary data and coding libraries. Contact us at info@swainsmith.com or 828-215-9471 to get started.

Tracy S. Smith has been helping organizations implement successful EAM software systems for 20 years. He is the president of SwainSmith, Inc., an EAM solutions company. He also offers complimentary 30-minute EAM consultations. No sales pitch or a pesky follow-up call. Just straight answers to your questions—and an objective, experienced assessment of your issues and goals.