Open topic with navigation

About the Risk Based Inspection (RBI) 581 Data Loader Workbook Layout and Use

To import data using the Risk Based Inspection (RBI) 581 Data Loader, GE Digital APM provides an Excel workbook, RBI_581_Data_Loader.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_Component

This worksheet is used to specify the following types of RBI Component records that will be updated or created and linked to assets.

  • Cylindrical Shell
  • Exchanger Header
  • Exchanger Tube
  • Piping
  • Pump Compressor Casing
  • Tank Bottom

RBI_581_Analysis

This worksheet is used to specify RBI 581 Risk Analysis records that will be created and linked to components. You cannot update an RBI 581 Risk Analysis using the data loader workbook.

RBI_581_Consequence

This worksheet is used to specify RBI 581 Consequence Evaluation records that will be created and linked to analyses. Each analysis can be linked to only one RBI 581 Consequence Evaluation.

DME_Lining

This worksheet is used to specify the 581-Internal Component Lining Damage DMs (which are or will be represented by the RBI 581 Thinning and Lining Evaluation records) that you want to create or update. These records will be linked to an RBI 581 Risk Analysis. You can specify these DMs only if the value in the Lining Present column is True in the RBI_Component worksheet for the associated component.

DME_AST

This worksheet is used to specify the 581-Atmospheric Tank Bottom Corrosion DMs (which are or will be represented by the RBI 581 Thinning and Lining Evaluation records) that you want to create or update. These records will be linked to an RBI 581 Risk Analysis.

You can specify these DMs only if:

  • The component tamily is Tank Bottom (i.e., the value in the Component Family column in the RBI_Component worksheet for the associated component is MI_CCRBICTB).
  • The value in the Is Intrusive column in the RBI_Component worksheet for the associated component is True.

DME_Thinning

This worksheet is used to specify the following DMs that you want to create or update:

  • 581-High Temperature Oxidation

  • 581-Cooling Water Corrosion

  • 581-High Temperature H2/H2S Corrosion

  • 581-Amine Corrosion

  • 581-Hydrofluoric Acid Corrosion

  • 581-Sulfuric Acid Corrosion

  • 581-Hydrochloric Acid Corrosion

  • 581-Acid Sour Water Corrosion

  • 581-High Temperature Sulfidic and Naphthenic Acid

  • 581-Alkaline Sour Water Corrosion

  • 581-Soil Side Corrosion

    581-Thinning Damage

These DMs belong to the RBI 581 Thinning and Lining Evaluation methodology. These records will be linked to an RBI 581 Risk Analysis.

DME_ExternalDamage

This worksheet is used to define the following DMs that you want to create or update:

  • 581-Ferritic Component Atmospheric Corrosion

  • 581-Ferritic Component Corrosion Under Insulation

These DMs belong to the RBI 581 External Damage Evaluation methodology. These records will be linked to an RBI 581 Risk Analysis. You can specify these DMs only if the component type is not Tank Bottom (i.e., the value in the Component Family column in the RBI_Component worksheet is not MI_CCRBICTB).

DME_ExternalCracking

This worksheet is used to define the following DMs that you want to create or update:

  • 581-Austenitic Component Cracking Under Insulation
  • 581-Austenitic Component Atmospheric Cracking

These DMs belong to the RBI 581 External Cracking Damage Evaluation methodology. These records will be linked to an RBI 581 Risk Analysis. You can specify these DMs only if the component type is not Tank Bottom (i.e., the value in the Component Family column in the RBI_Component worksheet is not MI_CCRBICTB).
DME_Cracking

This worksheet is used to specify the following DMs that you want to create or update:

  • 581-Amine Cracking
  • 581-Alkaline Carbonate Stress Corrosion Cracking
  • 581-HIC/SOHIC - HF
  • 581-HIC/SOHIC - H2S
  • 581-Caustic Cracking
  • 581-Hydrogen Stress Cracking
  • 581-Other Cracking
  • 581-Sulfide Stress Cracking
  • 581-Chloride Stress Corrosion Cracking
  • 581-Polythionic Acid Cracking

These DMs belong to the RBI 581 Cracking Damage Evaluation methodology. These records will be linked to an RBI 581 Risk Analysis.
DME_HTHA

This worksheet is used to specify the 581-High Temperature Hydrogen Attack DMs (which are or will be represented by the RBI 581 HTHA Damage Evaluation records) that you want to create or update. These records will be linked to an RBI 581 Risk Analysis. You can specify these DMs only if the component type is not Tank Bottom (i.e., the value in the Component Family column in the RBI_Component worksheet is not MI_CCRBICTB).
DME_BrittleFracture

This worksheet is used to specify the following DMs (which are or will be represented by the RBI 581 Brittle Fracture Damage Evaluation records) that you want to create or update.

  • 581-Sigma Phase Embrittlement
  • 581-885F Embrittlement
  • 581-Brittle Fracture
  • 581-Low Alloy Steel Embrittlement

These records will be linked to an RBI 581 Risk Analysis. You can specify these DMs only if the component type is not Tank Bottom (i.e., the value in the Component Family column in the RBI_Component worksheet is not MI_CCRBICTB).
(Picklist)

This worksheet contains a list of valid values that you can enter in each column (as applicable) in the aforementioned worksheets. When you load data using the data loader, the data on this worksheet is not loaded.

The values in the some of the columns are filtered based on the values in other fields. For example, the values in the following columns are filtered based on the values in the Stress Lookup Table column:

  • BM Code
  • BM Year
  • BM Spec
  • BM Grade

Also, if you select a value in the BM Code column, the values in the BM Year, BM Spec, and BM Grade columns are filtered accordingly.

IMPORTANT: The Risk Based Inspection (RBI) 581 Data Loader overrides the default values specified in the RBI 581 Admin Options workspace.

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) 581 Data Loader has the following limitations:

Assets WorksheetClosed

In 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. The combination of values in the three columns on this worksheet must be unique.

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, enter that value in this column.

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, enter that value in this column.

If there is no value in the CMMS System field, this column can be blank, even if the Equipment record contains a value for the Equipment Technical Number field.
RBI_Component WorksheetClosed

In the RBI_Component worksheet, you will specify the components (which are or will be represented by RBI Component records) that you want to create or update.

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 in 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 in 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 in 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 and must be unique. This value identifies the component.

Component Type

MI_RBICOMPO_COMPO_TYPE_C

 Character (60) A value is required.

This cell may only contain one of the following values, which exist in the list in the Component Type field for RBI Component records:

  • 1" Pipe

  • 1.25" Pipe

  • 1.5" Pipe

  • 1/2" Pipe

  • 10" Pipe

  • 102" Pipe

  • 12" Pipe

  • 14" Pipe

  • 16" Pipe

  • 18" Pipe

  • 2" Pipe

  • 2.5" Pipe

  • 20" Pipe

  • 24" Pipe

  • 26" Pipe

  • 28" Pipe

  • 3" Pipe

  • 3/4" Pipe

  • 30" Pipe

  • 32" Pipe

  • 34" Pipe

  • 36" Pipe

  • 4" Pipe

  • 40" Pipe

  • 42" Pipe

  • 48" Pipe

  • 5" Pipe

  • 54" Pipe

  • 56" Pipe

  • 6" Pipe

  • 60" Pipe

  • 8" Pipe

  • 90" Pipe

  • Air Cooled Exchanger-Header

  • Air Cooled Exchanger-Tbs

  • Balanced Bellows PRD

  • Column-Bottom

  • Column-Middle

  • Column-Tank Bottom

  • Column-Top

  • Compressor

  • Conventional PRD

  • Filter

  • Fin/Fan Cooler

  • Heat Exchanger Tubes

  • Heat Exchanger-Bundle

  • Heat Exchanger-Chan

  • Heat Exchanger-Channel

  • Heat Exchanger-Shell

  • Heat Exchanger-Tubes

  • Pilot-Operated PRD

  • PRD with Rupture Disk

  • Pressure Vessel

  • Pump

  • Reactor

  • Rupture Disk Only

  • Storage Tank

  • Storage Tank Bottom

Component Family

FAMILY_ID

Character (50)

A value is required.

This cell may only contain one of the following values:

Value Component Family
MI_CCRBICCS Cylindrical Shell
MI_CCRBICEH Exchanger Header
MI_CCRBICET Exchanger Tube
MI_CCRBICPI Piping
MI_CCRBIPCC Pump Compressor Casing
MI_CCRBICTB Tank Bottom

Component Description

MI_RBICOMPO_COMPO_DESCR_C

 Character (255) None

Component Start Date

MI_RBICOMPO_COMP_STRT_DATE_DT

 Date A value is required. Enter the value in the following format: YYYY-MM-DD hh:mm:ss

Circuit From

MI_CCRBICPI_CIRCU_FROM_C

 Character (250) This value is applicable only if the component type is piping (i.e., the value in the Component Family cell is MI_CCRBICPI).

Circuit To

MI_CCRBICPI_CIRCU_TO_C

 Character (250) This value is applicable only if the component type is piping (i.e., the value in the Component Family cell is MI_CCRBICPI).

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.

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.

Foundation Type

MI_CCRBICTB_FOUND_TYPE_C

 Character (50)

A value is required if the value in the Component Type cell is Storage Tank Bottom.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • Clay

  • Silt

  • Sand

  • Gravel

  • Concrete

  • Double Floor

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.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • Liquid

  • Gas

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.

Process Fluid

MI_RBICOMPO_PROCE_FLUID_C

 Character (50)

A value is required.

This cell may only contain a value that exists in the list in the Process Fluid field for RBI Component records. If you enter a value that is not valid for RBI 581, the Data Loader will skip that row.

If the value in the Component Type is Storage Tank Bottom, then this cell may only contain one of the following values:

  • C6-C8
  • C9-C12
  • C13-16 (Diesel)
  • C17-25 (Gas Oil)
  • C25+ (Resid)

Toxic Mixture

MI_RBICOMPO_TOXIC_MIX_F

 Boolean

Enter True or False.

Toxic Fluid

MI_RBICOMPO_TOXIC_MODEL_C

 Character (50)

A value is required if the value in the Toxic Mixture cell is True.

This cell may only contain a value that exists in the list in the Toxic Fluid field for RBI Component records.

Percent Toxic

MI_RBICOMPO_PERCE_TOXIC_N

 Numeric A value is required if the value in the Toxic Mixture cell is True.

Inventory

MI_RBICOMPO_INVEN_N

 Numeric A value is required if component type is not Tank Bottom (i.e., the value in the Component Family cell is not MI_CCRBICTB).

Inventory Group

MI_RBICOMPO_INVEN_GROUP_C

 Character (50)

You cannot use this column to link the Component to an inventory group. You can link a component to an inventory group only by accessing the MI Admin Preferences page in GE Digital APM.

