To import data using the Risk Based Inspection (RBI) 580 Data Loader, GE Digital APM provides an Excel workbook, Risk Based Inspection (RBI) 580.xlsx, which supports baseline Risk Based Inspection in GE Digital APM. This workbook must be used to perform the data load. You can modify the Excel workbook to include custom fields used by your organization.
Note: The Excel workbook is referred to throughout this documentation as the data loader workbook.
The following table lists the worksheets that are included in the data loader workbook.
Worksheet |
Description |
---|---|
Assets |
This worksheet is used to specify existing Equipment records to which components will be linked. |
RBI_Components |
This worksheet is used to specify the following types of RBI Component records that will be updated or created and linked to assets.
|
RBI_Criticality_Analysis |
This worksheet is used to define RBI Criticality Analysis records that will be linked to components. |
Consequence_Evaluation |
This worksheet is used to define Consequence Evaluation records that will be linked to analyses. |
DME_Environmental_Cracking |
This worksheet is used to define Criticality Env. Crack. Deg. Mech. Eval. records and Degradation Mechanisms that will be linked to analyses. |
DME_External_Corrosion |
This worksheet is used to define Criticality Ext. Corr. Deg. Mech. Eval. records and Degradation Mechanisms that will be linked to analyses. |
DME_Internal_Corrosion |
This worksheet is used to define Criticality Int. Corr. Deg. Mech. Eval. records and Degradation Mechanisms that will be linked to analyses. |
DME_Other |
This worksheet is used to define Criticality Other Damage Mech. Eval. records and Degradation Mechanisms that will be linked to analyses. |
DME_Custom | This worksheet is used to define custom Criticality Other Damage Mech. Eval. records and Degradation Mechanisms that will be linked to analyses. |
Degradation_Mechanism | This worksheet is used to define or update Damage Mechanisms that are or will be linked to the specified analyses. |
(PickList) |
This worksheet details the valid values available for fields that have pick lists. The field values listed in the (PickList) worksheet have been detailed in the corresponding worksheet. When you load data using the data loader, the data on this worksheet is not loaded. |
Color Coding
Certain columns on the worksheets have different functions and requirements. To illustrate this, certain columns are color-coded. The following table lists the colors and what they represent.
Color |
Description |
Comments |
---|---|---|
|
Required Key Fields |
Indicates columns that contain values that are used by the Risk Based Inspection (RBI) 580 Data Loader to look up and create records. If these columns are removed from the worksheets, the data load will fail. While the worksheets require that these columns be present, values are not necessarily required in these columns. |
|
Fields Required for Calculation |
Indicates columns that contain values that are required to perform calculations in Risk Based Inspection. Some cells only require values in certain cases. Such cases are found in parentheses in the first row of each worksheet. |
|
Recommended Fields |
Indicates columns that, according to GE Digital Best Practice for Risk Based Inspection, should contain values. |
|
Custom Fields |
Indicates columns where you can specify custom fields. |
Limitations
The Risk Based Inspection (RBI) 580 Data Loader has the following limitations:
If you reimport data, the records that have been created by the Risk Based Inspection (RBI) 580 Data Loader will be updated. Therefore, while reimporting data, if you remove the data for a field in the data loader workbook, the value for the corresponding field in GE Digital APM will be blank.
When you use the data loader to update an RBI Analysis and the associated Consequence Evaluation, Damage Mechanisms, and Damage Mechanism Evaluations:
On the Assets worksheet, you will specify assets to which you want to link components. 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 assets.
Note: Each row in this worksheet represents a unique asset. You should not include the same asset more than once.
Field Caption |
Field ID |
Data Type (Length) |
Comments |
---|---|---|---|
Equipment ID |
MI_EQUIP000_EQUIP_ID_C |
Character (255) |
This column requires at least one cell to have a value. |
CMMS System |
MI_EQUIP000_SAP_SYSTEM_C |
Character (255) |
If the Equipment record for an asset has a value in the CMMS System field, that value is required in this cell. |
Equipment Technical Number |
MI_EQUIP000_EQUIP_TECH_NBR_C |
Character (255) |
If you are required to enter a value for the CMMS System cell for an asset, and the Equipment record for the asset has a value in the Equipment Technical Number field, that value is required in this cell. If there is no value in the CMMS System field, this cell can be blank, even if the Equipment record contains a value for the Equipment Technical Number field. |
On the RBI Components worksheet, you will specify the Criticality RBI Component records that you want to create or update.
Note: Each row represents a unique component, though multiple components may be related to the same asset.
Field Caption |
Field ID |
Data Type (Length) |
Comments |
---|---|---|---|
Equipment ID |
MI_EQUIP000_EQUIP_ID_C |
Character (255) |
Values in this column must match values entered on the Assets worksheet. Multiple components can be linked to the same asset (i.e., rows may have the same value in this column). |
CMMS System |
MI_EQUIP000_SAP_SYSTEM_C |
Character (255) |
Values in this column must match values entered on the Assets worksheet, if they exist. Multiple components can be linked to the same asset (i.e., rows may have the same value in this column). |
Equipment Technical Number |
MI_EQUIP000_EQUIP_TECH_NBR_C |
Character (255) |
Values in this column must match values entered on the Assets worksheet, if they exist. Multiple components can be linked to the same asset (i.e., rows may have the same value in this column). |
Component |
MI_RBICOMPO_COMPO_C |
Character (250) |
A value is required. |
Component Type |
MI_RBICOMPO_COMPO_TYPE_C |
Character (60) |
A value is required. In the baseline GE Digital APM system, this cell may only contain one of the following values:
|
Component Family | FAMILY_ID |
In the baseline GE Digital APM system, this cell may only contain one of the following values:
|
|
Component Description |
MI_RBICOMPO_COMPO_DESCR_C |
Character (255) |
A value is required if the value in the Toxic Mixture cell is True. |
Component Date in Service |
MI_RBICOMPO_COMP_STRT_DATE_DT |
Date |
A value is required if a Criticality Ext. Corr. Deg. Mech. Eval., Criticality Int. Corr. Deg. Mech. Eval., or Criticality Env. Crack. Deg. Mech. Eval. record will be created for an analysis linked to this component. |
Circuit From |
MI_CCRBICPI_CIRCU_FROM_C |
Character (250) |
None |
Circuit To |
MI_CCRBICPI_CIRCU_TO_C |
Character (250) |
None |
Component Comments |
MI_RBICOMPO_COMPO_COMME_TX |
Text |
None |
Operating Pressure |
MI_RBICOMPO_OPERA_PRESS_N |
Numeric |
A value is required. The value in this cell is copied to the Operating Pressure field of the associated RBI Analysis. The value in this cell must be less than or equal to the value in the Design Pressure cell for the analysis to be created. |
Operating Pressure - Shell |
MI_CCRBICEB_OPER_PRES_SHEL_N |
Numeric |
A value is required. |
Operating Temperature |
MI_RBICOMPO_OPERA_TEMPE_N |
Numeric |
A value is required. The value in this cell is copied to the Operating Temperature field of the associated RBI Analysis. The value in this cell must be less than or equal to the value in the Design Temperature cell for the analysis to be created. |
Operating Temperature - Shell |
MI_CCRBICEB_OP_TEMP_SHEL_N |
Numeric |
None |
Area Humidity |
MI_CCRBICOM_AREA_HUMID_C |
Character (100) |
A value is required if a Criticality Ext. Corr. Deg. Mech. Eval. record will be created for an analysis linked to this component. In the baseline GE Digital APM system, this cell may only contain one of the following values:
If the family has been customized, the valid values could be different. This cell may only contain a value that exists in the list in the Area Humidity field for Criticality RBI Component records. |
Foundation Type |
MI_CCRBICTB_FOUND_TYPE_C |
Character (50) |
A value is required for RBI Storage Tank Bottom Components. This cell may only contain one of the following values:
The list in this field is populated by the FOUNDATION TYPES System Code Table. If the system code table has been customized, the valid values could be different. To verify which options are acceptable in your GE Digital APM system, via Configuration Manager, refer to the appropriate table. |
Initial Fluid Phase |
MI_RBICOMPO_INIT_FLU_PHASE_C |
Character (20) |
A value is required for each row. In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:
The list in this field is populated by the FLUID TYPES System Code Table. If the system code table has been customized, the valid values could be different. To verify which options are acceptable in your GE Digital APM system, via Configuration Manager, refer to the appropriate table. |
Initial Fluid Phase - Shell Side |
MI_CCRBICEB_INI_FD_PHS_SH_SD_C |
Character (20) |
A value is required for each row. In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:
The list in this field is populated by the FLUID TYPES System Code Table. If the system code table has been customized, the valid values could be different. To verify which options are acceptable in your GE Digital APM system, via Configuration Manager, refer to the appropriate table. This field is only required for Exchanger Bundle RBI Components. |
Process Fluid |
MI_RBICOMPO_PROCE_FLUID_C |
Character (50) |
A value is required. In the baseline GE Digital APM system, this cell may only contain one of the following values:
|
Process Fluid - Shell Side |
MI_CCRBICEB_PROC_FD_SH_SD_C |
Character (50) |
A value is required. In the baseline GE Digital APM system, this cell may only contain one of the following values:
|
Toxic Mixture |
MI_RBICOMPO_TOXIC_MIX_F |
Boolean |
Enter True or False. A value is required if the value in the Toxic Mixture cell is True. |
Toxic Fluid |
MI_RBICOMPO_TOXIC_MODEL_C |
Character (50) |
A value is required if the value in the Toxic Mixture cell is True. In the baseline GE Digital APM system, this cell may only contain one of the following values:
|
Percent Toxic |
MI_RBICOMPO_PERCE_TOXIC_N |
Numeric |
A value is required if the value in the Toxic Mixture cell is True. |
Toxic Mixture - Shell Side |
MI_CCRBICEB_TOX_MX_SH_SD_C |
Boolean |
Enter True or False. A value is required if the value in the Toxic Mixture - Shell cell is True. |
Toxic Fluid - Shell Side |
MI_CCRBICEB_TOX_FLD_SH_SD_C |
Character (50) |
A value is required if the value in the Toxic Mixture - Shell Side cell is True. In the baseline GE Digital APM system, this cell may only contain one of the following values:
|
Percent Toxic - Shell Side |
MI_CCRBICEB_PER_TOX_SHEL_SD_N |
Numeric |
A value is required if the value in the Toxic Mixture - Shell Side cell is True. |
Inventory |
MI_RBICOMPO_INVEN_N |
Numeric |
A value is required if:
|
Detection Time |
MI_CCRBICOM_DETEC_TIME_N |
Numeric |
A value is required. |
Isolation Time |
MI_CCRBICOM_ISOLA_TIME_N |
Numeric |
A value is required. |
Design Pressure |
MI_RBICOMPO_DESIG_PRESS_N |
Numeric |
A value is required for External Damage DMs, AST DMs, or Thinning and Lining DMs. The value in this cell is copied to the Design Pressure field of the associated RBI Analysis. The value in this cell must be greater than or equal to the value in the Operating Pressure cell for the analysis to be created. |
Design Pressure - Shell Side |
MI_CCRBICEB_DES_PRES_SHEL_SD_N |
Numeric |
A value is required for a component of type Exchanger Bundle. |
Design Temperature |
MI_RBICOMPO_DESIG_TEMPE_N |
Numeric |
A value is required for External Damage DMs, AST DMs, and Thinning and Lining DMs. The value in this cell is copied to the Design Temperature field of the associated RBI Analysis. The value in this cell must be greater than or equal to the value in the Operating Temperature cell for the analysis to be created. |
Design Temperature - Shell Side |
MI_CCRBICEB_DES_TEMP_SH_SD_N |
Numeric |
A value is required for a component of type Exchanger Bundle. |
Diameter |
MI_RBICOMPO_DIAME_INNER_N |
Numeric |
A value is required if the Component Type is Storage Tank. |
Length |
MI_RBICOMPO_LENGT_N |
Numeric |
A value is required in order to populate the Calculated Inventory field. |
Fill Height |
MI_CCRBICTB_FILL_HEIGH_N |
Numeric |
A value is required if the Component Type is Storage Tank. |
Nominal Thickness |
MI_RBICOMPO_NOMIN_THICK_N |
Numeric |
A value is required for External Damage DMs, AST DMs, and Thinning and Lining DMs. |
Stress Lookup Table |
MI_RBICOMPO_STRESS_TABLE_C |
Character (50) |
A value is required for External Damage DMs, AST DMs, Thinning and Lining DMs, and Brittle Fracture DMs. This cell may only contain one of the following values:
If the family has been customized, the valid values could be different. This cell may only contain a value that exists in the list in the Stress Lookup Table field for Criticality RBI Component records. |
BM CODE |
MI_RBICOMPO_BM_CODE_C |
Character (30) |
A value is required for External Damage DMs, AST DMs, Thinning and Lining DMs, and Brittle Fracture DMs. Refer to the (Picklist) worksheet in the excel workbook for valid values that you enter in this cell. |
BM YEAR |
MI_RBICOMPO_BM_YEAR_C |
Character (50) |
A value is required for External Damage DMs, AST DMs, Thinning and Lining DMs, and Brittle Fracture DMs. Refer to the (Picklist) worksheet in the excel workbook for valid values that you enter in this cell. |
BM SPEC |
MI_RBICOMPO_BM_SPEC_C |
Character (50) |
A value is required for External Damage DMs, AST DMs, Thinning and Lining DMs, and Brittle Fracture DMs. Refer to the (Picklist) worksheet in the excel workbook for valid values that you enter in this cell. |
BM GRADE |
MI_RBICOMPO_BM_GRADE_C |
Character (50) |
A value is required for External Damage DMs, AST DMs, Thinning and Lining DMs, and Brittle Fracture DMs. Refer to the (Picklist) worksheet in the excel workbook for valid values that you enter in this cell. |
Weld Joint Effy |
MI_RBICOMPO_WELD_JOINT_EFFY_N |
Numeric |
A value is required for External Damage DMs, AST DMs, and Thinning and Lining DMs. In the baseline GE Digital APM system, this cell may only contain one of the following values:
If the family has been customized, the valid values could be different. This cell may only contain a value that exists in the list in theWeld Joint Effyfield for Criticality RBI Component records. |
Insulated? |
MI_RBICOMPO_INSUL_F |
Boolean |
Enter True or False. |
Insulation Type |
MI_RBICOMPO_INSUL_C |
Character (200) |
A value is required if the value in the Insulated? cell is True. In the baseline GE Digital APM system, this cell may only contain one of the following values:
|
Piping Circuit Length |
MI_CCRBICPI_PIP_CIR_LENG_N |
Numeric |
A value is required in order to populate the Calculated Inventory field. This field is only required for RBI Pipeline Components. |
PWHT |
MI_CRENCDME_PWHT_F |
Boolean |
Enter True or False. |
Course Number | MI_CCRBICTB_COURS_NUM_N | Numeric | None |
Is Entry Possible? |
MI_CRENCDME_IS_ENTRY_POSS_C |
Character (50) |
A value is required. In the baseline GE Digital APM system, this cell may only contain one of the following values:
The list in this field is populated by the MI_YES_NO System Code Table. If the system code table has been customized, the valid values could be different. To verify which options are acceptable in your GE Digital APM system, via Configuration Manager, refer to the appropriate table. |
Corrosive Product |
MI_CCRBICOM_CORRO_PRODU_C |
Character (250) |
None |
Internal Corrosion Type |
MI_RBICOMPO_INTER_CORR_TYPE_C |
Character (50) |
While not required, it is recommended you enter a value in this cell. This field is used when generating RBI Recommendations. In the baseline GE Digital APM system, this cell may only contain one of the following values:
If the family has been customized, the valid values could be different. This cell may only contain a value that exists in the list in the Internal Corrosion Type field for Criticality RBI Component records. |
Internal Corrosion Type - Shell Side |
MI_CCRBICEB_INT_COR_TP_SH_SD_C |
Character (50) |
This field is used when generating RBI Recommendations. In the baseline GE Digital APM system, this cell may only contain one of the following values:
If the family has been customized, the valid values could be different. This cell may only contain a value that exists in the list in the Internal Corrosion Type field for Criticality RBI Component records. |
Predictable Int. Corr. Location |
MI_CCRBICOM_PRED_INT_COR_LOC_F |
Boolean |
Enter True or False. |
Pred_Int_Corr_Location - Shell Side |
MI_CCRBICEB_PRD_INT_CR_LC_SH_F |
Boolean |
Enter True or False. |
Estimated Internal Corrosion Rate |
MI_RBICOMPO_EXP_INT_CORR_RT_N |
Numeric |
A value is required in this cell if a Criticality Int. Corr. Deg. Mech. Eval. record will be created for an analysis linked to this component. |
Estimated External Corrosion Rate |
MI_RBICOMPO_EXP_EXT_CORR_RT_N |
Numeric |
A value is required in this cell if a Criticality Ext. Corr. Deg. Mech. Eval. record will be created for an analysis linked to this component. |
Measured External Corrosion Rate |
MI_RBICOMPO_MEAS_EXT_COR_RT_N |
Numeric |
None |
Source of Calculated Corrosion Rates | MI_CCRBICOM_CALCD_CR_SRC_C | Character (50) |
In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:
The list in this field is populated by the MI_RBI_CALC_CORRO_SRC System Code Table. If the system code table has been customized, the valid values could be different. To verify which options are acceptable in your GE Digital APM system, via Configuration Manager, refer to the appropriate table. |
On the RBI_Criticality_Analysis worksheet, you will specify RBI Criticality Analysis records that you want to create.
Note: Each row represents a unique analysis, though multiple analyses may be related to the same asset.
Field Caption |
Field ID |
Data Type (Length) |
Comments |
---|---|---|---|
Equipment ID |
MI_EQUIP000_EQUIP_ID_C |
Character (255) |
Values in this column must match values entered on the Assets worksheet. Multiple components can be linked to the same asset (i.e., rows may have the same value in this column). |
CMMS System |
MI_EQUIP000_SAP_SYSTEM_C |
Character (255) |
Values in this column must match values entered on the Assets worksheet, if they exist. Multiple components can be linked to the same asset (i.e., rows may have the same value in this column). |
Equipment Technical Number |
MI_EQUIP000_EQUIP_TECH_NBR_C |
Character (255) |
Values in this column must match values entered on the Assets worksheet, if they exist. Multiple components can be linked to the same asset (i.e., rows may have the same value in this column). |
Component |
MI_RBICOMPO_COMPO_C |
Character (250) |
A value is required. |
Component Type |
MI_RBICOMPO_COMPO_TYPE_C |
Character (60) |
A value is required. This cell may only contain a value that exists in the list in the Component Type field for Criticality RBI Component records. |
Analysis Unique ID |
MI_ANALYSIS_ID |
N/A |
This cell is required, but is only used in the context of the workbook. The Risk Based Inspection (RBI) 580 Data Loader uses the value in this cell to match and link Consequence Evaluations and Degradation Mechanism Evaluations to the analysis. |
Scenario ID |
MI_CRITANAL_TURNAROUND_ID_C |
Character (100) |
While not required, it is recommended you enter a value in this cell. |
Scenario Reference Date |
MI_CRITANAL_TURN_AROUN_DATE_D |
Date |
While not required, it is recommended you enter a value in this cell. |
Allowable Stress Override | MI_CRITANAL_MTL_A_STRESS_OVR_F | Boolean |
Enter True or False. |
Allowable Stress | MI_CRITANAL_MTL_ALLOW_STRESS_N | Numeric |
If the Allowable Stress Override cell is True, a value is required in this cell. Required only for RBI Analysis records that are linked to Criticality Int. Corr. Deg. Mech. Eval. or Criticality Ext. Corr. Deg. Mech. Eval. records. |
Override Minimum Required Thickness | MI_CRITANAL_EQ_EST_TCK_OVRDE_F | Boolean |
Enter True or False. |
On the Consequence_Evaluation worksheet, you will specify Consequence Evaluations that you want to create and link to RBI Criticality Analysis records.
Note: Each row represents a unique Consequence Evaluation. Only one Consequence Evaluation can be linked to an analysis, unless you specify a different Consequence for each Consequence Evaluation.
Field Caption |
Field ID |
Data Type (Length) |
Comments |
---|---|---|---|
Equipment ID |
MI_EQUIP000_EQUIP_ID_C |
Character (255) |
Values in this column must match values entered on the Assets worksheet. Multiple components can be linked to the same asset (i.e., rows may have the same value in this column). |
CMMS System |
MI_EQUIP000_SAP_SYSTEM_C |
Character (255) |
Values in this column must match values entered on the Assets worksheet, if they exist. Multiple components can be linked to the same asset (i.e., rows may have the same value in this column). |
Equipment Technical Number |
MI_EQUIP000_EQUIP_TECH_NBR_C |
Character (255) |
Values in this column must match values entered on the Assets worksheet, if they exist. Multiple components can be linked to the same asset (i.e., rows may have the same value in this column). |
Component |
MI_RBICOMPO_COMPO_C |
Character (250) |
A value is required. |
Component Type |
MI_RBICOMPO_COMPO_TYPE_C |
Character (60) |
A value is required. This cell may only contain a value that exists in the list in the Component Type field for Criticality RBI Component records. |
Analysis Unique ID |
MI_ANALYSIS_ID |
N/A |
The value in this cell must correspond to a value entered in the Analysis Unique ID column on the RBI_Criticality_Analysis worksheet. |
Consequence |
MI_RCONEVAL_CONS_C |
Character (50) |
A value is required in this cell if you are creating more than one Consequence Evaluation for the same analysis. If left blank, the Consequence field will be populated with the value RBI. |
Comments |
MI_RCONEVAL_COMM_TX |
Text |
None |
Inventory Group |
MI_RCONEVAL_INV_GRP_C |
Character (100) |
None |
Number of Towers |
MI_CRCOEVAL_NUM_OF_TOW_N |
Numeric |
None |
Number of Storage Tanks |
MI_CRCOEVAL_NUM_STO_TNKS_N |
Numeric |
None |
Number of Vessels |
MI_CRCOEVAL_NUM_OF_VESS_N |
Numeric |
None |
Use Calculated Inventory |
MI_CRCOEVAL_USE_CALC_INV_F |
Boolean |
Enter True or False. |
Inspection Interval |
MI_CRCOEVAL_INSPE_INTER_N |
Numeric |
A value is required if the component to which the analysis is linked is a Storage Tank or Tank Bottom. |
Consequence Near Ignition Source |
MI_CRCOEVAL_CON_NEAR_IGN_SRC_F |
Boolean |
Enter True or False. |
Bottom Thickness |
MI_CRCOEVAL_BOT_THK_N |
Numeric |
None |
Diked? |
MI_CRCOEVAL_DIKED_F |
Boolean |
Enter True or False. |
Diked Area |
MI_CRCOEVAL_DIKED_AREA_N |
Numeric |
None |
Persistent Fluid? |
MI_CRCOEVAL_PERS_FLUID_F |
Boolean |
Enter True or False. |
Leak Effect |
MI_CRCOEVAL_LEAK_EFFEC_C |
Character (50) |
A value is required if the component to which the analysis is linked is a Storage Tank or Tank Bottom. In the baseline GE Digital APM system, this cell may only contain one of the following values:
If the family has been customized, the valid values could be different. This cell may only contain a value that exists in the list in the Leak Effect field for Consequence Evaluation records. |
Unit Cleanup Cost |
MI_CRCOEVAL_UNIT_CLEAN_COST_N |
Numeric |
None |
Underside Corrosion Rate |
MI_CRCOEVAL_UNDER_COR_RT_N |
Numeric |
None |
(Flammable) Leak Type |
MI_CRCOEVAL_LEAK_TYPE_C |
Character (150) |
In the baseline GE Digital APM system, this cell may only contain one of the following values:
If the family has been customized, the valid values could be different. This cell may only contain a value that exists in the list in the Flammable Leak Type field for Consequence Evaluation records. |
Toxic Leak Type |
MI_CRCOEVAL_TOX_LK_TYPE_C |
Character (50) |
In the baseline GE Digital APM system, this cell may only contain one of the following values:
If the family has been customized, the valid values could be different. This cell may only contain a value that exists in the list in the Toxic Leak Type field for Consequence Evaluation records. |
Product Unit Value |
MI_CRCOEVAL_PROD_UNIT_VAL_C |
Character (150) |
None |
On the DME_Environmental_Cracking worksheet, you will specify Degradation Mechanisms related to Environmental Cracking that you want to create and link to RBI Criticality Analysis records. For each Degradation Mechanism, a Degradation Mechanism Evaluation is created and linked to the specified analysis. Additionally, a corresponding Potential Degradation Mechanism is created and linked to the specified component.
Note: Each row represents a unique Degradation Mechanism. Only one of each type of Degradation Mechanism can be linked to an analysis. For example, the same analysis could have a Carbonate Cracking Degradation Mechanism and a Caustic Cracking Degradation Mechanism, but not two Carbonate Cracking Degradation Mechanisms.
Field Caption |
Field ID |
Data Type (Length) |
Comments |
---|---|---|---|
Equipment ID |
MI_EQUIP000_EQUIP_ID_C |
Character (255) |
Values in this column must match values entered on the Assets worksheet. Multiple components can be linked to the same asset (i.e., rows may have the same value in this column). |
CMMS System |
MI_EQUIP000_SAP_SYSTEM_C |
Character (255) |
Values in this column must match values entered on the Assets worksheet, if they exist. Multiple components can be linked to the same asset (i.e., rows may have the same value in this column). |
Equipment Technical Number |
MI_EQUIP000_EQUIP_TECH_NBR_C |
Character (255) |
Values in this column must match values entered on the Assets worksheet, if they exist. Multiple components can be linked to the same asset (i.e., rows may have the same value in this column). |
Component |
MI_RBICOMPO_COMPO_C |
Character (250) |
A value is required. |
Component Type |
MI_RBICOMPO_COMPO_TYPE_C |
Character (60) |
A value is required. This cell may only contain a value that exists in the list in the Component Type field for Criticality RBI Component records. |
Analysis Unique ID |
MI_ANALYSIS_ID |
Character (255) |
The value in this cell must correspond to a value entered in the Analysis Unique ID column on the RBI_Criticality_Analysis worksheet. |
Damage Mechanism |
MI_RBDEMEEV_DAM_MECH_C |
Character (50) |
The value in this cell must be a Degradation Mechanism that corresponds to a Criticality Env. Crack. Deg. Mech. Eval. record. In the baseline GE Digital APM system, this cell may only contain one of the following values:
|
Damage Comments |
MI_RBDEMEEV_DAM_COM_T |
Text |
None |
Inspection Date |
MI_CRDEMEEV_INSP_DATE_D |
Date |
None |
Number of Inspections |
MI_CRDEMEEV_NUM_INSP_N |
Numeric |
In the baseline GE Digital APM system, this cell may only contain a numeric value between 1 -20.
|
Inspection Confidence |
MI_CRDEMEEV_INSP_CONF_C |
Character (50) |
A value is required. In the baseline GE Digital APM system, this cell may only contain one of the following values:
|
Damaged At Last Inspection |
MI_CRENCDME_DAM_LST_INS_F |
Boolean |
Enter True or False. |
Env. Cracking Higher Levels |
MI_CRENCDME_ENV_CRK_HI_LEV_F |
Boolean |
Enter True or False. |
Initial Potential |
MI_RBDEMEEV_ESTIM_C |
Character (50) |
A value is required. In the baseline GE Digital APM system, this cell may only contain one of the following values:
If the family has been customized, the valid values could be different. This cell may only contain a value that exists in the list in the Initial Potential field for Criticality Env. Crack. Deg. Mech. Eval. records. |
Cyanides? |
MI_RBDEMEEV_CYANI_F |
Boolean |
Enter True or False. |
Free Water |
MI_RBDEMEEV_FREE_WATER_N |
Numeric |
None |
H2S Content |
MI_RBDEMEEV_H2S_CON_C |
Character (50) |
None |
HIC Resistant Steel |
MI_CRENCDME_HIC_RESIS_STE_F |
Boolean |
Enter True or False. |
Stable Scale |
MI_CRENCDME_STAB_SCALE_F |
Boolean |
Enter True or False. |
PT or MT Access? |
MI_CRENCDME_PT_OR_MT_ACCES_C |
Character (50) |
While not required, it is recommended you enter a value in this cell. In the baseline GE Digital APM system, this cell may only contain one of the following values:
The list in this field is populated by the MI_YES_NO System Code Table. If the system code table has been customized, the valid values could be different. To verify which options are acceptable in your GE Digital APM system, via Configuration Manager, refer to the appropriate table. |
On the DME_External_Corrosion worksheet, you will specify Criticality Calculator External Corrosion Degradation Mechanisms that you want to create and link to RBI Criticality Analysis records. For each Degradation Mechanism, a Degradation Mechanism Evaluation is created and linked to the specified analysis. Additionally, a corresponding Potential Degradation Mechanism is created and linked to the specified component.
Note: Each row represents a unique Degradation Mechanism. Only one Criticality Calculator External Corrosion Degradation Mechanism can be linked to an analysis.
Field Caption |
Field ID |
Data Type (Length) |
Comments |
---|---|---|---|
Equipment ID |
MI_EQUIP000_EQUIP_ID_C |
Character (255) |
Values in this column must match values entered on the Assets worksheet. Multiple components can be linked to the same asset (i.e., rows may have the same value in this column). |
CMMS System |
MI_EQUIP000_SAP_SYSTEM_C |
Character (255) |
Values in this column must match values entered on the Assets worksheet, if they exist. Multiple components can be linked to the same asset (i.e., rows may have the same value in this column). |
Equipment Technical Number |
MI_EQUIP000_EQUIP_TECH_NBR_C |
Character (255) |
Values in this column must match values entered on the Assets worksheet, if they exist. Multiple components can be linked to the same asset (i.e., rows may have the same value in this column). |
Component |
MI_RBICOMPO_COMPO_C |
Character (250) |
A value is required. |
Component Type |
MI_RBICOMPO_COMPO_TYPE_C |
Character (60) |
A value is required. This cell may only contain a value that exists in the list in the Component Type field for Criticality RBI Component records. |
Analysis Unique ID |
MI_ANALYSIS_ID |
Character (255) |
The value in this cell must correspond to a value entered in the Analysis Unique ID column on the RBI_Criticality_Analysis worksheet. |
Damage Mechanism |
MI_RBDEMEEV_DAM_MECH_C |
Character (50) |
The value in this cell must be Criticality Calculator Internal Corrosion. |
Damage Comments |
MI_RBDEMEEV_DAM_COM_T |
Text |
None |
Insulation Condition |
MI_RBDEMEEV_INSUL_CON_C |
Character (50) |
In the baseline GE Digital APM system, this cell may only contain one of the following values:
If the family has been customized, the valid values could be different. This cell may only contain a value that exists in the list in the Coating Quality field for Criticality Ext. Corr. Deg. Mech. Eval records. |
Coating Quality |
MI_RBDEMEEV_COAT_QUAL_C |
Character (50) |
A value is required if the value in the Coating Present? cell is Y. In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:
The list in this field is populated by the MI_RBI_Coating_Quality System Code Table. If the system code table has been customized, the valid values could be different. To verify which options are acceptable in your GE Digital APM system, via Configuration Manager, refer to the appropriate table. |
Selected Corrosion Rate |
MI_RBDEMEEV_SEL_CORR_RATE_N |
Numeric |
A value is required for each row. In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:
For this field:
The list in this field is populated by the RBI_INT_COR_TYP System Code Table. If the system code table has been customized, the valid values could be different. To verify which options are acceptable in your GE Digital APM system, via Configuration Manager, refer to the appropriate table. |
Measured Corrosion Rate |
MI_RBDEMEEV_BM_MEASU_RT_N
|
Numeric |
A value is required if the value in the Selected Corrosion Rate column is 1. |
Inspection Date |
MI_CRDEMEEV_INSP_DATE_D |
Date |
None |
Number of Inspections |
MI_CRDEMEEV_NUM_INSP_N |
Numeric |
A value is required. |
Inspection Confidence |
MI_CRDEMEEV_INSP_CONF_C |
Character (50) |
A value is required. This cell may only contain the ID of a System Code listed in the INSPECTION CONFIDENCE, MI_RBI_REFERENCES, and MI_RBI_INSPCONF System Code Tables. To verify which options are acceptable in your GE Digital APM system, via Configuration Manager, refer to the appropriate table. |
Near Cooling Tower? |
MI_RBDEMEEV_N_COOL_TOWER_F |
Boolean |
Enter True or False. |
On the DME_Internal_Corrosion worksheet, you will specify Criticality Calculator Internal Corrosion Degradation Mechanisms that you want to create and link to RBI Criticality Analysis records. For each Degradation Mechanism, a Degradation Mechanism Evaluation is created and linked to the specified analysis. Additionally, a corresponding Potential Degradation Mechanism is created and linked to the specified component.
Note: Each row represents a unique Degradation Mechanism. Only one Criticality Calculator Internal Corrosion Degradation Mechanism can be linked to an analysis.
Field Caption |
Field ID |
Data Type (Length) |
Comments |
---|---|---|---|
Equipment ID |
MI_EQUIP000_EQUIP_ID_C |
Character (255) |
Values in this column must match values entered on the Assets worksheet. Multiple components can be linked to the same asset (i.e., rows may have the same value in this column). |
CMMS System |
MI_EQUIP000_SAP_SYSTEM_C |
Character (255) |
Values in this column must match values entered on the Assets worksheet, if they exist. Multiple components can be linked to the same asset (i.e., rows may have the same value in this column). |
Equipment Technical Number |
MI_EQUIP000_EQUIP_TECH_NBR_C |
Character (255) |
Values in this column must match values entered on the Assets worksheet, if they exist. Multiple components can be linked to the same asset (i.e., rows may have the same value in this column). |
Component |
MI_RBICOMPO_COMPO_C |
Character (250) |
A value is required. |
Component Type |
MI_RBICOMPO_COMPO_TYPE_C |
Character (60) |
A value is required. This cell may only contain a value that exists in the list in the Component Type field for Criticality RBI Component records. |
Analysis Unique ID |
MI_ANALYSIS_ID |
Character (255) |
The value in this cell must correspond to a value entered in the Analysis Unique ID column on the RBI_Criticality_Analysis worksheet. |
Damage Mechanism |
MI_RBDEMEEV_DAM_MECH_C |
Character (50) |
The value in this cell must be Criticality Calculator Internal Corrosion. |
Damage Comments |
MI_RBDEMEEV_DAM_COM_T |
Text |
None |
Selected Corrosion Rate |
MI_RBDEMEEV_SEL_CORR_RATE_N |
Numeric |
A value is required for each row. In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:
For this field:
The list in this field is populated by the RBI_INT_COR_TYP System Code Table. If the system code table has been customized, the valid values could be different. To verify which options are acceptable in your GE Digital APM system, via Configuration Manager, refer to the appropriate table. |
Long Term Avg. Corr. Rate |
MI_CRINCDME_LONG_TRM_AV_C_RT_N |
Numeric |
If the Selected Corrosion Rate cell is Long Term Avg., a value is required in this cell. |
Short Term Avg. Corr. Rate |
MI_CRINCDME_SHRT_TRM_A_C_RT_N |
Numeric |
If the Selected Corrosion Rate cell is Short Term Avg., a value is required in this cell. |
Thinning Type |
MI_RBDEMEEV_THIN_TYPE_C |
Character (50) |
A value is required. In the baseline GE Digital APM system, this cell may only contain one of the following values:
|
Inspection Date |
MI_CRDEMEEV_INSP_DATE_D |
Date |
None |
Number of Inspections |
MI_CRDEMEEV_NUM_INSP_N |
Numeric |
A value is required. In the baseline GE Digital APM system, this cell may only contain a numeric value between 1 and 20. |
Inspection Confidence |
MI_CRDEMEEV_INSP_CONF_C |
Character (50) |
A value is required. In the baseline GE Digital APM system, this cell may only contain one of the following values:
|
Predictable |
MI_CRINCDME_PRED_C |
Character (50) |
While not required, it is recommended you enter a value in this cell. In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:
The list in this field is populated by the MI_YES_NO System Code Table. If the system code table has been customized, the valid values could be different. To verify which options are acceptable in your GE Digital APM system, via Configuration Manager, refer to the appropriate table. |
On the DME_Other worksheet, you will specify Degradation Mechanisms related that you want to create and link to RBI Criticality Analysis records. For each Degradation Mechanism, a Degradation Mechanism Evaluation is created and linked to the specified analysis. Additionally, a corresponding Potential Degradation Mechanism is created and linked to the specified component.
Field Caption |
Field ID |
Data Type (Length) |
Comments |
---|---|---|---|
Equipment ID |
MI_EQUIP000_EQUIP_ID_C |
Character (255) |
Values in this column must match values entered on the Assets worksheet. Multiple components can be linked to the same asset (i.e., rows may have the same value in this column). |
CMMS System |
MI_EQUIP000_SAP_SYSTEM_C |
Character (255) |
Values in this column must match values entered on the Assets worksheet, if they exist. Multiple components can be linked to the same asset (i.e., rows may have the same value in this column). |
Equipment Technical Number |
MI_EQUIP000_EQUIP_TECH_NBR_C |
Character (255) |
Values in this column must match values entered on the Assets worksheet, if they exist. Multiple components can be linked to the same asset (i.e., rows may have the same value in this column). |
Component |
MI_RBICOMPO_COMPO_C |
Character (250) |
A value is required. |
Component Type |
MI_RBICOMPO_COMPO_TYPE_C |
Character (60) |
A value is required. This cell may only contain a value that exists in the list in the Component Type field for Criticality RBI Component records. |
Analysis Unique ID |
MI_ANALYSIS_ID |
Character (255) |
The value in this cell must correspond to a value entered in the Analysis Unique ID column on the RBI_Criticality_Analysis worksheet. |
Damage Mechanism |
MI_RBDEMEEV_DAM_MECH_C |
Character (50) |
The value in this cell must be a Degradation Mechanism that corresponds to a Criticality Other Damage Mech. Eval. record. The value in this cell is used to create the Degradation Mechanism for the Degradation Mechanism Evaluation that will be linked to the analysis, as well as the corresponding Potential Degradation Mechanism that will be related to the component. In the baseline GE Digital APM system, this cell may only contain one of the following values:
|
Probability Category |
MI_RBDEMEEV_LIKE_CAT_C |
Character (50) |
While not required, it is recommended you enter a value in this cell. In the baseline GE Digital APM system, this cell may only contain one of the following values:
|
Damage Comments |
MI_RBDEMEEV_DAM_COM_T |
Text |
None |
On the DME_Other worksheet, you will specify custom Degradation Mechanisms that you want to create and link to RBI Criticality Analysis records. For each Degradation Mechanism, a Degradation Mechanism Evaluation is created and linked to the specified analysis. Additionally, a corresponding Potential Degradation Mechanism is created and linked to the specified component.
Field Caption |
Field ID |
Data Type (Length) |
Comments |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Equipment ID |
MI_EQUIP000_EQUIP_ID_C |
Character (255) |
Values in this column must match values entered on the Assets worksheet. Multiple components can be linked to the same asset (i.e., rows may have the same value in this column). |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CMMS System |
MI_EQUIP000_SAP_SYSTEM_C |
Character (255) |
Values in this column must match values entered on the Assets worksheet, if they exist. Multiple components can be linked to the same asset (i.e., rows may have the same value in this column). |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Equipment Technical Number |
MI_EQUIP000_EQUIP_TECH_NBR_C |
Character (255) |
Values in this column must match values entered on the Assets worksheet, if they exist. Multiple components can be linked to the same asset (i.e., rows may have the same value in this column). |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Component |
MI_RBICOMPO_COMPO_C |
Character (250) |
A value is required. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Component Type |
MI_RBICOMPO_COMPO_TYPE_C |
Character (60) |
A value is required. This cell may only contain a value that exists in the list in the Component Type field for Criticality RBI Component records. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analysis Unique ID |
MI_ANALYSIS_ID |
Character (255) |
The value in this cell must correspond to a value entered in the Analysis Unique ID column on the RBI_Criticality_Analysis worksheet. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Damage Mechanism |
MI_RBDEMEEV_DAM_MECH_C |
Character (50) |
The value in this cell must be a Degradation Mechanism that corresponds to a Criticality Other Damage Mech. Eval. record. The value in this cell is used to create the Degradation Mechanism for the Degradation Mechanism Evaluation that will be linked to the analysis, as well as the corresponding Potential Degradation Mechanism that will be related to the component. In the baseline GE Digital APM system, this cell may only contain one of the following values:
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DME Family | MI_DME_FAMILY | Character (50) | A value is required. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Probability Category |
MI_RBDEMEEV_LIKE_CAT_C |
Character (50) |
While not required, it is recommended you enter a value in this cell. In the baseline GE Digital APM system, this cell may only contain one of the following values:
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Damage Comments |
MI_RBDEMEEV_DAM_COM_T |
Text |
None |
On the Degradation_Mechanism worksheet, you will specify related Degradation Mechanisms that you want to create and link to RBI Criticality Analysis records.
Field Caption |
Field ID |
Data Type (Length) |
Comments |
---|---|---|---|
Equipment ID |
MI_EQUIP000_EQUIP_ID_C |
Character (255) |
Values in this column must match values entered on the Assets worksheet. Multiple components can be linked to the same asset (i.e., rows may have the same value in this column). |
CMMS System |
MI_EQUIP000_SAP_SYSTEM_C |
Character (255) |
Values in this column must match values entered on the Assets worksheet, if they exist. Multiple components can be linked to the same asset (i.e., rows may have the same value in this column). |
Equipment Technical Number |
MI_EQUIP000_EQUIP_TECH_NBR_C |
Character (255) |
Values in this column must match values entered on the Assets worksheet, if they exist. Multiple components can be linked to the same asset (i.e., rows may have the same value in this column). |
Component |
MI_RBICOMPO_COMPO_C |
Character (250) |
A value is required. |
Component Type |
MI_RBICOMPO_COMPO_TYPE_C |
Character (60) |
A value is required. This cell may only contain a value that exists in the list in the Component Type field for Criticality RBI Component records. |
Analysis Unique ID |
MI_ANALYSIS_ID |
N/A |
The value in this cell must correspond to a value entered in the Analysis Unique ID column on the RBI_Criticality_Analysis worksheet. |
Damage Mechanism |
MI_RBDEMEEV_DAM_MECH_C |
Character (50) |
The value in this cell must be a Degradation Mechanism that corresponds to a Criticality Other Damage Mech. Eval. record. The value in this cell is used to create the Degradation Mechanism for the Degradation Mechanism Evaluation that will be linked to the analysis, as well as the corresponding Potential Degradation Mechanism that will be related to the component. In the baseline GE Digital APM system, this cell may only contain one of the following values:
|
Deg Mech Comments |
MI_DEGR_MECH_DEG_MECH_COMM_TX |
Text |
None |
Copyright © 2018 General Electric Company. All rights reserved.