Open topic with navigation

About the Thickness Monitoring (TM) Data Loaders Workbook Layout and Use

The data loader workbooks contain one worksheet for each node that is represented in the data model. The following table provides a list of the worksheets that are included in the data loader workbooks.

Worksheet

Description
Assets

This worksheet is used to specify existing Equipment records to which Thickness Measurement Locations (TMLs) and TML Groups will be linked. This worksheet is included only in the Thickness Monitoring (TM) Equipment Data Loader.
Functional_Location This worksheet is used to specify existing Functional Location records to which Thickness Measurement Locations (TMLs) and TML Groups will be linked. This worksheet is included only in the Thickness Monitoring (TM) Functional Location Data Loader.
Asset_CAS This worksheet is used to specify Corrosion Analysis Settings records for an Equipment. This worksheet is included only in the Thickness Monitoring (TM) Equipment Data Loader.
Functional_Location_CAS This worksheet is used to specify Corrosion Analysis Settings records for a Functional Location. This worksheet is included only in the Thickness Monitoring (TM) Functional Location Data Loader.

TML _Group

This worksheet is used to create or update TML Group records.
TML_Group_CAS This worksheet is used to specify Corrosion Analysis Settings records for a TML Group.

TML

This worksheet is used to create or update Thickness Measurement Location records.

TML_CAS This worksheet is used to specify Corrosion Analysis Settings records for a TML.

MEASUREMENTS

