Open topic with navigation

About the Asset Strategy Management (ASM) Data Loaders Workbook Layout and Use

In order to import data using the Asset Strategy Management (ASM) Data Loaders, GE Digital provides Excel workbooks, Asset Strategy Management (ASM).xlsx and Asset Strategy Management (ASM) Templates.xlsx, which support baseline ASM in GE Digital APM. These workbooks must be used to perform the data load. You can modify the Excel workbook to include custom fields used by your organization. The following tables list the worksheets that are included in the workbooks and then the fields in the corresponding worksheets for both the Strategy and Template Data Loaders.

Asset Strategy Management (ASM) Data LoaderClosed

Worksheet

Description

Strategies

This worksheet is used to specify new or existing strategies to which Action, Risks, and Mitigations will be linked.

Actions

This worksheet is used to specify Action records that will be updated or created and linked to assets.

Risks

This worksheet is used to specify Risk records that will be updated or created and linked to assets.

Mitigations

This worksheet is used to define Mitigation records that will be linked to Analyses.

Strategies WorksheetClosed

Field Caption

Field ID

Data Type (Length)

Comments

Strategy ID

MI_ASTSTRAT_ID_C

Character (255)

This field is the master reference column for each of the four tabs in the data loader spreadsheet.

Asset ID

ASSET_ID_CHR

Character (255)

This field allows the user to enter values to search for an asset.

Asset Family ID

ASSET_FAMILY_ID

Character (15)

This field allows the user to enter values to search for an asset.

Asset ID Field

ASSET_ID_FIELD

Character (255)

This field allows the user to enter values to search for an asset.

CMMS ID

ASSET_CMMS_ID

Character (255)

This field allows the user to enter values to search for an asset.

CMMS Value

ASSET_CMMS_VALUE

Character (255)

This field allows the user to enter values to search for an asset.

Strategy Notes

MI_ASTSTRAT_NOTES_T

Text

None

Risk Analysis Type

MI_ASTSTRAT_RISK_ANAL_TYPE_C

Character (255)

None

Quantitative Result

MI_ASTSTRAT_QUANT_RESUL_T

Text

None

Plan Length

MI_ASTSTRAT_PLAN_LENGTH_N

Numeric

None
Actions WorksheetClosed

Field Caption

Field ID

Data Type (Length)

Comments

Strategy ID

MI_ASTSTRAT_ID_C

Character (255)

This field is the master reference column for each of the four tabs in the data loader spreadsheet.

Action ID

MI_ACTION_ID_C

Character (255)

This field is used to look up existing Actions, and if none are found, a new Action will be created.

Name

MI_ACTION_SHORT_DESC_C

Character (255)

None

Description

MI_ACTION_DESCRIPTION_T

Text

None

Basis

MI_ACTION_BASIS_C

Character (255)

None

Type

MI_ACTION_TYPE_C

Character (255)

None

Condition Monitoring Type

MI_ACTION_CM_TYPE_C

Character (50)

None

Interval

MI_ACTION_INTV_N

Numeric

None

Interval Unit

MI_ACTION_INTV_UNITS_C

Character (50)

None

Resource Cost

MI_ACTION_RESOURCE_COST_N

Numeric

None

Shutdown Required

MI_ACTION_SHUTDOWN_L

Boolean

None
Risks WorksheetClosed

Field Caption

Field ID

Data Type (Length)

Comments

Strategy ID

MI_ASTSTRAT_ID_C

Character (255)

This field is used as the master reference column for each of the four tabs in the data loader spreadsheet.

Risk ID

MI_RISKASSE_ID_C

Numeric

This field is used to look up existing Risks, and if none are found a new Risk will be created.

(ENVIRONMENT) Consequence

ENVIRONMENT|MI_CONSE_N

Numeric

None

(ENVIRONMENT) Probability

ENVIRONMENT|MI_PROB_N

Numeric

None

(ENVIRONMENT) Protection Level

ENVIRONMENT|MI_PROT_N

Numeric

None

(FINANCIAL) Consequence

FINANCIAL|MI_CONSE_N

Numeric

None

(FINANCIAL) Maintenance Cost

FINANCIAL|MI_RISK_MAIN_COST_N

Numeric

None

(FINANCIAL) Probability

FINANCIAL|MI_PROB_N

Numeric

None

(FINANCIAL) Production Loss

FINANCIAL|MI_RISK_PROD_LOSS_N

