PLA Data Loaders

About the PLA Data Loaders

The Production Loss Analysis (PLA) Data Loaders allow you to load the production data that exists in a legacy system into APM. By loading the legacy production data, you can gain insight into the previous performance and compare it to the current and future performance. Using the data loaded by the PLA Data Loaders, you can maintain visibility and continuity in production reliability.

The PLA Data Loaders can also be used to:

  • Validate solution readiness by performing functional tests on the loaded data elements.
  • Enable effective training for a specific course by using the loaded data elements.

APM uses the following Data Loaders in PLA:

  • Production Loss Analysis (PLA) 1-Admin
  • Production Loss Analysis (PLA) 2-Event
  • Production Loss Analysis (PLA) 3-Plan

Each PLA Data Loader uses an Excel workbook, which is referred to as the data loader workbook.

PLA Data Loaders Purpose

You can use the three stage PLA Data Loaders for the following purposes:

  1. To upload historical records for Production Profiles, Production Events, and Production Plans.
  2. To update existing Production Plans with the following criteria:
    1. Add Production Plan data for reporting period 1.
    2. Update with Production data for period 2 with period 1 data being retained in target plans.
    3. Modify previously uploaded data.
    4. Modify Loss Reconciliation data by breaking them down into multiple elements.
    5. Change Events linked to losses.
    6. Change Event content (Event codes, OEE codes, and causing asset).
Note: The above use case is conditional on the target Production Plan being found for each data load.  If a target Production Plan is not found, a new Plan will be created.  This will occur when the analyst performing the data upload has a different timezone setting from the target Production Plan.  For example, an analyst in the USA with MM/DD/YYYY setting will cause a Production Plan in Europe with Plan Creation Date of DD/MM/YYYY to be missed by the loader.  To avoid creating duplicate plans in this way, ensure that the timezone matches that of the target Production Plan before performing the upload.