This worksheet is used to specify Thickness Measurement records.
(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.

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 Thickness Monitoring (TM) Data Loaders have the following limitations:

Assets WorksheetClosed

On the Assets worksheet, you will specify Equipment to which you want to link Thickness Measurement Locations (TMLs) and TML Groups. This worksheet is included only in the Thickness Monitoring (TM) Equipment Data Loader. The columns that appear on this worksheet also appear on every subsequent worksheet in the Thickness Monitoring (TM) Equipment Data Loader. They are used to identify the records that will be linked, directly or indirectly, to the Equipment. 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 a piece of equipment, and the Equipment record 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.
Functional_Location WorksheetClosed

On the Functional_Location worksheet, you will specify Functional Locations to which you want to link Thickness Measurement Locations (TMLs) and TML Groups. This worksheet is included only in the Thickness Monitoring (TM) Functional Location Data Loader. The columns that appear on this worksheet also appear on every subsequent worksheet in the Thickness Monitoring (TM) Functional Location Data Loader. They are used to identify the records that will be linked, directly or indirectly, to the Functional Locations. The combination of values in the two columns on this worksheet must be unique.

Field Caption

Field ID

Data Type (Length)

Comments

Functional Location ID

MI_FNCLOC00_FNC_LOC_C

Character (255)

This column requires at least one cell to have a value.

CMMS System

MI_FNCLOC00_SAP_SYSTEM_C

Character (255)

If the Functional Location record for an asset has a value in the CMMS System field, enter that value in this column.
Asset_CAS WorksheetClosed

On the Asset_CAS worksheet, you will specify Corrosion Analysis Settings records for an Equipment. If you do not enter values on this worksheet, the default values are used. This worksheet is included only in the Thickness Monitoring (TM) Equipment Data Loader.

In addition, the values that you enter on this worksheet are used to specify Corrosion Analysis Settings for associated TML Groups and TMLs. You can, however, overwrite these values by specifying different values on the TML_Group_CAS and TML_CAS worksheets respectively.

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.
Inspection Type MI_CA_SET_ANALY_TYPE_CHR Character (50)

If you do not enter a value in this cell, then data in this row is not loaded.

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

System Code ID Inspection Type
UT

Ultrasonic Thickness
RT Radiographic Thickness
TML Thickness Measurement Location

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

Controlling Corrosion Rate MI_CA_SET_CR_ROLL_OPT_CHR Character (50)

This cell may only contain one of the following values:

  • Average
  • Formula
  • Maximum

The default value is Maximum.
Comments MI_CA_SET_COM_CON_COR_RAT_CHR Character (2500) None
Apply CCR to TML Rem Life Next Insp Date Calc MI_CA_SET_APPLY_CR_FLG Boolean Enter True or False. The default value is False.
Safety Factor MI_CA_SET_AVG_CR_SFTY_FCTR_NBR Numeric The default value is 1.
Minimum Number of TMLs MI_CA_SET_AVG_CR_MN_TML_NBR Numeric The default value is 1.
Percentile MI_CA_SET_AVG_CR_PERC_NBR Numeric

The default value is 100.

Std Deviation Factor MI_CA_SET_STD_DEV_FCTR_NBR Numeric The default value is 2.
Remaining Life Critical Number of TMLs MI_CA_SET_RM_LIF_CRIT_TMLS_NBR Numeric The default value is 1. Enter a value between 0 and 1.
Corrosion Rate Options - Least Squares MI_CA_SET_CR_OPT_LS_FLG Boolean Enter True or False. The default value is False.
Corrosion Rate Options - Short Term MI_CA_SET_CR_OPT_ST_FLG Boolean Enter True or False. The default value is True.
Corrosion Rate Options - Long Term MI_CA_SET_CR_OPT_LT_FLG Boolean Enter True or False. The default value is True.
Corrosion Rate Options - Custom A MI_CA_SET_CR_OPT_A_F Boolean Enter True or False. The default value is False.
Corrosion Rate Options - Custom B MI_CA_SET_CR_OPT_B_F Boolean Enter True or False. The default value is False.
Default Inspection Interval (Months) MI_CA_SET_INSP_INTRVL_NBR Numeric The default value is 0.
Inspection Interval Options - Factor Remaining Life MI_CA_SET_INSP_INT_OPT_FRL_FLG Boolean Enter True or False. The default value is True.
Inspection Interval Options - Inspection Interval MI_CA_SET_INSP_INT_OPT_II_FLG Boolean Enter True or False. The default value is True.
Default T-Min (Inches) MI_CA_SET_REF_TMIN_NBR Numeric The default value is 0.
Minimum Corrosion Rate (Mils/year) MI_CA_SET_MN_CR_NBR Numeric The default value is 5.
Use Minimum Corrosion Rate MI_CA_SET_USE_MN_CR_FLG Boolean Enter True or False. The default value is False.
Remaining Life Factor MI_CA_SET_REM_LIFE_FCTR_NBR Numeric The default value is 0.5. Enter a number between 0 and 1.
Allowable Measurement Variance (inches) MI_CA_SET_ALLOW_VARIA_NBR Numeric The default value is 0.
Corrosion Rate Variance MI_CA_SET_CRV_N Numeric The default value is 0.
Functional_Location_CAS WorksheetClosed

On the Functional_Location_CAS worksheet, you will specify Corrosion Analysis Settings records for a Functional Location. If you do not enter values on this worksheet, the default values are used. This worksheet is included only in the Thickness Monitoring (TM) Functional Location Data Loader.

In addition, the values that you enter on this worksheet are used to specify Corrosion Analysis Settings for associated TML Groups and TMLs. You can, however, overwrite these values by specifying different values on the TML_Group_CAS and TML_CAS worksheets respectively.

Field Caption

Field ID

Data Type (Length)

Comments

Functional Location ID

MI_FNCLOC00_FNC_LOC_C

Character (255)

This column requires at least one cell to have a value.

CMMS System

MI_FNCLOC00_SAP_SYSTEM_C

Character (255)

If the Functional Location record for an asset has a value in the CMMS System field, enter that value in this column.
Inspection Type MI_CA_SET_ANALY_TYPE_CHR Character (50)

If you do not enter a value in this cell, then data in this row is not loaded.

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

System Code ID Inspection Type
UT

Ultrasonic Thickness
RT Radiographic Thickness
TML Thickness Measurement Location

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

Controlling Corrosion Rate MI_CA_SET_CR_ROLL_OPT_CHR Character (50)

This cell may only contain one of the following values:

  • Average
  • Formula
  • Maximum

The default value is Maximum.
Comments MI_CA_SET_COM_CON_COR_RAT_CHR Character (2500) None
Apply CCR to TML Rem Life Next Insp Date Calc MI_CA_SET_APPLY_CR_FLG Boolean Enter True or False. The default value is False.
Safety Factor MI_CA_SET_AVG_CR_SFTY_FCTR_NBR Numeric The default value is 1.
Minimum Number of TMLs MI_CA_SET_AVG_CR_MN_TML_NBR Numeric The default value is 1.
Percentile MI_CA_SET_AVG_CR_PERC_NBR Numeric

The default value is 100.

Std Deviation Factor MI_CA_SET_STD_DEV_FCTR_NBR Numeric The default value is 2.
Remaining Life Critical Number of TMLs MI_CA_SET_RM_LIF_CRIT_TMLS_NBR Numeric The default value is 1.
Corrosion Rate Options - Least Squares MI_CA_SET_CR_OPT_LS_FLG Boolean Enter True or False. The default value is False.
Corrosion Rate Options - Short Term MI_CA_SET_CR_OPT_ST_FLG Boolean Enter True or False. The default value is True.
Corrosion Rate Options - Long Term MI_CA_SET_CR_OPT_LT_FLG Boolean Enter True or False. The default value is True.
Corrosion Rate Options - Custom A MI_CA_SET_CR_OPT_A_F Boolean Enter True or False. The default value is False.
Corrosion Rate Options - Custom B MI_CA_SET_CR_OPT_B_F Boolean Enter True or False. The default value is False.
Default Inspection Interval (Months) MI_CA_SET_INSP_INTRVL_NBR Numeric The default value is 0.
Inspection Interval Options - Factor Remaining Life MI_CA_SET_INSP_INT_OPT_FRL_FLG Boolean Enter True or False. The default value is True.
Inspection Interval Options - Inspection Interval MI_CA_SET_INSP_INT_OPT_II_FLG Boolean Enter True or False. The default value is True.
Default T-Min (Inches) MI_CA_SET_REF_TMIN_NBR Numeric The default value is 0.
Minimum Corrosion Rate (Mils/year) MI_CA_SET_MN_CR_NBR Numeric The default value is 5.
Use Minimum Corrosion Rate MI_CA_SET_USE_MN_CR_FLG Boolean Enter True or False. The default value is False.
Remaining Life Factor MI_CA_SET_REM_LIFE_FCTR_NBR Numeric The default value is 0.5. Enter a number between 0 and 1.
Allowable Measurement Variance (inches) MI_CA_SET_ALLOW_VARIA_NBR Numeric The default value is 0.
Corrosion Rate Variance MI_CA_SET_CRV_N Numeric The default value is 0.
TML_Group WorksheetClosed

On the TML_Group worksheet, you will specify the TML groups (which are or will be represented by TML Group 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)

This column requires at least one cell to have a value. This column appears only in the Thickness Monitoring (TM) Equipment Data Loader.

Functional Location ID

MI_FNCLOC00_FNC_LOC_C

Character (255)

This column requires at least one cell to have a value. This column appears only in the Thickness Monitoring (TM) Functional Location Data Loader.

CMMS System

MI_EQUIP000_SAP_SYSTEM_C

Character (255)

If the Equipment or the Functional Location 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)

