The DQM Check for Preservative evaluates if the chemical preservative for each test method in a sample matches the required chemical preservative. When a discrepancy is found, DQM qualifies all results for the TEST_ID with the mismatch.
The preservation field is used by both the Preservative check and the Holding Time Check. However, because the technical holding times for some analytical method and matrix combinations are dependent upon whether the sample is preserved, access to the relevant data in RT_HOLDING_TIME.PRESERVATIVE is in the Holding Time Check in DQM Settings.
Check name is EarthSoft.DQM.Preservative.
There is one check parameter:
1.sample_type_code – the sample type(s) of the samples to be included in this check. The default value is “N”.
This check uses three Global Parameters:
1.reportable_result - dt_result.reportable_result values to include in DQM datasets
2.result_type_code - dt_result.result_type_code to include in DQM datasets
3.test_type_batch - at_test_batch_assign.test_batch_type to include in DQM dataset
There is one rule:
1.Incorrect Preservative – for when the preservative for the test method in DT_TEST.PRESERVATIVE does not match the preservative for the test method in the DQM QAPP in RT_HOLDING_TIME.PRESERVATIVE.
The Apply Remark for this rule in the DQM Starter QAPP when an exception is encountered is:
“The preservative for this test id does not match the required preservative in RT_HOLDING_TIME.”
•A non-null value must be input into RT_HOLDING_TIME.PRESERVATIVE for each analytic_method and medium_code. If a given analytic_method and medium_code should have no preservative, RT_HOLDING_TIME.PRESERVATIVE should be populated with "None". DQM will then flag the presence of any preservative as an exceedance.
•The RT_HOLDING_TIME.PRESERVATIVE field may be populated with more than one preservative.
•All preservatives input into the RT_HOLDING_TIME.PRESERVATIVE field must already exist in RT.PRESERVATIVE.PRESERVATIVE. If populating the RT_HOLDING_TIME.PRESERVATIVE field with a value that includes an underscore (e.g. HCL_NA2S2O3), then this exact value (HCL_NA2S2O3) must also exist in RT.PRESERVATIVE.PRESERVATIVE. In addition, if populating the RT_HOLDING_TIME.PRESERVATIVE field with a comma separated string, the entire comma separated string is required to be populated in RT.PRESERVATIVE.PRESERVATIVE (e.g. “ICE,HCL” as one value).
An error occurs when no value is populated in RT_HOLDING_TIME.PRESERVATIVE for a given analytic_method and medium_code contained in the data set in the DQM Event.
An example error message is: No value was found in the RT_HOLDING_TIME_PRESERVATIVE column for the QAPP Code and Analytic Method = SW-846 8270D and Medium_Code = Water.
DQM will compare the preservative listed in DT_TEST.PRESERVATIVE for each analytical method and medium code for every sample_type_code in RT_DQM_CHECK_PARAM.PARAM_VALUE to the preservative listed in RT_HOLDING_TIME.PRESERVATIVE.
When the preservative field in DT_TEST.PRESERVATIVE does not match the preservative in RT_HOLDING_TIME.PRESERVATIVE, and exception is added for the Rule = INCORRECT PRESERVATIVE.
An example remark saved to DT_RESULT.DQM_REMARK for this exception is:
•“The preservative for this test id does not match the required preservative, NONE, in RT_HOLDING_TIME.”
•DQM treats a null value or a value of “NONE” in DT_TEST.PRESERVATIVE to be the same and to mean that the sample was not chemically preserved.
Copyright © 2022 EarthSoft, Inc • Modified: 17 Feb 2022