If the Component is already linked to an inventory group, you can override the value in the Inventory Group field by entering a value in this column. However, the calculated value in the Inventory Group Mass field remains as is.

Design Pressure

MI_RBICOMPO_DESIG_PRESS_N

 Numeric

A value is required if the component is linked to the following Potential Degradation Mechanisms (PDMs):

  • RBI 581 Thinning and Lining Evaluation
  • RBI 581 External Damage Evaluation

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.

Design Temperature

MI_RBICOMPO_DESIG_TEMPE_N

 Numeric

A value is required if the component is linked to a PDM that belongs to the following DMEs:

  • RBI 581 Thinning and Lining Evaluation
  • RBI 581 External Damage Evaluation

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.

Diameter

MI_RBICOMPO_DIAME_INNER_N

 Numeric A value is required.

Length

MI_RBICOMPO_LENGT_N

 Numeric

A value is required if you want to calculate inventory.
Fill Height MI_CCRBICTB_FILL_HEIGH_N Numeric

A value is required if the value in the Component Type cell is Storage Tank Bottom or Storage Tank.

Nominal Thickness

MI_RBICOMPO_NOMIN_THICK_N

 Numeric

A value is required if the component is linked to an analysis that is linked to the following damage mechanisms (DMs):

  • 581-Brittle Fracture
  • 581-Low Alloy Steel Embrittlement
  • All DMs that belong to RBI 581 Thinning and Lining Evaluation
  • All DMs that belong to RBI 581 External Damage Evaluation

Stress Lookup Table

MI_RBICOMPO_STRESS_TABLE_C

 Character (50)

A value is required if the component is linked to an analysis that is linked to the following damage mechanisms (DMs):

  • 581-Brittle Fracture
  • 581-Low Alloy Steel Embrittlement
  • All DMs that belong to RBI 581 Thinning and Lining Evaluation
  • All DMs that belong to RBI 581 External Damage Evaluation

In the baseline GE Digital APM system, this cell may only contain one of the following values:

  • Pressure Vessels
  • Tanks
  • Piping

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 RBI Component records.

BM CODE

MI_RBICOMPO_BM_CODE_C

 Character (30)

A value is required if the component is linked to an analysis that is linked to the following damage mechanisms (DMs):

  • 581-Brittle Fracture
  • 581-Low Alloy Steel Embrittlement
  • All DMs that belong to RBI 581 Thinning and Lining Evaluation
  • All DMs that belong to RBI 581 External Damage Evaluation

Refer to the (Picklist) worksheet in the excel workbook for valid values that you can enter in this cell.

BM YEAR

MI_RBICOMPO_BM_YEAR_C

 Character (50)

A value is required if the component is linked to an analysis that is linked to the following damage mechanisms (DMs):

  • 581-Brittle Fracture
  • 581-Low Alloy Steel Embrittlement
  • All DMs that belong to RBI 581 Thinning and Lining Evaluation
  • All DMs that belong to RBI 581 External Damage Evaluation

Refer to the (Picklist) worksheet in the excel workbook for valid values that you can enter in this cell.

BM SPEC

MI_RBICOMPO_BM_SPEC_C

 Character (50)

A value is required if the component is linked to an analysis that is linked to the following damage mechanisms (DMs):

  • 581-Brittle Fracture
  • 581-Low Alloy Steel Embrittlement
  • All DMs that belong to RBI 581 Thinning and Lining Evaluation
  • All DMs that belong to RBI 581 External Damage Evaluation

Refer to the (Picklist) worksheet in the excel workbook for valid values that you can enter in this cell.

BM GRADE

MI_RBICOMPO_BM_GRADE_C

 Character (50)

A value is required if the component is linked to an analysis that is linked to the following damage mechanisms (DMs):

  • 581-Brittle Fracture
  • 581-Low Alloy Steel Embrittlement
  • All DMs that belong to RBI 581 Thinning and Lining Evaluation
  • All DMs that belong to RBI 581 External Damage Evaluation

Weld Joint Effy

MI_RBICOMPO_WELD_JOINT_EFFY_N

 Numeric

A value is required if the component is linked to a PDM that belongs to the following DMEs:

  • RBI 581 Thinning and Lining Evaluation
  • RBI 581 External Damage Evaluation

In the baseline GE Digital APM, this cell may only contain one of the following values:

  • 0.35
  • 0.4
  • 0.45
  • 0.5
  • 0.55
  • 0.6
  • 0.65
  • 0.7
  • 0.75
  • 0.8
  • 0.85
  • 0.9
  • 0.95
  • 1

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 Weld Joint Efficiency field for RBI Component records.

Insulated?

MI_RBICOMPO_INSUL_F

 Boolean

Enter True or False. The value in this cell must be True if the an analysis in the component is linked to one of the following DMs:

  • 581-Ferritic Component Corrosion Under Insulation
  • 581-Austenitic Component Cracking Under Insulation
Insulation Type MI_RBICOMPO_INSUL_C Character (200)

A value is required if the value in the Insulated? cell is True.

This cell may only contain one of the following values, which exist in the list in the Insulation Type field for RBI Component records:

  • Asbestos
  • Calcium Silicate (Cl Free)
  • Calcium Silicate (Not Cl Free)
  • Foam/Cellular Glass
  • Mineral Wool/Fiber Glass
  • Pearlite
  • Unknown

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 Insulation Type field for RBI Component records.
Injection Point Data MI_CCRBICPI_INJ_PT_CIR_C Character (50) A value is required if the component type is Piping (i.e., the value in the Component Family cell is CCRBICPI).
Piping Circuit Length MI_CCRBICPI_PIP_CIR_LENG_N Numeric

A value is required if:

  • The component type is Piping (i.e., the value in the Component Family cell is MI_CCRBICPI).

    -and-

  • The value in the Use Calculate Inventory cell in the RBI_581_Consequence worksheet is True.
PWHT MI_RBICOMPO_PWHT_F Boolean Enter True or False.
Internal Corrosion Type MI_RBICOMPO_INTER_CORR_TYPE_C Character (50)

A value is required if component is linked to RBI 581 Thinning and Lining Evaluation.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • General
  • Localized
  • Pitting

The list in this field is populated by the CORROSION 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 yourGE Digital APM system, via Configuration Manager, refer to the appropriate table.
Predictable Int. Corr. Location MI_CCRBICOM_PRED_INT_COR_LOC_F Boolean Enter True or False.
Estimated Internal Corrosion Rate MI_RBICOMPO_EXP_INT_CORR_RT_N Numeric

A value is required if:

  • The component is linked to the 581 Internal Component Lining Damage DM.

    -and-

  • The value in the Selected Base Material Corrosion Rate cell in the linked DM is Estimated Rate.
Estimated External Corrosion Rate MI_RBICOMPO_EXP_EXT_CORR_RT_N Numeric

A value is required if:

  • The component is linked to a PDM that belongs to RBI 581 External Cracking Damage Evaluation or RBI 581 External Corrosion Damage Evaluation.

    -and-

  • The value in the Selected External Corrosion Rate cell for the associated DMs is Estimated.
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:

  • ASSET
  • COMPONENT
  • MANUAL

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.
Percent Liquid Volume MI_RBICOMPO_PER_LIQ_VOL_N Numeric

A value is required if you want to calculate inventory.
Detection System MI_CCRBICOM_DETECTION_SYSTEM_C Character (4)

A value is required.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Detection System
A Loss Of Pressure Or Flow
B Pressure Envelope
C Visual Detection

The list in this field is populated by the 581_Detection 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.
Isolation System MI_CCRBICOM_ISOLA_SYSTE_CHR Character (50)

A value is required.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Isolation System
A Auto Shutdown
B Leakage Shutdown (This value is valid only if the value in the Detection System cell is B or C).
C Manual Shutdown (This value is valid only if the value in the Detection System cell is C).

The list in this field is populated by the 581_Isolation 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.
Mitigation System MI_CCRBICOM_MITIGATION_SYSTM_C Character (60)

A value is required.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Mitigation System
1 Inventory blowdown
2 Fire water deluge system
3 Fire water monitors only
4 Foam spray system
5 No mitigation system

The list in this field is populated by the 581_Mitigation_System 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.
Fluid Velocity MI_CCRBICOM_FLUID_VELOCITY_N Numeric

A value is required if an analysis in the component is linked to any of the following DMs:

  • 581-Acid Sour Water Corrosion
  • 581-Hydrofluoric Acid Corrosion
  • 581-Amine Corrosion
  • 581-Cooling Water Corrosion
  • 581-High Temperature Sulfidic and Naphthenic Acid
  • 581-Sulfuric Acid Corrosion
  • 581-Alkaline Sour Water Corrosion
pH of Water MI_CCRBICOM_PH_OF_WATER_N Numeric

A value is required if an analysis in the component is linked to any of the following DMs:

  • 581-Acid Sour Water Corrosion
  • 581-Cooling Water Corrosion
  • 581-Hydrochloric Acid Corrosion

  • 581-Alkaline Carbonate Stress Corrosion Cracking

  • 581-Chloride Stress Corrosion Cracking

  • 581-HIC/SOHIC - H2S

  • 581-Sulfide Stress Cracking
Geometry Type MI_CCRBICOM_GEOMETRY_TYPE_C Character (60)

A value is required if the component is linked to any of the following PDMs:

  • RBI 581 Thinning and Lining Evaluation
  • RBI 581 External Corrosion Damage Evaluation

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Geometry Type
CYL Cylinder
SPH Spherical Head
HEM Hemispherical Head
PIPE Piping
HEAD Head
PLT PLT (only if the value in the Component Family cell is MI_CCRBICTB)

The list in this field is populated by the MI_581_Component_Geometry_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.
GFF Component Type MI_CCRBICOM_GFF_COMPO_TYPE_CHR Character (50)

A value is required.

This cell may only contain one of the following values, which exist in the list in the GFF Component Type field for RBI Component records:

Value General Fail Frequency (GFF) Component Type
COLBTM Vessel/FinFan
COLMID Vessel/FinFan
COLTOP Vessel/FinFan
COMPC Compressor
COMPR Compressor
COURSE-1-10 Tank650 (only for an AST Shell component)
DRUM Vessel/FinFan
FILTER Vessel/FinFan
FINFAN Vessel/FinFan
HEXSS Heat Exchanger
HEXTS Heat Exchanger
KODRUM Vessel/FinFan
PIPE-1 Pipe
PIPE-10 Pipe
PIPE-12 Pipe
PIPE-16 Pipe
PIPE-2 Pipe
PIPE-4 Pipe
PIPE-6 Pipe
PIPE-8 Pipe
PIPEGT16 Pipe
PUMP1S Pump
PUMP2S Pump
PUMPR Pump
REACTOR Vessel/FinFan
TANKBOTTOM Tank650 (only if the value in the Component Family cell is MI_CCRBICTB)
Cladding Present MI_CCRBICOM_CLADDING_PRESENT_L Character (50)