This column appears only in the Thickness Monitoring (TM) Equipment Data Loader. 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.

TML Group ID

MI_TMLGROUP_ID_C

Character (50)

A value is required and must be unique among all the TML Groups linked to an Asset.

Note: Although the TML Group ID field is disabled and populated automatically in GE Digital APM, you can override the value using the data loader workbook.
Description MI_TMLGROUP_DESCR_C Character (255) None
Corrosion Group MI_TMLGROUP_CORRO_GROUP_C Character (255) None
Comments MI_TMLGROUP_COMME_T Character (2500) None
TML_Group_CASClosed

On the TML_Group_CAS worksheet, you will specify Corrosion Analysis Settings records for a TML Group. If you do not enter values on this worksheet, the values on the Asset_CAS or Functional_Location_CAS worksheet for the associated asset are used. Otherwise, the values that you enter on the TML_Group_CAS are used for the TML Group.

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. This column appears only in the Thickness Monitoring (TM) Equipment Data Loader.

Functional Location ID

MI_FNCLOC00_FNC_LOC_C

Character (255)

This column requires at least one cell to have a value. This column appears only in the Thickness Monitoring (TM) Functional Location Data Loader.

CMMS System

MI_EQUIP000_SAP_SYSTEM_C

Character (255)

If the Equipment or the Functional Location 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)

This column appears only in the Thickness Monitoring (TM) Equipment Data Loader. 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.
Inspection Type MI_CA_SET_ANALY_TYPE_CHR Character (50) If you do not enter a value in this cell, then data in this row is not loaded. This cell may only contain a value that you entered in the Inspection Type cell for the associated asset on the Asset_CAS or Functional_Location_CAS worksheet.

TML Group ID

MI_TMLGROUP_ID_C

Character (50)

A value is required and must match one of the value in the corresponding cell on the TML Group worksheet.
Controlling Corrosion Rate MI_CA_SET_CR_ROLL_OPT_CHR Character (50)

This cell may only contain one of the following values:

  • Average
  • Formula
  • Maximum

Comments

MI_CA_SET_COM_CON_COR_RAT_CHR

Character (2000)

 None
Apply CCR to TML Rem Life Next Insp Date Calc MI_CA_SET_APPLY_CR_FLG Boolean

Enter True or False.

If you do not enter a value in this cell, the value in the corresponding cell on the Asset_CAS or the Functional_Location_CAS worksheet is used.
Safety Factor MI_CA_SET_AVG_CR_SFTY_FCTR_NBR Numeric

If you do not enter a value in this cell, the value in the corresponding cell on the Asset_CAS or the Functional_Location_CAS worksheet is used.
Minimum Number of TMLs MI_CA_SET_AVG_CR_MN_TML_NBR Numeric

If you do not enter a value in this cell, the value in the corresponding cell on the Asset_CAS or the Functional_Location_CAS worksheet is used.
Percentile MI_CA_SET_AVG_CR_PERC_NBR Numeric

If you do not enter a value in this cell, the value in the corresponding cell on the Asset_CAS or the Functional_Location_CAS worksheet is used.
Std Deviation Factor MI_CA_SET_STD_DEV_FCTR_NBR Numeric