Numeric

None

(FINANCIAL) Protection level

FINANCIAL|MI_PROT_N

Numeric

None

(OPERATIONS) Consequence

OPERATIONS|MI_CONSE_N

Numeric

None

(OPERATIONS) Probability

OPERATIONS|MI_PROB_N

Numeric

None

(OPERATIONS) Protection Level

OPERATIONS|MI_PROT_N

Numeric

None

(SAFETY) Consequence

 

SAFETY|MI_CONSE_N

Numeric

None

(SAFETY) Probability

 

SAFETY|MI_PROB_N

Numeric

None

(SAFETY) Protection Level

SAFETY|MI_PROT_N

Numeric

None

Basis for Assessment

MI_RISKASSE_BASIS_T

Text

None

Condition

MI_FAILRISK_CODE3_C

Character (50)

None

Description

MI_FAILRISK_DESC_T

Text

None

Driving Unmitigated Risk Alias

MI_RISKASSE_DRIV_RISK_ALIAS_C

Character (50)

None

Estimated Repair Time

MI_FAILRISK_EST_REP_TIME_N

Numeric

None

Failure Cause

MI_FAILRISK_CODE4_C

Character (50)

None

Failure Mode

MI_FAILRISK_CODE1_C

Character (255)

None

Failure Without Replacement

MI_FAILRISK_FAIL_WITH_REPL_F

Boolean

None

Is Active

MI_FAILRISK_IS_ACTIV_F

Boolean

None

Is Latent

MI_FAILRISK_IS_LATEN_F

Boolean

None

Last Failure

MI_FAILRISK_LAST_FAILU_D

Date

None

Maintainable Item

MI_FAILRISK_CODE2_C

Character (50)

None

Name

MI_RISKASSE_NAME_C

Character (515)

None

Number of Subcomponents

MI_FAILRISK_NUMB_OF_SUBC_N

Numeric

None

Percentage of PF Interval to Wait

MI_FAILRISK_PER_OF_PF_INT_N

 

Numeric

None

PF Interval

 

MI_FAILRISK_PF_INTER_N

Character (50)

None

PF Interval Units

MI_FAILRISK_PF_INTER_UNITS_C

Character (50)

None

Planned Correction Cost

MI_FAILRISK_PLAN_CORR_COST_N

Numeric

None

Planned Correction Duration

MI_FAILRISK_PLAN_CORR_DURA_N

Numeric

None

Repair Immediately

MI_FAILRISK_REPAI_IMMED_F

Boolean

None

Risk Basis

MI_RISKASSE_RISK_BASIS_C

Character (255)

None

Unmitigated Risk Alias

MI_RISKASSE_RISK_ALIAS_C

Character (50)

None

Wear Pattern

MI_FAILRISK_WEAR_PATTE_C

Character (50)

None
Mitigations WorksheetClosed

Field Caption

Field ID

Data Type (Length)

Comments

Strategy ID

MI_ASTSTRAT_ID_C

Numeric

This field is used as the master reference column for each of the four tabs in the data loader spreadsheet.

 

Risk ID

MI_RISKASSE_ID_C

Character (265)

This field is used to look up existing Risks to which the Mitigations will be linked.

Action ID

MI_ACTION_ID_C

Character (265)

This field is used to lookup existing Actions to which the Mitigations will be linked.

(ENVIRONMENT) Consequence

ENVIRONMENT|MI_CONSE_N

Numeric

None

(ENVIRONMENT) Probability

ENVIRONMENT|MI_PROB_N

Numeric

None

(ENVIRONMENT) Protection Level

ENVIRONMENT|MI_PROT_N

Numeric

None

(FINANCIAL) Consequence

FINANCIAL|MI_CONSE_N

Numeric

None

(FINANCIAL) Maintenance Cost

FINANCIAL|MI_RISK_MAIN_COST_N

Numeric

None

(FINANCIAL) Probability

FINANCIAL|MI_PROB_N

Numeric

None

(FINANCIAL) Production Loss

FINANCIAL|MI_RISK_PROD_LOSS_N

Numeric

None

(FINANCIAL) Protection level

FINANCIAL|MI_PROT_N

 

Numeric

None

(OPERATIONS) Consequence

OPERATIONS|MI_CONSE_N

Numeric

None

(OPERATIONS)

Probability

OPERATIONS|MI_PROB_N

Numeric

None