A value is required if an associated analysis is linked to any of the following DMs:

  • 581-HIC/SOHIC – HF

  • 581-Hydrogen Stress Cracking

  • 581-Polythionic Acid Cracking

  • All DMs that belong to RBI 581 Thinning and Lining Evaluation

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Cladding Present
Y Yes
N No

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.
Furnished Cladding Thickness MI_CCRBICOM_CHR Numeric A value is required if the value in the Cladding Present cell is Y.
Minimum Structural Thickness MI_CCRBICOM_MNMM_STRCTRL_THS_N Numeric

A value is required if the component is linked to any of the following PDMs:

  • RBI 581 Thinning and Lining Evaluation
  • RBI 581 External Corrosion Damage Evaluation
Liner Present MI_CCRBICOM_LINER_PRESE_CHR Character (50)

A value is required if the component is linked to the RBI 581 Thinning and Lining Evaluation PDM.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Liner Present
Y Yes
N No

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.

For the 581-Internal Component Lining Damage DM, the value in this cell must be Yes.
Liner Type MI_CCRBICOM_LINER_TP_C Character (50)

A value is required if the value in the Liner Present cell is Y.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Liner Type
1 Strip Lined Alloy
2 Organic Coating (typically > 0.762mm / 30 mils)
3 Thermal Resistant Service - Castable Refractory
6 Severe/Abrasive Service - Castable Refractory
8 Glass Linings
10 Fiberglass

The list in this field is populated by the MI_581_Lining_Types_And_Resistance 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.
Has Release Prevention Barrier? MI_CCRBICTB_HAS_RELEA_PREVE_F Boolean

A value is required if the value in the Component Type cell is Storage Tank Bottom.

Enter True or False. If you enter True, then after you load data, the value in the Maximum Fill Height in AST field is populated with the value 0.25 feet.
CM Corrosion Rate MI_CCRBICOM_CM_COR_RT_C Numeric

A value is required if:

  • The value in the Cladding Present cell is Y.
  • The value in the Cladding Material Corrosion Rate is Estimated.
Corrosion Allow MI_RBICOMPO_CORRO_ALLOW_N Numeric None
Is Intrusive? MI_RBICOMPO_IS_INTRU_CHR Character (50)

A value is required if an analysis in the component is linked to any of the following DMs:

  • 581-High Temperature Oxidation
  • 581-Cooling Water Corrosion
  • 581-High Temperature H2/H2S Corrosion
  • 581-Amine Corrosion
  • 581-Hydrofluoric Acid Corrosion
  • 581-Sulfuric Acid Corrosion
  • 581-Hydrochloric Acid Corrosion
  • 581-Acid Sour Water Corrosion
  • 581-High Temperature Sulfidic and Naphthenic Acid
  • 581-Alkaline Sour Water Corrosion
  • 581-Soil Side Corrosion
  • 581-Thinning Damage
  • All DMs that belong to RBI 581 Cracking Damage Evaluation
  • All DMs that belong to RBI 581 External Cracking Damage Evaluation
  • All DMs that belong to RBI 581 External Damage Evaluation
Specified Tmin MI_CCRBICOM_SPECIFIED_TMIN_N Numeric A value is required if the value in the Override Minimum Thickness cell is True.
Base Material MI_CCRBICOM_BASE_MATER_C Character (50)

A value is required if an analysis in the component is linked to any of the following DMs:

  • 581-HIC/SOHIC – HF (only if the value in the Cladding Present field is No (N))
  • 581-Hydrogen Stress Cracking (only if the value in the Cladding Present field is No (N))
  • 581-Polythionic Acid Cracking (only if the value in the Cladding Present field is No (N))
  • 581-High Temperature Hydrogen Attack
  • 581-Brittle Fracture
  • All DMs that belong to RBI 581 Thinning and Lining Evaluation

This cell may only contain one of the values that exist in the list in the Base Material field for RBI Component records.
Cladding Material MI_CCRBICOM_CLADDING_MATERIL_C Character (50)

A value is required if:

  • The value in the Cladding Present cell is Y.
  • An analysis in the component is linked to one of the following DMs:

    • 581-High Temperature Oxidation

    • 581-Cooling Water Corrosion

    • 581-High Temperature H2/H2S Corrosion

    • 581-Amine Corrosion

    • 581-Hydrofluoric Acid Corrosion

    • 581-Sulfuric Acid Corrosion

    • 581-Hydrochloric Acid Corrosion

    • 581-Acid Sour Water Corrosion

    • 581-High Temperature Sulfidic and Naphthenic Acid

    • 581-Alkaline Sour Water Corrosion

    • 581-Soil Side Corrosion

      581-Thinning Damage

This cell may only contain one of the values that exist in the list in the Cladding Material field for RBI Component records.
Total Acid Number MI_CCRBICOM_TOTAL_ACID_NUMBR_N Numeric A value is required if an analysis in the component is linked to the 581-High Temperature Sulfidic and Naphthenic Acid DM.
RBI_581_Analysis WorksheetClosed

In the RBI_581_Analysis worksheet, you will specify the analyses (which will be represented by RBI 581 Risk Analysis records) that you want to create. You cannot update an RBI 581 Risk Analysis using the data loader workbook.

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 in the Assets worksheet. Multiple analyses 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 in the Assets worksheet, if they exist. Multiple analyses 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 in 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) Values in this column must match values entered on the RBI_Component worksheet, if they exist. Multiple analyses can be linked to the same component (i.e., rows may have the same value in this column).

Component Type

MI_RBICOMPO_COMPO_TYPE_C

 Character (60)

Values in this column must match values that you entered in the Component Type column in the RBI_Component worksheet for the associated component.
Analysis Unique ID MI_ANALYSIS_ID Character (255) A value is required and must be unique. This value identifies the analysis. However, in the RBI 581 Risk Analysis records that are created by the data loader in GE Digital APM, the value in the Analysis ID field is different from the value that you enter in this cell.
Scenario ID MI_CRITANAL_TURNAROUND_ID_C Character (50) None
Coefficient Y Material MI_581RANAL_COEFFICNT_Y_MTRL_C Character (255)

A value is required if the component type is Piping (i.e., the value in the Component Family cell is MI_CCRBICPI).

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Coefficient Y Material
1 Ferritic Steels
2 Austenitic Steels
3 Other Ductile Metals
4 Cast Iron

The list in this field is populated by the MI_581_Coefficient_Materials 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.
Stress Override MI_581RANAL_STRES_OVER_F Boolean Enter True or False.
Allowable Stress MI_CRITANAL_MTL_ALLOW_STRESS_N Numeric A value is required if the value in the Stress Override cell is True.
Flow Stress MI_581RANAL_FLOW_STRESS_N Numeric A value is required if the value in the Stress Override cell is True.
Override Minimum Required Thickness MI_581RANAL_OVERR_MINIM_REQUI_THICK_FLG Boolean Enter True or False.
Course Number MI_581RANAL_COURS_NUMBE_NBR Numeric A value is required if the analysis is linked to a component of type Storage Tank (i.e., the value in the Component Type cell in the RBI_Component worksheet for the associated component is Storage Tank).
RBI_581_Consequence WorksheetClosed

In the RBI_581_Consequence worksheet, you will specify the consequences (which are or will be represented by RBI 581 Consequence Evaluation records) that you want to create or update. You can create only one RBI 581 Consequence Evaluation for an RBI 581 Risk 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 Consequence Evaluations 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 Consequence Evaluations 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 Consequence Evaluations 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) Values in this column must match values entered on the RBI_Component worksheet, if they exist. Multiple Consequence Evaluations can be linked to the same component (i.e., rows may have the same value in this column).

Component Type

MI_RBICOMPO_COMPO_TYPE_C

 Character (60)

Values in this column must match values that you entered in the Component Type column on the RBI_Component worksheet for the associated component.
Analysis Unique ID MI_ANALYSIS_ID Character (255) Values in this column must match values entered on the RBI_581_Analysis worksheet. Each analysis can have only one Consequence Evaluation.
Consequence MI_RCONEVAL_CONS_C Character (50) A value is required. The default value is RBI.
Use Calculated Inventory MI_RBI_EVN0_USE_CAL_INV_L Boolean

Enter True or False.

If the value in this cell is True, values in the following cells in the RBI_Component worksheet for the associated component are required:

  • Length
  • Diameter
  • Piping Circuit Length
Inventory Group Mass MI_RBI_EVN0_INV_GRP_MSS_N Numeric

A value is required if the value in the Component Family cell is not Storage Tank Bottom.
Include Personnel Injury MI_RBI_EVN0_INCLDPRSNNLNJRYG_L Boolean Enter True or False.
Injury Cost MI_RCONEVAL_INJUR_COST_N Numeric A value is required if the value in the Include Personnel Injury cell is True.
Equipment Cost MI_RCONEVAL_EQU_COST_N Numeric A value is required if the value in the Component Type cell is not Storage Tank Bottom.
Production Cost MI_RCONEVAL_PROD_COST_N Numeric A value is required.
Environmental Clean-up Costs MI_RBI_EVN0_ENVIR_CLEAN_COSTS_NBR Numeric A value is required if the value in the Component Type cell is not Storage Tank Bottom.
Allow Override of Total Financial Consequence MI_RBI_EVN0_ALW_OVE_OF_TT_FC_FLAG Boolean Enter True or False.
User Total Financial Consequences MI_RBI_EVN0_USERTOTAL_FC_N Numeric A value is required if the value in the Allow Override of Total Financial Consequence cell is True.
Maximum Fill Height in AST MI_RBI_EVN0_MXM_FLL_HGT_AST_N Numeric

A value is required if, on the RBI_Component worksheet:

  • The value in the Component Type cell is Storage Tank or Storage Tank Bottom.
  • The value in the Has Release Prevention Barrier cell is False.

If, however, the value in the Has Release Prevention Barrier cell is True, after you load data, the Maximum Fill Height is AST field is populated with the value 0.25 feet irrespective of the value in this cell.
Fluid Percent Leaving Dike MI_RBI_EVN0_FLD_PRCT_LVG_DKE_N Numeric A value is required if the component family is Tank Bottom (i.e., the value in the Component Family column in the RBI_Component worksheet is MI_CCRBICTB).
Fluid Percent Onsite MI_RBI_EVN0_FLUD_PRCNT_ONSTE_N Numeric A value is required if the component family is Tank Bottom (i.e., the value in the Component Family column in the RBI_Component worksheet is MI_CCRBICTB).
Fluid Percent Offsite MI_RBI_EVN0_FLD_PRCNT_OFFSTE_N Numeric A value is required if the component family is Tank Bottom (i.e., the value in the Component Family column in the RBI_Component worksheet is MI_CCRBICTB).
Environmental Sensitivity MI_RBI_EVN0_ENVRNMNTL_SNSTVY_C Character (50)

