Achieving CMMS Data Integrity

Introduction

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 LAKESHORE ISL Achieving CMMS Data Integrity training seminar 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

Objectives

  • 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

Training Methodology

Delegates will learn by active participation during the course and with exercises, questionnaires, case studies. Laptop is required with Microsoft Excel and Microsoft Access.

Organizational Impact

  • Reduce rework in CMMS Builds
  • Lower build costs
  • Quality and consistent builds
  • Reduction in stock holding through avoidance of duplicate stock
  • Motivate staff to be more critical of own data in CMMS or when done by consultants

Personal Impact

  • Learn how to audit the quality of their CMMS data
  • Understand the CMMS data build process
  • Achieved improved CMMS quality and effectiveness
  • Understand how to develop databases in MS Access and create reports
  • Minimise need for data integrity reworks
  • Manage the data builds done by consultants

Who Should Attend?

  • Maintenance Managers, Engineers, Analyst
  • CMMS Key Users
  • Anyone who is involved in data integrity in maintenance & operations
  • Spares and Inventory Personnel

Seminar Outline

DAY 1

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
  • Exercises Spares Cataloguing
  • Introduction to MS Access Tables, Queries, Reports

DAY 2

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

DAY 3

Building the Asset Register

  • The Build Process
  • Develop Guides & Standards
  • Naming & Numbering Conventions
  • Maintainable Groups
  • Conducting Quality Checks
  • Equipment Attributes
  • Exercise Building Equipment Register

DAY 4

Building the Spares Database

  • The Build Process
  • Develop Guides & Standards
  • Naming & Numbering Conventions
  • Conducting Data Quality Checks
  • Determining Inventory Levels
  • Exercise Building Spares Register

DAY 5

Building the PM Data

  • Introduction including Definitions
  • Maximo vs. 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