About the Risk Based Inspection (RBI) Corrosion Loop Data Loader Load Verification

Following a data load, you should perform the following steps in GE Digital APM to confirm the integrity and accuracy of the data imported from the data loader workbook:

Access the details of the import job. These details will indicate if any errors, minor or otherwise, were encountered during the import job. The log may help account for any records that are unexpectedly absent after the data load.
In Risk Based Inspection or Record Manager, access the Corrosion Loops specified in the data loader workbook, and then verify that the expected Corrosion Loops are present or updated, and that any associated records that you expected to be created are also present in the database.

You can enter the following query in the SQL workspace of the Query page to review a list of components created after a specified date:

SELECT [MI_RBiSYS00].LAST_UPDT_DT "LAST_UPDT_DT", [MI_RBiSYS00].[MI_RBI_SYSTEM_RBI_SYS_ID_C] "RBI Corrosion Loop ID", [MI_RBiSYS00].[MI_RBI_SYSTEM_RBI_SYS_DESC_C] "RBI Corrosion Loop Description", [MI_RBiSYS00].[MI_RBI_SYSTEM_RBI_SYS_TO_C] "RBI Corrosion Loop To", [MI_RBiSYS00].[MI_RBI_SYSTEM_RBI_SYS_FROM_C] "RBI Corrosion Loop From", [MI_RBICOMPO].[MI_RBICOMPO_COMPO_C] "RBI Component ID", [MI_RBICOMPO].[MI_RBICOMPO_COMPO_TYPE_C] "Component Type" FROM [MI_RBiSYS00] LEFT JOIN {MIR_HSRBICMP} JOIN [MI_RBICOMPO] ON {MIR_HSRBICMP}.SUCC_ENTY_KEY = [MI_RBICOMPO].ENTY_KEY ON [MI_RBiSYS00].ENTY_KEY = {MIR_HSRBICMP}.PRED_ENTY_KEY WHERE [MI_RBiSYS00].LAST_UPDT_DT >= CONVERT(VARCHAR(255), (? :d :caption='Enter a Date'), 110)