A value is required if the component family is Tank Bottom (i.e., the value in the Component Family column in the RBI_Component worksheet is MI_CCRBICTB).

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Environmental Sensitivity
L Low
M Medium
H High

The list in this field is populated by the MI_581_Environmental_Sensitivity 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.
Tank Course Height MI_RBI_EVN0_TANK_COURSE_HGHT_N Numeric A value is required if the value in the Component Type cell is Storage Tank.
Distance from Tankbottom to Groundwater MI_RBI_EVN0_DSE_FRM_TNM_GRR_N Numeric A value is required if the value in the Component Type cell is Storage Tank Bottom.
Soil Type under Tank bottom MI_RBI_EVN0_SL_TYE_UNR_T_BTM_C Character (50)

A value is required if the value in the Component Type cell is Storage Tank Bottom.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Soil Type
CL Clay
CS Coarse Sand
CA Concrete Asphalt
FS Fine Sand
GR Gravel
SC Sandy Clay
SL Slit
VF Very Fine Sand

The list in this field is populated by the MI_581_Soil_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.
DME_Lining WorksheetClosed

On the DME_Lining worksheet, you will specify the 581-Atmospheric Tank Bottom Corrosion DMs (which are or will be represented by the RBI 581 Thinning and Lining Evaluation records) that you want to create or update. You can specify these records only if the value in the Liner Present cell in the RBI_Component worksheet for the associated component is Y.

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 in the Assets worksheet. Multiple DMs 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 in the Assets worksheet, if they exist. Multiple DMs 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 in the Assets worksheet, if they exist. Multiple DMs 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) Values in this column must match values entered in the RBI_Component worksheet, if they exist. Multiple DMs can be linked to the same component (i.e., rows may have the same value in this column).

Component Type

MI_RBICOMPO_COMPO_TYPE_C

 Character (60)

Values in this column must match values that you entered in the Component Type column in the RBI_Component worksheet for the associated component.
Analysis Unique ID MI_ANALYSIS_ID Character (255) Values in this column must match values entered in the RBI_581_Analysis worksheet, if they exist. Multiple DMs can be linked to the same analysis (i.e., rows may have the same value in this column).
Damage Mechanism MI_RBDEMEEV_DAM_MECH_C Character (50) Enter 581-Internal Component Lining Damage.
Last Known Inspection Date MI_581DMCHE_LST_KNWN_INN_DTE_D Date Enter a value in the following format: YYYY-MM-DD hh:mm:ss
Online Monitoring Flag MI_581DMCHE_ONLNE_MNTRNG_FLG_C Character (50)

A value is required.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Online Monitoring Flag
Y Yes
N No

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.
Key Process Variable? MI_581DMCHE_KEY_PROCSS_VRBLE_C Character (3)

A value is required if the value in the Online Monitoring Flag column is Y.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Key Process Variable
Y Yes
N No

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.
Electrical Resistance Probes? MI_581DMCHE_ELCTRCL_RSSE_PRS_C Character (3)

A value is required if the value in the Online Monitoring Flag column is Y.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Electrical Resistance Probes
Y Yes
N No

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.
Corrosion Coupons? MI_581DMCHE_CORROSION_COUPNS_C Character (3)

A value is required if the value in the Online Monitoring Flag column is Y.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Corrosion Coupons
Y Yes
N No

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.
Liner Installation Date MI_581THNL_LIN_INST_DT_D Date

A value is required. Enter the value in the following format: YYYY-MM-DD hh:mm:ss
Liner Condition MI_581THNL_LINER_COND_C Character (50)

A value is required.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Liner Condition
A Good
B Average
C Poor

The list in this field is populated by the MI_581_Lining_Condition 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.
Immersion Grade Coating Quality MI_581THNL_IMMN_GRE_CTG_QLY_C Character (50)

A value is required if the liner type is organic coating (i.e., the value in the Liner Type column in the RBI_Component worksheet for the associated component is 2).

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Immersion Grade Coating Quality
A High
B Merdium
C Low

The list in this field is populated by the MI_581_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.
DME_AST WorksheetClosed

In the DME_Lining worksheet, you will specify the 581-Atmospheric Tank Bottom Corrosion DM (which are or will be represented by the RBI 581 Thinning and Lining Evaluation records) that you want to create or update.

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 in the Assets worksheet. Multiple DMs 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 in the Assets worksheet, if they exist. Multiple DMs 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 in 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) Values in this column must match values entered in the RBI_Component worksheet, if they exist. Multiple DMs can be linked to the same component (i.e., rows may have the same value in this column).

Component Type

MI_RBICOMPO_COMPO_TYPE_C

 Character (60)

Values in this column must match values that you entered in the Component Type column in the RBI_Component worksheet for the associated component.
Analysis Unique ID MI_ANALYSIS_ID Character (255) Values in this column must match values entered in the RBI_581_Analysis worksheet, if they exist. Multiple Consequences can be linked to the same analysis (i.e., rows may have the same value in this column).
Damage Mechanism MI_RBDEMEEV_DAM_MECH_C Character (50) Enter 581-Atmospheric Tank Bottom Corrosion.
Selected Base Material Corrosion Rate MI_581THNL_SELEC_BM_COR_R_C Character (50)

A value is required.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • Calculated Rate
  • Estimated Rate
  • Short Term Avg
  • Long Term Avg
  • Controlling Corrosion Rate

The list in this field is populated by the 581_CORR_TYPE 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_581THNL_LNG_TRM_AVG_COR_R_N Numeric

A value is required if:

  • The value in the Selected Base Material Corrosion Rate column is Long Term Avg.

    -and-

  • The value in the Source of Calculated Corrosion Rates column in the RBI_Component worksheet for the associated component is MANUAL.
Short Term Avg Corr Rate MI_581THNL_SHRT_TRM_AVG_COR_N Numeric

A value is required if:

  • The value in the Selected Base Material Corrosion Rate column is Short Term Avg.

    -and-

  • The value in the Source of Calculated Corrosion Rates column in the RBI_Component worksheet for the associated component is MANUAL.
Selected Cladding Material Corrosion Rate MI_581THNL_SELEC_CLADD_COR_R_C Character (50)

A value is required if the value in the Cladding Present column in the RBI_Component worksheet for the associated component is Y.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • Calculated Rate
  • Estimated Rate
  • Short Term Avg
  • Long Term Avg
  • Controlling Corrosion Rate

The list in this field is populated by the 581_CORR_TYPE 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.
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 System Code IDs:

  • General
  • Localized
  • Pitting

The list in this field is populated by the CORROSION 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.
Highest Effective Inspection Level MI_RBDEMEEV_HIGH_EFF_INSP_C Character (25)

A value is required.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Highest Effective Inspection Level
A Highly Effective
B Usually Effective
C Fairly Effective
D Poorly Effective
E Ineffective (None)

The list in this field is populated by the MI_581_Inspection_Effectiveness 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.
Number of Highest Effective Inspections MI_RBDEMEEV_NO_HIGH_EFF_INS_N Numeric A value is required, and must be between 0 and 6. If you enter 0 in this column, then the value in the Highest Effective Inspection Level column must be E.
Welded Construction Flag MI_581DMCHE_WLDD_CNSTRCN_FLG_C Character (50)

A value is required.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Welded Construction Flag
Y Yes
N No

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.
API 653 Maintenance Flag MI_581THNL_API_653_MNTE_FLG_L Boolean A value is required. Enter True or False.
Foundation Type MI_581DMCHE_FOUND_TYPE_CHR Character (50)

A value is required.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • Clay

  • Silt

  • Sand

  • Gravel

  • Concrete

  • Double Floor

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.
Settlement Adjustment Flag MI_581DMCHE_STTLMNT_ADJT_FLG_C Character (3)

A value is required if the value in the Foundation Type column is not Concrete.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Settlement Adjustment Flag
Y Yes
N No

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.
Settlement Adjustment Inspection MI_581DMCHE_STTLMNT_ADJT_INN_C Character (50)

A value is required if the value in the Settlement Adjustment Flag column is Y.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Settlement Adjustment Inspection
1 Meets API 653
1.5 Never Evaluated
2 Exceeds API 653

The list in this field is populated by the MI_581_Recorded_Settlement_Criteria 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.
Online Monitoring Flag MI_581DMCHE_ONLNE_MNTRNG_FLG_C Character (50)

A value is required.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Online Monitoring Flag
Y Yes
N No

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.
Key Process Variable? MI_581DMCHE_KEY_PROCSS_VRBLE_C Character (3)

A value is required if the value in the Online Monitoring Flag column is Y.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Key Process Variable
Y Yes
N No

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.
Electrical Resistance Probes? MI_581DMCHE_ELCTRCL_RSSE_PRS_C Character (3)

A value is required if the value in the Online Monitoring Flag column is Y.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Electrical Resistance Probes
Y Yes
N No

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.
Corrosion Coupons? MI_581DMCHE_CORROSION_COUPNS_C Character (3)

A value is required if the value in the Online Monitoring Flag column is Y.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Corrosion Coupons
Y Yes
N No

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.
Soil Resistivity MI_581THNL_SOIL_RESIS_C Numeric

A value is required if the value in the Selected Base Material Corrosion Rate cell is Calculated Rate.

AST Pad MI_581THNL_AST_PAD_C Character (50)

A value is required if the value in the Selected Base Material Corrosion Rate cell is Calculated Rate.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • Soil With High Salt

  • Crushed Limestone

  • Native Soil

  • Construction Grade Sand

  • Continuous Asphalt

  • Continuous Concrete

  • Oil Sand

  • High Resistivity Low Chloride Sand

The list in this field is populated by the 581_AST_PAD_MAT_TYPE 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.
AST Drainage MI_581THNL_AST_DRAINAGE_C Character (50)

A value is required if the value in the Selected Base Material Corrosion Rate cell is Calculated Rate.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • One Third Frequently Underwater
  • Storm Water Collects At AST Base
  • Storm Water Does Not Collect At AST Base

The list in this field is populated by the 581_AST_DRAINAGE_TYPE 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.
AST Steam Coil Heater MI_581THNL_AST_STEAM_CL_HTR_C Character (50)

A value is required if the value in the Selected Base Material Corrosion Rate cell is Calculated Rate.

In the baselineGE Digital APM system, this cell may only contain one of the following System Code IDs:

  • YES
  • NO

The list in this field is populated by the MI_581_AST_STEAMCOIL_WATERDRWASOFF 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.
AST Bottom Type MI_581THNL_AST_BOTTOM_TYPE_C Character (50)

A value is required if the value in the Selected Base Material Corrosion Rate cell is Calculated Rate.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • RPB Not Per API 650
  • RPB Per API 650
  • Single Bottom