If you do not enter a value in this cell, the value in the corresponding cell on the Asset_CAS or the Functional_Location_CAS worksheet is used.
Remaining Life Critical Number of TMLs MI_CA_SET_RM_LIF_CRIT_TMLS_NBR Numeric

If you do not enter a value in this cell, the value in the corresponding cell on the Asset_CAS or the Functional_Location_CAS worksheet is used.
Corrosion Rate Options - Least Squares MI_CA_SET_CR_OPT_LS_FLG Boolean

Enter True or False.

If you do not enter a value in this cell, the value in the corresponding cell on the Asset_CAS or the Functional_Location_CAS worksheet is used.
Corrosion Rate Options - Short Term MI_CA_SET_CR_OPT_ST_FLG Boolean

Enter True or False.

If you do not enter a value in this cell, the value in the corresponding cell on the Asset_CAS or the Functional_Location_CAS worksheet is used.
Corrosion Rate Options - Long Term MI_CA_SET_CR_OPT_LT_FLG Boolean

Enter True or False.

If you do not enter a value in this cell, the value in the corresponding cell on the Asset_CAS or the Functional_Location_CAS worksheet is used.
Corrosion Rate Options - Custom A MI_CA_SET_CR_OPT_A_F Boolean

Enter True or False.

If you do not enter a value in this cell, the value in the corresponding cell on the Asset_CAS or the Functional_Location_CAS worksheet is used.
Corrosion Rate Options - Custom B MI_CA_SET_CR_OPT_B_F Boolean

Enter True or False.

If you do not enter a value in this cell, the value in the corresponding cell on the Asset_CAS or the Functional_Location_CAS worksheet is used.
Default Inspection Interval (Months) MI_CA_SET_INSP_INTRVL_NBR Numeric

If you do not enter a value in this cell, the value in the corresponding cell on the Asset_CAS or the Functional_Location_CAS worksheet is used.
Inspection Interval Options - Factor Remaining Life MI_CA_SET_INSP_INT_OPT_FRL_FLG Boolean

Enter True or False.

If you do not enter a value in this cell, the value in the corresponding cell on the Asset_CAS or the Functional_Location_CAS worksheet is used.
Inspection Interval Options - Inspection Interval MI_CA_SET_INSP_INT_OPT_II_FLG Boolean

Enter True or False.

If you do not enter a value in this cell, the value in the corresponding cell on the Asset_CAS or the Functional_Location_CAS worksheet is used.
Default T-Min (Inches) MI_CA_SET_REF_TMIN_NBR Numeric

If you do not enter a value in this cell, the value in the corresponding cell on the Asset_CAS or the Functional_Location_CAS worksheet is used.
Minimum Corrosion Rate (Mils/year) MI_CA_SET_MN_CR_NBR Numeric

If you do not enter a value in this cell, the value in the corresponding cell on the Asset_CAS or the Functional_Location_CAS worksheet is used.
Use Minimum Corrosion Rate MI_CA_SET_USE_MN_CR_FLG Boolean

Enter True or False.

If you do not enter a value in this cell, the value in the corresponding cell on the Asset_CAS or the Functional_Location_CAS worksheet is used.
Remaining Life Factor MI_CA_SET_REM_LIFE_FCTR_NBR Numeric

Enter a number between 0 and 1.

If you do not enter a value in this cell, the value in the corresponding cell on the Asset_CAS or the Functional_Location_CAS worksheet is used.
Allowable Measurement Variance (inches) MI_CA_SET_ALLOW_VARIA_NBR Numeric

If you do not enter a value in this cell, the value in the corresponding cell on the Asset_CAS or the Functional_Location_CAS worksheet is used.
Corrosion Rate Variance MI_CA_SET_CRV_N Numeric

If you do not enter a value in this cell, the value in the corresponding cell on the Asset_CAS or the Functional_Location_CAS worksheet is used.
TML WorksheetClosed

On the TML worksheet, you will specify the TMLs (that are or will be represented by Thickness Measurement Location records) that you want to create. For some of the cells, if you do not enter a value on this worksheet, after you load data, the corresponding fields are populated automatically in GE Digital APM.

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. This column appears only in the Thickness Monitoring (TM) Equipment Data Loader.

Functional Location ID

MI_FNCLOC00_FNC_LOC_C

Character (255)

This column requires at least one cell to have a value. This column appears only in the Thickness Monitoring (TM) Functional Location Data Loader.

CMMS System

MI_EQUIP000_SAP_SYSTEM_C

Character (255)

If the Equipment or the Functional Location 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)

This column appears only in the Thickness Monitoring (TM) Equipment Data Loader. 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.
TML Group ID MI_TMLGROUP_ID_C

Character (50)

 If you do not enter a value in this cell, the TML is directly linked to the Asset.

