Data Loader
About the System Reliability Data Loader
The System Reliability Data Loader allows both primary and third-party content to be delivered to GE Digital APM through the System Reliability Data Model.
Using the System Reliability Data Loader, you can import the following types of primary and third-party data from a fixed-format Excel workbook into the System Reliability Data Model:
- System Analysis records
- System Scenario records
- System Subsystem records
- System Asset records
- System Risk records
- System Action records
- System Risk Assessment records
About the System Reliability Data Loader Requirements
To use the System Reliability Data Loader, your organization must have completed the deployment of the Reliability Analytics module.
Security Settings
The Security User performing the data load operation must be associated with either the MI Data Loader User or MI Data Loader Admin Security Role, and must also be associated with the MI Reliability Administrator Security Group, the MI Reliability User Security Group, or a Security Role that is associated with this Security Group.
About the System Reliability Data Loader Data Model
System Reliability Data Loader Data Model
The following diagram shows how the families used in System Reliability Data Loader are related to one another.
About the System Reliability Data Loader General Loading Strategy
Best Practices
When importing data using the System Reliability Data Loader, you must use the following best practices:
- ID fields (row 2 of each worksheet) must not include special characters or spaces.
- Columns in the worksheets should be formatted as either text or dates.
- The first two rows of each worksheet should not be edited.
- Only import a maximum of 500 analyses in each data load.
Limitations
This section documents a list of the limitations for the System Reliability Data Loader:
- The user must use the System Reliability Data Loader workbook (System Reliability.xlsx). Any modifications made by the user to the values in column headings in any of the worksheets will not be imported.Note: Any column values in a customized format will not be imported by the System Reliability Data Loader.
- If the user imports the same data multiple times, multiple analyses will be created.
Load Sequence
- Create System Analysis record.
- Link a System Analysis record to a System Scenario record through the Has Scenarios Relationship.
- Link a System Scenario record to a System Subsystem record through the Has Root System Relationship.
- Link a System Subsystem record to a System Asset record through the Has System Elements Relationship.
- Link a System Asset record to a System Action record through the Has System Actions Relationship, and then link the System Action Record to a System Risk Assessment record.
- Link a System Asset record to a System Risk record through the Has System Risks Relationship, and then link the System Risk record to a Distribution.
About the System Reliability Data Loader Workbook Layout and Use
In order to import data using the System Reliability Data Loader, GE Digital APM provides an Excel workbook (System Reliability.xlsx) that supports baseline System Reliability in GE Digital APM. This template must be used to perform the data load.
| Worksheet | Description |
|---|---|
| System Analysis | This worksheet is used to define System Analysis records. |
| System Scenario | This worksheet is used to define System Scenario records. |
| System Subsystem | This worksheet is used to define System Subsystem records. |
| System Asset | This worksheet is used to define System Asset records. |
| System Risk | This worksheet is used to define System Risk records. |
| System Action | This worksheet is used to define System Action records. |
| System Risk Assessment | This worksheet is used to determine the System Risk Assessment records used for a System Scenario record. |
Example: System Scenario Worksheet
The following table depicts a System Scenario record for a Parallel Motor/Pump Configuration. You can enter the details of a System Scenario record into the System Scenario worksheet provided by the System Reliability Data Loader workbook.
| System Reliability Analysis Key | Scenario Key | Scenario Name |
|---|---|---|
|
MI_STRATANA_ANALY_KEY |
MI_STRATSCE_KEY |
MI_STRATSCE_NAME_C |
|
1234 |
4567 |
Parallel Motor/Pump Configuration |
System Code Tables
The following table lists the fields from the Reliability Analytics System Codes table that must be configured:
|
Field Name |
Field ID |
|---|---|
| Action Type | MI_ACTION_TYPE |
| Action - Condition Monitoring Type | MI_CONDITION_MONITORING_TYPE |
System Analysis Worksheet
System Analysis records store general information about a System Analysis.
|
Field Caption |
Field ID |
Data Type (Length) |
Comments |
|---|---|---|---|
| System Reliability Analysis Key | MI_STRATANA_ANALY_KEY | Numeric |
This field is required and must be unique. |
| Analysis ID | MI_AN_ANALY_ID_CHR | Character (255) |
This field is required and must be unique. |
| Site ID | MI_SITE_ID | Character (50) |
This field is required and must be unique. If the value in this field is black, then the site will be set to Global by default. |
System Scenario
System Scenario records store general information about a scenario in a System Reliability Analysis.
|
Field Caption |
Field ID |
Data Type (Length) |
Comments |
|---|---|---|---|
| System Reliability Analysis Key | MI_STRATANA_ANALY_KEY | Numeric |
This field is required and must match the System Reliability Analysis Key in the System Analysis worksheet. |
| Scenario Key | MI_STRATSCE_KEY | Numeric | This field is required and must be unique. This field must be associated with the System Reliability Analysis Key in the System Analysis worksheet . |
| Scenario Name | MI_STRATSCE_NAME_C | Character (255) | This field is required and must be unique. This field must be associated with the System Reliability Analysis Key in the System Analysis worksheet . |
System Subsystem
System Subsystem records store information about a system of equipment or locations.
|
Field Caption |
Field ID |
Data Type (Length) |
Comments |
|---|---|---|---|
| System Reliability Analysis Key | MI_STRATANA_ANALY_KEY | Numeric |
This field is required and must match the System Reliability Analysis Key in the System Analysis worksheet. |
| Scenario Key | MI_STRATSCE_KEY | Numeric |
This field is required and must match the Scenario Key in the System Scenario worksheet. |
| Predecessor Asset Key | MI_ASOSYSTE_CONNE_PRED | Numeric |
This field is required. If the value in this field is blank, then the asset will be connected to the Start node. |
| Successor Asset Key | MI_ASOSYSTE_CONNE_SUCC | Numeric | This field is required. If the value in this field is blank, then the asset will be connected to the End node. |
System Asset
System Asset records store information about equipment and locations that exist in the System Analysis diagram.
|
Field Caption |
Field ID |
Data Type (Length) |
Comments |
|---|---|---|---|
| System Reliability Analysis Key | MI_STRATANA_ANALY_KEY | Numeric |
This field is required and must match the System Reliability Analysis Key in the System Analysis worksheet. |
| Scenario Key | MI_STRATSCE_KEY | Numeric |
This field is required and must match the Scenario Key in the System Scenario worksheet. |
| Asset Key | MI_ASOASSET_ASSET_KEY_N | Numeric | This field is required and must be unique. This field must be associated with the System Reliability Analysis Key in the System Analysis worksheet and with the System Scenario Key in the System Scenario worksheet. |
| Asset Name | MI_ASOELEME_NAME_C | Character (255) | This field is required and must be unique. This field must be associated with the System Reliability Analysis Key in the System Analysis worksheet and with the System Scenario Key in the System Scenario worksheet. |
| Equipment ID | MI_EQUIP000_EQUIP_ID_C | Character (255) | This field is optional. |
| Functional Location ID | MI_FNCLOC00_ID | Character (50) | This field is optional. |
System Risk
System Risk records store details about a Risk in a System Analysis and the cost of an equipment or location failure due to that Risk.
|
Field Caption |
Field ID |
Data Type (Length) |
Comments |
|---|---|---|---|
| System Reliability Analysis Key | MI_STRATANA_ANALY_KEY | Numeric |
This field is required and must match the System Reliability Analysis Key in the System Analysis worksheet. |
| Scenario Key | MI_STRATSCE_KEY | Numeric |
This field is required and must match the Scenario Key in the System Scenario worksheet. |
| Asset Key | MI_ASOASSET_ASSET_KEY_N | Numeric |
This field is required and must match the Asset Key in the System Asset worksheet. |
| Risk Key | MI_ASORISK_KEY | Numeric | This field is required and must be unique. This field must be associated with the System Reliability Analysis Key in the System Analysis worksheet and the Asset Key in the System Asset worksheet. |
| Risk Name | MI_ASORISK_NAME | Character (255) | This field is required and must be unique. This field must be associated with the System Reliability Analysis Key in the System Analysis worksheet and the Asset Key in the System Asset worksheet. |
| TTF | MI_DISTRIB_EXPN_TTF | Numeric |
This field is required. |
| TTF Units | MI_DISTRIB_UNIT_TTF | Character (20) |
This field is required. |
| TTR | MI_DISTRIB_EXPN_TTR | Numeric |
This field is required. |
| TTR Units | MI_DISTRIB_UNIT_TTR | Character (20) | This field is required. |
System Action
System Action records store information about Condition-Based Maintenance, Procedure, Redesign, Time-Based Maintenance, and Training Actions.
|
Field Caption |
Field ID |
Data Type (Length) |
Comments |
|---|---|---|---|
| System Reliability Analysis Key | MI_STRATANA_ANALY_KEY | Numeric |
This field is required and must match the System Reliability Analysis Key in the System Analysis worksheet. |
| Scenario Key | MI_STRATSCE_KEY | Numeric |
This field is required and must match the Scenario Key in the System Scenario worksheet. |
| Asset Key | MI_ASOASSET_ASSET_KEY_N | Numeric |
This field is required and must match the Asset Key in the System Asset worksheet. |
| Action Key | MI_STRATACT_KEY | Numeric | This field is required and must be unique. This field must be associated with the System Reliability Analysis Key in the System Analysis worksheet, the Scenario Key in the System Scenario worksheet, and the Asset Key in the System Asset worksheet. |
| Action Name | MI_STRATACT_NAME_C | Character (255) | This field is required and must be unique. This field must be associated with the System Reliability Analysis Key in the System Analysis worksheet, the Scenario Key in the System Scenario worksheet, and the Asset Key in the System Asset worksheet. |
| Action Type | MI_STRATACT_ACTIO_TYPE_C | Character (50) |
This field is required. |
| Action - Condition Monitoring Type | MI_STRATACT_COND_MONI_TYPE_C | Character (50) | This field is required only if the value in the Action Type field is Condition-Based Maintenance (Preventative). The values in this field are populated by the MI_ACTION_TYPE System Code Table. |
|
Action Cost | MI_STRATACT_FIXED_COST_N | Numeric |
This field is required. This value represents an expense that is incurred every time the action occurs. By default, the value in this field is set to 0 (zero). |
| Action Interval | MI_STRATINSP_INTER_N | Numeric |
This field is required. |
| Action Interval UOM | MI_STRATINSP_INTER_UNITS_C | Character (50) |
This field is required. |
| Action Duration | MI_STRATINSP_DURAT_N | Numeric |
This field is required. |
| Action Duration UOM | MI_STRATINSP_DURAT_UNITS_C | Character (50) |
This field is required. |
System Risk Assessment
System Risk Assessment records store information about the Risks and Actions included in a specific scenario.
|
Field Caption |
Field ID |
Data Type (Length) |
Comments |
|---|---|---|---|
| System Reliability Analysis Key | MI_STRATANA_ANALY_KEY | Numeric |
This field is required and must match the System Reliability Analysis Key in the System Analysis worksheet. |
| Scenario Key | MI_STRATSCE_KEY | Numeric |
This field is required and must match the Scenario Key in the System Scenario worksheet. |
| Asset Key | MI_ASOASSET_ASSET_KEY_N | Numeric |
This field is required and must match the Asset Key in the System Asset worksheet. |
| Action Key | MI_STRATACT_KEY | Numeric |
This field is required and must match the Action Key in the System Action worksheet. |
| Risk Key | MI_ASORISK_KEY | Numeric |
This field is required and must match the Risk Key in the System Risk worksheet. |
About the System Reliability Data Loader Load Verification
About This Task
A successful import can also be defined as an event where partial data on a worksheet was loaded into GE Digital APM, and where the user was given appropriate messaging that enabled him or her to identify and correct issues resulting from the import.