About the Thickness Monitoring (TM) Data Loaders Load Verification

After you load data, perform the following steps in GE Digital APM to confirm the integrity and accuracy of the data that you have loaded:

Access the details of the import job. These details indicate if any errors were encountered during the data load. The log may help account for any records that are not loaded.

In Thickness Monitoring or Record Manager, access the assets specified in the data loader workbook, and then verify that the expected TML Groups and TMLs are present or updated, and that any associated records that you expected to be created are also present in the database.

To view a list of TML Groups created after a specific date, run the following query:

For an SQL database:

SELECT [MI_TMLGROUP].[MI_TMLGROUP_ID_C] "TML Group ID", [MI_TMLGROUP].[MI_TMLGROUP_DESCR_C] "Description", [MI_TMLGROUP].LAST_UPDT_DT "LAST_UPDT_DT" FROM [MI_TMLGROUP] WHERE [MI_TMLGROUP].LAST_UPDT_DT >= CONVERT(VARCHAR(255), (? :d :caption='Enter a Date'), 110)
For an Oracle database:

SELECT [MI_TMLGROUP].[MI_TMLGROUP_ID_C] "TML Group ID", [MI_TMLGROUP].[MI_TMLGROUP_DESCR_C] "Description", [MI_TMLGROUP].LAST_UPDT_DT "LAST_UPDT_DT", [MI_TMLGROUP].ENTY_ID "ENTY_ID" FROM [MI_TMLGROUP] WHERE [MI_TMLGROUP].LAST_UPDT_DT >= to_date(to_char((? :d :caption='Enter a Date'), 'mm/dd/yyyy'), 'mm/dd/yyyy')

To view a list of TMLs created after a specific date, run the following query:

For an SQL database:

SELECT [MI Thickness Measurement Location].[MI_DP_ID_CHR] "TML ID", [MI Thickness Measurement Location].[MI_DP_ASSET_ID_CHR] "TML Asset ID", [MI Thickness Measurement Location].LAST_UPDT_DT "LAST_UPDT_DT" FROM [MI Thickness Measurement Location] WHERE [MI Thickness Measurement Location].LAST_UPDT_DT >= CONVERT(VARCHAR(255), (? :d :caption='Enter a Date'), 110)
For an Oracle database:

SELECT [MI Thickness Measurement Location].[MI_DP_ID_CHR] "TML ID", [MI Thickness Measurement Location].[MI_DP_ASSET_ID_CHR] "TML Asset ID", [MI Thickness Measurement Location].LAST_UPDT_DT "LAST_UPDT_DT", [MI Thickness Measurement Location].ENTY_KEY "ENTY_KEY" FROM [MI Thickness Measurement Location] WHERE [MI Thickness Measurement Location].LAST_UPDT_DT >= to_date(to_char((? :d :caption='Enter a Date'), 'mm/dd/yyyy'), 'mm/dd/yyyy')

To view a list of Thickness Measurements created after a specific date, run the following query:

For an SQL database:
SELECT [MI Thickness Measurement].[MI_THICK_MEASU_ID_CHR] "Measurement ID", [MI Thickness Measurement].[MI_DP_MEAS_TAKEN_BY_CHR] "Measurement Taken By", [MI Thickness Measurement].[MI_THICK_MEAS_TML_KEY_C] "TML Key", [MI Thickness Measurement].LAST_UPDT_DT "LAST_UPDT_DT" FROM [MI Thickness Measurement] WHERE [MI Thickness Measurement].LAST_UPDT_DT >= CONVERT(VARCHAR(255), (? :d :caption='Enter a Date'), 110)
For an Oracle database:
SELECT [MI Thickness Measurement].[MI_THICK_MEASU_ID_CHR] "Measurement ID", [MI Thickness Measurement].[MI_DP_MEAS_TAKEN_BY_CHR] "Measurement Taken By", [MI Thickness Measurement].[MI_THICK_MEASU_READ_PF_C] "Readings Pass/Fail", [MI Thickness Measurement].[MI_THICK_MEAS_TML_KEY_C] "TML Key", [MI Thickness Measurement].LAST_UPDT_DT "LAST_UPDT_DT", [MI Thickness Measurement].ENTY_KEY "ENTY_KEY" FROM [MI Thickness Measurement] WHERE [MI Thickness Measurement].LAST_UPDT_DT >= to_date(to_char((? :d :caption='Enter a Date'), 'mm/dd/yyyy'), 'mm/dd/yyyy')