+44 (0)20 7264 3250

Casualty Response

Get emergency support now


CMMS Master Data Precision and Enrichment

Client: Midstream/upstream oil and gas operator

Asset: Pipeline and compressor stations

Project Objective: To verify and enrich the master equipment list of pipeline assets within the CMMS using our ePAV™ software.

Software: ePAV™Effio™

Location: North America

Building an accurate digital reflection of the physical plant is key to effective maintenance, integrity, and inventory management.

Why we were contracted

  • Known data accuracy and duplication issues
  • Tags in the asset register were missing key attributes such as location, make, model, descriptions etc
  • Tags in CMMS were not assigned to drawings · Inability to demonstrate management of safety critical equipment due to missing tags in the CMMS
  • Inability to assign preventative maintenance and spare parts to equipment not included in the asset register
  • Lack of in-house capacity to complete the verification and enrichment project in house, in the desired timeframe

What we did:

  • Performed a desktop asset verification (DAV) to link the tags to their associated drawings
  • Completed a physical asset verification (PAV), where we:
    • Identified and recorded over 1000 tags that were missing from the asset register (including valves, transmitters, detectors, and control valves)
    • Removed over 2700 duplicate tags from the asset register due to tags existing across multiple drawing types.
    • Increased the manufacturer data by 470%
    • Increased the model data by 416%
    • Increased the serial number data by 477%
    • Improved meter site data accuracy from 43% to 100%
  • Developed CMMS templates containing enriched data
  • Developed an engineering report detailing data collected and changes made, with further recommendations for improvement

How we delivered

ABL travelled over 7000KM to verify and enrich data for 11,700 tags of pipeline assets using our ePAV™ software.

This software enabled ABL to:

  • Save 87% on project costs for the client when compared to traditional verification and post walkdown data processing techniques
  • Cut 17.5 weeks off the project timeline, without compromising quality
  • Reduce the project team by 60%, having only 4 engineers complete the PAV facilitated by our ePAV™ software loaded tablets


CMMS Templates: CMMS templates containing the final, enriched asset register of 7,700 tags

P&ID Updates: Marked up P&IDs and SLDs detailing newly identified tags

Project Report: Project close out report detailing findings and improvements made

Optimisation Recommendations: Recommendations for further improvement and optimization of CMMS data

“We would like to extend our thanks to the team who have just wrapped up their field work. The work they have performed was executed in very difficult times due to COVID-19. Their professionalism has been demonstrated as they dealt with these issues every day and help to ensure that no spread of COVID occurred while they interacted with site personnel.”

Project Manager, Upstream/Midstream Oil and Gas Operator

Benefits Provided

Optimised costs

Assured that what was on site was reflected accurately in the CMMS and therefore could be managed appropriately to assure reliability and optimise costs

Mitigated risk

All safety, production and environmentally critical equipment are accounted for and can be managed to reduce exposure to risk

Optimised inventory management

The correct name plate data is now available in the CMMS for BoMs to be developed and the correct spares to be purchased to avoid wasted expenditure

Minimised downtime

Reduced equipment downtime by having access to the correct spare parts to assure procurement of the right equipment

Diminished operational impact

Assured the team remained focused on day-to-day operations and productiveness, by outsourcing to experienced specialists to diminish operational impact and production