Open topic with navigation

About the Failure Modes and Effects Analysis (FMEA) Data Loader Workbooks Layout and Use

This section provides a high-level overview and explanation of how the FMEA data loader workbooks are constructed.

In order to import data using the Failure Modes and Effects Analysis (FMEA) Data Loaders, GE Digital provides Excel workbooks, Failure Modes and Effects Analysis (FMEA).xlsx, FMEA_Asset_Template_Data_Loader.xlsx, and FMEA_Analysis_Template_Data_Loader.xlsx, which support baseline data loading of FMEA analyses, FMEA asset templates, and FMEA analysis templates, in GE Digital APM. These workbooks must be used to perform the data load.

The following table lists the worksheets that are included in the Failure Modes and Effects Analysis (FMEA) Data Loader workbook.

Failure Modes and Effects Analysis (FMEA) Data LoaderClosed

Worksheet

Description

Analysis

The analysis is the root record in the data model and is created first. Links to other records are established after the child record is created.

Team Members

This worksheet is used to load team members data for the analysis. Team members are linked to the FMEA Analysis through the Has RCM FMEA Team Member relationship.

Note: If the user wants to add team members, the individuals must already have an entry in GE Digital APM.

Assets

This worksheet is used to load data into the various assets linked to the Analysis record. The FMEA Asset is a virtual asset that links the actual equipment or functional location to the analysis. This node must be created and linked to the analysis using information from the asset ID.

Failure Modes

This worksheet is used to load data into the Failure Mode family node. The FMEA Failure Mode is linked directly to the virtual asset.

Failure Effects

This worksheet is used to load data into the Failure Effect family node.

The Failure Effect is linked to both the Failure Mode and the associated Recommendation record. See the Recommendations section for its relationship.

Recommendations

This worksheet is used to load data into the Recommendations. FMEA Recommendations are linked to the associated Failure Effects. Failure Effect can have multiple recommendations, but each one must be unique.
Analysis WorksheetClosed

Field Caption

Field ID

Data Type (Length)

Comments

Analysis Short Description

MI_AN_SHORT_DESCR_CHR

Character (255)

This is a key field.
Analysis Long Description MI_AN_LONG_DESCR_TX Text None

Start Date

MI_AN_ANALY_START_DATE_DT

Date

None

End Date

MI_AN_ANALY_END_DATE_DT

Date

None

Re-Evaluation Date

MI_RCMANALY_ANALY_REEV_D

Date

None
Team Members WorksheetClosed

Field Caption

Field ID

Data Type (Length)

Comments

Analysis Short Description

MI_AN_SHORT_DESCR_CHR

Character (255)

This is a key field.

User ID

SEUS_ID

Character (255)

This is a key field.

Relationship:

Predecessor

Relationship

Successor

MI_RCMANALY

MIR_HRCMTMMEM

MI Human Resource
Assets WorksheetClosed

Field Caption

Field ID

Data Type (Length)

Comments

Analysis Short Description

MI_AN_SHORT_DESCR_CHR

Character (255)

Used to locate Analysis.

Asset ID Value

ASSET_ID_CHR

Character (255)

This is a key field.
Asset ID Field ASSET_FIELD_ID Character (255) This is a key field.

Asset Family ID

ASSET_FAMILY_ID

Character (255)

Used to determine which MI family to create, by identifying whether the Asset is an Equipment or Functional Location. The valid values are:

  • MI_EQUIP000
  • MI_FNCLOC00
CMMS ID

ASSET_CMMS_ID

Character (255)

None
CMMS Value ASSET_CMMS_VALUE Character (255)

None

Relationships:

Predecessor

Relationship

Successor

MI_RCMANALY

MIR_HRCMEQP

MI_RCMEQPMT

Predecessor

Relationship

Successor

MI_EQUIP000

MIR_IRCMEQP

MI_RCMEQPMT

MI_FNCLOC00

MIR_IRCMEQP

MI_RCMEQPMT
Failure Mode WorksheetClosed

Field Caption

Field ID

Data Type (Length)

Comments

Analysis Short Description

MI_AN_SHORT_DESCR_CHR

Character (255)

This is a key field.

Asset ID Value

ASSET_ID_CHR

Character (255)

This is a key field.

Name

MI_RCMFMODE_NAME_C

Character (255)

This is a key field.
Long Description

MI_RCMFMODE_LNG_DESC_T

Text

 None
Maintainable Item MI_RCMFMODE_MAINT_ITEM_C Character (50) None
Damage Code MI_RCMFMODE_CONDI_DAMA_C Character (50)  

