System Reliability Data Loader

About the System Reliability Data Loader

The System Reliability Data Loader allows both primary and third-party content to be delivered to 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 Buffer records
System Link records
System Switch records
System Sensor records
System Risk records
System Action records
System Risk Assessment records

Note: The System Reliability Data Loader will not be backwards compatible to earlier versions of APM.

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.

Note: In the diagram, boxes represent entity families and arrows represent relationship families that are configured in the baseline database. You can determine the direction of each relationship definition from the direction of the arrow head: the box from which the arrow originates is the predecessor, and the box to which the arrow head points is the successor.

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 Subsystem record to a System Buffer record through the Has System Elements Relationship.
Link a System Subsystem record to a System Link record through the Has System Elements Relationship.
Link a System Subsystem record to a System Switch record through the Has System Elements Relationship.
Link a System Subsystem record to a System Sensor 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, APM provides an Excel workbook (System Reliability.xlsx) that supports baseline System Reliability in APM. This template must be used to perform the data load.

The following table lists the worksheets that are included in the System Reliability workbook.


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 Buffer	This worksheet is used to define System Buffer records.
System Link	This worksheet is used to define System Link records.
System Switch	This worksheet is used to define System Switch records.
System Sensor	This worksheet is used to define System Sensor records.
System Diagram	This worksheet is used to define connections between System Element 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

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_STRATANA_NAME_C	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. The value in the field 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. The value in the field 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.
Parent Subsystem Key	MI_ASOSUBSYSTEM_PARENT_KEY	Numeric	This field must be blank or match the Subsystem Key in another row of the same worksheet.
Subsystem Key	MI_ASOSUBSYSTEM_KEY	Numeric	This field is required. The value in the field must be unique. The field must be associated with the System Reliability Analysis Key in the System Analysis worksheet and with the Scenario Key in the System Scenario worksheet.
Name	MI_ASOSUBSYSTEM_NAME_C	Character (255)	This field is required. The value in the field must be unique. The field must be associated with the System Reliability Analysis Key in the System Analysis worksheet and with the Scenario Key in the System Scenario worksheet.

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.
Subsystem Key	MI_ASOSUBSYSTEM_KEY	Numeric	This field is required and must match the Subsystem Key in the System Subsystem worksheet.
Asset Key	MI_ASOASSET_KEY	Numeric	This field is required. The value in the field 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_ASOASSET_NAME_C	Character (255)	This field is required. The value in the field must be unique. The 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 Buffer

System Buffer records store information about buffer elements 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.
Subsystem Key	MI_ASOSUBSYSTEM_KEY	Numeric	This field is required and must match the Subsystem Key in the System Subsystem worksheet.
Buffer Key	MI_ASOBUFFE_KEY	Numeric	This field is required. The value in the field must be unique. The 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.
Name	MI_ASOBUFFE_NAME_C	Character (255)	This field is required. The value in the field must be unique. The 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.
Initial Quantity in Percentage	MI_ASOBUFFE_INI_QUA_IN_PER_N	Numeric	This field is required.
Time to Empty	MI_ASOBUFFE_TIME_TO_EMP_N	Numeric	This field is required.
Time to Empty Units	MI_ASOBUFFE_TIME_TO_EMPUNS_C	Character (50)	This field is required.
Time to Refill	MI_ASOBUFFE_TIME_TO_REF_N	Numeric	This field is required.
Time to Refill Units	MI_ASOBUFFE_TIME_TO_REFUNS_C	Character (50)	This field is required.

System Link

System Link records store information about link elements 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.
Subsystem Key	MI_ASOSUBSYSTEM_KEY	Numeric	This field is required and must match the Subsystem Key in the System Subsystem worksheet.
Link Key	MI_ASOLINK_KEY	Numeric	This field is required. The value in the field must be unique. The 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.
Name	MI_ASOLINK_NAME_C	Character (255)	This field is required. The value in the field must be unique. The 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.
Minimum Predecessors	MI_ASOLINK_MINIM_PREDE_N	Numeric	This field is required.

System Switch

System Switch records store information about switch elements 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.
Subsystem Key	MI_ASOSUBSYSTEM_KEY	Numeric	This field is required and must match the Subsystem Key in the System Subsystem worksheet.
Switch Key	MI_ASOSWIT_KEY	Numeric	This field is required. The value in the field must be unique. The 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.
Name	MI_ASOSWIT_NAME_C	Character (255)	This field is required. The value in the field must be unique. The 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.
Is Initially On	MI_ASOSWIT_IS_INIT_ON_F	Boolean	This field is required.

System Sensor

System Sensor records store information about sensor elements 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.
Subsystem Key	MI_ASOSUBSYSTEM_KEY	Numeric	This field is required and must match the Subsystem Key in the System Subsystem worksheet.
Name	MI_ASOSENSO_NAME_C	Character (255)	This field is required. The value in the field must be unique. The 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.
Monitored Elements	MI_ASOSENSO_MONIT_ELEME_T	Text	This field is required. The field contains the comma-separated keys of System Subsystem/Asset/Buffer/Switch records.
Deactivated Switches	MI_ASOSENSO_DEACTI_SWIT_T	Text	This field is required. The field contains the comma-separated keys of System Switch records.
Activated Switches	MI_ASOSENSO_ACTI_SWIT_T	Text	This field is required. The field contains the comma-separated keys of System Switch records.

System Diagram

System Diagram records store information about element connections 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.
Subsystem Key	MI_ASOSUBSYSTEM_KEY	Numeric	This field is required and must match the Subsystem Key in the System Subsystem worksheet
Predecessor Node Key	MI_ASODIAG_PRED_KEY	Numeric	This field is required and must match the System Subsystem key in the System Analysis worksheet. If the value in the field is blank, the asset will be connected to the Start node. Note: This is a complex field storing xml text.
Successor Node Key	MI_ASODIAG_SUCC_KEY	Numeric	This field is required and must match the System Subsystem key in the System Analysis worksheet. If the value in the field is blank, the asset will be connected to the End node. Note: This is a complex field storing xml text.

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_KEY	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. The value in the field must be unique. The 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. The value in the field must be unique. The 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. It must be associated with the TTF Distribution in the Exponential family with the MTBF field.
TTF Units	MI_DISTRIB_UNIT_TTF	Character (20)	This field is required. It must be associated with the TTF Distribution in the Exponential family with the Units field.
TTR	MI_DISTRIB_EXPN_TTR	Numeric	This field is required. It must be associated with the TTR Distribution in the Exponential family with the MTBF field.
TTR Units	MI_DISTRIB_UNIT_TTR	Character (20)	This field is required. It must be associated with the TTR Distribution in the Exponential family with the Units field.

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_KEY	Numeric	This field is required and must match the Asset Key in the System Asset worksheet.
Action Key	MI_ASOACT_KEY	Numeric	This field is required. The value in the field must be unique. The 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_ASOACT_NAME_C	Character (255)	This field is required. The value in the field must be unique. The 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 the field are populated by the MI_ACTION_TYPE System Code Table.
Action Cost	MI_STRATACT_FIXED_COST_N	Numeric	This field is required. The value in the field represents an expense that is incurred every time the action occurs. By default, the value in the field is 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

Following a successful data load, you can navigate to the System Reliability section of the RA Overview page and view the analysis created from the imported workbook.

A successful import can also be defined as an event where partial data on a worksheet was loaded into APM, and where the user was given appropriate messaging that enabled him or her to identify and correct issues resulting from the import.