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 GE Digital 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 GE Digital 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 GE Digital 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 GE Digital APM by the Production Loss Analysis (PLA) 2-Event Data Loader.
- Elements shown in green exist in GE Digital 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, GE Digital APM may modify the data model from one version to the next. In this scenario, the data loaders will be modified and maintained by GE Digital APM between releases.
Limitations
- If you reimport a record that currently exists in GE Digital APM, the newly imported record will replace the existing one in GE Digital 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
- Download the Production Loss Analysis (PLA) 2-Event data loader workbook provided by GE Digital APM:
- Identify the data requirements for exporting data from the legacy system into the data loader workbooks.
- Extract data from the legacy system to populate the data loader workbooks.
- Load data using the Production Loss Analysis (PLA) 2-Event data loader workbook.
- Monitor the status of the data load operation and report results.
- Conduct tests in GE Digital 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, GE Digital APM provides an Excel workbook, Production Loss Analysis (PLA) 2-Event.xlsx, which supports baseline PLA in GE Digital 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 following table provides a list of colors and what they represent.
|
Color |
Description |
Comments |
|---|---|---|
|
|
Fields with Special Notes |
Indicates columns that contain values that are used by the Production Loss Analysis (PLA) 2-Event Data Loader to create records. If these columns are removed from the worksheets, the data load operation will fail. While the worksheets require that these columns be present, values are not necessarily required in these columns. |
|
|
Required Fields |
Indicates columns that contain values that are required in PLA. |
|
|
Recommended Fields |
Indicates columns that, according to GE Digital Best Practice for PLA, should contain values. |
|
|
Optional |
Indicates columns where you can specify custom fields. |
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:
|
| Site Id | MI_SITE_ID | Character (255) | This cell is recommended. Enter the site ID where the Production Event occurred. |
| HeadLine | MI_PRDNEVNT_HEADLINE_C | Character (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 Date | MI_PRDNEVNT_START_DATE_D | Date |
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 Date | MI_PRDNEVNT_END_DATE_D | Date |
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 Code | MI_PRDNEVNT_RLT_PRDNEVNT_CD_C | Character (50) | This cell is recommended. Enter a value that matches an existing Production Event Code in GE Digital APM. |
| Causing Asset Category | MI_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 Asset | MI_PRDNEVNT_RLT_CAUSE_EQP_C | Character (255) | This cell is recommended. Enter the Equipment or Functional Location to which you want to attribute the cost of the Production Event. |
| Work History Link | MI_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 | Numeric | This 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_C | Text | This 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 GE Digital APM to confirm the accuracy and integrity of the data imported from the data loader workbook:
Procedure
- 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.
- In PLA, access the records specified in the data loader workbook, and then verify that the expected data is present or updated, as applicable.