--- title: "Master Data Management" description: "Often in the implementation of software systems, attention to master data is neglected in favour of the transactional data and the processes surrounding" image: https://www.pragmaworld.net/wp-content/uploads/pragma-social-placeholder-blue.jpg canonical: https://www.pragmaworld.net/master-data-management/ url: https://pragma-world.getmd.ai/master-data-management/.md last_converted: 2026-09-17T12:04:47.154Z --- # Master Data Management November 27, 2015Often in the implementation of software systems, attention to master data is neglected in favour of the transactional data and the processes surrounding that. And almost understandably so as the question to be answered arises from the transactional data, for example, “We need a system to help with planning and scheduling the work”. For that to be effective, you need accurate master data for example what staff members do you have available, what skills do they have, on which assets must the work be performed, where are those assets, etc. The result of this neglected attention is that master data is then treated as static data which it certainly is not. Staff members, financial codes, assets; they all change just not as often. And then often the master data is not looked at again after implementation until a specific item is not found. I believe that the effective management of master data is facilitated through creating ownership of the data, formalising the processes to manage changes to and regularly evaluating the master data. ### 1. Single source of truth Ownership of master data should only be in one system and with specific responsibility to maintain that data. Let us look at financial codes in a CMMS. The financial codes should only be maintained in the financial system or ERP and then used in the CMMS. The ERP becomes the master of the data and the CMMS the slave. Updates to financial codes in the CMMS can only happen as a result of changes in the ERP. Ideally, you want a date stamp on the slave data to indicate when last the data was verified from the master data. During a recent implementation, I was presented with two spreadsheets containing data on the same items with the two sheets coming from separate management systems. It was impossible to reconcile the information as there was no master system and thus both systems created their own identifiers which were not cross referenced to the other. The cost of this? Someone had to go to each item to identify it and cross reference back to both information systems. ### 2. Formalised change processes Once the responsibility and origination of master data are identified, formalised change processes should be in place to manage any changes typically contained in three categories: change, delete and add or insert. It is important that the impact of changes is understood by the person making the change and that the change is communicated effectively. A mere change in staff code in one system can have a dramatic change in other systems example the payroll system! Quite often we do not want to spend too much time in managing these small changes by engaging with all stakeholders. And whilst every effort must be made not to paralyse systems with change management, effective communication of changes will limit data inaccuracies. A top solution would be to have a list of impacted systems contained on the master record for reference. ### 3. Scheduled assessments When electronic interfaces are used to effect changes to master data between systems care must be taken to not only rely on the error notifications of the interfaces. The error notifications are typically reviewed by an IT specialist responsible for the interface but they are not directly impacted by the change itself. Here a monthly master data change log report can be a valuable tool to verify what the changes were and that the changes have been effected. Other than only managing the changes to the master data it is also important to schedule master data assessments. This is similar to assessing the condition of the assets or assessing the condition of the tools to be used by artisans. Master data must be assessed for relevance (do we still require it), quality (is it useable) and ownership (who is maintaining it). Your master data is the foundation on which transactions are done and just as you would assess your assets in order to create products, you need to assess master data to facilitate transactions. In closing, the control of master data is crucial to the success of any information system. This is why we spend such a concentrated effort on master data during an implementation of On Key. Consider the cost of losing control of your master data in terms of the time and effort to reconcile data between systems with the truth and the time wasted on completion of transactions due to inaccurate master data. Also, consider the cost of missed opportunity when analysis of information is based on inaccurate master data. The effort to reconcile master data is always more than the incremental effort to maintain the data. ##### Subscribe to our newsletter ##### More content ##### The lonely learner problem: why self-paced learning still needs people Author | Karen Greyling - Business Development Manager, Pragma Self-paced learning has solved a very real problem for busy adults. It gives people more... ##### Pragma appoints Stephan Kornelius as Chief Executive Officer Author | Pragma Experienced Pragma executive takes the helm on 1 October as the business continues its next... ##### No time for training? Look at what is taking the time. Author | Karen Greyling - Business Development Manager, Pragma “Not now. The team is too busy.” It is one of the most understandable reasons... ##### When Finance and Operations agree on spares Author | Pragma MRO spares are often the source of a familiar business tension. Finance wants to reduce... ##### You don’t train for a marathon by running a marathon Author | Tim Beavon - Partner Consultant, Pragma Why shutdown readiness depends on applying lessons before the next major event A major shutdown... ##### Pragma announces leadership transition and continues strategic momentum Author | Pragma Pragma has announced an important leadership transition as the business continues to build on... ##### Are we solving the wrong training problem? Author | Karen Greyling - Academy Business Development Manager, Pragma When organisations say they need training, they may already be solving the wrong training problem:... ##### The art of balancing work order feedback with compliance, learning, and wrench time Author | Scheepers Schoeman - Senior Associate, Professional Services Most organisations don’t choose their work order feedback culture. They drift into it. A new... ##### Why a qualified maintenance planner changes more than maintenance Author | Karen Greyling - Academy Business Development Manager, Pragma In many plants, the same pattern repeats itself. Work arrives late. Materials are chased at... ##### Why MRO inventory is different from other inventory classes Author | Andre Jordaan - Partner Consultant, Pragma MRO inventory differs from other inventory classes because demand is irregular, the consequences of stockouts... ##### How failing water infrastructure is quietly reshaping South Africa’s cities Author | Nelson Broden – Business Lead Pragma Managed Services On the school run through... ##### From dead capital to operational certainty: Smarter spare parts management Author: André Jordaan, Partner Consultant, Pragma Most MRO stores aren’t short of parts; they’re short... ##### Asset Management Awareness Training that fits real work Author | Karen Greyling, Business Development Manager If you’ve ever thought, “We don’t need another... ##### Asset Management Masterclass: Strategic training for leaders driving performance, reliability and results Author | Karen Greyling – Business Development Manager In asset-intensive industries, leaders are under growing... ##### Beyond compliance: Why repeated maturity assessments define asset performance leadership Author | Stephan Kornelius – Pragma Professional Services Business Lead In asset-intensive industries, leaders face... ##### OEMs need a connected platform for services Author | Henk Wynjeterp – Regional Lead – Europe | Henk leads Pragma’s OEM after-sales... ##### When rivers cry out: How asset management can help heal South Africa’s waterways Author | Nelson Broden – Business Lead Pragma Managed Services The Hennops River, once part... ##### Ditch the buzzword: OEM after-sales leaders buy execution, not “servitization” Author | Henk Wynjeterp – Regional Lead – Europe | Henk leads Pragma’s OEM after-sales... ##### Beyond the software – embedding your EAMS into your organisation’s DNA for sustainable value The key to a successful EAMS (Enterprise Asset Management System) implementation lies in integrating the... ##### Pragma’s perspective on what the proposed South African budget means for infrastructure governance Author | Stephan Kornelius Author | Stephan Kornelius – Pragma Professional Services Business Lead Finance Minister Enoch Godongwana’s 2025... ##### Government infrastructure investments must go beyond bricks and mortar – A global perspective Author | Bani Kgosana Author | Bani Kgosana Across the globe, ageing infrastructure threatens economic stability. In the US,... ##### Pragma partners with Q36.5 Pro Cycling Team to power maintenance excellence Author | Liza Schroeder Pragma is proud to announce its support of the Q36.5 Pro... ##### Revitalising South Africa – a better path to infrastructure renewal Author | Bani Kgosana, Pragma CRO South Africa faces an extraordinary opportunity to transform its... ##### Transforming maintenance from a grudge purchase to a strategic investment Author | Scott Gibson, Pragma CEO  With South Africans enjoying a break from load shedding... ##### Pragma 2.0 – CEO of Pragma, Scott Gibson’s vision is to compete with international giants through engineering excellence At Pragma, our roots are deeply embedded in engineering consulting. We are proud to be... ##### Are you proactively shaping your focused improvement process or is it evolving organically? Author | André Jordaan, Pragma Partner Consultant Focused improvement (FI) is the overarching process used... ##### Introducing Pragma’s Enhanced Asset Management Assessment Framework: AMIP Physical assets must be managed effectively for a business to grow and be competitive. Across... ##### Unlocking Asset Management Excellence: Pragma’s Spotlight at the SAAMA Conference, 5-6 June 2024 As anticipation builds for the upcoming South African Asset Management Association (SAAMA) Conference, Pragma is... ##### A new era at Pragma: Scott Gibson appointed CEO Designate After an illustrious 34-year tenure as co-founder and CEO of the Pragma Group, Adriaan Scheeres... ##### Enhancing OEM Service Revenue Growth: Overcoming After-Sales Challenges Author | Stefan Terblanche, Pragma Partner Consultant Over the last decade, more and more Original...