About the Inspection Management (IM) Data Loaders Workbook Layout and Use

To import data using the Inspection Management (IM) Data Loaders, GE Digital APM provides the following Excel workbooks:

Inspection Management (IM) Assets.xlsx (for Inspections related to Equipment records)
Inspection Management (IM) Functional Location.xlsx (for Inspections related to Functional Location records)

You must use these workbooks to load the data. You can modify the Excel workbooks to include custom fields used by your organization. Generally, your organization will use one of the two workbooks, but not both.

Note: The Excel workbooks are referred to throughout this documentation as the data loader workbooks.

The following table provides a list of worksheets that are included in the data loader workbooks. Unless otherwise specified, the worksheets appear in both the workbooks.

Worksheet	Description
Assets	This worksheet is used to specify existing Equipment records to which Inspections and related records will be linked. This worksheet appears only in the Inspection Management (IM) Assets Data Loader workbook.
Functional_Location	This worksheet is used to specify existing Functional Location records to which Inspections and related records will be linked. This worksheet appears only in the Inspection Management (IM) Functional Location Data Loader workbook.
Inspection_Profile	This worksheet is used to specify Inspection Profile records that you want to create or update.
Inspection_Method	This worksheet is used to specify Inspection Method records that you want to create or update.
Inspection_Task	This worksheet is used to specify Inspection Task records that you want to create or update.
Inspections	This worksheet is used to specify the following records: Bundle Inspection Full Inspection General Inspection Pressure Test Inspection All types of Checklists
Inspection_Confidence_Eval	This worksheet is used to specify Inspection Confidence Evaluation records that you want to create or update.
Bundle_Sub_Inspection	This worksheet is used to specify Bundle Sub-Inspection records that you want to create or update.
Press_Test_Sub_Inspection	This worksheet is used to specify Pressure Test Sub-Inspection records that you want to create or update.
General_Finding	This worksheet is used to specify General Finding records that you want to create or update.
Custom_Sub_Inspection	If you have created a custom sub inspection family, this worksheet is used to specify the custom sub inspection records that you want to create or update.
Inspection_Recommendation	This worksheet is used to specify Inspection Recommendation records that you want to create or update.
Reference_Document	This worksheet is used to specify Reference Document records that you want to create or update.
(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 Inspection Management (IM) Data Loaders 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 Saving Records	Indicates columns that contain values that are required to save the record.
	Recommended Fields	Indicates columns that, according to GE Digital Best Practice for Inspection Management, should contain values.
	Custom Fields	Indicates columns in which you can specify custom fields.

Limitations

The Inspection Management (IM) Data Loaders have the following limitations:

The values that you enter in the data loader workbooks are case-sensitive.
When you use the data loader to update Inspection Management families:
- If a cell contains data, the value in the corresponding field will be updated in the database.
- If a cell is blank, the value in the corresponding field will not be updated with a blank value in the database. The value that previously existed in the field is retained.

Tip: If you do not want to update a field value, you can remove the corresponding column from the data loader workbooks. You cannot, however, remove columns that correspond to required fields.

Assets Worksheet

On the Assets worksheet, you can specify assets to which you want to link Inspections and related records. 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. This worksheet only appears in the Inspection Management (IM) Assets Data Loader workbook.

Note: Each row in this worksheet represents a unique asset. You should not include the same asset more than once.

Field Caption	Field ID	Data Type (Length)	Comments
Equipment ID	MI_EQUIP000_EQUIP_ID_C	Character (255)	A value is required in at least one cell.
CMMS System	MI_EQUIP000_SAP_SYSTEM_C	Character (255)	If the Equipment record for an asset has a value in the CMMS System field, you must enter that value in this column.
Equipment Technical Number	MI_EQUIP000_EQUIP_TECH_NBR_C	Character (255)	If the CMMS System column contains a value, and the Equipment record for the asset has a value in the Equipment Technical Number field, you must enter that value in this column. If the CMMS System column does not contain a value, this column can be blank, even if the Equipment record contains a value for the Equipment Technical Number field.

Field Caption

Field ID

Data Type (Length)

Comments

Equipment ID

MI_EQUIP000_EQUIP_ID_C

Character (255)

A value is required in at least one cell.

CMMS System

MI_EQUIP000_SAP_SYSTEM_C

Character (255)

If the Equipment record for an asset has a value in the CMMS System field, you must enter that value in this column.

Equipment Technical Number

MI_EQUIP000_EQUIP_TECH_NBR_C

Character (255)

If the CMMS System column contains a value, and the Equipment record for the asset has a value in the Equipment Technical Number field, you must enter that value in this column.

If the CMMS System column does not contain a value, this column can be blank, even if the Equipment record contains a value for the Equipment Technical Number field.

Functional_Location Worksheet

On the Functional_Location worksheet, you can specify Functional Location records to which you want to link Inspections and related records. 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 Functional Locations. This worksheet appears only in the Inspection Management (IM) Functional Location Data Loader workbook.

Note: Each row in this worksheet represents a unique Functional Location. You should not include the same Functional Location more than once.

Field Caption	Field ID	Data Type (Length)	Comments
Functional Location ID	MI_FNCLOC00_FNC_LOC_C	Character (255)	A value is required in at least one cell.
CMMS System	MI_FNCLOC00_SAP_SYSTEM_C	Character (255)	If the CMMS System field in the Functional Location record contains a value, you must enter that value in this column.

Inspection_Profile Worksheet

On the Inspection_Profile worksheet, you can specify Inspection Profile records that you want to create or update.

Note: Each row represents a unique record, though multiple records may be related to the same asset.

Field Caption	Field ID	Data Type (Length)	Comments
Equipment ID	MI_EQUIP000_EQUIP_ID_C	Character (255)	Values in this column must match the values entered on the Assets worksheet. You can link multiple records to the same asset.
Functional Location ID	MI_FNCLOC00_FNC_LOC_C	Character (255)	Values in this column must match the values entered on the Functional_Location worksheet. You can link multiple records to the same Functional Location.
CMMS System	MI_EQUIP000_SAP_SYSTEM_C MI_FNCLOC00_SAP_SYSTEM_C	Character (255)	Values in this column must match the values entered on the Assets or Functional_Location worksheet, if they exist. You can link multiple records to the same asset or Functional Location.
Equipment Technical Number	MI_EQUIP000_EQUIP_TECH_NBR_C	Character (255)	Values in this column must match the values entered on the Assets worksheet, if they exist. You can link multiple records to the same asset.
Item Category	MI_PROFINSP_ITEM_CAT_C	Character (50)	A value is required. The combination of values in the Item Category and Item ID columns must be unique per asset. This column must only contain System Code IDs from the MI_INSPECTION_PROFILE_CATEGORY System Code Table. Refer to the (Picklist) worksheet for a list of values that you can enter in this column.
Item ID	MI_PROFINSP_ITEM_ID_C	Character (255)	A value is required. The combination of values in the Item Category and Item ID columns must be unique per asset.
Item Description	MI_PROFINSP_ITEM_DESC_C	Text	None
RBI Component	MI_PROFINSP_COMPONENT_C	Character (250)	This column must only contain the Entity ID of an existing Criticality RBI Component record that is linked to the same asset or Functional Location as the Inspection Profile.
RBI Component Family	MI_PROFINSP_COMP_FAM_C	Character (100)	This column must only contain the Family name of the Criticality RBI Component specified in the RBI Component column (e.g., Criticality RBI Component - Piping). This column appears only in the Inspection Management (IM) Assets Data Loader workbook.
Sequence	MI_PROFINSP_SEQUENCE_N	Numeric	None

Inspection_Method Worksheet

On the Inspection_Method worksheet, you can specify Inspection Method records that you want to create or update.

Note: Each row represents a unique record, though multiple records may be related to the same Inspection Profile.

Field Caption	Field ID	Data Type (Length)	Comments
Equipment ID	MI_EQUIP000_EQUIP_ID_C	Character (255)	Values in this column must match the values entered on the Assets worksheet. You can link multiple records to the same asset.
Functional Location ID	MI_FNCLOC00_FNC_LOC_C	Character (255)	Values in this column must match the values entered on the Functional_Location worksheet. You can link multiple records to the same Functional Location.
CMMS System	MI_EQUIP000_SAP_SYSTEM_C MI_FNCLOC00_SAP_SYSTEM_C	Character (255)	Values in this column must match the values entered on the Assets or Functional_Location worksheet, if they exist. You can link multiple records to the same asset or Functional Location.
Equipment Technical Number	MI_EQUIP000_EQUIP_TECH_NBR_C	Character (255)	Values in this column must match the values entered on the Assets worksheet, if they exist. You can link multiple records to the same asset.
Item Category	MI_PROFINSP_ITEM_CAT_C	Character (50)	Values in this column must match the values entered on the Inspection_Profile worksheet, if they exist. You can link multiple records to the same Inspection Profile.
Item ID	MI_PROFINSP_ITEM_ID_C	Character (255)	Values in this column must match the values entered on the Inspection_Profile worksheet, if they exist. You can link multiple records to the same Inspection Profile.
Method Category	MI_INSPMETH_ITEM_CAT_C	Character (100)	A value is required. The combination of values in the Method Category, Method ID, and RBI Degradation Mechanism columns must be unique per Inspection Profile. This column must only contain one of the System Code IDs from the MI_INSPECTION_METHOD_CATEGORY System Code Table. To verify which options are acceptable in your GE Digital APM system, via Configuration Manager, refer to the appropriate table.
Method ID	MI_INSPMETH_ITEM_ID_C	Character (255)	A value is required. The combination of values in the Method Category, Method ID, and RBI Degradation Mechanism columns must be unique per Inspection Profile.
RBI Degradation Mechanism	MI_INSPMETH_DAMAGE_MECH_C	Character (255)	A value is required. This column must only contain the Entity ID of a Potential Degradation Mechanism that is linked to the Criticality RBI Component specified in the corresponding RBI Component column on the Inspection_Profile worksheet. The combination of values in the Method Category, Method ID, and RBI Degradation Mechanism columns must be unique per Inspection Profile. IMPORTANT: This column appears only in the Inspection Management (IM) Assets Data Loader workbook, and should not be included in the Inspection Management (IM) Functional Location Data Loader workbook.
Description	MI_INSPMETH_ITEM_DESC_C	Character (1000)	None

Inspection_Task Worksheet

On the Inspection_Task worksheet, you can specify Inspection Task records that you want to create or update.

Note: Each row represents a unique record, though multiple records may be related to the same Inspection Profile.

Field Caption	Field ID	Data Type (Length)	Comments
Equipment ID	MI_EQUIP000_EQUIP_ID_C	Character (255)	Values in this column must match the values entered on the Assets worksheet. You can link multiple records to the same asset.
Functional Location ID	MI_FNCLOC00_FNC_LOC_C	Character (255)	Values in this column must match the values entered on the Functional_Location worksheet. You can link multiple records to the same Functional Location.
CMMS System	MI_EQUIP000_SAP_SYSTEM_C MI_FNCLOC00_SAP_SYSTEM_C	Character (255)	Values in this column must match the values entered on the Assets or Functional_Location worksheet, if they exist. You can link multiple records to the same asset or Functional Location.
Equipment Technical Number	MI_EQUIP000_EQUIP_TECH_NBR_C	Character (255)	Values in this column must match the values entered on the Assets worksheet, if they exist. You can link multiple records to the same asset.
Task ID	MI_TASK_ID	Character (255)	A value is required and must be unique. This value identifies the Inspection Task.
Task Type	MI_TASK_TASK_TYPE_CHR	Character (255)	None
Task Description	MI_TASK_DESC_TX	Text	None
Task Details	MI_TASK_DETAILS_T	Text	None
Last Date	MI_TASK_LAST_DATE_DT	Date	Enter a value in the following format: YYYY-MM-DD hh:mm:ss
Override Interval	MI_TASK_OVERRIDE_INTER_F	Boolean	Enter True or False.
Desired Interval	MI_TASK_DESIR_INTER_NBR	Numeric	None
Next Date	MI_TASK_NEXT_DATE_DT	Date	Enter a value in the following format: YYYY-MM-DD hh:mm:ss
Next Date Basis	MI_TASK_NEXT_DATE_BASIS_C	Character (1000)	None
Coverage	MI_TASK_COVER_NBR	Numeric	None
Task Assigned To	MI_TASK_ASSGN_TO_C	Character (50)	None
Reoccurring	MI_TASK_REOCC_FLG	Boolean	Enter True or False. You can enter a value in this column only if you want to create an Inspection Task. If, however, you want to modify an Inspection Task using the data loader workbook, you cannot modify the value in this column.
Unconstrain Min/Max Dates	MI_TASK_UNCONSTR_MN_MX_DT_FLG	Boolean	Enter True or False.
Min Interval	MI_TASK_MIN_INTER_NBR	Numeric	None
Max Interval	MI_TASK_MAX_INTER_NBR	Numeric	None
Inspection Document Type	MI_TASK_INSP_INSPTYPE_FMLYID_C	Character (50)	None

Inspections Worksheet

On the Inspections worksheet, you can specify the following types of Inspections that you want to create or update:

Bundle Inspection
All types of Checklists (e.g., API 510 External Checklist, ILI Checklist)
Full Inspection
General Inspection
Pressure Test Inspection

Note: Each row represents a unique record, though multiple records may be related to the same asset or Functional Location.

IMPORTANT: If you have created a custom Inspection, and if you want to create or update records of that family using the data loader workbooks, ensure that the custom inspection family is linked to the Equipment or Functional Location family using the Has Inspections relationship definition.

Field Caption	Field ID	Data Type (Length)	Comments
Equipment ID	MI_EQUIP000_EQUIP_ID_C	Character (255)	Values in this column must match the values entered on the Assets worksheet. You can link multiple records to the same asset.
Functional Location ID	MI_FNCLOC00_FNC_LOC_C	Character (255)	Values in this column must match the values entered on the Functional_Location worksheet. You can link multiple records to the same Functional Location.
CMMS System	MI_EQUIP000_SAP_SYSTEM_C MI_FNCLOC00_SAP_SYSTEM_C	Character (255)	Values in this column must match the values entered on the Assets or Functional_Location worksheet, if they exist. You can link multiple records to the same asset or Functional Location.
Equipment Technical Number	MI_EQUIP000_EQUIP_TECH_NBR_C	Character (255)	Values in this column must match the values entered on the Assets worksheet, if they exist. You can link multiple records to the same asset.
Inspection Reference	MI_EVENT_ID	Character (255)	A value is required. If the value in the Use System Generated ID column is False (or if the column is blank or removed), then the value in this column must be unique. If the value in the Use System Generated ID column is True, then, after you load data, the value in this column is not used to populate the Inspection Reference field in the Inspection. Instead, a system-generated value is used to populate the field. In this case, the value in this column is used only to identify the records that must be linked to the Inspection.
Use System Generated ID	MI_SYS_GEN_ID	Logical	Enter True or False. If you enter False (or if the column is blank or removed), after you load data, the value in the Inspection Reference column is used to populate the Inspection Reference field in the Inspection. The default value is False. If you enter True, after you load data, the value in the Inspection Reference field in the Inspection is populated with a system-generated value. In this case, even if you enter a value in the Inspection Reference column, it is not used to populate the field. If you want to use the data loader workbooks to modify an Inspection, you must enter False (or leave the column blank or remove it). If, however, the value in this column is True, then, after you load data, the Inspection is not modified. Instead, a new Inspection is created.
Family ID	FMLY_ID	Character (255)	Values in this column are used to identify the type of the Inspection record that you want to create or update. In addition to the values specified on the (Picklist) worksheet, if you want to enter the family ID of a custom inspection family that you created, ensure that the family is linked to the Equipment or Functional Location family using the Has Inspections relationship family.
Inspection Headline	MI_EVENT_SHRT_DSC_CHR	Character (255)	None
Commencement Date	MI_EVENT_STRT_DT	Date	Enter a value in the following format: YYYY-MM-DD hh:mm:ss
Completion Date	MI_EVENT_END_DT	Date	Enter a value in the following format: YYYY-MM-DD hh:mm:ss
Tasks Addressed	MI_EVENT_TASKKEYS_C	Character (1000)	Enter a list of Entity Keys or Task IDs of Inspection Tasks, separated by commas. You can enter up to 20 values in each cell.
Equipment Operating State	MI_INSP_001_STATE_EQUIP_OP_C	Character (50)	This column must only contain the System Code IDs from the MI_EQUIP_OP_STATE System Code Table. If the system code table has been customized, the valid values could be different. Refer to the (Picklist) worksheet for a list of values that you can enter in this column.
Reason for Inspection	MI_INSP_001_REASON_C	Character (50)	Refer to the (Picklist) worksheet for a list of values that you can enter in this column.
Inspection Summary	MI_EVENT_LNG_DSC_TX	Text	None
Inspection Report Owner	MI_INSP_001_NAME_INSPECTOR_C	Character (255)	The value in this column must match an existing Security User who is assigned the Inspector Resource Role. Enter value in the following format: <Last Name>, <First Name> ~ <User ID>
Inspection Document Status	MI_INSP_001_STATUS_INSP_C	Character (50)	Refer to the (Picklist) worksheet for a list of values that you can enter in this column.
Inspection Lock	MI_INSP_001_LOCK_INSP_L	Boolean	Enter True or False. If the value in this column is True, and the Final Inspection Lock column is blank or False, the value in the Inspection Report Owner column must match the Security User who is loading the data.
Reviewers Name	MI_INSP_001_NAME_REVIEWER_C	Character (255)	The value in this column must match an existing Security User who is assigned the Inspection Supervisor Resource Role. Enter value in the following format: <Last Name>, <First Name> ~ <User ID>
Reviewers Comments	MI_INSP_001_COMMENTS_REVIEW_T	Text	None
Final Inspection Lock	MI_INSP_001_LOCK_FINAL_L	Boolean	Enter True or False. If the value in this column and the Inspection Lock column is True, the Inspection Report Owner and Reviewer's Name fields for the record will be populated with the name of the user who is loading the data.
Published	MI_INSP_001_PUBLISHED_L	Boolean	Enter True or False.
Inspection Confidence Evaluation Reviewed	MI_INSP_001_ICE_COMP_F	Boolean	Enter True of False. If the value in this column is True, the Inspection Confidence Evaluation records are locked. You can update this field only if: You have the Risk Analyst resource role assigned to you. The Allow Risk Analyst to Lock Inspection Confidence Evaluation Records check box is selected in the Application Configurations section of the Inspection Configuration workspace. Note: This column is not a part of the baseline data loader template. If required, you can add this column to the Inspections worksheet.

Inspection_Confidence_Eval Worksheet

On the Inspection_Confidence_Eval Worksheet, you can specify Inspection Confidence Evaluation records that you want to create or update.

Note: Each row represents a unique record, though multiple records may be related to the same Inspection Profile.

Field Caption	Field ID	Data Type (Length)	Comments
Equipment ID	MI_EQUIP000_EQUIP_ID_C	Character (255)	Values in this column must match the values entered on the Assets worksheet. You can link multiple records to the same asset.
Functional Location ID	MI_FNCLOC00_FNC_LOC_C	Character (255)	Values in this column must match the values entered on the Functional Location worksheet. You can link multiple records to the same Functional Location.
CMMS System (only for Asset load)	MI_EQUIP000_SAP_SYSTEM_C	Character (255)	Values in this column must match the values entered on the Assets worksheet. You can link multiple records to the same asset.
Equipment Technical Number	MI_EQUIP000_EQUIP_TECH_NBR_C	Character (255)	Values in this column must match the values entered on the Assets worksheet. You can link multiple records to the same asset.
Inspection Reference	MI_EVENT_ID	Character (255)	Value in this column must match the value in the Inspection Reference column of the parent inspection specified on the Inspections worksheet.
Inspection Confidence ID	MI_EVENT_SUB_INSP_ID	Character (255)	Enter a unique value in the following format: <Inspection Reference>-<Sequence Number>
RBI Component	MI_INSCONFEV_RBI_COMP_N	Numeric	Enter the Component field value of an existing RBI Component. The value in this field should be a valid RBI Component for the Asset that the Inspection is related to. Note: This column is not a part of the baseline data loader template. If required, you can add this column to the Inspection_Confidence_Eval worksheet.
Filter DM	MI_INSCONFEV_FILT_DM_F	Boolean	Enter True or False. This field is required if the RBI Component field has a value. If the RBI Component field is blank, this field is ignored during loading. If the value in this column is True, and an RBI Component is specified, the degradation mechanism must belong to the specified RBI Component. Note: This column is not a part of the baseline data loader template. If required, you can add this column to the Inspection_Confidence_Eval worksheet.
Degradation Mechanism	MI_INSP_001_DEG_MECH_C	Character (100)	This column must only contain the System Code IDs from the DEGRADATION_MECHANISM_TYPES System Code Table. Refer to the (Picklist) worksheet for a list of values that you can enter in this column. If you specify an RBI component and set the value in Filter DM as true, the degradation mechanism must belong to the specified RBI component.
Type of Inspection	MI_INSP_001_TYPE_C	Character (50)	Refer to the (Picklist) worksheet for a list of values that you can enter in this column.
Extent	MI_INSP_001_EXTENT_C	Character (1000)	This column must only contain System Code IDs from the MI_MI_INSPECTION_EXTENT System Code Table. Refer to the (Picklist) worksheet for a list of values that you can enter in this column.

Bundle_Sub_Inspection Worksheet

On the Bundle_Sub_Inspection worksheet, you can specify Bundle Sub-Inspection records that you want to create or update.

Note: Each row represents a unique record, though multiple records may be related to the same Inspection Profile.

Field Caption	Field ID	Data Type (Length)	Comments
Equipment ID	MI_EQUIP000_EQUIP_ID_C	Character (255)	Values in this column must match the values entered on the Assets worksheet. You can link multiple records to the same asset.
CMMS System	MI_EQUIP000_SAP_SYSTEM_C MI_FNCLOC00_SAP_SYSTEM_C	Character (255)	Values in this column must match the values entered on the Assets or Functional_Location worksheet, if they exist. You can link multiple records to the same asset or Functional Location.
Equipment Technical Number	MI_EQUIP000_EQUIP_TECH_NBR_C	Character (255)	Values in this column must match the values entered on the Assets worksheet, if they exist. You can link multiple records to the same asset.
Inspection Reference	MI_EVENT_ID	Character (255)	Values in this column must match the Inspection Reference of the parent inspection specified on the Inspections worksheet.
Bundle Sub Inspection Reference	MI_EVENT_SUB_INSP_ID	Character (255)	Values in this column are used to uniquely identify the Bundle Sub-Inspection. This field does not appear on the datasheet; however, it is used to uniquely identify the Bundle Sub-Inspection.
Bundle Tag	MI_EVENT_ASST_ID_CHR	Character (255)	None
Bundle Type	MI_INSPBUND_BUNDLE_TYPE_C	Character (50)	Refer to the (Picklist) worksheet for a list of values that you can enter in this column.
Total Number of Tubes In Bundle	MI_INSPBUND_TUBES01_N	Numeric	None
Action This Inspection	MI_INSPBUND_ACTION_THIS_INSP_C	Character (50)	Refer to the (Picklist) worksheet for a list of values that you can enter in this column.
Tubes Plugged At Inspection Start	MI_INSPBUND_TUBES02_N	Numeric	None
Tubes Plugged During This Inspection	MI_INSPBUND_TUBES07_N	Numeric	This column is not applicable if the value in the Action This Inspection column is NO ACTION.
Tubes (Plugged At Start) Replaced	MI_INSPBUND_TUBES03_N	Numeric	This column is not applicable if the Action This Inspection column contains one of the following values: NO ACTION TUBES PLUGGED TOTAL RETUBE BUNDLE REPLACED
Tubes (Not Previously Plugged) Replaced	MI_INSPBUND_TUBES04_N	Numeric	This column is not applicable if the Action This Inspection column contains one of the following values: NO ACTION TUBES PLUGGED TOTAL RETUBE BUNDLE REPLACED
Bundle Inspection Summary	MI_EVENT_LNG_DSC_TX	Text	None

Press_Test_Sub_Inspection Worksheet

On the Press_Test_Sub_Inspection worksheet, you can specify Pressure Test Sub-Inspection records that you want to create or update.

Note: Each row represents a unique record, though multiple records may be related to the same parent Inspection Record.

Field Caption	Field ID	Data Type (Length)	Comments
Equipment ID	MI_EQUIP000_EQUIP_ID_C	Character (255)	Values in this column must match the values entered on the Assets worksheet. You can link multiple records to the same asset.
Functional Location ID	MI_FNCLOC00_FNC_LOC_C	Character (255)	Values in this column must match the values entered on the Functional_Location worksheet. You can link multiple records to the same Functional Location.
CMMS System	MI_EQUIP000_SAP_SYSTEM_C MI_FNCLOC00_SAP_SYSTEM_C	Character (255)	Values in this column must match the values entered on the Assets or Functional Location worksheet, if they exist. You can link multiple records to the same asset or Functional Location.
Equipment Technical Number	MI_EQUIP000_EQUIP_TECH_NBR_C	Character (255)	Values in this column must match the values entered on the Assets worksheet, if they exist. You can link multiple records to the same asset.
Inspection Reference	MI_EVENT_ID	Character (255)	Values in this column must match the Inspection Reference of the parent inspection specified on the Inspections worksheet.
Pressure Test Inspection Reference	MI_EVENT_SUB_INSP_ID	Character (255)	Enter a unique value. Values in this column are used to identify the Pressure Test Sub-Inspection.
Test Media - Shell Side	MI_INSPPTST_MEDIA_TEST_SH_C	Character (50)	None
Test Media - Tube Side	MI_INSPPTST_MEDIA_TEST_TB_C	Character (50)	None
Test Pressure -Shell Side	MI_INSPPTST_PRESS_TEST_SH_N	Numeric	None
Test Pressure - Tube Side	MI_INSPPTST_PRESS_TEST_TB_N	Numeric	None
Test Duration - Shell Side	MI_INSPPTST_DURATION_TEST_SH_N	Numeric	None
Test Duration - Tube Side	MI_INSPPTST_DURATION_TEST_TB_N	Numeric	None
Test Media Temperature - Shell Side	MI_INSPPTST_MEDIA_TEMP_SH_N	Numeric	None
Test Media Temperature - Tube Side	MI_INSPPTST_MEDIA_TEMP_TB_N	Numeric	None
No. of Gauges Used - Shell Side	MI_INSPPTST_NO_GAUGE_USED_SH_N	Numeric	None
No. of Gauges Used - Tube Side	MI_INSPPTST_NO_GAUGE_USED_TB_N	Numeric	None
Witnessed By - Shell Side	MI_INSPPTST_WITNESS_BY_SH_C	Character (100)	Enter a value in the following format: <Last Name>, <First Name> ~ <User ID>
Witnessed By - Tube Side	MI_INSPPTST_WITNESS_BY_TB_C	Character (100)	Enter a value in the following format: <Last Name>, <First Name> ~ <User ID>
SRV Set Pressure - Shell Side	MI_INSPPTST_SRV_SET_PRESS_SH_N	Numeric	None
SRV Set Pressure - Tube Side	MI_INSPPTST_SRV_SET_PRESS_TB_N	Numeric	None
Test Comments - Shell Side	MI_INSPPTST_COMMENTS_TEST_SH_T	Text	None
Test Comments - Tube Side	MI_INSPPTST_COMMENTS_TEST_TB_T	Text	None

General_Finding Worksheet

On the General_Finding worksheet, you can specify General Finding records that you want to create or update.

Note: Each row represents a unique record, though multiple records may be related to the same Full Inspection.

Field Caption	Field ID	Data Type (Length)	Comments
Equipment ID	MI_EQUIP000_EQUIP_ID_C	Character (255)	Values in this column must match the values entered on the Assets worksheet. You can link multiple records to the same asset.
Functional Location ID	MI_FNCLOC00_FNC_LOC_C	Character (255)	Values in this column must match the values entered on the Functional_Location worksheet. You can link multiple records to the same Functional Location.
CMMS System	MI_EQUIP000_SAP_SYSTEM_C MI_FNCLOC00_SAP_SYSTEM_C	Character (255)	Values in this column must match the values entered on the Assets or Functional_Location worksheet, if they exist. You can link multiple records to the same asset or Functional Location.
Equipment Technical Number	MI_EQUIP000_EQUIP_TECH_NBR_C	Character (255)	Values in this column must match the values entered on the Assets worksheet, if they exist. You can link multiple records to the same asset.
Inspection Reference	MI_EVENT_ID	Character (255)	Values in this column must match the values entered on the Inspections worksheet, if they exist. You can link multiple records to the same Inspection.
Inspection Profile Category	MI_FIND_001_ITEM_PROFILE_CAT_C	Character (100)	A value is required. This column must only contain System Code IDs from the MI_INSPECTION_PROFILE_CATEGORY System Code Table. To verify which options are acceptable in your GE Digital APM system, via Configuration Manager, refer to the appropriate table. The combination of values in the Inspection Profile Category, Inspection Profile Item, and Inspection Method Item columns must be unique.
Inspection Profile Item	MI_FIND_001_ITEM_PROFILE_C	Character (100)	A value is required. The combination of values in the Inspection Profile Category, Inspection Profile Item, and Inspection Method Item columns must be unique.
Inspection Method Item	MI_FIND_001_ITEM_METHOD_C	Character (100)	A value is required for each row. This column must only contain the System Code IDs from the MI_INSPECTION_METHOD_CATEGORY System Code Table. To verify which options are acceptable in your GE Digital APM system, via Configuration Manager, refer to the appropriate table. The combination of values in the Inspection Profile Category, Inspection Profile Item, and Inspection Method Item columns must be unique.
Sequence	MI_FIND_001_SEQUENCE_N	Numeric	None
Location Details	MI_FIND_001_LOCATION_DETAILS_C	Text	None
Headline	MI_FIND_001_HEADLINE_C	Character (50)	None
Finding Summary	MI_FIND_001_SUMMARY_T	Text	None
Type	MI_FIND_001_TYPE_C	Character (100)	This column must only contain the System Code IDs from the MI_FINDING_TYPE System Code Table. Refer to the (Picklist) worksheet for a list of values that you can enter in this column.
As Found Degradation Mechanism	MI_FIND_001_MECH_DET_C	Character (100)	This column must only contain the System Code IDs from the MI_DAMAGE_MECHANISM System Code Table. Refer to the (Picklist) worksheet for a list of values that you can enter in this column.
Damage Mode	MI_FIND_001_MODE_DET_C	Character (100)	This column must only contain the System Code IDs from the MI_DAMAGE_MODE System Code Table. Refer to the (Picklist) worksheet for a list of values that you can enter in this column.
Action Taken Code	MI_FIND_001_ACT_TAKEN_CODE_C	Character (100)	Refer to the (Picklist) worksheet for a list of values that you can enter in this column.
Action Taken Description	MI_FIND_001_ACT_TAKEN_DESC_T	Text	None
Predictable	MI_FIND_001_PREDICTABLE_C	Character (3)	In the baseline GE Digital APM system, This column must only contain the following System Code IDs: Y N 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.

Custom_Sub_Inspection Worksheet

If you have created a custom sub inspection family, on the Custom_Sub_Inspection worksheet, you can specify the custom sub inspection records that you want to create or update.

IMPORTANT: Ensure that the custom sub inspection family that you have created is linked to the Inspections family using the Has Sub Inspections relationship definition.

Field Caption	Field ID	Data Type (Length)	Comments
Equipment ID	MI_EQUIP000_EQUIP_ID_C	Character (255)	Values in this column must match the values entered on the Assets worksheet. You can link multiple records to the same asset.
Functional Location ID	MI_FNCLOC00_FNC_LOC_C	Character (255)	Values in this column must match the values entered on the Functional_Location worksheet. You can link multiple records to the same Functional Location.
CMMS System	MI_EQUIP000_SAP_SYSTEM_C MI_FNCLOC00_SAP_SYSTEM_C	Character (255)	Values in this column must match the values entered on the Assets or Functional_Location worksheet, if they exist. You can link multiple records to the same asset or Functional Location.
Equipment Technical Number	MI_EQUIP000_EQUIP_TECH_NBR_C	Character (255)	Values in this column must match the values entered on the Assets worksheet, if they exist. You can link multiple records to the same asset.
Inspection Reference	MI_EVENT_ID	Character (255)	Values in this column must match the values entered for the parent Inspection on the Inspections worksheet. You can link multiple records to the same Inspection.
Sub Inspection Reference	MI_EVENT_SUB_INSP_ID	Character (255)	A value is required and must be unique. Values in this column are used to identify the custom sub inspection record.
Family ID	FMLY_ID	Character (255)	A value is required and must match the value entered for the parent Inspection family on the Inspections worksheet.

Inspection_Recommendation Worksheet

On the Inspection_Recommendation worksheet, you can specify Inspection Recommendation records that you want to create or update.

Note: Each row represents a unique record, though multiple records may be related to the same Full Inspection.

Field Caption	Field ID	Data Type (Length)	Comments
Equipment ID	MI_EQUIP000_EQUIP_ID_C	Character (255)	Values in this column must match the values entered on the Assets worksheet. You can link multiple records to the same asset.
Functional Location ID	MI_FNCLOC00_FNC_LOC_C	Character (255)	Values in this column must match the values entered on the Functional_Location worksheet. You can link multiple records to the same Functional Location.
CMMS System	MI_EQUIP000_SAP_SYSTEM_C MI_FNCLOC00_SAP_SYSTEM_C	Character (255)	Values in this column must match the values entered on the Assets or Functional_Location worksheet, if they exist. You can link multiple records to the same asset or Functional Location.
Equipment Technical Number	MI_EQUIP000_EQUIP_TECH_NBR_C	Character (255)	Values in this column must match the values entered on the Assets worksheet, if they exist. You can link multiple records to the same asset.
Inspection Reference	MI_EVENT_ID	Character (255)	Values in this column must match the values entered on the Inspections worksheet, if they exist. You can link multiple records to the same Full Inspection.
Recommendation ID	MI_REC_ID	Character (255)	A value is required and must be unique.
Target Completion Date	MI_REC_TARGE_COMPL_DATE_DT	Date	A value is required. Enter a value in the following format: YYYY-MM-DD hh:mm:ss
Recommendation Headline	MI_REC_SHORT_DESCR_CHR	Character (255)	None
Recommendation Description	MI_REC_LONG_DESCR_TX	Text	None
Recommendation Priority	MI_REC_PRIORITY_C	Character (50)	This column must only contain the System Code IDs from the MI_PRIORITY System Code Table. Refer to the (Picklist) worksheet for a list of values that you can enter in this column.
Required Equipment Status	MI_REC_REQUI_EQUIP_STATU_CHR	Character (50)	This column must only contain the System Code IDs from the MI_EQUIP_OP_STATE System Code Table. Refer to the (Picklist) worksheet for a list of values that you can enter in this column.
Business Impact	MI_REC_IMPAC_CHR	Character (100)	This column must only contain the System Code IDs from the MI_BUSINESS_IMPACT System Code Table. Refer to the (Picklist) worksheet for a list of values that you can enter in this column.
Mandatory Date	MI_REC_MANDA_DATE_DT	Date	Enter a value in the following format: YYYY-MM-DD hh:mm:ss
Assigned To Name	MI_REC_ASSIG_NM_CHR	Character (255)	Enter a value in the following format: <Last Name>, <First Name> ~ <User ID>
Author Name	MI_REC_AUTHO_NM_CHR	Character (255)	The value in this column must match an existing Security User who is assigned the Inspector, Inspection Administrator, or Inspection Supervisor Resource Role. Enter a value in the following format: <Last Name>, <First Name> ~ <User ID>
Reviewer Name	MI_REC_REVIE_NM_CHR	Character (255)	The value in this column must match an existing Security User who is assigned the Inspection Supervisor Resource Role. Enter a value in the following format: <Last Name>, <First Name> ~ <User ID>
Final Approver Name	MI_REC_FINAL_APPROVE_NAME_C	Character (255)	Enter a value in the following format: <Last Name>, <First Name> ~ <User ID>
Implemented Date	MI_REC_COMPL_DATE_DT	Date	Enter a value in the following format: <Last Name>, <First Name> ~ <User ID>

Reference_Document Worksheet

On the Reference_Document worksheet, you can specify Reference Document records that you want to create or update.

Note: Each row represents a unique record, though multiple records may be related to the same Full Inspection.

Field Caption	Field ID	Data Type (Length)	Comments
Equipment ID	MI_EQUIP000_EQUIP_ID_C	Character (255)	Values in this column must match the values entered on the Assets worksheet. You can link multiple records to the same asset.
Functional Location ID	MI_FNCLOC00_FNC_LOC_C	Character (255)	Values in this column must match the values entered on the Functional_Location worksheet. You can link multiple records to the same Functional Location.
CMMS System	MI_EQUIP000_SAP_SYSTEM_C MI_FNCLOC00_SAP_SYSTEM_C	Character (255)	Values in this column must match the values entered on the Assets or Functional_Location worksheet, if they exist. You can link multiple records to the same asset or Functional Location.
Equipment Technical Number	MI_EQUIP000_EQUIP_TECH_NBR_C	Character (255)	Values in this column must match the values entered on the Assets worksheet, if they exist. You can link multiple records to the same asset.
Inspection Reference	MI_EVENT_ID	Character (255)	Values in this column must match the values entered on the Inspections worksheet, if they exist. You can link multiple records to the same Full Inspection.
Reference Document ID	CTIT_ID	Character (255)	A value is required and must be unique.
Description	CTIT_DESC_TX	Character (255)	None
Document Path	MIRD_DOC_PATH_CHR	Character (1023)	None