Failure Pattern

MI_RCMFMODE_FAIL_SHP_FACT_C

Character

(40)

None

PF Interval

MI_RCMFMODE_PF_INTER_N

Numeric

None

PF Interval Units

MI_RCMFMODE_PF_INTER_UNITS_C

Character (40)

None

Relationships:

Predecessor

Relationship

Successor

MI_RCMEQPMT

MIR_HRCMFMD

MI_RCMFMODE
Failure Effects WorksheetClosed

Field Caption

Field ID

Data Type (Length)

Comments

Analysis Short Description

MI_AN_SHORT_DESCR_CHR

Character (255)

This is a key field.

Mode Name

MI_RCMFMODE_NAME_C

Character (255)

This is a key field.

Effect Name

MI_RCMFEFFT_NAME_C

Character (255)

None

Effect Long Description

MI_RCMFEFFT_LNG_DESC_T

Text

None

Effect Impact

MI_RCMFEFFT_EFF_IMPACT_C

Character (40)

None

(ENVIRONMENT) Consequence

ENVIRONMENT|MI_CONSE_N

 Numeric

None

(ENVIRONMENT) Probability

ENVIRONMENT|MI_PROB_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
(OPERATIONS) Consequence OPERATIONS|MI_CONSE_N Numeric

None
(OPERATIONS) Probability OPERATIONS|MI_PROB_N Numeric

None
(SAFETY) Consequence SAFETY|MI_CONSE_N Numeric

None
(SAFETY) Probability SAFETY|MI_PROB_N Numeric

None
Basis for Assessment MI_RCMFEFFT_BASIS_T Text None

Relationships:

Predecessor

Relationship

Successor

MI_RCMFMODE

MIR_HRCMFEF

MI_RCMFEFFT
Recommendations WorksheetClosed

Field Caption

Field ID

Data Type (Length)

Comments

Analysis Short Description

MI_AN_SHORT_DESCR_CHR

Character (255)

This is a key field.

Effect Name

MI_RCMFEFFT_NAME_C

Character (255)

This is a key field.

Headline

MI_REC_SHORT_DESCR_CHR

Character (255)

None

Description

MI_REC_LONG_DESCR_TX

Text

None

Business Impact

MI_REC_IMPAC_CHR

Character (100)

None

Shutdown Required?

MI_RECRCM_SYS_SHUTDN_REQ_L

L

None

Target Completion Date

MI_REC_TARGE_COMPL_DATE_DT

Date

None

Action Type

MI_RECRCM_ACTIO_TYPE_C

Character (5)

None

Interval

MI_RECRCM_INTER_N

Numeric

None

Interval Units

MI_RECRCM_INTER_UNITS_C

Character (50)

None
Nonrecurring

MI_RECRCM_NONRE_L

 Logical

Defaults to False when no value.

Performance Interval

MI_RECRCM_PERFO_INTER_N

Numeric

None

Performance Interval Units

MI_RECRCM_PERFO_INTER_UNITS_C

Character (50)

None

Estimated Cost

MI_RECRCM_ESTIM_COST_N

Numeric

None

Estimated Cost Basis

MI_RECRCM_COST_BASIS_C

Character (255)

None

Recommended Resource

MI_RECRCM_RECOMM_RSRC_C

Character

Must match a resource configured in the system picklist for this field.

(ENVIRONMENT) Consequence

ENVIRONMENT|MI_CONSE_N

 Numeric

None

(ENVIRONMENT) Probability

ENVIRONMENT|MI_PROB_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
(OPERATIONS) Consequence OPERATIONS|MI_CONSE_N Numeric

None
(OPERATIONS) Probability OPERATIONS|MI_PROB_N Numeric

None
(SAFETY) Consequence SAFETY|MI_CONSE_N Numeric

None
(SAFETY) Probability SAFETY|MI_PROB_N Numeric

None
Basis for Assessment MI_RCMFEFFT_BASIS_T Text None

Relationships:

Predecessor

Relationship

Successor

MI_RCMFEFFT

MIR_HRCMREC

MI_RECRCM
Failure Modes and Effects Analysis (FMEA) Asset Templates Data LoaderClosed

Worksheet

Description

Assets

This worksheet is used to load data into the various assets linked to the Analysis record. The FMEA Asset is a virtual asset that links the actual equipment or functional location to the analysis. This node must be created and linked to the analysis using information from the asset ID.

Failure Modes

This worksheet is used to load data into the Failure Mode family node. The FMEA Failure Mode is linked directly to the virtual asset.