(OPERATIONS) Protection Level

 

OPERATIONS|MI_PROT_N

Numeric

None

(SAFETY) Consequence

SAFETY|MI_CONSE_N

Numeric

None

(SAFETY) Probability

 

SAFETY|MI_PROB_N

 

Numeric

None

(SAFETY) Protection Level

 

SAFETY|MI_PROT_N

 

Numeric

None

Basis for Assessment

 

MI_RISKASSE_BASIS_T

 

Text

None
Asset Strategy Management (ASM) Templates Data LoaderClosed

Worksheet

Description

Templates

This worksheet is used to specify new or existing templates to which Action, Risks, and Mitigations will be linked.

Actions

This worksheet is used to specify Action records that will be updated or created and linked to templates.

Risks

This worksheet is used to specify Risk records that will be updated or created and linked to templates.

Mitigations

This worksheet is used to define Mitigation records that will be linked to Analyses.
Templates WorksheetClosed

Field Caption

Field ID

Data Type (Length)

Comments

Template ID

MI_ASTSTRAT_ID_C

Character (255)

This field is the master reference column for each of the four tabs in the data loader spreadsheet.

Template Notes

MI_ASTSTRAT_NOTES_T

Text

 None

Risk Matrix Name

TEMPLATE_RISK_MATRIX_NAME

Character (255)

 None

Template Category

MI_ASTSTTMP_GEN_FIELD_1_C

Character (255)

 None

Criticality

MI_ASTSTTMP_GEN_FIELD_2_C

Character (255)

 None

Duty

MI_ASTSTTMP_GEN_FIELD_3_C

Character (255)

None

Service

MI_ASTSTTMP_GEN_FIELD_4_C

Character (255)

None
Actions WorksheetClosed

Field Caption

Field ID

Data Type (Length)

Comments

Strategy ID

MI_ASTSTRAT_ID_C

Character (255)

This field is the master reference column for each of the four tabs in the data loader spreadsheet.

Action ID

MI_ACTION_ID_C

Character (255)

This field is used to look up existing Actions, and if none are found, a new Action will be created.

Name

MI_ACTION_SHORT_DESC_C

Character (255)

None

Description

MI_ACTION_DESCRIPTION_T

Text

None

Basis

MI_ACTION_BASIS_C

Character (255)

None

Type

MI_ACTION_TYPE_C

Character (255)

None

Condition Monitoring Type

MI_ACTION_CM_TYPE_C

Character (50)

None

Interval

MI_ACTION_INTV_N

Numeric

None

Interval Unit

MI_ACTION_INTV_UNITS_C

Character (50)

None

Resource Cost

MI_ACTION_RESOURCE_COST_N

Numeric

None

Shutdown Required

MI_ACTION_SHUTDOWN_L

Boolean

None
Risks WorksheetClosed

Field Caption

Field ID

Data Type (Length)

Comments

Strategy ID

MI_ASTSTRAT_ID_C

Character (255)

This field is used as the master reference column for each of the four tabs in the data loader spreadsheet.

Risk ID

MI_RISKASSE_ID_C

Numeric

This field is used to look up existing Risks, and if none are found a new Risk will be created.

(ENVIRONMENT) Consequence

ENVIRONMENT|MI_CONSE_N

Numeric

None

(ENVIRONMENT) Probability

ENVIRONMENT|MI_PROB_N

Numeric

None

(ENVIRONMENT) Protection Level

ENVIRONMENT|MI_PROT_N

Numeric

None

(FINANCIAL) Consequence

FINANCIAL|MI_CONSE_N

Numeric

None

(FINANCIAL) Maintenance Cost

FINANCIAL|MI_RISK_MAIN_COST_N

Numeric

None

(FINANCIAL) Probability

FINANCIAL|MI_PROB_N

Numeric

None

(FINANCIAL) Production Loss

FINANCIAL|MI_RISK_PROD_LOSS_N

Numeric

None

(FINANCIAL) Protection level

FINANCIAL|MI_PROT_N

Numeric

None

(OPERATIONS) Consequence

OPERATIONS|MI_CONSE_N

Numeric

None

(OPERATIONS) Probability

OPERATIONS|MI_PROB_N

Numeric

None

(OPERATIONS) Protection Level

OPERATIONS|MI_PROT_N

Numeric

None

(SAFETY) Consequence

 

SAFETY|MI_CONSE_N

Numeric

None

