About the Calibration Management Data Loader Load Verification

Following a successful data load, the user is able to navigate to any of the imported templates, to view the details and logic tree associated with the template, and to import template content into an analysis.

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 Calibration Management or Record Manager, access the assets specified in the data loader workbook, and then verify that the expected Calibration records are present or updated, and that any associated records that you expected to be created are also present in the database.
To access a list of Calibration Templates created after a specific date, run the following query:

SELECT [MI_TMCA0000].[MI_TM000000_ID] "Template ID", [MI_TMCA0000].[MI_TMCA0000_CAL_TYP_C] "Calibration Type", [MI_TMCA0000].[MI_TMCA0000_INPUT_TYP_C] "Input Type", [MI_TMCA0000].[MI_TMCA0000_OUTPU_TYP_C] "Output Type", [MI_TMCA0000].[MI_TMCA0000_IS_MAST_TEMP_L] "Is Master Template", [MI_TMCA0000].LAST_UPDT_DT "Created Date"FROM [MI_TMCA0000] WHERE [MI_TMCA0000].LAST_UPDT_DT >= (? :d :caption='Enter Date')
To access a list of Calibration Tasks created after a specific date, run the following query:

SELECT [MI_TASKCALB].[MI_TASK_ID] "Task ID", [MI_TASKCALB].[MI_TASK_LAST_DATE_DT] "Last Date", [MI_TASKCALB].[MI_TASK_NEXT_DATE_DT] "Next Date", [MI_TASKCALB].[MI_TASK_DESIR_INTER_NBR] "Desired Interval", [MI_TASKCALB].[MI_TASK_DESIR_INTER_UOM_C] "Desired Interval UOM", [MI_TASKCALB].LAST_UPDT_DT "Created Date" FROM [MI_TASKCALB] WHERE [MI_TASKCALB].LAST_UPDT_DT >= (? :d :caption='Enter Date')
To access a list of Calibrations created after a specific date, run the following query:
SELECT [MI_EVCALIBR].[MI_EVENT_ID] "Event ID", [MI_EVCALIBR].[MI_EVCALIBR_CALIB_TYP_C] "Calibration Type", [MI_EVCALIBR].[MI_EVCALIBR_STRATEGY_C] "Calibration Strategy", [MI_EVCALIBR].[MI_EVCALIBR_CAL_CLOSE_L] "Calibration Closed", [MI_EVCALIBR].[MI_SM_STATE_ID_C] "Calibration State", [MI_EVCALIBR].LAST_UPDT_DT "Created Date"FROM [MI_EVCALIBR] WHERE [MI_EVCALIBR].LAST_UPDT_DT >= (? :d :caption='Enter Date')