TML ID

MI_DP_ID_CHR

Character (50)

A value is required, and must be unique among all the TMLs linked to a TML Group or an Asset.

TML Analysis Type

MI_TML_TYPE_CHR

Character (50)

A value is required. This cell may only contain one of the values that you entered in the Inspection Type cell in the Asset_CAS, Functional_Location_CAS, or TML_Group_CAS worksheet, whichever is linked to the TML.

Component Type

MI_TML_COMP_TYPE_CHR

Character (10)

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

  • Piping
  • Pressure Vessel
  • Tank
Location MI_DP_LOCTN_CHR Character (50) None
ISO Drawing Number MI_DP_ISO_DRAW_CHR Character (50) None

Access

MI_DP_ACCESS_CHR

Character (50)

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

  • LADDER
  • MANLIFT
  • SCAFFOLD

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

Inspection Sequence Number

MI_DP_INSP_SEQ_NBR

Numeric

 None

Insulated Flag

MI_TML_INSLTED_FLG

Boolean

Enter True or False. The default value is False.
TML Comment MI_DP_COMMNT_CHR Character (255) None

Minimum Thickness

MI_TML_MIN_THICK_NBR

Numeric

 If you do not enter a value in this cell, the value in the Default T-Min (Inches) cell on the TML_CAS worksheet is used.

Additional Thickness

MI_THICK_MEASU_LOCAT_ADDIT_THI

Numeric

 None
Excluded From Analysis MI_DP_EXCL_FROM_ANALYSIS_FLG Logical Enter True or False. The default value is False.

Number of Readings

MI_TML_READ_NUM_N

Numeric

 Enter a number between 1 and 26. The default value is 1.

Design Code

MI_TML_DSGN_CODE_CHR

Character (50)

In the baseline GE Digital APM system, this cell may only contain one of the following System Code IDs based on the value in the Component Type cell:

Component Type Design Code
Piping

B31.1

B31.3
Pressure Vessel ASME VIII DIV 1
Tank API 653

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

Code Year (T-Min Formula)

MI_TML_CODE_YEAR_C

Character (4)

A value is required if the value in the Design Code cell is not N/A. This cell may only contains one of the following values:

  • N/A
  • 1995

Code Year (Allowable Stress Lookup)

MI_TML_CODE_YEAR_STRESS_C

Character (4)

A value is required if the value in the Design Code cell is not N/A. The following table provides the valid values that you can enter in this cell based on the value in the Design Code cell.

Design Code Code Year (Allowable Stress Lookup)
API 653 2008
ASME VIII DIV 1

1998

2010
B31.1

2014
B31.3

2014

Material Specification

MI_TML_MAT_SPEC_CHR

Character

A value is required if the value in the Override Allowable Stress cell is False, and if you want GE Digital APM to calculate T-min values. Refer to the (Picklist) worksheet in the data loader workbook for valid values that you can enter in this cell based on the values in the Design Code and Code Year (Allowable Stress Lookup) cells.

Material Grade

MI_TML_MAT_GRADE_CHR

Character (50)

A value is required if the value in the Override Allowable Stress cell is False, and if you want GE Digital APM to calculate T-min values. Refer to the (Picklist) worksheet in the data loader workbook for valid values that you can enter in this cell based on the values in the Design Code, Code Year (Allowable Stress Lookup), and Material Specification cells.

Material Type

MI_TML_MATER_TYPE_CHR

Character

 None

Design Pressure

MI_TML_DSGN_PRESS_NBR

Numeric

 A value is required if you want GE Digital APM to calculate T-min values.

Design Temperature

MI_TML_DSGN_TEMP_NBR

Numeric

 A value is required if you want GE Digital APM to calculate T-min values.

Nominal Thickness

MI_TML_NOM_THICK_NBR

Numeric

 None
Override Allowable Stress MI_TML_OVRD_ALLOW_STRES_F Boolean

Enter True or False.

Allowable Stress

MI_TML_ALLOWABLE_STRESS_N

Numeric

A value is required if the value in the Override Allowable Stress cell is True, and you want GE Digital APM to calculate T-min values.

Outside Diameter

MI_TML_OUTSD_DIAM_NBR

Numeric

A value is required if all of the following conditions are satisfied:

  • The value in the Vessel Type cell is CON_HEAD (Conical Head), ELLIP_HEAD (Ellipsoidal Head), PIPENOZZ (Pipe nozzle),TORCC_HEAD (Toriconical Head), or TORCK_HEAD (Toriconical Head, Knuckle Portion).
  • The value in the PV Formula cell is Outside.
  • You want GE Digital APM to calculate T-min values.

Inside Diameter

MI_TML_INSD_DIAM_NBR

Numeric

