About the ACA Data Loader General Loading Strategy

This section describes any prerequisites to loading the data and the order in which the data will be loaded.

Note: Before reading this section, refer to the Data Model section.

Prerequisites

The sites to which ACA records are to be assigned have been created.

Load Sequence

Note: If you want to set the site reference to be a Global Site Reference, enter the constant ‘*Global*’ in the MI_SITE_NAME column on the spreadsheet.

The ACA data load must be performed in a specific sequence to successfully populate fields, create records and link them to the predecessor and/or successor records:

Create the ACA Analysis.
Create and link one or more ACA Systems to the ACA Analysis through the Asset Criticality Analysis Has System relationship.
Create and link a Risk Assessment to the ACA System through the Has Risk relationship.
Create and link one or more Functional Locations to the ACA System through the Has Functional Location relationship.
Create and link a Risk Assessment to the Functional Location through the Has Risk Relationship.
Create and link one or more Equipment to the ACA System through the Safety Analysis Has Equipment relationship.
Create and link one or more Equipment to the Functional Locations through the Safety Analysis Has Equipment relationship.
Create and link a Risk Assessment to the Equipment through the Has Risk Relationship.

Limitations

In the data loader workbook, if the risks in the sheets are empty, the system risks are not inherited by the assets.
You can only create a new Analysis, System, and then link functional Locations and equipment. If you want to add any functional Locations and equipment to an existing system using a data loader workbook, all the earlier functional Locations and equipment are removed, and the new functional Locations and equipment are added.