Training Achieving CMMS Data Integrity

Training Achieving CMMS Data Integrity


Many CMMS new data builds are performed very badly or frequently companies upgrade their CMMS and upload legacy data to the new version. Frequently the data build is outsourced to engineering consultants or companies who specialise in this type of activity. The main reason for a lack of data integrity is a lack of standards and guides so the people involved do what they think is the right way, but everyone has different ideas.

This workshop shows delegates the best practices in building the CMMS data during the pre-operational phase and how to  carry out major clean ups of the equipment and spares data.

  • provides a structure approach to all aspects of data builds for new builds
  • shows how to carry out critical reviews of current CMMS Data
  • shows the quality checks and how to transfer legacy systems


Learn how to audit the quality of their CMMS data

  • Understand the CMMS data build process
  • Achieve improved CMMS quality and effectiveness
  • Understand how to develop databases in MS Access  and create reports
  • Minimise need for data integrity rework
  • Manage the data builds done by consultants


Introduction to CMMS Data Build

  • Common problems with data builds
  • Scope of CMMS Data & Process
  • CMMS version Upgrades and Critical Reviews
  • Which is the best tool MS Excel or MS Access
  • Features of MS Access and
  • Exercises spares cataloguing
  • Introduction to MS Access tables, queries, reports

Maintenance & Spares Coding

  • Approaches to criticality for Equipment & Spares
  • Equipment class
  • Failure classes
  • Shutdown codes
  • WO Priority codes
  • Building the failure coding structure
  • Exercise Failure Code Structure

Building the Asset Register

  • The build process
  • Develop Guides & Standards
  • Naming & Numbering conventions
  • Maintainable Groups
  • Conducting quality checks
  • Equipment attributes
  • Exercise building equipment register

Building the Spares Database

  • The build process
  • Develop Guides & Standards
  • Naming & Numbering conventions
  • Conducting data quality checks
  • Determining inventory levels
  • Exercise building spares register

Building the PM Data

  • Introduction including definitions
  • Maximo versus SAP – common terminology
  • Developing generic strategy guides including those based on FMEA concepts
  • Writing effective tasks good practices
  • Job Plan formats
  • Routes and Linking PMs to Tags
  • Quality checks
  • Exercise


General Notes

  • All our courses can be facilitated as Customized In-House Training course.
  • Course duration is flexible and the contents can be modified to fit any number of days.
  • As for Open Enrolment Courses, we offer our clients the flexibility to chose the location, date, and time and our team of experts who are spread around the globe will assist in facilitating the course.
  • The course fee includes facilitation, training materials, 2 coffee breaks, buffet lunch and a Certificate of successful completion of Training.
  • FREE Consultation and Coaching provided during and after the course.


  • Certificate, Quality Training Kit (Pencil case: Erase, Bolpoint, Pencil, Tipe X, Stabillo, Flash Disk 8 GB.
  • Bag (Public Training)
  • Training Material (Hand Out & Soft Copy)
  • Convenient training facilities in stars hotel (Public Training)
  • Lunch 1x and Coffee Break 2x / Day (Public Training)
  • Souvenir.
  • Gratis antar Jemput dari Bandara/Stasiun ( Khusus Yogyakarta )


PT. BORNEO BINA MITRA ( BBM TRAINING AND CONSULTING ) – Lembaga Sertifikasi dan Pelatihan SDM Untuk Perusahaan / Instansi Pemerintahan . Dan di dukung dengan tenaga ahli yang sudah berpengalaman dan berkompeten di bidangnya. Kami ingin menawarkan Training atau Pelatihan kepada Bapak/Ibu pimpinan perusahaan atau Instansi. Adapun Lokasi Training atau Pelatihan bisa menyesuaikan dari Intansi/Perusahaan Bapak/Ibu, Seperti di Yogyakarta, Jakarta, Bandung, Bogor, Cirebon, Solo, Semarang, Surabaya, Malang, Bali, Lombok, Samarinda, Balikpapan, Banjarmasin, Pontianak, Makassar, Medan, Palembang, Lampung, Timor Leste, Thailand, Singapore dan Kuala Lumpur. Dll. (dengan harga dan minimal kuota yang berbeda).

Berikut adalah Kategori Training yang kami Tawarkan:


·        Marine And Offshore Engineering

·        Science And Analysis

·        Telecommunication

·        Facility Integrity, Inspection, Metallurgy And Corrosion Engineering

·        Water And Wastewater Treatment Engineering

·        Mechanical And Utility Engineering

·        Civil And Construction

·        Chemical Laboratory Engineering, Technology & Management

·        Drilling, Reservoir And Petroleum Engineering

·        Welding Engineering

·        Project And Construction Management

·        Electrical And Power Engineering

·        Maintenance And Reliability Engineering

·        Information Technology

·        Instrumentation And Control Engineering

·        Process And Chemical Engineering


·        Leadership And Management

·        HR, Training And Development

·        Secretarial And Office Management

·        Interpersonal And Self Development

·        Finance And Accounts

·        Public Relation And Media

·        Sales And Marketing

·        Customer Service And Communication Skills


·        Logistics & Supply Chain

·        Logistic Health And Safety Management

·        Logistic Purchasing Management

·        Sales Management, Retail And Negotiation

·        Tenders & Contract Management

·        Ships And Port Management

·        Warehouse Management And Storekeeping


·        Health, Safety & Environmental

·        Food Safety