The list in this field is populated by the 581_AST_BOTTOM_TYPE 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.
Cathodic Protection MI_581THNL_CATHODIC_PROTCTN_C Character (50)

A value is required if the value in the Selected Base Material Corrosion Rate cell is Calculated Rate.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Cathodic Protection
None None
Yes Not Per API 651 Yes and Not Per API 651
Yes Per API 651 Yes and Per API 651

The list in this field is populated by the 581_AST_Cathodic Protection 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.
Product Side Condition MI_581THNL_PRODCT_SDE_CNDTN_C Character (50)

A value is required if the value in the Selected Base Material Corrosion Rate cell is Calculated Rate.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • Wet
  • Dry

The list in this field is populated by the 581_Product_Side_Condition 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.
Water Product Draws MI_581THNL_WATER_PRDCT_DRWS_C Character (50)

A value is required if the value in the Selected Base Material Corrosion Rate cell is Calculated Rate.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • YES
  • NO

The list in this field is populated by the MI_581_AST_STEAMCOIL_WATERDRWASOFF 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.
DME_Thinning WorksheetClosed

In the DME_Thinning worksheet, you will specify the following DMs (which are or will be represented by the RBI 581 Thinning and Lining Evaluation records) that you want to create or update.

These DMs belong to the RBI 581 Thinning and Lining Evaluation methodology. You can specify these DMs only if the value in the Component Type cell in the RBI_Component worksheet for the associated component is not Storage Tank Bottom.

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 in the Assets worksheet. Multiple DMs 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 in the Assets worksheet, if they exist. Multiple DMs 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 in the Assets worksheet, if they exist. Multiple DMs 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) Values in this column must match values entered in the RBI_Component worksheet, if they exist. Multiple DMs can be linked to the same component (i.e., rows may have the same value in this column).

Component Type

MI_RBICOMPO_COMPO_TYPE_C

 Character (60)

Values in this column must match values that you entered in the Component Type column on the RBI_Component worksheet for the associated component.
Analysis Unique ID MI_ANALYSIS_ID Character (255) Values in this column must match values entered in the RBI_581_Analysis worksheet, if they exist. Multiple DMs can be linked to the same analysis (i.e., rows may have the same value in this column).
Damage Mechanism MI_RBDEMEEV_DAM_MECH_C Character (50)

In the baseline GE Digital APM system, this cell may only contain one of the following values, which exist in the list in the Damage Mechanism field in the Potential Degradation Mechanisms record:

  • 581-High Temperature Oxidation

  • 581-Cooling Water Corrosion

  • 581-High Temperature H2/H2S Corrosion

  • 581-Amine Corrosion

  • 581-Hydrofluoric Acid Corrosion

  • 581-Sulfuric Acid Corrosion

  • 581-Hydrochloric Acid Corrosion

  • 581-Acid Sour Water Corrosion

  • 581-High Temperature Sulfidic and Naphthenic Acid

  • 581-Alkaline Sour Water Corrosion

  • 581-Soil Side Corrosion

  • 581-Thinning Damage
Governing Thinning Damage Mechanism MI_581THNL_GOV_THIN_DMG_MECH_C Character (50)

A value is required if the value in the Damage Mechanism column is 581-Thinning Damage.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • Ammonium Bisulfide Corrosion (Alkaline Sour Water)
  • Cooling Water Corrosion
  • Dealloying
  • Decarburization
  • Erosion/Erosion-Corrosion
  • Flue Gas Dew Point Corrosion
  • Fuel Ash Corrosion
  • Galvanic Corrosion
  • Graphitic Corrosion
  • High Temperature H2/H2S
  • HCl Acid Corrosion
  • Ammonium Chloride Corrosion
  • Hydrofluoric Acid Corrosion
  • Oxidation
  • Metal Dusting
  • Microbioligically Induced Corrosion (MIC)
  • Naphthenic Acid Corrosion (NAC)
  • Nitriding
  • Phenol (Carbonic Acid) Corrosion
  • Phosphoric Acid Corrosion
  • Soil Corrosion
  • Sour Water Corrosion (Acidic)
  • Amine Corrosion
  • Sulfidation
  • Sulfuric Acid Corrosion
  • Other
  • Aqueous Organic Acid Corrosion
  • Boiler Water Condensate (BW/C) Corrosion
  • Carburization
  • Caustic Corrosion
  • Cavitation
  • CO2 Corrosion

The list in this field is populated by the MI_581_GOV_THINNING_DAMAGE 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.
Last Known Inspection Date MI_581DMCHE_LST_KNWN_INN_DTE_D Date Enter a value in the following format: YYYY-MM-DD hh:mm:ss
Last Known Thickness MI_581DMCHE_LST_KNWN_THCKNSS_N Numeric A value is required if you entered a value in the Last Known Inspection Date cell.
Selected Base Material Corrosion Rate MI_581THNL_SELEC_BM_COR_R_C Character (50)

A value is required.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • Calculated Rate
  • Estimated Rate
  • Short Term Avg
  • Long Term Avg
  • Controlling Corrosion Rate

The list in this field is populated by the 581_CORR_TYPE 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_581THNL_LNG_TRM_AVG_COR_R_N Numeric

A value is required if:

  • The value in the Selected Base Material Corrosion Rate column is Long Term Avg.

    -and-

  • The value in the Source of Calculated Corrosion Rates column in the RBI_Component worksheet for the associated component is MANUAL.
Short Term Avg Corr Rate MI_581THNL_SHRT_TRM_AVG_COR_N Numeric

A value is required if:

  • The value in the Selected Base Material Corrosion Rate column is Short Term Avg.

    -and-

  • The value in the Source of Calculated Corrosion Rates column in the RBI_Component worksheet for the associated component is MANUAL.
Selected Cladding Material Corrosion Rate MI_581THNL_SELEC_CLADD_COR_R_C Character (50)

A value is required if the value in the Cladding Present column in the RBI_Component worksheet for the associated component is Y.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • Calculated Rate
  • Estimated Rate
  • Short Term Avg
  • Long Term Avg
  • Controlling Corrosion Rate

The list in this field is populated by the 581_CORR_TYPE 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.
Number of A Level Inspections MI_581DMCHE_NMR_OF_A_LVL_INS_N Numeric A value is required.
Number of B Level Inspections MI_581DMCHE_NMR_OF_B_LVL_INS_N Numeric A value is required.
Number of C Level Inspections MI_581DMCHE_NMR_OF_C_LVL_INS_N Numeric A value is required.
Number of D Level Inspections MI_581DMCHE_NMR_OF_D_LVL_INS_N Numeric A value is required.
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 System Code IDs:

  • General
  • Localized
  • Pitting

The list in this field is populated by the CORROSION 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.
Highest Effective Inspection Level MI_RBDEMEEV_HIGH_EFF_INSP_C Character (25)

A value is required.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Highest Effective Inspection Level
A Highly Effective
B Usually Effective
C Fairly Effective
D Poorly Effective
E Ineffective (None)

The list in this field is populated by the MI_581_Inspection_Effectiveness 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.
Number of Highest Effective Inspections MI_RBDEMEEV_NO_HIGH_EFF_INS_N Numeric Enter a value between 0 and 6. If you enter 0 in this column, then the value in the Highest Effective Inspection Level column must be E.
Injection Point Flag MI_581DMCHE_INJECTIN_PNT_FLG_C Character (50)

A value is required if the component type is piping (i.e., the value in the Component Family column in the RBI_Component worksheet for the associated component is MI_CCRBICPI).

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Injection Point Flag
Y Yes
N No

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.
Injection Point Inspection MI_581DMCHE_INJCTN_PNT_INSPN_C Character (50)

A value is required if the value in the Injection Point Flag column is Y.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Injection Point Inspection
Y Yes
N No

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.
Deadleg Flag MI_581DMCHE_DEADLEG_FLAG_C Character (50)

A value is required if the component type is piping (i.e., the value in the Component Family column in the RBI_Component worksheet for the associated component is MI_CCRBICPI).

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Deadleg Flag
Y Yes
N No

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.
Deadleg Inspection MI_581DMCHE_DEADLEG_INSPECTN_C Character (50)

A value is required if the value in the Deadleg Flag column is Y.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Deadleg Inspection
Y Yes
N No

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.
Welded Construction Flag MI_581DMCHE_WLDD_CNSTRCN_FLG_C Character (50)

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Welded Construction Flag
Y Yes
N No

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.
API 653 Maintenance Flag MI_581THNL_API_653_MNTE_FLG_L Boolean Enter True or False.
Foundation Type MI_581DMCHE_FOUND_TYPE_CHR Character (50)

A value is required.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • Clay

  • Silt

  • Sand

  • Gravel

  • Concrete

  • Double Floor

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.
Settlement Adjustment Flag MI_581DMCHE_STTLMNT_ADJT_FLG_C Character (3)

A value is required if the value in the Foundation Type column is not Concrete.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Settlement Adjustment Flag
Y Yes
N No

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.
Settlement Adjustment Inspection MI_581DMCHE_STTLMNT_ADJT_INN_C Character (50)

A value is required if the value in the Settlement Adjustment Flag column is Y.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Settlement Adjustment Inspection
1 Meets API 653
1.5 Never Evaluated
2 Exceeds API 653

The list in this field is populated by the MI_581_Recorded_Settlement_Criteria 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.
Online Monitoring Flag MI_581DMCHE_ONLNE_MNTRNG_FLG_C Character (50)

A value is required.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Online Monitoring Flag
Y Yes
N No

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.
Key Process Variable? MI_581DMCHE_KEY_PROCSS_VRBLE_C Character (3)

A value is required if the value in the Online Monitoring Flag column is Y.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Key Process Variable
Y Yes
N No

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.
Electrical Resistance Probes? MI_581DMCHE_ELCTRCL_RSSE_PRS_C Character (3)

A value is required if the value in the Online Monitoring Flag column is Y.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Electrical Resistance Probes
Y Yes
N No

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.
Corrosion Coupons? MI_581DMCHE_CORROSION_COUPNS_C Character (3)

A value is required if the value in the Online Monitoring Flag column is Y.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Corrosion Coupons
Y Yes
N No

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.
Cl Concentration MI_581THNL_HCL_CONCENTRATIN_N Numeric A value is required if the value in the Damage Mechanism column is 581-Cooling Water Corrosion.
Is Air or Oxidant Present? MI_581THNL_IS_AR_OR_OXN_PRT_C Character (50)

A value is required if the Damage Mechanism column contains one of the following values:

  • 581-Hydrochloric Acid Corrosion
  • 581-High Temperature Oxidation
  • 581-Sulfuric Acid Corrosion
Soil Resistivity MI_581THNL_SOIL_RESIS_C Numeric A value is required if the value in the Damage Mechanism column is 581-Soil Side Corrosion.
H2S Content MI_581THNL_H2_CONTENT_N Numeric A value is required if the value in the Damage Mechanism column is 581-High Temperature H2/H2S Corrosion.
Hydrocarbon Type MI_581THNL_HYDROCARBON_TYPE_C Character (50)

