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

After you load data, 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 assets specified in the data loader workbook, and then verify that the expected components 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_CCRBICOM].LAST_UPDT_DT "LAST_UPDT_DT", [MI_CCRBICOM].[MI_RBICOMPO_COMPO_C] "Component", [MI_CCRBICOM].[MI_RBICOMPO_COMPO_TYPE_C] "Component Type", [MI_CCRBICOM].[MI_RBICOMPO_EQUIP_C] "Equipment", [MI_CCRBICOM].ENTY_ID "ENTY_ID" FROM [MI_CCRBICOM] WHERE [MI_CCRBICOM].LAST_UPDT_DT >= CONVERT(VARCHAR(255), (? :d :caption='Enter a Date'), 110) ORDER BY [MI_CCRBICOM].LAST_UPDT_DT Desc,[MI_CCRBICOM].[MI_RBICOMPO_EQUIP_C] Asc

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

SELECT [MI_CCRBICOM].LAST_UPDT_DT "LAST_UPDT_DT", [MI_CCRBICOM].[MI_RBICOMPO_COMPO_C] "Component", [MI_CCRBICOM].[MI_RBICOMPO_COMPO_TYPE_C] "Component Type", [MI_CCRBICOM].[MI_RBICOMPO_EQUIP_C] "Equipment", [MI_CCRBICOM].ENTY_ID "ENTY_ID" FROM [MI_CCRBICOM] WHERE [MI_CCRBICOM].LAST_UPDT_DT >= to_date(to_char((? :d :caption='Enter a Date'),'mm/dd/yyyy'),'mm/dd/yyyy') ORDER BY [MI_CCRBICOM].LAST_UPDT_DT Desc,[MI_CCRBICOM].[MI_RBICOMPO_EQUIP_C] Asc

When prompted, enter the date on which the data load was performed.