Failure Effects

This worksheet is used to load data into the Failure Effect family node.

The Failure Effect is linked to both the Failure Mode and the associated Recommendation record. See the Recommendations section for its relationship.

Recommendations

This worksheet is used to load data into the Recommendations. FMEA Recommendations are linked to the associated Failure Effects. Failure Effect can have multiple recommendations, but each one must be unique.
Templates This worksheet is used to load data into the Templates. FMEA Templates are linked to the associated virtual assets, as well as a specific site.
Templates WorksheetClosed

Field Caption

Field ID

Data Type (Length)

Comments

Template ID

MI_TM000000_ID

Character (255)

Used to locate template.
Site Reference Name MI_SITEREF_NAME_C Character (255) This is a key field.
Template Short Description

MI_TM000000_SHRT_DSC_C

Character (255)

 None
Template Long Description MI_TM000000_LNG_DSC_T Text None
Assets WorksheetClosed

Field Caption

Field ID

Data Type (Length)

Comments

Template ID

MI_TM000000_ID

Character (255)

Used to locate template.
Asset ID MI_RCMEQPMT_EQUIP_ID_C Character (255) This is a key field.
Asset Description

MI_RCMEQPMT_DESC_C

Text

None
Failure Modes WorksheetClosed

Field Caption

Field ID

Data Type (Length)

Comments

Template ID

MI_TM000000_ID

Character (255)

Used to locate template.
Asset ID MI_RCMEQPMT_EQUIP_ID_C Character (255) This is a key field.

Name

MI_RCMFMODE_NAME_C

Character (255)

This is a key field.
Long Description

MI_RCMFMODE_LNG_DESC_T

Text

 None
Maintainable Item MI_RCMFMODE_MAINT_ITEM_C Character (50) None
Damage Code MI_RCMFMODE_CONDI_DAMA_C Character (50)  

Failure Pattern

MI_RCMFMODE_FAIL_SHP_FACT_C

Character

(40)

None

PF Interval

MI_RCMFMODE_PF_INTER_N

Numeric

None

PF Interval Units

MI_RCMFMODE_PF_INTER_UNITS_C

Character (40)

None
Failure Effects WorksheetClosed

Field Caption

Field ID

Data Type (Length)

Comments

Template ID

MI_TM000000_ID

Character (255)

Used to locate template.
Asset ID MI_RCMEQPMT_EQUIP_ID_C Character (255) This is a key field.

Mode Name

MI_RCMFMODE_NAME_C

Character (255)

This is a key field.

Effect Name

MI_RCMFEFFT_NAME_C

Character (255)

This is a key field.

Effect Long Description

MI_RCMFEFFT_LNG_DESC_T

Text

None

Effect Impact

MI_RCMFEFFT_EFF_IMPACT_C

Character (40)

None

(ENVIRONMENT) Consequence

ENVIRONMENT|MI_CONSE_N

 Numeric

None

(ENVIRONMENT) Probability

ENVIRONMENT|MI_PROB_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
(OPERATIONS) Consequence OPERATIONS|MI_CONSE_N Numeric

None
(OPERATIONS) Probability OPERATIONS|MI_PROB_N Numeric

None
(SAFETY) Consequence SAFETY|MI_CONSE_N Numeric

None
(SAFETY) Probability SAFETY|MI_PROB_N Numeric

None
Basis for Assessment MI_RCMFEFFT_BASIS_T Text None
Recommendations WorksheetClosed

Field Caption

Field ID

Data Type (Length)

Comments

Template ID

MI_TM000000_ID

Character (255)

Used to locate template.
Asset ID MI_RCMEQPMT_EQUIP_ID_C Character (255) This is a key field.

Mode Name

MI_RCMFMODE_NAME_C

Character (255)

This is a key field.

Effect Name

MI_RCMFEFFT_NAME_C

Character (255)

This is a key field.
Headline MI_REC_SHORT_DESCR_CHR

Character (255)

 This is a key field.

Description

MI_REC_LONG_DESCR_TX

Text

None

Business Impact

MI_REC_IMPAC_CHR

Character (100)

None

Shutdown Required?

MI_RECRCM_SYS_SHUTDN_REQ_L

L

None

Target Completion Date

MI_REC_TARGE_COMPL_DATE_DT

Date

None

Action Type

MI_RECRCM_ACTIO_TYPE_C

Character (5)

None

Interval

MI_RECRCM_INTER_N

Numeric

None

Interval Units

MI_RECRCM_INTER_UNITS_C

Character (50)

None
Nonrecurring

