About the ACA Data Loader Workbook Layout and Use

This section provides a high-level overview and explanation of how the data loader workbook is constructed.

In order to import data using the ACA Data Loader, GE Digital provides an Excel workbook, ACA DataLoader(ACA).xlsx, which supports baseline Asset Criticality Analysis in GE Digital APM. This workbook must be used to perform the data load. You can modify the Excel template to include custom fields used by your organization.

The master Excel workbook contains one worksheet for each node that will be populated in the data model.

The following table lists the worksheets that are included in the Asset Criticality Analysis (ACA) workbook.

Worksheet	Description
Analysis	This worksheet is used to specify data for import to the Asset Criticality Analysis family.
System	This worksheet is used to specify data for import to the Asset Criticality Analysis System family including system level risk entries.
Asset	This worksheet is used to specify data for linking existing Functional Locations and Equipment to the Asset Criticality Analysis System family including asset level risk entries.
Equipment	This worksheet is used to specify data for linking existing Equipment to existing Functional Locations including equipment-level risk entries.

Each worksheet in the ACA Data Loader Template workbook contains field values that must be mapped to the appropriate GE Digital APM family/field combination. The individual sections in this document specify the source and target fields and relationships required between predecessor and successor.

The list of fields tabulated is not exhaustive. The user can add additional field columns to the worksheets and still perform a successful upload, provided:

Column fields are properly mapped within the worksheet
Equivalent fields exist in ACA

Analysis Worksheet

On the Analysis worksheet, you will specify the Analysis ID to which you want link the System. The columns that appear on this worksheet also appear on every subsequent worksheet, and are used to identify the records that will be linked, directly or indirectly, to the analysis.

Note: Each row in this worksheet represents a unique analysis. You should not include the same analysis more than once.

Field Caption	Field ID	Data Type (Length)	Comments
Batch ID	MI_BATCH_ID	Character (255)	This field is required and can be either a character string or numeric field.
Analysis ID	MI_AN_ANALY_ID_CHR	Character (255)	This field is required and must be unique.
Site Reference Name	MI_SITE_NAME	Character (50)	This field is required and must match an existing Site name. 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.
Analysis Description	MI_AN_SHORT_DESCR_CHR	Character(255)	This field contains a brief description about the Asset Criticality Analysis.
Analysis Owner	MI_ASCRTANL_OWNER_C	Character (255)	The name of the team member who is specified as the Process Owner for the ACA. This field is disabled and populated automatically with the value in the Process Owner field.
Analysis Type	MI_AN_ANALY_TYPE_CHR	Character (255)	This field contains the type of analysis.

System Worksheet

On the System worksheet, you will specify the systems that will be created and linked to analysis. The System ID column on this worksheet also appears on the Asset Worksheet and relates System to the Asset.

Note: Each row in this worksheet represents a unique system. You should not include the same asset more than once to the same analysis.

Note: When you enter N/A in the column for any of the Safety, Environment, Operations or Financial values in the Data Loader, the associated Unmitigated Risk is set as Not Applicable.