A value is required if the value in the Damage Mechanism column is 581-High Temperature H2/H2S Corrosion.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • NAPTHA

  • GAS OIL

The list in this field is populated by the MI_581_HYDROCARBON_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.
Sulphur Concentration MI_581THNL_SULPHUR_CNCNTRTN_N Numeric A value is required if the value in the Damage Mechanism column is 581-High Temperature Sulfidic and Naphthenic Acid.
Cooling System Type MI_581THNL_COOLI_SYSTE_TYPE_C Character (50)

A value is required if the value in the Damage Mechanism column is 581-Cooling Water Corrosion.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • Once-Through

  • Recirculating

The list in this field is populated by the MI_581_Cooling_System 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.
Water Type MI_581THNL_WATER_TYPE_C Character (50)

A value is required if the value in the Cooling System Type column is Once-Through.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • Fresh Water

  • Sea Water

The list in this field is populated by the MI_581_Water_Type 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.
Water Treatment Type MI_581THNL_WATER_TREAT_TYPE_C Character (50)

A value is required if:

  • The value in the Cooling System Type column is Recirculating.

    -or-

  • The value in the Water Type column is Fresh Water.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • Treated

  • Untreated

The list in this field is populated by the MI_581_Water_Treatment_Type 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.
Recirculating System Type MI_581THNL_RECIR_SYSTE_TYPE_C Character (50)

A value is required if the value in the Cooling System Type column is Recirculating.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • Open

  • Closed

The list in this field is populated by the MI_581_Recirculating_System 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.
Calcium Hardness MI_581THNL_CALCI_HARDN_N Numeric

A value is required if:

  • The value in the Cooling System Type column is Recirculating.

    -or-

  • The value in the Water Type column is Fresh Water and the value in the Water Treatment Type column is Untreated.
Total Dissolved Solids MI_581THNL_TOTAL_DISSO_SOLID_N Numeric

A value is required if:

  • The value in the Cooling System Type column is Recirculating.

    -or-

  • The value in the Water Type column is Fresh Water and the value in the Water Treatment Type column is Untreated.
MO Alkalinity MI_581THNL_MO_ALKAL_N Numeric

A value is required if:

  • The value in the Cooling System Type column is Recirculating.

    -or-

  • The value in the Water Type column is Fresh Water and the value in the Water Treatment Type column is Untreated.
Oxygen in the Process Stream MI_581THNL_OXYGN_ADJSTT_FCR_N Numeric A value is required if the value in the Damage Mechanism column is 581-Acid Sour Water Corrosion.
Acid Concentration MI_581THNL_ACID_CONCENTRATN_N Numeric A value is required if the value in the Damage Mechanism column is 581-Sulfuric Acid Corrosion.
Soil Type MI_581THNL_SOIL_TYPE_C Character (50)

A value is required if the value in the Damage Mechanism column is 581-Soil Side Corrosion.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • Sand
  • Silt
  • Clay

The list in this field is populated by the 581_Primary_Soil_Type 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.
Cathodic Protection Effectiveness MI_581THNL_CATHO_PROTE_EFFEC_C Character (50)

A value is required if the value in the Damage Mechanism column is 581-Soil Side Corrosion.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Cathodic Protection Effectiveness
Cathodic_Protection_ exists_NONACE RP0169 Cathodic Protection exists not per NACE RP0169
No_Cathodic_Protection No Cathodic Protection
Cathodic_Protection_Tested Cathodic Protection is tested annually
No_CP_Structure No Cathodic Protection on Structure
CP_Tested_ NACE RP0169_Supported Tested Cathodic protection NACE RP0169 supported

The list in this field is populated by the MI_581_Cathodic Protection Effectiveness Factors 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.
Coating Present? MI_581DMCHE_COATING_PRESENT_C Character (3)

A value is required if the value in the Damage Mechanism column is 581-Soil Side Corrosion.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Coating Present?
Y Yes
N No

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.
Coating Age MI_581DMCHE_COATING_AGE_N Numeric

A value is required if the value in the Coating Present? column is Y.
Maximum Coating Temperature Rating Exceeded? MI_581THNL_MAXCOTEMP_EXCEE_C Character (50)

A value is required if the value in the Coating Present? column is Y.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Maximum Coating Temperature Rating Exceeded?
Y Yes
N No

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.
Coating Maintenance Rare or None? MI_581THNLCOATI_MAINT_NONE_C Character (50)

A value is required if the value in the Coating Present? column is Y.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Coating Maintenance Rare or None?
Y Yes
N No

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.
Coating Type MI_581THNL_COATINGTYPE_C Character (50)

A value is required if the value in the Coating Present? column is Y.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Coating Type
Fusn_Bnd_Epxy Fusion Bonded Epoxy
Lqd_Epxy Liquid Epoxy
Asphl_Enml Asphalt Enamel
Asphlt_Mastic Asphalt Mastic
Coat_Tar_Enml Coat Tar Enamel
Extrd_Polythln_with_mastic_rubber Extruded Polyethylene with mastic rubber
Mill_Appld_PE_Tape_with_mastic Mill Applied PE Tape with mastic
Field_Appld_PE_Tape_with_mastic Field Applied PE Tape with mastic
Three_Layer_PE_or_PP Three-Layer PE or PP

The list in this field is populated by the 581_Coating_Type 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.
Amine Type MI_581THNL_AMINE_TYPE_C Character (50)

A value is required if the value in the Damage Mechanism column is 581-Amine Corrosion.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • MEA
  • DEA
  • MDEA

The list in this field is populated by the MI_581_Amine_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.
Heat Stable Amine Salts(HSAS) MI_581THNL_HSAS_N Numeric A value is required if the value in the Damage Mechanism column is 581-Amine Corrosion.
Acid Gas Loading MI_581THNL_ACID_GAS_LOADING_N Numeric A value is required if the value in the Damage Mechanism column is 581-Amine Corrosion.
Amine Concentration MI_581THNL_AMINE_CONCENTRTN_N Numeric A value is required if the value in the Damage Mechanism column is 581-Amine Corrosion.
HF Concentration MI_581THNL_HF_CONCE_NBR Numeric A value is required if the value in the Damage Mechanism column is 581-Hydrofluoric Acid Corrosion.
H2S Partial Pressure MI_581THNL_H2S_PARTI_PRESS_NBR Numeric A value is required if the value in the Damage Mechanism column is 581-Alkaline Sour Water Corrosion.
NH4HS Concentration MI_581THNL_NH4HS_CONCE_NBR Numeric A value is required if the value in the Damage Mechanism column is 581-Alkaline Sour Water Corrosion.
DME_ExternalDamage WorksheetClosed

In the DME_ExternalDamage worksheet, you can specify the following DMs that you want to create or update:

These DMs belong to the RBI 581 External Damage Evaluation methodology. These records will be linked to an RBI 581 Risk Analysis. You can specify these DMs only if the component type is not Tank Bottom (i.e., the value in the Component Family column in the RBI_Component worksheet is not MI_CCRBICTB).

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 in the Assets worksheet. Multiple DMs 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 in the Assets worksheet, if they exist. Multiple DMs 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 in the Assets worksheet, if they exist. Multiple DMs 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) Values in this column must match values entered in the RBI_Component worksheet, if they exist. Multiple DMs can be linked to the same component (i.e., rows may have the same value in this column).

Component Type

MI_RBICOMPO_COMPO_TYPE_C

 Character (60)

Values in this column must match values that you entered in the Component Type column on the RBI_Component worksheet for the associated component.
Analysis Unique ID MI_ANALYSIS_ID Character (255) Values in this column must match values entered in the RBI_581_Analysis worksheet, if they exist. Multiple DMs can be linked to the same analysis (i.e., rows may have the same value in this column).
Damage Mechanism MI_RBDEMEEV_DAM_MECH_C Character (50)

In the baseline GE Digital APM system, this cell may only contain one of the following values, which exist in the list in the Damage Mechanism field in the Potential Degradation Mechanisms record:

  • 581-Ferritic Component Atmospheric Corrosion

  • 581-Ferritic Component Corrosion Under Insulation
Selected External Corrosion Rate MI_581_XDME_SEL_EXT_CORR_RT_C Character (50)

A value is required.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • Estimated
  • Calculated
  • Measured

The list in this field is populated by the MI_581_Corrosion_Rate 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.
Base Material Measured Rate MI_RBDEMEEV_BM_MEASU_RT_N Numeric A value is required if the value in the Selected External Corrosion Rate cell is Estimated.
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 System Code IDs:

  • General
  • Localized
  • Pitting

The list in this field is populated by the CORROSION 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.
Coating Present? MI_581DMCHE_COATING_PRESENT_C Character (3)

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Coating Present?
Y Yes
N No

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.
Coating Installation Date MI_581DMCHE_CTNG_INSTLLN_DTE_D Date A value is required if the value in the Coating Present? cell is Y. Enter the value in the following format: YYYY-MM-DD hh:mm:ss
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:

  • NONE
  • POOR
  • MEDIUM
  • HIGH

The list in this field is populated by the 581_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.
Insulation Condition MI_RBDEMEEV_INSUL_CON_C Character (50)

A value is required if the value in the Damage Mechanism cell is 581-Ferritic Component Corrosion Under Insulation.

This cell may only contain one of the following values:

  • Above Average
  • Average
  • Below Average
Piping System Complexity MI_RBDEMEEV_PIP_SYS_COMPL_C Character (50)

A value is required if the value in the Damage Mechanism cell is 581-Ferritic Component Corrosion Under Insulation.

This cell may only contain one of the following values:

  • Above Average
  • Average
  • Below Average
Corrosion Rate Adjustment for bad Design/Fabrication MI_581_XDME_ADJST_FR_DSN_FBN_C Boolean Enter True or False.
Soil to Air Interface Present? MI_581_XDME_SL_TO_AR_INE_PRT_L Boolean Enter True or False.
Atmospheric Condition MI_581_XDME_ATMOSPHERC_CNDTN_C Character (50)

A value is required if the value in the Selected External Corrosion Rate cell is Calculated.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • MARINE
  • TEMPERATE
  • DRY
  • SEVERE

The list in this field is populated by the MI_ATMOSPHERIC_CONDITION 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.
Last Known Inspection Date MI_581DMCHE_LST_KNWN_INN_DTE_D Date Enter a value in the following format: YYYY-MM-DD hh:mm:ss
Last Known Thickness MI_581DMCHE_LST_KNWN_THCKNSS_N Numeric A value is required if you entered a value in the Last Known Inspection Date cell.
Number of A Level Inspections MI_581DMCHE_NMR_OF_A_LVL_INS_N Numeric A value is required.
Number of B Level Inspections MI_581DMCHE_NMR_OF_B_LVL_INS_N Numeric A value is required.
Number of C Level Inspections MI_581DMCHE_NMR_OF_C_LVL_INS_N Numeric A value is required.
Number of D Level Inspections MI_581DMCHE_NMR_OF_D_LVL_INS_N Numeric A value is required.
DME_ExternalCracking WorksheetClosed

