# Determination of Benefits of the Application of CMMS Database Improvement Proposals
## 2 The Evaluation Methodology
\begin{table}
\begin{tabular}{c c c c} \hline \hline
**Group** & **Color** & **No.** & **Question** \\ \hline \multirow{8}{*}{Jobs inside DB} & \multirow{8}{*}{R} & \multirow{8}{*}{9} & Is there a linked maintenance schedule for all equipment on DB according to the manufacturer’s recommendations? \\  & & & \\ \cline{2-3}  & & & \\ \cline{2-3}  & & & \\ \cline{2-3}  & & & \\ \cline{2-3}  & & & \\ \cline{2-3}  & & & \\ \cline{2-3}  & & & \\ \hline \multirow{2}{*}{Special jobs and rules} & \multirow{2}{*}{R} & \multirow{2}{*}{17} & Is the PMS DB self-improvement program entered into DB, and is there a control mechanism for the PMS DB self-improvement program? \\ \cline{2-3}  & & & \\ \cline{2-3}  & & & \\ \cline{2-3}  & & & \\ \hline \multirow{8}{*}{DB jobs general} & \multirow{8}{*}{DB jobs} & \multirow{8}{*}{19} & Are job descriptions clearly and unambiguously stated? \\  & & & \\ \cline{2-3}  & & & \\ \cline{2-3}  & & & \\ \cline{2-3}  & & & \\ \cline{2-3}  & & & \\ \cline{2-3}  & & & \\ \hline \multirow{8}{*}{Sparse parts} & \multirow{8}{*}{R} & \multirow{2}{*}{25} & Are all spare parts correctly identified, do they have sufficient data for ordering? \\  & & & & \\ \cline{2-3}  & & & & \\ \cline{2-3}  & & & & \\ \cline{2-3}  & & & & \\ \cline{2-3}  & & & & \\ \cline{2-3}  & & & & \\ \cline{2-3}  & & & & \\ \hline \multirow{8}{*}{Miscellaneous} & \multirow{8}{*}{G} & \multirow{2}{*}{29} & Are all users entered in the DB, are all access rights correctly defined? \\ \cline{2-3}  & & & & \\ \cline{2-3}  & & & & \\ \cline{2-3}  & & & & \\ \cline{2-3}  & & & & \\ \cline{2-3}  & & & & \\ \hline \hline \end{tabular}
\end{table} 
Table 1: _Cont._two, or one are considered unsatisfactory and data improvement should be made here. The schedule for data changes in the database should correspond to the color schedule (R, Y, G). After the development of the methodology, serious efforts were made to test it in practice and to study various aspects of its application. The methodology was used (from 2017 to 2019) to analyze the state and quality of forty-four CMMS databases in five different shipping companies operating different types of vessels (one company operates passenger vessels, two companies operate a mix of bulk carriers and tankers, one company operates bulk carriers, and one company operates VLCCs). Testing of the methodology in different companies, with different working practices and methods, and on different types of vessels has shown that it can be used as a universal tool for evaluating CMMS databases and paper-based PMSs. After testing, the following claims about the methodology were made and verified:  
* The methodology is a useful tool for evaluating CMMS data and databases [30];
* The methodology is easy to use [30];
* The results obtained are reliable [30];
* The application of the methodology reduces the subjectivity of the evaluator [32];
* The application of the methodology facilitates the evaluation of databases [32];
* The application of the methodology makes the evaluation much more detailed [32];
* The application of the methodology facilitates the identification of deficiencies [32].