A value is required if all of the following conditions are satisfied:

  • The value in the Vessel Type cell is CON_HEAD (Conical Head), ELLIP_HEAD (Ellipsoidal Head), TORCC_HEAD (Toriconical Head), or TORCK_HEAD (Toriconical Head, Knuckle Portion).
  • The value in the PV Formula cell is Inside.
  • You want GE Digital APM to calculate T-min values.

Joint Factor

MI_TML_JOINT_EFF_NBR

Numeric

A value is required if all of the following conditions are satisfied:

  • The value in the Design Code cell is API 653.
  • The value in the Tank Type cell is RIVSHELL (Rivited Shell) or WELDSHELL (Welded Shell).
  • You want GE Digital APM to calculate T-min values.

The default value is 1.

Corrosion Allowance

MI_TML_CORR_ALLOW_NBR

Numeric

 None

Piping Nominal Diameter - NPS

MI_TML_NOM_DIAM_NBR

Numeric

Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this cell.

The values in the Piping Nominal Diameter - NPS and Piping Nominal Diameter - DN cells are mapped using the Piping Properties reference table. Therefore, if you enter a value in one of these cells, the other field is populated with the mapped value after you load data.

If you enter a value that is not mapped to the value in the Piping Nominal Diameter - DN cell, then the value in this cell is ignored, and the corresponding field is populated with the value mapped to the value in the Piping Nominal Diameter - DN cell. For example, if the value in the Piping Nominal Diameter - DN cell is 6, then the value in this cell must be 0.125. If you enter a different value in this cell or leave it blank, then the value 0.125 is used to populate the corresponding field in GE Digital APM.

Piping Nominal Diameter - DN

MI_TML_PIPING_NOM_DIAM_DN_N

Numeric

Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this cell.

The values in the Piping Nominal Diameter - NPS and Piping Nominal Diameter - DN cells are mapped using the Piping Properties reference table. Therefore, if you enter a value in one of these cells, the other field is populated with the mapped value after you load data.

Schedule

MI_TML_SCHED_CHR

Character (50)

 A value is required if you have entered a value in the Piping Nominal Diameter - NPS cell. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this cell based on the value in the Piping Nominal Diameter - NPS cell.

Piping Formula

MI_TML_PIPING_FORMULA_C

Character (4)

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

Design Code Piping Formula
No value

A

B

C

D
B31.3

A

B

C

D
Any value other than B31.3 N/A

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

Mechanical Allowance

MI_TML_MECH_ALLOWANCE_N

Numeric

 The default value is 0.

Design Factor

MI_TML_DESIGN_FACTOR_N

Numeric

A value is required if all of the following conditions are satisfied:

  • The value in the Component Type cell is Piping.
  • The value in the Design Code cell is B31.8.
  • You want GE Digital APM to calculate T-min values.

The default value is 1.

Temperature Factor

MI_TML_TEMP_FACTOR_N

Numeric

 A value is required if the value in the Component Type cell is Piping, and if you want GE Digital APM to calculate T-min values. The default value is 1.

Tank Type

MI_TML_TANK_TYPE_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 Tank Type
ANNRING Annular Ring
FLRPLATE Floor Plate
RIVSHELL Rivited Shell
ROOFPLATE Roof Plate
WELDSHELL Welded Shell

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

Shell Type

MI_TML_SHELL_TYPE_C

Character (50)

 None

API Method

MI_TML_API_METHOD_C

Character (50)

 None

Plate Thickness

MI_TML_PLATE_THICKNESS_N

Numeric

A value is required if all of the following conditions are satisfied:

  • The value in the Design Code cell is API 653.
  • The value in the Tank Type cell is ANNRING (Annular Ring).
  • You want GE Digital APM to calculate T-min values.

Minimum Yield Strength

MI_TML_MIN_YIELD_STR_N

Numeric

A value is required if all of the following conditions are satisfied:

  • The value in the Design Code cell is API 653.
  • The value in the Tank Type cell is WELDSHELL (Welded Shell).
  • You want GE Digital APM to calculate T-min values.

Minimum Tensile Strength

MI_TML_MIN_TENSILE_STR_N

Numeric

A value is required if all of the following conditions are satisfied:

  • The value in the Design Code cell is API 653.
  • The value in the Tank Type cell is WELDSHELL (Welded Shell).
  • You want GE Digital APM to calculate T-min values.

Course Height

MI_TML_COURSE_HEIGHT_N

Numeric

 None

Course Number

MI_TML_COURSE_NUMBER_N

Numeric

A value is required if all of the following conditions are satisfied:

  • The value in the Design Code cell is API 653.
  • The value in the Tank Type cell is WELDSHELL (Welded Shell).
  • You want GE Digital APM to calculate T-min values.

Fill Height

MI_TML_FILL_HEIGHT_N

Numeric

 None

Specific Gravity