In the DME_ExternalCracking worksheet, you can specify the following DMs that you want to create or update:

These DMs belong to the RBI 581 External Cracking Damage Evaluation methodology. These records will be linked to an RBI 581 Risk Analysis. You can specify these DMs only if the component type is not Tank Bottom (i.e., the value in the Component Family column in the RBI_Component worksheet is not MI_CCRBICTB).

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 in the Assets worksheet. Multiple DMs 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 in the Assets worksheet, if they exist. Multiple DMs 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 in the Assets worksheet, if they exist. Multiple DMs 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) Values in this column must match values entered in the RBI_Component worksheet, if they exist. Multiple DMs can be linked to the same component (i.e., rows may have the same value in this column).

Component Type

MI_RBICOMPO_COMPO_TYPE_C

 Character (60)

Values in this column must match values that you entered in the Component Type column on the RBI_Component worksheet for the associated component.
Analysis Unique ID MI_ANALYSIS_ID Character (255) Values in this column must match values entered in the RBI_581_Analysis worksheet, if they exist. Multiple DMs can be linked to the same analysis (i.e., rows may have the same value in this column).
Damage Mechanism MI_RBDEMEEV_DAM_MECH_C Character (50)

In the baseline GE Digital APM system, this cell may only contain one of the following values, which exist in the list in the Damage Mechanism field in the Potential Degradation Mechanism record:

  • 581-Ferritic Component Atmospheric Corrosion

  • 581-Ferritic Component Corrosion Under Insulation
Number of Highest Effective Inspections MI_RBDEMEEV_NO_HIGH_EFF_INS_N Numeric A value is required, and must be between 0 and 6. If you enter 0 in this column, then the value in the Highest Effective Inspection Level column must be E.
Highest Effective Inspection Level MI_RBDEMEEV_HIGH_EFF_INSP_C Character (25)

A value is required.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Highest Effective Inspection Level
A Highly Effective
B Usually Effective
C Fairly Effective
D Poorly Effective
E Ineffective (None)

The list in this field is populated by the MI_581_Inspection_Effectiveness 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.
Last Known Inspection Date MI_581DMCHE_LST_KNWN_INN_DTE_D Date Enter a value in the following format: YYYY-MM-DD hh:mm:ss
Susceptibility Type MI_581DMCHE_SUSCEPTBLTY_TYPE_C Character (50)

A value is required.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • Estimated
  • Detected
  • Calculated

The list in this field is populated by the MI_581_Cracking_Susceptibility_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.
Atmospheric Condition MI_581_XCDME_ATMOS_CONDI_C Character (50)

A value is required if the value in the Susceptibility Type cell is Calculated.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • MARINE
  • TEMPERATE
  • DRY
  • SEVERE

The list in this field is populated by the MI_ATMOSPHERIC_CONDITION 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 APMM system, via Configuration Manager, refer to the appropriate table.
Susceptibility MI_581DMCHE_SUSCEPTIBILITY_C Character (50)

A value is required if the value in the Susceptibility Type cell is Estimated.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • High
  • Medium
  • Low
  • None

The list in this field is populated by the MI_581_Cracking_Susceptibility 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.
Coating Present? MI_581DMCHE_COATING_PRESENT_C Character (3)

A value is required.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Coating Present?
Y Yes
N No

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.
Coating Installation Date MI_581DMCHE_CTNG_INSTLLN_DTE_D Date A value is required if the value in the Coating Present? cell is Y. Enter the value in the following format: YYYY-MM-DD hh:mm:ss
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:

  • NONE
  • POOR
  • MEDIUM
  • HIGH

The list in this field is populated by the 581_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.
Piping System Complexity MI_RBDEMEEV_PIP_SYS_COMPL_C Character (50)

A value is required if the value in the Damage Mechanism cell is 581-Austenitic Component Cracking Under Insulation.

This cell may only contain one of the following values:

  • Above Average
  • Average
  • Below Average
Insulation Condition MI_RBDEMEEV_INSUL_CON_C Character (50)

A value is required if the value in the Damage Mechanism cell is 581-Austenitic Component Cracking Under Insulation.

This cell may only contain one of the following values:

  • Above Average
  • Average
  • Below Average
Chloride Free Insulation MI_581_XCDME_CHL_FREE_INSUL_C Character (50)

A value is required if the value in the Damage Mechanism cell is 581-Austenitic Component Cracking Under Insulation.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Coating Present?
Y Yes
N No

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.
DME_Cracking WorksheetClosed

In the DME_Cracking worksheet, you can specify the following DMs that you want to create or update:

These DMs belong to the RBI 581 Cracking Damage Evaluation methodology. These records will be linked to an RBI 581 Risk 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 in the Assets worksheet. Multiple DMs 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 in the Assets worksheet, if they exist. Multiple DMs 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 in the Assets worksheet, if they exist. Multiple DMs 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) Values in this column must match values entered in the RBI_Component worksheet, if they exist. Multiple DMs can be linked to the same component (i.e., rows may have the same value in this column).

Component Type

MI_RBICOMPO_COMPO_TYPE_C

 Character (60)

Values in this column must match values that you entered in the Component Type column on the RBI_Component worksheet for the associated component.
Analysis Unique ID MI_ANALYSIS_ID Character (255) Values in this column must match values entered in the RBI_581_Analysis worksheet, if they exist. Multiple DMs can be linked to the same analysis (i.e., rows may have the same value in this column).
Damage Mechanism MI_RBDEMEEV_DAM_MECH_C Character (50)

In the baseline GE Digital APM system, this cell may only contain one of the following values, which exist in the list in the Damage Mechanism field in the Potential Degradation Mechanism record:

  • 581-Amine Cracking
  • 581-Alkaline Carbonate Stress Corrosion Cracking
  • 581-HIC/SOHIC - HF
  • 581-HIC/SOHIC - H2S
  • 581-Caustic Cracking
  • 581-Hydrogen Stress Cracking
  • 581-Other Cracking
  • 581-Sulfide Stress Cracking
  • 581-Chloride Stress Corrosion Cracking
  • 581-Polythionic Acid Cracking
Number of Highest Effective Inspections MI_RBDEMEEV_NO_HIGH_EFF_INS_N Numeric A value is required, and must be between 0 and 6. If you enter 0 in this column, then the value in the Highest Effective Inspection Level column must be E.
Highest Effective Inspection Level MI_RBDEMEEV_HIGH_EFF_INSP_C Character (25)

A value is required.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Highest Effective Inspection Level
A Highly Effective
B Usually Effective
C Fairly Effective
D Poorly Effective
E Ineffective (None)

The list in this field is populated by the MI_581_Inspection_Effectiveness 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.
Last Known Inspection Date MI_581DMCHE_LST_KNWN_INN_DTE_D Date Enter a value in the following format: YYYY-MM-DD hh:mm:ss
Susceptibility Type MI_581DMCHE_SUSCEPTBLTY_TYPE_C Character (50)

A value is required.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • Estimated
  • Detected
  • Calculated

The list in this field is populated by the MI_581_Cracking_Susceptibility_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.
Susceptibility MI_581DMCHE_SUSCEPTIBILITY_C Character (50)

A value is required only if the value in the Susceptibility Type cell is Estimated. If the value in the Susceptibility Type cell is Calculated or Detected, then GE Digital APM will not consider the value that you enter in this cell.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • High
  • Medium
  • Low
  • None

The list in this field is populated by the MI_581_Cracking_Susceptibility 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.
Severity Index Adjustment Factor MI_581DMCHE_SVRY_INX_ADT_FCR_N Numeric

A value is required if the value in the Damage Mechanism cell is 581-Other Cracking.

In the baseline GE Digital APM system, this cell may only contain one of the following values:

  • 1
  • 0.2
  • 0.02

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 Severity Index Adjustment Factor field for RBI 581 Cracking Damage Evaluation records.
Online Monitoring Flag MI_581DMCHE_ONLNE_MNTRNG_FLG_C Character (50)

A value is required if the value in the Damage Mechanism cell is 581-HIC/SOHIC - H2S.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Online Monitoring Flag
Y Yes
N No

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.
Key Process Variable? MI_581DMCHE_KEY_PROCSS_VRBLE_C Character (3)

A value is required if the value in the Online Monitoring Flag cell is Y.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Key Process Variable
Y Yes
N No

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.
Hydrogen Probes MI_581DMCHE_HYDROGEN_PROBES_C Character (3)

A value is required if the value in the Online Monitoring Flag cell is Y.

 
Steam Out? MI_581CRKEV_STEAM_OUT_C Character (50)

A value is required if:

  • The value in the Damage Mechanism cell is 581-Amine Cracking or 581-Caustic Cracking.

    -and-

  • The value in the Susceptibility Type cell is Calculated.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Steam Out?
Y Yes
N No

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.
Sulfur Content of Steel MI_581CRKEV_SLFR_CNTT_OF_STL_C Character (50)

A value is required if:

  • The value in the Damage Mechanism cell is 581-HIC/SOHIC - H2S.

    -and-

  • The value in the Susceptibility Type cell is Calculated.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • High Sulfur Steel (>0.01% S)
  • Low Sulfur Steel (<=0.01% S)

The list in this field is populated by the MI_581_Sulfur_Content_Of_Steel 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.
Maximum Brinnell Hardness MI_581CRKEV_MAX_BRIN_HARD_N Numeric

A value is required if:

  • The value in the Damage Mechanism cell is 581-Hydrogen Stress Cracking or 581-Sulfide Stress Cracking.

    -and-

  • The value in the Susceptibility Type cell is Calculated.
Heat Traced? MI_581CRKEV_HEAT_TRACED_C Character (50)

A value is required if:

  • The value in the Damage Mechanism cell is 581-Amine Cracking or 581-Caustic Cracking.

    -and-

  • The value in the Susceptibility Type cell is Calculated.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Heat Traced?
Y Yes
N No

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.
H2S Water Content MI_581DMCHE_H2S_WTR_CONT_N Numeric

A value is required if:

  • The value in the Damage Mechanism cell is 581-HIC/SOHIC - H2S.

    -and-

  • The value in the Susceptibility Type cell is Calculated.
Product Form MI_581CRKEV_PRODUCT_FORM_C Character (50)

A value is required if:

  • The value in the Damage Mechanism cell is 581-HIC/SOHIC - H2S.

    -and-

  • The value in the Susceptibility Type cell is Calculated.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • Seamless/Extruded Pipe
  • Rolled Plate