Field Caption	Field ID	Data Type (Length)	Comments
Batch ID	MI_BATCH_ID	Character (255)	This field is required and can be either a character string or numeric field.
Analysis ID	MI_AN_ANALY_ID_CHR	Character (255)	This field is required and must be unique.
System ID	MI_ASCRTSYS_SYSTEM_ID_C	Character (255)	The System ID must be unique with respect to other systems that belong to the same analysis.
System Description	MI_ASCRTSYS_SYSTEM_DESCR_T	Text	A brief description of the system.
System Equipment Type	MI_ASCRTSYS_SYSTEM_EQ_TYPE_C	Character (255)	A description of the type of equipment that the system contains. You can select a value from the list.
System Process Type	MI_ASCRTSYS_SYSTEM_PROC_TYPE_C	Character (255)	The field describes the type of equipment that the system contains.
(ENVIRONMENT) Consequence	ENVIRONMENT\|MI_CONSE_N	Numeric	Must be filled based on the risk matrix of the site.
(ENVIRONMENT) Probability	ENVIRONMENT\|MI_PROB_N	Numeric	Must be filled based on the risk matrix of the site.
(ENVIRONMENT) Protection Level	ENVIRONMENT\|MI_PROT_N	Numeric	Must be filled based on the risk matrix of the site.
(ENVIRONMENT) Risk Rank	ENVIRONMENT-RISK_RANK	Numeric	Must be filled based on the risk matrix of the site
(FINANCIAL) Consequence	FINANCIAL\|MI_CONSE_N	Numeric	Must be filled based on the risk matrix of the site.
(FINANCIAL) Maintenance Cost	FINANCIAL\|MI_RISK_MAIN_COST_N	Numeric	Must be filled based on the risk matrix of the site.
(FINANCIAL) Probability	FINANCIAL\|MI_PROB_N	Numeric	Must be filled based on the risk matrix of the site.
(FINANCIAL) Production Loss	FINANCIAL\|MI_RISK_PROD_LOSS_N	Numeric	Must be filled based on the risk matrix of the site.
(FINANCIAL) Protection level	FINANCIAL\|MI_PROT_N	Numeric	Must be filled based on the risk matrix of the site.
(FINANCIAL) Risk Rank	FINANCIAL-RISK_RANK	Numeric	Must be filled based on the risk matrix of the site.
(OPERATIONS) consequence	OPERATIONS\|MI_CONSE_N	Numeric	Must be filled based on the risk matrix of the site.
(OPERATIONS) Probability	OPERATIONS\|MI_PROB_N	Numeric	Must be filled based on the risk matrix of the site.
(OPERATIONS) Protection Level	OPERATIONS\|MI_PROT_N	Numeric	Must be filled based on the risk matrix of the site.
(OPERATIONS) Risk Rank	OPERATIONS-RISK_RANK	Numeric	Must be filled based on the risk matrix of the site.
(SAFETY) Consequence	SAFETY\|MI_CONSE_N	Numeric	Must be filled based on the risk matrix of the site.
(SAFETY) Probability	SAFETY\|MI_PROB_N	Numeric	Must be filled based on the risk matrix of the site.
(SAFETY) Protection Level	SAFETY\|MI_PROT_N	Numeric	Must be filled based on the risk matrix of the site.
(SAFETY) Risk Rank	SAFETY-RISK_RANK	Numeric	Must be filled based on the risk matrix of the site.
Basis for Assesment	MI_RISKASSE_BASIS_T	Text	Must be filled based on the risk matrix of the site.

Asset Worksheet

On the Asset worksheet, you will specify Functional Locations or Equipment that will be created and linked to the system. The Asset Id column that appears on this worksheet also appears on the Equipment Worksheet and relates Functional Location to the Equipment.

Note: Each row in this worksheet represents a unique asset. You should not include the same asset more than once.

Note: When you enter N/A in the column for any of the Safety, Environment, Operations or Financial values in the Data Loader, the associated Unmitigated Risk is set as Not Applicable.

Field Caption	Field ID	Data Type (Length)	Comments
Batch ID	MI_BATCH_ID	Character (255)	This field is required and can be either a character string or numeric field.
Analysis ID	MI_AN_ANALY_ID_CHR	Character (255)	This field is required and must be unique.
System ID	MI_ASCRTSYS_SYSTEM_ID_C	Character (255)	The System ID must be unique with respect to other systems that belong to the same analysis.
Asset ID	ASSET_ID	Character (255)	This field displays the identification number of a Functional Location or an Equipment.
Asset Family ID	ASSET_FAMILY	Character (255)	Based on the ID, this field is populates either an Equipment or a Functional Location.
(ENVIRONMENT) Consequence	ENVIRONMENT\|MI_CONSE_N	Numeric	Must be filled based on the risk matrix of the site.
(ENVIRONMENT) Probability	ENVIRONMENT\|MI_PROB_N	Numeric	Must be filled based on the risk matrix of the site.
(ENVIRONMENT) Protection Level	ENVIRONMENT\|MI_PROT_N	Numeric	Must be filled based on the risk matrix of the site.
(ENVIRONMENT) Risk Rank	ENVIRONMENT-RISK_RANK	Numeric	Must be filled based on the risk matrix of the site.
(FINANCIAL) Consequence	FINANCIAL\|MI_CONSE_N	Numeric	Must be filled based on the risk matrix of the site.
(FINANCIAL) Maintenance Cost	FINANCIAL\|MI_RISK_MAIN_COST_N	Numeric	Must be filled based on the risk matrix of the site.
(FINANCIAL) Probability	FINANCIAL\|MI_PROB_N	Numeric	Must be filled based on the risk matrix of the site.
(FINANCIAL) Production Loss	FINANCIAL\|MI_RISK_PROD_LOSS_N	Numeric	Must be filled based on the risk matrix of the site.
(FINANCIAL) Protection level	FINANCIAL\|MI_PROT_N	Numeric	Must be filled based on the risk matrix of the site.
(FINANCIAL) Risk Rank	FINANCIAL-RISK_RANK	Numeric	Must be filled based on the risk matrix of the site.
(OPERATIONS) consequence	OPERATIONS\|MI_CONSE_N	Numeric	Must be filled based on the risk matrix of the site.
(OPERATIONS) Probability	OPERATIONS\|MI_PROB_N	Numeric	Must be filled based on the risk matrix of the site.
(OPERATIONS) Protection Level	OPERATIONS\|MI_PROT_N	Numeric	Must be filled based on the risk matrix of the site.
(OPERATIONS) Risk Rank	OPERATIONS-RISK_RANK	Numeric	Must be filled based on the risk matrix of the site.
(SAFETY) Consequence	SAFETY\|MI_CONSE_N	Numeric	Must be filled based on the risk matrix of the site.
(SAFETY) Probability	SAFETY\|MI_PROB_N	Numeric	Must be filled based on the risk matrix of the site.
(SAFETY) Protection Level	SAFETY\|MI_PROT_N	Numeric	Must be filled based on the risk matrix of the site.
(SAFETY) Risk Rank	SAFETY-RISK_RANK	Numeric	Must be filled based on the risk matrix of the site.
Basis for Assesment	MI_RISKASSE_BASIS_T	Text	Must be filled based on the risk matrix of the site.

