PLA Event Data Loader

About the Production Loss Analysis (PLA) 2-Event Data Loader

Using the Production Loss Analysis (PLA) 2-Event Data Loader, you can create the Production Event record.

About the Production Loss Analysis (PLA) 2-Event Data Loader Requirements

Before you use the Production Loss Analysis (PLA) 2-Event Data Loader:

  • If the following details are specified in the data loader workbook, ensure that they exist in APM:
    • Asset (Equipment or Functional Location)
    • Production Unit
    • Work History
    Tip: You can use the Production Loss Analysis (PLA) 1-Admin Data Loader to create the Production Unit records in APM.
    Important: To use this data loader, the Equipment and Functional Location families must use the baseline format of the ID Template.
  • If a Production Event Code is specified in the data loader workbook for a Production Unit, ensure that it is associated with the same Production Unit in APM.

Security Settings

The user who loads data must be associated with the following Security Groups and Security Roles:

  • MI Data Loader User Security Role

    -or-

    MI Data Loader Admin Security Role

  • MI Production Loss Accounting Administrator Security Group

    -or-

    A role that is associated with the MI Production Loss Accounting Administrator Security Group

About the Production Loss Analysis (PLA) 2-Event Data Loader Data Model

The following data model illustrates which records are supported by the Production Loss Analysis (PLA) 2-Event Data Loader:

  • The element shown in grey is imported into APM by the Production Loss Analysis (PLA) 2-Event Data Loader.
  • Elements shown in green exist in APM and may be related to the data that is being loaded.

About the Production Loss Analysis (PLA) 2-Event Data Loader General Loading Strategy

Best Practices

When using the Production Loss Analysis (PLA) 2-Event data loader workbook, ensure that:

  • The ID fields (that is, row 2) in each worksheet do not include special characters or spaces.
  • Columns of each worksheet, including those representing custom fields, are not formatted as Text.
  • The first two rows of each worksheet are not modified.

Modification Requirements and Guidelines

To accommodate a new or an enhanced feature, APM may modify the data model from one version to the next. In this scenario, the data loaders will be modified and maintained by APM between releases.

Limitations

  • If you reimport a record that currently exists in APM, the newly imported record will replace the existing one in APM. The Production Loss Analysis (PLA) 1-Admin Data Loader does not create a duplicate record.
  • You must not modify the template of the data loader workbook.

Load Sequence

  1. Download the Production Loss Analysis (PLA) 2-Event data loader workbook provided by APM:
  2. Identify the data requirements for exporting data from the legacy system into the data loader workbooks.
  3. Extract data from the legacy system to populate the data loader workbooks.
  4. Load data using the Production Loss Analysis (PLA) 2-Event data loader workbook.
  5. Monitor the status of the data load operation and report results.
  6. Conduct tests in APM to ensure that the imported data is loaded properly.

About the Production Loss Analysis (PLA) 2-Event Data Loader Workbook Layout and Use

To load data using the Production Loss Analysis (PLA) 2-Event Data Loader, APM provides an Excel workbook, Production Loss Analysis (PLA) 2-Event.xlsx, which supports baseline PLA in APM.

The following table provides a list of worksheets that are included in the Production Loss Analysis (PLA) 2-Event data loader workbook.

Worksheet

Description

ProductionEvent

This worksheet is used to specify the Production Event records.

Color Coding

Certain columns in the worksheets have different functions and requirements. To illustrate this, they are color-coded.

The PLA Administrators can choose and assign colors to the Impact Codes, and you can apply the code from the drop-down list.
Note: Colors are not applied in the baseline configuration and are not essential to the workflows.

ProductionEvent Worksheet

In the ProductionEvent worksheet, you will specify the Production Event records that you want to create.

Field Caption

Field ID

Data Type (Length)

Comments

Event Id

MI_PRDNEVENT_ID_C

Character (250)

This cell is required.

Enter a unique value.

RCA Needed

MI_PRDNEVNT_CREA_RCA_C

Character (50)

This cell is required.

Enter one of the following values:

  • No Entry
  • No RCA Needed
  • RCA Needed
Site IdMI_SITE_IDCharacter (255)This cell is recommended.

Enter the site ID where the Production Event occurred.

HeadLineMI_PRDNEVNT_HEADLINE_CCharacter (50)This cell is recommended.

Enter a short description of the Production Event.

Description

MI_PRDNEVNT_DESCR_C

Text

This cell need not have a value; however, the column must exist in the worksheet.

Enter a detailed description of the Production Event.

Start DateMI_PRDNEVNT_START_DATE_DDate

This cell is recommended.

Enter the date and time when the Production Event started.

The Start Date must represent the time zone of the Production Unit.

End DateMI_PRDNEVNT_END_DATE_DDate

This cell is recommended.

Enter the date and time when the Production Event ended.

The End Date must represent the time zone of the Production Unit.

Source Production Unit MI_PRDNEVNT_SRC_UNIT_C Character (50)This cell is recommended.

Enter the Production Unit to which the Production Loss is attributed.

Production Event CodeMI_PRDNEVNT_RLT_PRDNEVNT_CD_CCharacter (50)This cell is recommended.

Enter a value that matches an existing Production Event Code in APM.

Causing Asset CategoryMI_PRDNEVNT_UserSelection Character (50)

This cell is required if you specify a Causing Asset.

Select the family (that is, Equipment or Family) of the Causing Asset.

This cell is case-sensitive.

Causing AssetMI_PRDNEVNT_RLT_CAUSE_EQP_C Character (255)This cell is recommended.

Enter the baseline format ID Equipment or Functional location to which you want to attribute the cost of the Production Event.

For Equipment the baseline format ID is MI_EQUIP000_EQUIP_TECH_NBR_C~ MI_EQUIP000_EQUIP_SHRT_DESC_C~ MI_EQUIP000_EQUIP_ID_C

For Functional Equipment the baseline format ID is MI_FNCLOC00_FNC_LOC_C~MI_FNCLOC00_FNC_LOC_DESC_C

Work History LinkMI_PRDNEVNT_WRK_HIST_LNK_C Character (255)

This cell is recommended.

Enter one or more Work Histories that you want to link to the Production Event.

The cost of each linked Work History is added to the total cost of the Production Loss.

Other Event Cost

MI_PRDNEVNT_OTHR_EVNT_COST_N NumericThis cell need not have a value; however, the column must exist in the worksheet.

Enter a value for the additional costs, in dollars.

Comment

MI_PRDNEVNT_COMMENT_CTextThis cell need not have a value; however, the column must exist in the worksheet.

Enter a description of the event.

About the Production Loss Analysis (PLA) 2-Event Data Loader Load Verification

About This Task

After you load data, you can access the Production Event records.

You should perform the following steps in APM to confirm the accuracy and integrity of the data imported from the data loader workbook:

Procedure

  1. Access the details of the import job. In addition to the general information regarding the records that were loaded during the data load operation, these details may include error and warning messages pertaining to the records.
  2. In PLA, access the records specified in the data loader workbook, and then verify that the expected data is present or updated, as applicable.