MI_TML_SPECIFIC_GRAVITY_N

Numeric

A value is required if all of the following conditions are satisfied:

  • The value in the Design Code cell is API 653.
  • The value in the Tank Type cell is ANNRING (Annular Ring), RIVSHELL (Rivited Shell), or WELDSHELL (Welded Shell).
  • You want GE Digital APM to calculate T-min values.

Floor Plate has Detection?

MI_TML_FLR_PLATE_DETECTION_L

Boolean

Enter True or False. The default value is False.

Floor Plate has Reinforced Lining?

MI_TML_FLR_PLATE_REINFORCED_LINING_L

Boolean

Enter True or False. The default value is False.

Maximum Operating Fill Height

MI_TML_MAX_OP_FILL_HEIGHT_N

Numeric

A value is required if all of the following conditions are satisfied:

  • The value in the Design Code cell is API 653.
  • The value in the Tank Type cell is ANNRING (Annular Ring), RIVSHELL (Rivited Shell), or WELDSHELL (Welded Shell).
  • You want GE Digital APM to calculate T-min values.

Distance From the Bottom

MI_TML_DIST_FROM_BOTT_NBR

Numeric

 None

Tank Diameter

MI_TML_TANK_DIAMETER_N

Numeric

A value is required if all of the following conditions are satisfied:

  • The value in the Design Code cell is API 653.
  • The value in the Tank Type cell is ANNRING (Annular Ring), RIVSHELL (Rivited Shell), or WELDSHELL (Welded Shell).
  • You want GE Digital APM to calculate T-min values.

Vessel Type

MI_TML_VESSEL_TYPE_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 Tank Type
CON_HEAD Conical Head
CYL_SHELL Cylindrical Shell
ELLIP_HEAD Ellipsoidal Head
HEM_HEAD Hemispherical Head
PIPENOZZ Pipe Nozzle
SPH_SHELL Spherical Shell
TORCC_HEAD Toriconical Head
TORCK_HEAD Toriconical Head, Knuckle Portion
TORSP_HEAD Torispherical Head

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

PV Formula

MI_TML_PV_FORMULA_C

Character (10)

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

  • Inside
  • Outside

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

Dish Radius

MI_TML_DISH_RADIUS_N

Numeric

A value is required if:

  • The value in the Vessel Type cell is TORSP_HEAD (Torispherical Head).

    -and-

  • You want GE Digital APM to calculate T-min values.

Knuckle Radius

MI_TML_KNUCKLE_RADIUS_N

Numeric

A value is required if:

  • The value in the Vessel Type cell is TORCK_HEAD (Toriconical Head, Knuckle Portion) or TORSP_HEAD (Torispherical Head).

    -and-

  • You want GE Digital APM to calculate T-min values.

apex_angle

MI_TML_APEX_ANGLE_N

Numeric

A value is required if:

  • The value in the Vessel Type cell is CON_HEAD (Conical Head), TORCC_HEAD Toriconical Head), or TORCK_HEAD (Toriconical Head, Knuckle Portion).

    -and-

  • You want GE Digital APM to calculate T-min values.

Inside Radius

MI_TML_INSIDE_RADIUS_N

Numeric

A value is required if all of the following conditions are satisfied:

  • The value in the Vessel Type cell is CYL_SHELL (Cylindrical Shell), HEM_HEAD Hemispherical Head), or SPH_SHELL (Spherical Shell).
  • The value in the PV Formula cell is Inside.
  • You want GE Digital APM to calculate T-min values.

Outside Radius

MI_TML_OUTSIDE_RADIUS_N

Numeric

A value is required if all of the following conditions are satisfied:

  • The value in the Vessel Type cell is CYL_SHELL (Cylindrical Shell), HEM_HEAD Hemispherical Head), or SPH_SHELL (Spherical Shell).
  • The value in the PV Formula cell is Outside.
  • You want GE Digital APM to calculate T-min values.

Head Diameter

MI_TML_HEAD_DIAMETER_N

Numeric

 None
TML_CAS WorksheetClosed

On the TML_CAS worksheet, you will specify Corrosion Analysis Settings records for a TML.

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. This column appears only in the Thickness Monitoring (TM) Equipment Data Loader.

Functional Location ID

MI_FNCLOC00_FNC_LOC_C

Character (255)

This column requires at least one cell to have a value. This column appears only in the Thickness Monitoring (TM) Functional Location Data Loader.

CMMS System

MI_EQUIP000_SAP_SYSTEM_C

Character (255)

If the Equipment or the Functional Location 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)

This column appears only in the Thickness Monitoring (TM) Equipment Data Loader. 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.
Inspection Type MI_CA_SET_ANALY_TYPE_CHR Character (50) If you do not enter a value in this cell, then data in this row is not loaded. If the TML is linked to a TML Group, then this cell may only contain a value that you have entered in the Inspection Type cell for the associated TML Group on the TML_Group_CAS worksheet. Otherwise, this cell may only contain a value that you have entered in the Inspection Type cell for the associated asset on the Asset_CAS worksheet.
TML Group ID MI_TMLGROUP_ID_C