Equipment Worksheet

On the Equipment worksheet, you will specify equipment to which you want to link functional locations.

Note: Each row in this worksheet represents a unique equipment. You should not include the same equipment more than once.

Note: When you enter N/A in the column for any of the Safety, Environment, Operations or Financial values in the Data Loader, the associated Unmitigated Risk is set as Not Applicable.

Field Caption	Field ID	Data Type (Length)	Comments
Batch ID	MI_BATCH ID	Character (255)	This field is required and can be either a character string or numeric field.
Analysis ID	MI_AN_ANALY_ID_CHR	Character (255)	This field is required and must be unique.
Functional Location ID	MI_FNCLOC00_FNC_LOC_C	Character (255)	If the Asset is a Functional Location, this field is populated based on the Asset ID.
Equipment ID	MI_EQUIP000_EQUIP_ID_C	Character (255)	ID of the Equipment
(ENVIRONMENT) Consequence	ENVIRONMENT\|MI_CONSE_N	Numeric	Must be filled based on the risk matrix of the site.
(ENVIRONMENT) Probability	ENVIRONMENT\|MI_PROB_N	Numeric	Must be filled based on the risk matrix of the site.
(ENVIRONMENT) Protection Level	ENVIRONMENT\|MI_PROT_N	Numeric	Must be filled based on the risk matrix of the site.
(ENVIRONMENT) Risk Rank	ENVIRONMENT-RISK_RANK	Numeric	Must be filled based on the risk matrix of the site.
(FINANCIAL) Consequence	FINANCIAL\|MI_CONSE_N	Numeric	Must be filled based on the risk matrix of the site.
(FINANCIAL) Maintenance Cost	FINANCIAL\|MI_RISK_MAIN_COST_N	Numeric	Must be filled based on the risk matrix of the site.
(FINANCIAL) Probability	FINANCIAL\|MI_PROB_N	Numeric	Must be filled based on the risk matrix of the site.
(FINANCIAL) Production Loss	FINANCIAL\|MI_RISK_PROD_LOSS_N	Numeric	Must be filled based on the risk matrix of the site.
(FINANCIAL) Protection level	FINANCIAL\|MI_PROT_N	Numeric	Must be filled based on the risk matrix of the site.
(FINANCIAL) Risk Rank	FINANCIAL-RISK_RANK	Numeric	Must be filled based on the risk matrix of the site.
(OPERATIONS) consequence	OPERATIONS\|MI_CONSE_N	Numeric	Must be filled based on the risk matrix of the site.
(OPERATIONS) Probability	OPERATIONS\|MI_PROB_N	Numeric	Must be filled based on the risk matrix of the site.
(OPERATIONS) Protection Level	OPERATIONS\|MI_PROT_N	Numeric	Must be filled based on the risk matrix of the site.
(OPERATIONS) Risk Rank	OPERATIONS-RISK_RANK	Numeric	Must be filled based on the risk matrix of the site.
(SAFETY) Consequence	SAFETY\|MI_CONSE_N	Numeric	Must be filled based on the risk matrix of the site.
(SAFETY) Probability	SAFETY\|MI_PROB_N	Numeric	Must be filled based on the risk matrix of the site.
(SAFETY) Risk Rank	SAFETY-RISK_RANK	Numeric	Must be filled based on the risk matrix of the site.
Basis for Assessment	MI_RISKASSE_BASIS_T	Text	Must be filled based on the risk matrix of the site.