Source information

The Equipment Reliability model consists of two fact tables: one table holds planned and actual meter values, and the other holds statistics from maintenance operations in work orders.

Work order statistics are captured in the M3 table MBCOPE, and only closed work orders are included. The work orders are filtered by status that is greater than or equal to 90 but less than 99. For the model to work correctly, the downtime field in MOS070 must be populated. The work-order header information corresponds to data in MOS100.

Planned values are retrieved from M3 BE table MOOPPD. This table is populated by data entered in MOS380.

Actual usage and Life cycle usage are retrieved from tables MROOPM and MROOPC. The data corresponds to M3 program MOS271 or relation option 11 in MOS270.

Time is based on the date you enter when planning in MOS380 and on the date for actual usage transactions (daily meter values).

For work orders, time is based on the actual finish date of a work order.