search

Catalogs

hashtag
Introduction

In this paragraph, we will describe the format of Excel files used in the CMMS module to import various necessary catalogs, such as:

  1. Component Catalog: This catalog includes information about different components. Activities and replacement causes are associated with specific component groups and subgroups. Therefore, component catalog import is required for importing activities and replacement causes.

  2. Routine Maintenance Activity Catalog: This catalog contains a list of routine maintenance activities associated with specific component groups and subgroups.

  3. Replacement Causes Catalog: This catalog includes various causes for component replacements and is also associated with specific component groups and subgroups.

By importing the component catalog, activities, and replacement causes can be effectively linked to their respective component groups and subgroups.

hashtag
Notation

Before analyzing the syntax of the required catalogs, it is necessary to formalize the syntax to be used.

hashtag
Element

The lower hierarchical unit, which belongs to a group and a subgroup, is defined as an "element." Specifically, the elements for each available catalog are as follows:

  • Component Catalog: Component

  • Activity Catalog: Routine maintenance activity

  • Replacement Cause Catalog: Replacement cause

hashtag
Component in critical state

A component is defined to be in a critical state when the number of remaining cycles is less than or equal to the critical threshold specified in the database.

In the application, it is displayed in red color.

hashtag
General notes

In the first column of each table, bold entries specify which fields uniquely identify an element. These fields CANNOT be modified without creating a new element.

In general, the unique identifier for each element is defined as: Group + Subgroup + Element.

hashtag
Component Catalog

Component Catalog
Tipologia Colonna
Descrizione

GROUP

STR

Name group (ita)

GROUP ENG

STR (optional)

Nome group (eng)

SUBGROUP

STR

Name subgroup (ita)

SUBGROUP ENG

STR (optional)

Name subgroup (eng)

COMPONENT

STR

name component

CODE

STR (optional)

Component Code, it can be customer-specific for the purpose of reordering spare parts

DESCRIPTION

STR

Description (ita)

DESCRIPTION ENG

STR (optional)

Description (eng)

CRITICAL TRESHOLD

INT (optional)

Critical Threshold: The number of cycles at which the component is considered critical. When the component falls below this threshold, it is defined as critical. If this threshold is not defined, the component cannot be evaluated as being in a critical state.

SUBCRITICAL TRESHOLD

INT (optional)

Subcritical Threshold: The number of cycles at which the component is considered subcritical. This threshold must be greater than or equal to the critical threshold. When the component falls below this subcritical threshold, it is defined as subcritical. If this threshold is not defined, the component cannot be evaluated as being in a subcritical state.

EXPECTED NUMBER OF CYCLES

INT

Estimated Service Life of a Component: This refers to the number of cycles that a component can undergo from the installation date before reaching a high risk of failure that requires replacement.

IMAGE

INT (optional)

Image File Name: The name of the file that contains the image associated with the component (e.g., comp_XY1.png). Multiple components can share the same image.

INSTALLATION DATE

DATA (formato DD-MM-YYYY) (opzionale)

nstallation Date: The date on which the component was installed. If not specified, it is assumed to be the date of loading the Excel file (e.g., 14-06-2022).