Data integrity is the assurance that data is consistent and correct. Spare parts, sounds fairly simple?
What are the basic elements of a part record; name, part number, description? Data Integrity is used way too much but is a very vague concept. Let’s just look at the purchasing department; it is easy if the part records are only used by the purchasing department where the main objective is to purchase the item. This example is all the data that the buyer will need to purchase this switch.
How would a buyer know that these are the same parts? Two different manufacturer names and two different part numbers; this scenario will cause duplication in a purchasing system. The result is the additional work of creating and maintaining two contracts but also cause downstream effects such as excess inventory with more than 1 stocking location, lack of a volume purchase or a global view.
Question: Is the answer to always to confirm the actual manufacturer and set up supplier references?
Tags: BPO, Business Intelligence, data, DATAForge, dataquality, eOTD, ERP, maintenance, masterdata, MRO, SaaS, Software as a Service
You made some pleasant tips there. I did a search on the subject and encountered most people will agree with your web log.
Found your site on Google and I thought that I would drop by and take a look. Nice work!