Character (50)

 A value is required if the TML is linked to a TML Group. The value should match the value in the TML Group ID cell for the corresponding TML on the TML worksheet. If you do not enter a value in this cell, the TML is directly linked to the Asset.

TML ID

MI_DP_ID_CHR

Character (50)

A value is required and must be unique.
Std Deviation Factor MI_CA_SET_STD_DEV_FCTR_NBR Numeric

If you do not enter a value in this cell, and if the TML is linked to a TML Group, then the value in the corresponding cell on the TML_Group_CAS worksheet is used. Otherwise, the value in the corresponding cell on the Asset_CAS or the Functional_Location_CAS worksheet is used.
Default Inspection Interval (Months) MI_CA_SET_INSP_INTRVL_NBR Numeric

If you do not enter a value in this cell, and if the TML is linked to a TML Group, then the value in the corresponding cell on the TML_Group_CAS worksheet is used. Otherwise, the value in the corresponding cell on the Asset_CAS or the Functional_Location_CAS worksheet is used.
Minimum Corrosion Rate (Mils/year) MI_CA_SET_MN_CR_NBR Numeric

If you do not enter a value in this cell, and if the TML is linked to a TML Group, then the value in the corresponding cell on the TML_Group_CAS worksheet is used. Otherwise, the value in the corresponding cell on the Asset_CAS or the Functional_Location_CAS worksheet is used.
Allowable Measurement Variance (inches) MI_CA_SET_ALLOW_VARIA_NBR Numeric

If you do not enter a value in this cell, and if the TML is linked to a TML Group, then the value in the corresponding cell on the TML_Group_CAS worksheet is used. Otherwise, the value in the corresponding cell on the Asset_CAS or the Functional_Location_CAS worksheet is used.
Corrosion Rate Variance MI_CA_SET_CRV_N Numeric

If you do not enter a value in this cell, and if the TML is linked to a TML Group, then the value in the corresponding cell on the TML_Group_CAS worksheet is used. Otherwise, the value in the corresponding cell on the Asset_CAS or the Functional_Location_CAS worksheet is used.
Measurements WorksheetClosed

On the Measurements worksheet, you will specify the TMs (that are or will be represented by Thickness Measurement 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)

This column requires at least one cell to have a value. This column appears only in the Thickness Monitoring (TM) Equipment Data Loader.

Functional Location ID

MI_FNCLOC00_FNC_LOC_C

Character (255)

This column requires at least one cell to have a value. This column appears only in the Thickness Monitoring (TM) Functional Location Data Loader.

CMMS System

MI_EQUIP000_SAP_SYSTEM_C

Character (255)

If the Equipment or the Functional Location 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)

This column appears only in the Thickness Monitoring (TM) Equipment Data Loader. 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.
TML Group ID MI_TMLGROUP_ID_C Character (50)

A value is required if the corresponding TML is linked to a TML Group. The value that you enter must match the value in the TML Group ID cell for the corresponding TML on the TML worksheet.

TML ID

MI_DP_ID_CHR

Character (50)

A value is required and should match the value in the TML ID cell for the corresponding TML on the TML worksheet. Otherwise, data in this row is not loaded.

Readings

MI_THICK_MEASU_READI_C

Character (2000)

A value is required. Enter a number greater than 0. If you have multiple readings, separate them with semicolons.

If you do not enter a value in this cell, the data in this row is not loaded.

Measurement Date

MI_DP_MEAS_TAKEN_DT

Date

Enter a value in the following format: YYYY-MM-DD hh:mm:ss

If you do not enter a value, the current date is used.

Measurement Taken By MI_DP_MEAS_TAKEN_BY_CHR Character

Enter a value in the following format: <Last Name>, <First Name> ~ <User ID>

When you want to create a Thickness Monitoring record using the data loader workbook, and if your user ID appears in the Measurement Taken By field on a Thickness Measurement datasheet, then you need not enter a value in this cell. The appropriate value is automatically populated in the Measurement Taken By field after you load data. If not, enter a value that matches the user ID of a Security User in GE Digital APM. Otherwise, the data in this row is not loaded.

If, however, you do not want the Measurement Taken by field to be populated automatically, using the data loader workbook, update the Thickness Monitoring record by leaving the Measurement Taken By cell blank.

Measurement Comment

MI_DP_MEAS_COMMENT_CHR

Character (255)

 None

Temperature

MI_THICK_MEAS_TEMP_TAKEN_AT_N

Numeric

 None
Related Information

Copyright © 2018 General Electric Company. All rights reserved.