(SAFETY) Probability

 

SAFETY|MI_PROB_N

Numeric

None

(SAFETY) Protection Level

SAFETY|MI_PROT_N

Numeric

None

Basis for Assessment

MI_RISKASSE_BASIS_T

Text

None

Condition

MI_FAILRISK_CODE3_C

Character (50)

None

Description

MI_FAILRISK_DESC_T

Text

None

Driving Unmitigated Risk Alias

MI_RISKASSE_DRIV_RISK_ALIAS_C

Character (50)

None

Estimated Repair Time

MI_FAILRISK_EST_REP_TIME_N

Numeric

None

Failure Cause

MI_FAILRISK_CODE4_C

Character (50)

None

Failure Mode

MI_FAILRISK_CODE1_C

Character (255)

None

Failure Without Replacement

MI_FAILRISK_FAIL_WITH_REPL_F

Boolean

None

Is Active

MI_FAILRISK_IS_ACTIV_F

Boolean

None

Is Latent

MI_FAILRISK_IS_LATEN_F

Boolean

None

Last Failure

MI_FAILRISK_LAST_FAILU_D

Date

None

Maintainable Item

MI_FAILRISK_CODE2_C

Character (50)

None

Name

MI_RISKASSE_NAME_C

Character (515)

None

Number of Subcomponents

MI_FAILRISK_NUMB_OF_SUBC_N

Numeric

None

Percentage of PF Interval to Wait

MI_FAILRISK_PER_OF_PF_INT_N

 

Numeric

None

PF Interval

 

MI_FAILRISK_PF_INTER_N

Character (50)

None

PF Interval Units

MI_FAILRISK_PF_INTER_UNITS_C

Character (50)

None

Planned Correction Cost

MI_FAILRISK_PLAN_CORR_COST_N

Numeric

None

Planned Correction Duration

MI_FAILRISK_PLAN_CORR_DURA_N

Numeric

None

Repair Immediately

MI_FAILRISK_REPAI_IMMED_F

Boolean

None

Risk Basis

MI_RISKASSE_RISK_BASIS_C

Character (255)

None

Unmitigated Risk Alias

MI_RISKASSE_RISK_ALIAS_C

Character (50)

None

Wear Pattern

MI_FAILRISK_WEAR_PATTE_C

Character (50)

None
Mitigations WorksheetClosed

Field Caption

Field ID

Data Type (Length)

Comments

Strategy ID

MI_ASTSTRAT_ID_C

Numeric

This field is used as the master reference column for each of the four tabs in the data loader spreadsheet.

 

Risk ID

MI_RISKASSE_ID_C

Character (265)

This field is used to look up existing Risks to which the Mitigations will be linked.

Action ID

MI_ACTION_ID_C

Character (265)

This field is used to lookup existing Actions to which the Mitigations will be linked.

(ENVIRONMENT) Consequence

ENVIRONMENT|MI_CONSE_N

Numeric

None

(ENVIRONMENT) Probability

ENVIRONMENT|MI_PROB_N

Numeric

None

(ENVIRONMENT) Protection Level

ENVIRONMENT|MI_PROT_N

Numeric

None

(FINANCIAL) Consequence

FINANCIAL|MI_CONSE_N

Numeric

None

(FINANCIAL) Maintenance Cost

FINANCIAL|MI_RISK_MAIN_COST_N

Numeric

None

(FINANCIAL) Probability

FINANCIAL|MI_PROB_N

Numeric

None

(FINANCIAL) Production Loss

FINANCIAL|MI_RISK_PROD_LOSS_N

Numeric

None

(FINANCIAL) Protection level

FINANCIAL|MI_PROT_N

 

Numeric

None

(OPERATIONS) Consequence

OPERATIONS|MI_CONSE_N

Numeric

None

(OPERATIONS)

Probability

OPERATIONS|MI_PROB_N

Numeric

None

(OPERATIONS) Protection Level

 

OPERATIONS|MI_PROT_N

Numeric

None

(SAFETY) Consequence

SAFETY|MI_CONSE_N

Numeric

None

(SAFETY) Probability

 

SAFETY|MI_PROB_N

 

Numeric

None

(SAFETY) Protection Level

 

SAFETY|MI_PROT_N

 

Numeric

None

Basis for Assessment

 

MI_RISKASSE_BASIS_T

 

Text

None
Related Information

Copyright © 2018 General Electric Company. All rights reserved.