MI_RECRCM_NONRE_L

 Logical

Defaults to False when no value.

Performance Interval

MI_RECRCM_PERFO_INTER_N

Numeric

None

Performance Interval Units

MI_RECRCM_PERFO_INTER_UNITS_C

Character (50)

None

Estimated Cost

MI_RECRCM_ESTIM_COST_N

Numeric

None

Estimated Cost Basis

MI_RECRCM_COST_BASIS_C

Character (255)

None

Recommended Resource

MI_RECRCM_RECOMM_RSRC_C

Character

Must match a resource configured in the system picklist for this field.

(ENVIRONMENT) Consequence

ENVIRONMENT|MI_CONSE_N

 Numeric

None

(ENVIRONMENT) Probability

ENVIRONMENT|MI_PROB_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
(OPERATIONS) Consequence OPERATIONS|MI_CONSE_N Numeric

None
(OPERATIONS) Probability OPERATIONS|MI_PROB_N Numeric

None
(SAFETY) Consequence SAFETY|MI_CONSE_N Numeric

None
(SAFETY) Probability SAFETY|MI_PROB_N Numeric

None
Basis for Assessment MI_RCMFEFFT_BASIS_T Text None
Failure Modes and Effects Analysis (FMEA) Analysis Templates Data LoaderClosed

Worksheet

Description
Templates This worksheet is used to load data into the Templates. FMEA Templates are linked to the associated virtual assets, which are linked to specific sites.

Analysis

The analysis is the root record in the data model and is created first. Links to other records are established after the child record is created.

Team Members

This worksheet is used to load team members data for the analysis. Team members are linked to the FMEA Analysis through the Has RCM FMEA Team Member relationship.

Note: If the user wants to add team members, the individuals must already have an entry in GE Digital APM.

Assets

This worksheet is used to load data into the various assets linked to the Analysis record. The FMEA Asset is a virtual asset that links the actual equipment or functional location to the analysis. This node must be created and linked to the analysis using information from the asset ID.

Failure Modes

This worksheet is used to load data into the Failure Mode family node. The FMEA Failure Mode is linked directly to the virtual asset.

Failure Effects

This worksheet is used to load data into the Failure Effect family node.

The Failure Effect is linked to both the Failure Mode and the associated Recommendation record. See the Recommendations section for its relationship.

Recommendations

This worksheet is used to load data into the Recommendations. FMEA Recommendations are linked to the associated Failure Effects. Failure Effect can have multiple recommendations, but each one must be unique.
Templates WorksheetClosed

Field Caption

Field ID

Data Type (Length)

Comments

Template ID

MI_TM000000_ID

Character (255)

Used to locate template.
Site Reference Name MI_SITEREF_NAME_C Character (255) This is a key field.
Template Short Description

MI_TM000000_SHRT_DSC_C

Character (255)

 None
Template Long Description MI_TM000000_LNG_DSC_T Text None
Analyses WorksheetClosed

Field Caption

Field ID

Data Type (Length)

Comments
Template ID MI_TM000000_ID

Character (255)

Used to locate template.

Analysis Short Description

MI_AN_SHORT_DESCR_CHR

Character (255)

This is a key field.
Analysis Long Description MI_AN_LONG_DESCR_TX Text None

Start Date

MI_AN_ANALY_START_DATE_DT

Date

None

End Date

MI_AN_ANALY_END_DATE_DT

Date

None

Re-Evaluation Date

MI_RCMANALY_ANALY_REEV_D

Date

None
Team Members WorksheetClosed

Field Caption

Field ID

Data Type (Length)

Comments
Template ID MI_TM000000_ID

Character (255)

Used to locate template.

User ID

SEUS_ID

Character (255)

This is a key field.
Assets WorksheetClosed

Field Caption

Field ID

Data Type (Length)

Comments

Template ID

MI_TM000000_ID

Character (255)

Used to locate template.

Analysis Short Description

MI_AN_SHORT_DESCR_CHR

Character (255)

This is a key field.
Asset ID MI_RCMEQPMT_EQUIP_ID_C Character (255) This is a key field.
Asset Description

MI_RCMEQPMT_DESC_C

Character (255)

None
Failure Modes WorksheetClosed

Field Caption

Field ID

Data Type (Length)

Comments

Template ID

MI_TM000000_ID

Character (255)

Used to locate template.

Analysis Short Description

MI_AN_SHORT_DESCR_CHR

Character (255)

This is a key field.
Asset ID MI_RCMEQPMT_EQUIP_ID_C Character (255) This is a key field.

