Define Sorting Orders for Maintenance Statistics

This document explains how you define your own sorting orders and selection options to be used for maintenance statistics.

Outcome

Sorting orders with up to three inquiry fields per sorting order are defined. The information is stored in the Maintenance inquiry (MMCINO) file.

The sorting order is selected in 'Equipment Statistics. Display' (MCS420/P) and defaulted when you start (MCS430). This will sort and select the information according to your needs.

Before you start

No specific starting conditions exist for this activity.

Follow These Steps

Start 'Sorting order - Maintenance Stats. Open' (MCS490/B).
Enter an sorting order and select New to display the E panel.
Enter a description.
Enter 1 to 3 inquiry fields and optional field headings.
Enter 1 to 3 optional sorting fields along with operators.
Enter valid values in the From and To fields. Press Enter to finish.

Wild card searches can be entered in different ways.

Example: *A*B*C will search on fields that contain A, B and C in the order entered. There may however be letters between A, B and C.

*A_B_C* will search on fields with A, B and C. These must be in the order entered, but with only one letter between.

Parameters to Set


Program ID/Panel	Field	The field indicates …
(MCS490/B)	Sorting order	… the identity of a user-defined search key.
(MCS490/E)	Maintenance inquiry field	… the identity of the fields that are included in the sorting order. Three fields can be selected for each sorting order. The valid fields are: 001 = Equipment or position number 002 = Product number 003 = Structure type 004 = Service 005 = Service group 006 = Type of process 007 = Maintenance order type 008 = Maintenance responsible 009 = Error code 1 010 = Error code 2 011 = Error code 3 012 = Reason code 013 = Event type 014 = Priority 015 = Work center 016 = Department 017 = Planning area 018 = Item group 019 = Product group 020 = Accounting control object 021 = Project number 022 = Reference order number 023 = Criticality class 024 = MEL reference 025 = Work order number 026 = Lot number.
(MCS490/E)	Heading	… a user-defined heading to be connected to the field. The standard heading will be used if the field is left blank.
(MCS490/E)	Selection field	… up to three fields per sorting order that can be used to update the key file. The following fields can be used: 001 = Configuration position 002 = Product number 003 = Structure type 004 = Service 005 = Service group 006 = Type of process 007 = Maintenance order type 008 = Maintenance responsible 009 = Failure code 010 = Error code 2 011 = Error code 3 012 = Reason code 013 = Event type 014 = Priority 015 = Work center 016 = Department 017 = Planning area 018 = Item group 019 = Product group.
(MCS490/E)	Inquiry operator	… a selection within the records in the selection field. A number of alternatives exist for how the selection is made. The following alternatives exist: EQ=Equal, NE=Not equal, GT=Greater than, LT=Less than, GE=Greater than or equal to, LE=Less than or equal to, SC=Wild card search (XX, XX, XX), BT=Between the values given.