2 Workflow to Create Import Configurations

Figure 1: Workflow to Create FMEA Import Configuration (WF77: Create FMEA Import Configuration)

Flowchart steps:

1. Open Application Preferences
2. Select FMEA Data Tab
3. Create a new configuration
4. Define Import Configuration Details (fed by: Name, Description)
5. Define Item Mapping (fed by: Worksheet, Header Rows, *Item Name, *Item Number, Delay Time (hrs), Distribution Type, Duration of operation, Exponential - MTTF, Exponential - Part Failure Rate, Is Critical, LCN, MTTR, Parent Item Number, Physical Description, Safety Item?, Spares on Hand, Turn Around Time (hrs), Weibull - Characteristic Life, Weibull - Slope)
6. Define FMEA Mapping (fed by: Worksheet, Header Rows, *Item Number, *Function, *Failure Mode, *Failure Mode ID, Failure Cause, Local Effects, Next Effects, End Effect, Detection Methods, Compensating Provisions, Prevention Controls, Substantiation Actions, MIL-STD-1629A properties, MIL-STD-882E properties, RPN properties, Narrative, Comment, Parent Item Number)
7. Import configuration is created

Detailed Descriptions:

1. Open Application Preferences (Task Menu: Preferences > Application Preferences).
2. Select FMEA Data tab (Task Menu: Preferences > Application Preferences > Modeling > Import > FMEA Data).
3. Click the plus icon to create a new FMEA import configuration.
4. Define the Import Configuration file details with the following: Name, Description.
5. To define the mapping to import items, enter worksheet name that contains item information and number of header rows in the import document. Properties marked * are mandatory mappings.
6. To define the mapping to import FMEA, enter worksheet name that contains FMEA information and number of header rows in the import document. Properties marked * are mandatory mappings. MIL-STD-1629A properties include severity class, failure effect probability, failure mode ratio, operating time, probability of occurrence, failure mode criticality number, and item criticality number. MIL-STD-882E properties include probability, probability level, risk assessment code, severity, and severity category. RPN properties include detection, occurrence, risk priority number, and severity.
7. FMEA Import configuration is created and ready for use in Model-Based RCM. Refer to WF75 - Create a Model based RCM analysis.

Figure 2: Workflow to Create Maintenance Actions Import Configuration (WF78: Create Maintenance Action Import Configuration)

Flowchart steps:

1. Open Application Preferences
2. Select Maintenance Action Tab
3. Create a new configuration
4. Define Import Configuration Details (fed by: Name, Description)
5. Define mapping In Action tab (fed by: Worksheet, Header Rows, *Name, *Maintenance Action ID, Active?, Description, Location, Inspection Interval (hrs), Maintenance Interval (hrs), Maintenance Type)
6. Define mapping In Tasks tab (fed by: Worksheet, Header Rows, *Name, *Maintenance Action ID, *Task ID, Activity Type, Downtime?, Duration (hrs))
7. Define mapping In Personnel tab (fed by: Worksheet, Header Rows, *Name, *Personnel ID, *Maintenance Task ID, Quantity, Rate)
8. Define mapping In Items tab (fed by: Worksheet, Header Rows, *Name, *Maintenance Action ID, Item ID, Activity Type, Quantity, Unit Cost)
9. Import configuration is created

Detailed Descriptions:

1. Open Application Preferences (Task Menu: Preferences > Application Preferences).
2. Select Maintenance Action tab (Task Menu: Preferences > Application Preferences > Modeling > Import > Maintenance Action).
3. Click the plus icon to create a new Maintenance data import configuration.
4. Define the Import Configuration file details with the following: Name, Description.
5. Action tab allows mapping of essential details for each maintenance action defined for an item, such as the Name, Maintenance Action ID, and Active? status. Users can provide a Description, specify Inspection Interval (hrs) and Maintenance Interval (hrs), and select the Location from options like Field, Local Depot, or Remote Depot. The Maintenance Type combines the type and sub-type of maintenance (e.g., Breakdown, Repair) to fully define the action. Enter worksheet name that has the information, number of header rows in the import document, and complete the mapping. Properties marked * are mandatory mappings.
6. Tasks tab allows mapping of individual tasks linked to maintenance actions. The Maintenance Action ID links the Tasks and Action categories. Key fields include the Task ID; Activity Type, indicating whether the task is maintenance or inspection; Downtime?, specifying if the task requires downtime or not; and Duration (hrs), the time required to complete the task. Enter worksheet name that has the information, number of header rows in the import document, and complete the mapping. Properties marked * are mandatory mappings.
7. Personnel tab allows mapping of the individuals involved in maintenance tasks. Key fields include the Personnel ID, which identifies each person; Personnel - Quantity, the total number of individuals assigned to a task; and Rate, the cost per person per hour for conducting maintenance or inspection tasks. The Task ID links this information to the relevant tasks. Enter worksheet name that has the information, number of header rows in the import document, and complete the mapping. Properties marked * are mandatory mappings.
8. Items tab allows mapping of the equipment and consumables required for the maintenance action. Key fields include Item ID, Quantity, and the cost of a single item. Enter worksheet name that has the information, number of header rows in the import document, and complete the mapping. Properties marked * are mandatory mappings.
9. Maintenance Action import configuration is created and ready for use. Refer to the Maintenance Import guide (see maintenance-import-guide-background-and-process-flow.md and maintenance-import-guide-synchronization.md in this knowledge base).