Mode Name

MI_RCMFMODE_NAME_C

Character (255)

This is a key field.
Long Description

MI_RCMFMODE_LNG_DESC_T

Text

 None
Maintainable Item MI_RCMFMODE_MAINT_ITEM_C Character (50) None
Damage Code MI_RCMFMODE_CONDI_DAMA_C Character (50)  

Failure Pattern

MI_RCMFMODE_FAIL_SHP_FACT_C

Character

(40)

None

PF Interval

MI_RCMFMODE_PF_INTER_N

Numeric

None

PF Interval Units

MI_RCMFMODE_PF_INTER_UNITS_C

Character (40)

None
Failure Effects WorksheetClosed

Field Caption

Field ID

Data Type (Length)

Comments

Template ID

MI_TM000000_ID

Character (255)

Used to locate template.

Analysis Short Description

MI_AN_SHORT_DESCR_CHR

Character (255)

This is a key field.
Asset ID MI_RCMEQPMT_EQUIP_ID_C Character (255) This is a key field.

Mode Name

MI_RCMFMODE_NAME_C

Character (255)

This is a key field.

Effect Name

MI_RCMFEFFT_NAME_C

Character (255)

This is a key field.

Effect Long Description

MI_RCMFEFFT_LNG_DESC_T

Text

None

Effect Impact

MI_RCMFEFFT_EFF_IMPACT_C

Character (40)

None

(ENVIRONMENT) Consequence

ENVIRONMENT|MI_CONSE_N

 Numeric

None

(ENVIRONMENT) Probability

ENVIRONMENT|MI_PROB_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
(OPERATIONS) Consequence OPERATIONS|MI_CONSE_N Numeric

None
(OPERATIONS) Probability OPERATIONS|MI_PROB_N Numeric

None
(SAFETY) Consequence SAFETY|MI_CONSE_N Numeric

None
(SAFETY) Probability SAFETY|MI_PROB_N Numeric

None
Basis for Assessment MI_RCMFEFFT_BASIS_T Text None
Recommendations WorksheetClosed

Field Caption

Field ID

Data Type (Length)

Comments

Template ID

MI_TM000000_ID

Character (255)

Used to locate template.

Analysis Short Description

MI_AN_SHORT_DESCR_CHR

Character (255)

This is a key field.
Asset ID MI_RCMEQPMT_EQUIP_ID_C Character (255) This is a key field.

Mode Name

MI_RCMFMODE_NAME_C

Character (255)

This is a key field.

Effect Name

MI_RCMFEFFT_NAME_C

Character (255)

This is a key field.
Headline MI_REC_SHORT_DESCR_CHR

Character (255)

 This is a key field.

Description

MI_REC_LONG_DESCR_TX

Text

None

Business Impact

MI_REC_IMPAC_CHR

Character (100)

None

Shutdown Required?

MI_RECRCM_SYS_SHUTDN_REQ_L

L

None

Target Completion Date

MI_REC_TARGE_COMPL_DATE_DT

Date

None

Action Type

MI_RECRCM_ACTIO_TYPE_C

Character (5)

None

Interval

MI_RECRCM_INTER_N

Numeric

None

Interval Units

MI_RECRCM_INTER_UNITS_C

Character (50)

None
Nonrecurring

MI_RECRCM_NONRE_L

 Logical

Defaults to False when no value.

Performance Interval

MI_RECRCM_PERFO_INTER_N

Numeric

None

Performance Interval Units

MI_RECRCM_PERFO_INTER_UNITS_C

Character (50)

None

Estimated Cost

MI_RECRCM_ESTIM_COST_N

Numeric

None

Estimated Cost Basis

MI_RECRCM_COST_BASIS_C

Character (255)

None

Recommended Resource

MI_RECRCM_RECOMM_RSRC_C

Character

Must match a resource configured in the system picklist for this field.

(ENVIRONMENT) Consequence

ENVIRONMENT|MI_CONSE_N

 Numeric

None

(ENVIRONMENT) Probability

ENVIRONMENT|MI_PROB_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
(OPERATIONS) Consequence OPERATIONS|MI_CONSE_N Numeric

None
(OPERATIONS) Probability OPERATIONS|MI_PROB_N Numeric

None
(SAFETY) Consequence SAFETY|MI_CONSE_N Numeric

None
(SAFETY) Probability SAFETY|MI_PROB_N Numeric

None
Basis for Assessment MI_RCMFEFFT_BASIS_T Text None
Related Information

Copyright © 2018 General Electric Company. All rights reserved.