The list in this field is populated by the MI_581_Product_Form 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.
HF Present? MI_581CRKEV_HF_PRESENT_C Character (50)

A value is required if:

  • The value in the Damage Mechanism cell is 581-HIC/SOHIC - HF or 581-Hydrogen Stress Cracking.

    -and-

  • The value in the Susceptibility Type cell is Calculated.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID HF Present?
Y Yes
N No

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.
Amine Solution Type MI_581CRKEV_AMINE_SOLTN_TYPE_C Character (50)

A value is required if:

  • The value in the Damage Mechanism cell is 581-Amine Cracking.

    -and-

  • The value in the Susceptibility Type cell is Calculated.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • Fresh
  • Lean
  • Rich

The list in this field is populated by the MI_581_Amine_Solution_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.
Amine Type MI_581CRKEV_AMINE_TYPE_C Character (50)

A value is required if:

  • The value in the Damage Mechanism cell is 581-Amine Cracking.

    -and-

  • The value in the Susceptibility Type cell is Calculated.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • MEA
  • DIPA
  • DEA
  • Other Amine

The list in this field is populated by the MI_581_Amine_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 yourGE Digital APM system, via Configuration Manager, refer to the appropriate table.
Cyanides MI_RBDEMEEV_CYANI_F Boolean

Enter True or False.

Caustic Type MI_581CRKEV_CAUST_TYPE_C Character (50)

A value is required if:

  • The value in the Damage Mechanism cell is 581-Caustic Cracking.

    -and-

  • The value in the Susceptibility Type cell is Calculated.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • Area A
  • Area B
  • Area C

The list in this field is populated by the MI_581_Caustic_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.
NaOH Caustic Concentration MI_581CRKEV_NH_CSTC_CNCNTRTN_N Numeric

A value is required if:

  • The value in the Damage Mechanism cell is 581-Caustic Cracking.

    -and-

  • The value in the Susceptibility Type cell is Calculated.
CO3 Concentration in Water MI_581CRKEV_CO3_CONC_IN_WTR_N Numeric

A value is required if:

  • The value in the Damage Mechanism cell is 581-Alkaline Carbonate Stress Corrosion Cracking.

    -and-

  • The value in the Susceptibility Type cell is Calculated.
Chloride Concentration Water Process MI_581CRKEV_CH_CNC_OF_PR_WTR_C Numeric

A value is required if:

  • The value in the Damage Mechanism cell is 581-Chloride Stress Corrosion Cracking.

    -and-

  • The value in the Susceptibility Type cell is Calculated.
Exposure to Oxygen During Operation/Downtime MI_581CRKEV_EXE_TO_OXN_D_OPE_C Character (50)

A value is required if:

  • The value in the Damage Mechanism cell is 581-Polythionic Acid Cracking.

    -and-

  • The value in the Susceptibility Type cell is Calculated.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Exposure to Oxygen During Operation/Downtime
Y Yes
N No

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.
Exposure to Sulfur During Operation/Downtime MI_581CRKEV_EXE_TO_SLR_D_OPE_C Character (50)

A value is required if:

  • The value in the Damage Mechanism cell is 581-Polythionic Acid Cracking.

    -and-

  • The value in the Susceptibility Type cell is Calculated.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Exposure to Sulfur During Operation/Downtime
Y Yes
N No

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.
Exposure to Water During Operation/Shutdown MI_581CRKEV_EXE_TO_WTR_D_OPN_C Character (50)

A value is required if:

  • The value in the Damage Mechanism cell is 581-Polythionic Acid Cracking.

    -and-

  • The value in the Susceptibility Type cell is Calculated.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Exposure to Water During Operation/Shutdown
Y Yes
N No

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.
Downtime Protection Used MI_581CRKEV_DWNTME_PRTCN_USD_C Character (50)

A value is required if:

  • The value in the Damage Mechanism cell is 581-Polythionic Acid Cracking.

    -and-

  • The value in the Susceptibility Type cell is Calculated.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Downtime Protection Used
Y Yes
N No

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.
Thermal History (Heat Treatment History) MI_581CRKEV_THL_HSY_HT_T_HSY_C Character (50)

A value is required if:

  • The value in the Damage Mechanism cell is 581-Polythionic Acid Cracking.

    -and-

  • The value in the Susceptibility Type cell is Calculated.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • Solution Annealed
  • Stabilized Before Welding
  • Stabilized After Welding

The list in this field is populated by the MI_581_Heat_Treatment_History 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.
DME_HTHA WorksheetClosed

In the DME_HTHA worksheet, you can specify the 581-High Temperature Hydrogen Attack DM that you want to create or update. This DM, however, is not applicable for a component of type Storage Tank Bottom.

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 in the Assets worksheet. Multiple DMs 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 in the Assets worksheet, if they exist. Multiple DMs 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 in the Assets worksheet, if they exist. Multiple DMs 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)

Values in this column must match values entered in the RBI_Component worksheet, if they exist. Multiple DMs can be linked to the same component (i.e., rows may have the same value in this column).

Component Type

MI_RBICOMPO_COMPO_TYPE_C

 Character (60)

Values in this column must match values that you entered in the Component Type column on the RBI_Component worksheet for the associated component.
Analysis Unique ID MI_ANALYSIS_ID Character (255) Values in this column must match values entered in the RBI_581_Analysis worksheet, if they exist. Multiple DMs can be linked to the same analysis (i.e., rows may have the same value in this column).
Damage Mechanism MI_RBDEMEEV_DAM_MECH_C Character (50)

Enter 581-High Temperature Hydrogen Attack.
Is HTHA Damage Observed MI_581_HTHA_IS_DAMAG_OBS_C Character (50)

A value is required.

In the baselineGE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Is HTHA Observed
Y Yes
N No

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.
Is Component Replaced MI_581_HTHA_IS_COMPO_REPLA_C Character (50)

A value is required if the value in the Is HTHA Damage Observed cell is Y.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Is Component Replaced
Y Yes
N No

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.
Exposure Hydrogen Partial Pressure MI_581_HTHA_HYDRO_PAR_PRESS_N Numeric

A value is required if the value in the Is HTHA Damage Observed cell is N.
Delta Temperature MI_581_HTHA_DELTA_TEMPE_C Character (50)

A value is required if the value in the Is HTHA Damage Observed cell is N.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

  • >=0
  • >= -50 and < 0
  • >= -100 and < -50
  • < -100

The list in this field is populated by the MI_581_HTHA_Delta_Temperature 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.
DME_BrittleFracture WorksheetClosed

In the DME_BrittleFracture worksheet, you can specify the following DMs that you want to create or update:

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 in the Assets worksheet. Multiple DMs 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 in the Assets worksheet, if they exist. Multiple DMs 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 in the Assets worksheet, if they exist. Multiple DMs 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) Values in this column must match values entered in the RBI_Component worksheet, if they exist. Multiple DMs can be linked to the same component (i.e., rows may have the same value in this column).

Component Type

MI_RBICOMPO_COMPO_TYPE_C

 Character (60)

Values in this column must match values that you entered in the Component Type column on the RBI_Component worksheet for the associated component.
Analysis Unique ID MI_ANALYSIS_ID Character (255) Values in this column must match values entered in the RBI_581_Analysis worksheet, if they exist. Multiple DMs can be linked to the same analysis (i.e., rows may have the same value in this column).
Damage Mechanism MI_RBDEMEEV_DAM_MECH_C Character (50)

In the baseline GE Digital APM system, this cell may only contain one of the following values, which exist in the list in the Damage Mechanism field in the Potential Degradation Mechanism record:

  • 581-Sigma Phase Embrittlement
  • 581-885F Embrittlement
  • 581-Brittle Fracture
  • 581-Low Alloy Steel Embrittlement
Material Exemption Curve MI_581BRFRAC_MTRL_EXMPTNCRVE_N Character (50)

A value is required if the value in the Damage Mechanism cell is 581-Brittle Fracture or 581-Low Alloy Steel Embrittlement.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Material Exemption Curve
A Temperature Exemption A Curve
B Temperature Exemption B Curve
C Temperature Exemption C Curve
D Temperature Exemption D Curve

The list in this field is populated by the MI_581_Material_Temperature_Exemption_Curves 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.
Minimum Allowable Temperature MI_581BRFRAC_MNMM_ALLWBLETME_N Numeric

A value is required if the Damage Mechanism cell contains one of the following values:

  • 581-Sigma Phase Embrittlement
  • 581-885F Embrittlement
  • 581-Low Alloy Steel Embrittlement
Minimum Design Metal Temperature (MDMT) MI_581BRFRAC_MNM_DSN_MTL_MDT_N Numeric

A value is required if the Damage Mechanism cell contains one of the following values:

  • 581-885F Embrittlement
  • 581-Low Alloy Steel Embrittlement
Critical Exposure Temperature(CET) MI_581BRFRAC_CRTCLEXPSRE_TMT_N Numeric

A value is required if the value in the Damage Mechanism cell is 581-Brittle Fracture.
Is CET at the MAWP >= -29°C MI_581BRIFRAC_IS_CT_PVPCRT_L Boolean Enter True or False.
Is Cyclic service Design Requirement MI_581BRIFRAC_IS_CYC_SREFRQT_L Boolean Enter True or False.
Is Equipment Or Circuit Subject to EVN Cracking MI_581BRIFRAC_IS_EQT_CRCRG_L Boolean Enter True or False.
Is Equipment Or Circuit Subject to Shock Chilling MI_581BRIFRAC_IS_EQT_CR_SCHG_L Boolean Enter True or False.
Is Fabricated From P-1 and P-3 Steels MI_581BRIFRAC_IS_FBD_FRMP65F_L Boolean Enter True or False.
Is Nominal Operating Conditions Changed MI_581BRIFRAC_IS_NML_OPGCCHD_L Boolean Enter True or False.
Is Nominal Uncorroded Thickness < 50.8 mm (2 inch) MI_581BRIFRAC_NML_UNDTHS_INH_L Boolean Enter True or False.
Is Satisfied All Requirements For Fabrication MI_581BRIFRAC_IS_STD_ALLRFRN_L Boolean Enter True or False.
Fracture Appearance Transition Temperature(FATT) MI_581BRFRAC_FRCEAPE_TRN_TME_N Numeric A value is required if the value in the Damage Mechanism cell is 581-Low Alloy Steel Embrittlement.
Sigma Percentage MI_581BRIFRAC_SIGMA_AMOUNT_N Numeric

A value is required if the value in the Damage Mechanism cell is 581-Sigma Phase Embrittlement.

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs:

System Code ID Sigma Percentage
1 1
2 2
3 3
4 4
5 5
6 6
7 7
8 8
9 9
10 >=10

The list in this field is populated by the MI_581_Sigma_Percentage 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.
Related Information

Copyright © 2018 General Electric Company. All rights reserved.