About Reliability Centered Maintenance (RCM) 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 Reliability Centered Maintenance (RCM) Data Loader, GE Digital provides an Excel workbook, Reliability Centered Maintenance (RCM).xlsx, which supports baseline data loading RCM analysis in GE Digital APM.

The following table lists the worksheets that are included in the Reliability Centered Maintenance (RCM) Data Loader workbook.

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 data into the team members 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.
Functions	This worksheet is used to load data into the Functions for the analysis.
Functional Failures	This worksheet is used to load data into the Function Failures for the analysis.
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. See the recommendation section for its relationship.
Recommendations	This worksheet is used to load data into the Recommendations. RCM Recommendations are linked to the associated Failure Effects. A Failure Effect can have multiple recommendations but each one must be unique.

Analysis Worksheet

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	Character (255)	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 Worksheet

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

Functions Worksheet

Field Caption	Field ID	Data Type (Length)	Comments
Analysis Short Description	MI_AN_SHORT_DESCR_CHR	Character (255)	This is a key field.
Function Name	MI_RCMFUNCN_NAME_C	Character (255)	This is a key field.
Function Type	MI_RCMFUNCN_TYPE_C	Character (40)	None
Sub Function	MI_RCMFUNCN_SUB_FUNCT_C	Character (50)	None
Function Long Description	MI_RCMFUNCN_LNG_DESC_T	Text	None
Function Performance Parameters	MI_RCMFUNCN_PRI_VAR_T	Text	None

Relationship:

Predecessor	Relationship	Successor
MI_RCMANALY	MIR_HRCMFNC	MI_RCMFUNCN

Functional Failures Worksheet

Field Caption	Field ID	Data Type (Length)	Comments
Analysis Short Description	MI_AN_SHORT_DESCR_CHR	Character (255)	This is a key field.
Function Name	MI_RCMFUNCN_NAME_C	Character (255)	This is a key field. Used to locate the Function ID for the Analysis.
Function Failure Name	MI_RCMFFAIL_NAME_C	Character (255)	This is a key field.
Functional Long Description	MI_RCMFFAIL_LNG_DESC_T	Text	None

Failure Modes Worksheet

Field Caption	Field ID	Data Type (Length)	Comments
Analysis Short Description	MI_AN_SHORT_DESCR_CHR	Character (255)	This is a key field.
Function Failure Name	MI_RCMFFAIL_NAME_C	Character (255)	This is a key field.
Failure Mode Name	MI_RCMFMODE_NAME_C	Character (255)	This is a key field.
Asset ID Value	ASSET_ID_CHR	Character (50)	This is a key field.
Asset ID Field	ASSET_FIELD_ID	Character	This is a key field.
Asset Family ID	ASSET_FAMILY_ID	Character	This is a key field.
CMMS ID	ASSET_CMMS_ID	Character	None
CMMS Value	ASSET_CMMS_VALUE	Character (50)	None
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)	None
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	Comment
MI_RCMEQPMT	MIR_HRCMFMD	MI_RCMFMODE	Links to Equipment RCM FMEA Asset
MI_RCMFUNCN	MIR_HRCMFFL	MI_RCMFMODE	Links Failure Mode to RCM Function

Failure Effects Worksheet

Source Field Name	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 Worksheet

Source Field Name	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	Boolean	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	Boolean	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