Abstract

In pharmaceutical manufacturing areas, proper documentation of maintenance and calibration activities is an important aspect because it has to meet legal requirements, including GMP. Data normalisation is an important aspect of managing and transforming maintenance data into easily searchable, well-formatted, and efficient data for use. In this paper, we develop a detailed methodology for data normalisation, especially for use in pharmaceutical maintenance and calibration records. Normalisation entails the mapping of keys and tables to reduce the duplicity of data and the use of structured templates that increase operational efficiency. Examples of the suggested normalisation methods, such as the Boycott Normalization process, show how the strategies work in enhancing compliance besides decreasing the operational risks in reaping accuracy and increasing the reduction of redundancy.