{"id":1532,"date":"2025-07-28T18:13:39","date_gmt":"2025-07-28T18:13:39","guid":{"rendered":"https:\/\/omaintec.org\/journal\/?post_type=docs&p=1532"},"modified":"2025-07-28T20:35:56","modified_gmt":"2025-07-28T20:35:56","password":"","slug":"data-integration-of-plant-equipments-and-spare-parts-and-impact-of-that-on-the-cost-computing-in-the-seawater-desalination-sector","status":"publish","type":"docs","link":"https:\/\/omaintec.org\/journal\/index.php\/docs\/data-integration-of-plant-equipments-and-spare-parts-and-impact-of-that-on-the-cost-computing-in-the-seawater-desalination-sector\/","title":{"rendered":"DATA INTEGRATION OF PLANT EQUIPMENT\u2019S AND SPARE PARTS AND IMPACT OF THAT ON THE COST COMPUTING IN THE SEAWATER DESALINATION SECTOR"},"content":{"rendered":"

Ahmed Abdulrahim Abuouf*<\/sup>, Khalid Mohamed Al Habib**<\/sup><\/strong><\/p>\n

*<\/sup>Saline Water Conversion Coropration, Saudi Arabia, aabuouf@swcc.gov.sa<\/a><\/p>\n

**<\/sup>Water Transmission and Technologies Co., Saudi Arabia, kalhabib@wttco.com<\/a><\/p>\n

Abstract<\/h2>\n

The purpose of this paper is to discuss the method of data integration between the AKZ numbering and classification system; \u201cPlant Equipment Coding\u201d, and MESC; Material and Equipment Standard Code, for spare parts. The new results achieved is more cost computing accuracy and precision. In conclusion, there two method; method one for existing plant and method two for new plant construction and both of the methods are important to be implemented on enterprise resource planning system in the seawater desalination sector for better cost computing precision.<\/p>\n

Keywords:<\/strong> Data Integration, Plant Equipment\u2019s, Spare Parts<\/p>\n

Acknowledgment<\/strong><\/h2>\n

Full regards and appreciation to Professor Salih Duffuaa and Professor Shokri Selim from the department of Industrial Engineering in the university of King Fahad Univesity for Petroleum and Minerals for their vital contribution and support to complete this paper, towards boost the industrial sector in applying cost management and control.<\/p>\n

1 Introduction<\/strong><\/h2>\n

1.1 Brief<\/strong><\/h3>\n

In order to have better control of the cost on the plant, you need to pr\u00e9cised computing of the cost. Data integration between the equipment in the plant and its spare parts will be of much help in this. However, this is not achieved in practice due to separate system of coding. The equipment coding in the plant is following AKZ numbering and classification system, whereas, the spare parts coding is following MESC material and equipment standard code.<\/p>\n

1.2 Problem Definition<\/strong><\/h3>\n

There are two methods; method one is for the existing plants, and method two is for the new plants construction, and both of the methods are important to be implemented on enterprise resource planning system in the seawater desalination sector for better cost computing precision.<\/p>\n

1.3 Objective<\/strong><\/h3>\n

The purpose of this paper is to discuss the method of data integration between the AKZ numbering and classification system; \u201cPlant Equipment Coding\u201d, and MESC; Material and Equipment Standard Code, for spare parts<\/p>\n

1.4 Proposed Solution<\/strong><\/h3>\n

The suggested method is to do data normalization for existing data to have a system of data integration for new data when constructing a new plant.<\/p>\n

1.5 Alternative<\/strong><\/h3>\n

Many IT company have tried many methods to fix this problem but it was not having a remarkable achievement due to the complexity of the data integration of the existing data and at the end relied on the experience of the employee who is working on the plant.<\/p>\n

1.6 Evaluation<\/strong><\/h3>\n

The new results will be achieved is more cost computing accuracy and precision due to the data link between the equipment and the spares in the plant.<\/p>\n

2 Background<\/strong><\/h2>\n

<\/p>\n

Figure 1 AKZ Classification System [3].<\/p>\n

The plant designation system AKZ is\u00a0a predecessor system for identifying plants, systems, sub-systems, and equipment items for plant operating companies. The implementation of AKZ is formalized by commonly known regulations. The system categorization\u00a0identifies entire machinery in a plant, from the smallest electronic component to the largest turbo-alternator. It also covers the buildings and structures. equipment is broken down into a number of levels. nomenclature structure.<\/p>\n

The MESC \u2013 Material and Equipment Standards and Code, is the cumulative development from idea born on October 1932, when it was recognized that a system was required whereby materials from various manufacturers and countries specified to different national standards, could be readily compared, identified and administrated. Moreover, national standards did not exist for many articles used by the companies and own standards had to be established to ensure safe and efficient operations. These were the basic ideas on which the concept of the MESC was based [1].<\/p>\n

MESC comprises three kinds of document:<\/p>\n

The \u201cCODING SCHDULE\u201d; which provide the common framework for coding of any item used in the company. It specifies the relevant group sub-group and\/or sub-sub-group, viz.: the first 4 or 6 figure of a ten-figure code number.<\/p>\n

The \u201cCATALOGUE\u201d; which show buying descriptions, units of measure and illustrations of selected materials and equipment together with their ten-figure code numbers.<\/p>\n

The \u201cGENERAL INDEX TO MESC\u201d; which is a list, in alphabetical sequence, all materials and equipment recorded in the \u201cCoding Schedule\u201d and \u201cCatalogue\u201d and refer to the first 4 or 6 figures of the ten-figure code numbers.<\/p>\n

The \u201cGeneral Index to MESC\u201d is developed by SHELL INTERNATIONALE PETROLEUM MAATSCHAPPIJ B.V. [1]<\/p>\n

3 Methodology<\/strong><\/h2>\n

<\/p>\n

Figure 2 Data Integration of AKZ Classification System with the MESC and One-to-One Database Relationship<\/p>\n

First of all, the idea of integrating plant equipment\u2019s coding system to its crossponding material and spare parts, it looks simple from the first looking point, however, when you go into practice and to the deep details of the process, it looks not easy. From Information Technology point of view; it is only mater of establishing One-to-One database relationship. However, the table primary key\u2019s of the AKZ classification system is different from the table primary key\u2019s of the MESC. Thus, you endup with many-to-many database relationship instead of One-to-One database relationship. Next, we do have two types of plants; (1) existing plants and (2) new plants. For every type we need to establish a method of creating database<\/p>\n

relationship between its AKZ System and its MESC System. Then, for the newplant, we need to track the database relation creation from the early stage of the plant creation project. Whereas, for the existing plant, practicly, it is done through the maintenance and operation people experience to establish the database relationship with the help of the IT people. This is done through, the maintenance people start to code the spare parts of the equipment by the time when the plant is in operation. In Fact, there is a real need to establish a standard policy and procedure to qurantee early database relationship establishment.<\/p>\n

At the beging, we need a system that track and document the creation of the plant from its early stage; asset-by-asset.<\/p>\n

Also, nowadays, there are many companies for building Enterprise Resource Project such as Oracle and SAP had succeeded in developing ERP systems that cover many aspects of the investment projects. Then, Which all covers the life cycle of the assets and could suite the implementation of Data Integration. In Conclusion, Enterprise Asset Management enables the customer to Support compliance and corporate governance with an enterprise perspective.<\/p>\n

4 Discussion<\/strong><\/p>\n

\"\"<\/p>\n

At the beging, the plant operator should co-operate with the designer\/manufacturer\/installer in a full analysis of its reliability, maintainability and safety characteristics. Such a ‘plant procurement’ exercise should include assessment of spare-part provisioning, of maintenance personnel training and of supplier support systems. The higher the potential costs of maintenance and unavailability the more vital is this exercise. Also, Decisions to buy new or replacement equipment should be based on a present-value life-cycle analysis of costs. Such an analysis must take into consideration both maintenance and unavailability costs \u2014 these being estimated, wherever possible, from documented experience. Then, The plant operator and supplier should co-operate in the collection and analysis of plant failure and maintenance data in order to identify maintenance problem areas and to determine the plant’s optimum maintenance operation. Since the design of equipment is a continuing process, information thus gathered should, ideally, be continuously fed back to the equipment manufacturer, and in certain circumstances to a data bank, which could be shared on an intercompany, national or international basis. The difficulties of these last operations continue to pose a major obstacle to the successful implementation of a data integration approach, communication systems are expensive and different organizations (with different objectives) are involved during the equipment life cycle [4]. In Conclusion, <\/a>we need a system that track and document the creation of the plant from its early stage; asset-by-asset.<\/p>\n

5 Results<\/strong><\/h2>\n

\"\"<\/p>\n

At the beging, there two methods for applying cost accounting; one, applying cost accounting on your process, two, applying cost accounting on your activities. Also, the more you apply cost accounting on your system, the more accurate and precise your results. Then, the vital of data integration between your plant equipment\u2019s coding system and the spare parts and materials coding system of the plant. In addition, from quality control point of view, in order to control and identify the losses in your plant process and activity , you need to track the higher part of your plant that is producing failures in system. In Conclusion, having a system of data integration between the AKZ Classification System and the MESC is must not a luxury.<\/p>\n

6 Conclusions<\/strong><\/h2>\n

In order to have better control of the cost on the plant, you need to pr\u00e9cised computing of the cost. Data integration between the equipment in the plant and its spare parts will be of much help in this. However, this is not achieved in practice due to separate system of coding. The equipment coding in the plant is following AKZ numbering and classification system, whereas, the spare parts coding is following MESC material and equipment standard code. There are two methods; method one is for the existing plants, and method two is for the new plants construction, and both of the methods are important to be implemented on enterprise resource planning system in the seawater desalination sector for better cost computing precision.<\/p>\n

The purpose of this paper is to discuss the method of data integration between the AKZ numbering and classification system; \u201cPlant Equipment Coding\u201d, and MESC; Material and Equipment Standard Code, for spare parts. The suggested method is to do data normalization for existing data to have a system of data integration for new data when constructing a new plant. Many IT company have tried many methods to fix this problem but it was not having a remarkable achievement due to the complexity of the data integration of the existing data and at the end relied on the experience of the employee who is working on the plant. The new results will be achieved is more cost computing accuracy and precision due to the data link between the equipment and the spares in the plant.<\/p>\n

References<\/strong><\/h2>\n
    \n
  1. \u201cGeneral Index to MESC\u201d, SHELL INTERNATIONALE PETROLEUM MAATSCHAPPIJ B.V., 1979<\/li>\n
  2. Abuouf, M ,Al-Habbib, K,\u201d GOVERNING AND OP?TIMIZIN?G BUSINESS IN THE SEAWATER DESALINATION SECTOR THROUGH TEROTECHNOLGY\u201d, The International Desalination Association World Congress on Desalination and Water Reuse 2015\/San Diego, CA, USA<\/li>\n
  3. Anlagenkennzeichnungssystem\u00a0(AKS\u00a0oder\u00a0AKZ),Wikipedia, https:\/\/de.wikipedia.org\/wiki\/Anlagenkennzeichnungssystem<\/a><\/li>\n
  4. Anthony Kelly, “Strategic Maintenance Planning”\u00a0, Butterworth-Heinemann, 2006-06-28, ISBN: 0750669926, 304 pages<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    Ahmed Abdulrahim Abuouf*, Khalid Mohamed Al Habib** *Saline Water Conversion Coropration, Saudi Arabia, aabuouf@swcc.gov.sa **Water Transmission and Technologies Co., Saudi Arabia, kalhabib@wttco.com Abstract The purpose of this paper is to discuss the method of data integration between the AKZ numbering and classification system; \u201cPlant Equipment Coding\u201d, and MESC; Material and Equipment Standard Code, for spare […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"doc_category":[18],"glossaries":[],"doc_tag":[],"knowledge_base":[19],"class_list":["post-1532","docs","type-docs","status-publish","hentry","doc_category-articles-issue7","knowledge_base-issue-7"],"year_month":"2026-06","word_count":1713,"total_views":"222","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"support","author_nicename":"support","author_url":"https:\/\/omaintec.org\/journal\/index.php\/author\/support\/"},"doc_category_info":[{"term_name":"Articles7","term_url":"https:\/\/omaintec.org\/journal\/index.php\/docs\/issue-7\/articles-issue7\/"}],"doc_tag_info":[],"knowledge_base_info":[{"term_name":"ISSUE# 7","term_url":"https:\/\/omaintec.org\/journal\/index.php\/docs\/issue-7\/","term_slug":"issue-7"}],"knowledge_base_slug":["issue-7"],"_links":{"self":[{"href":"https:\/\/omaintec.org\/journal\/index.php\/wp-json\/wp\/v2\/docs\/1532","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/omaintec.org\/journal\/index.php\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/omaintec.org\/journal\/index.php\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/omaintec.org\/journal\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/omaintec.org\/journal\/index.php\/wp-json\/wp\/v2\/comments?post=1532"}],"version-history":[{"count":2,"href":"https:\/\/omaintec.org\/journal\/index.php\/wp-json\/wp\/v2\/docs\/1532\/revisions"}],"predecessor-version":[{"id":1540,"href":"https:\/\/omaintec.org\/journal\/index.php\/wp-json\/wp\/v2\/docs\/1532\/revisions\/1540"}],"wp:attachment":[{"href":"https:\/\/omaintec.org\/journal\/index.php\/wp-json\/wp\/v2\/media?parent=1532"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/omaintec.org\/journal\/index.php\/wp-json\/wp\/v2\/doc_category?post=1532"},{"taxonomy":"glossaries","embeddable":true,"href":"https:\/\/omaintec.org\/journal\/index.php\/wp-json\/wp\/v2\/glossaries?post=1532"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/omaintec.org\/journal\/index.php\/wp-json\/wp\/v2\/doc_tag?post=1532"},{"taxonomy":"knowledge_base","embeddable":true,"href":"https:\/\/omaintec.org\/journal\/index.php\/wp-json\/wp\/v2\/knowledge_base?post=1532"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}