<< Click to Display Table of Contents >> Navigation:  DQM > DQM Checks > Dilution Factor Check

•Check

•Parameters

•Rules

•Exceptions

•Errors

 

The DQM Check for Dilution Factor evaluates if a sample/analyte. was analyzed at a dilution (Dilution_Factor>1).

 

Check

 

Check name is EarthSoft.DQM.DilutionFactor.

 

Parameters

 

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

 

Three parameters are available for this check. None of these parameters allow for input of analyte-specific or method-specific PARAM_VALUEs.

1.sample_type_code – the sample type(s) of the samples to be included in this check. The default value is “N”.

2.result_type_code – the result type of the results to be included in this check. The default value is “TRG”.

3.non_detect_only – Y/N option to only review results with DETECT_FLAG = N. The default value is “N”.

 

 

Rules

 

There is one rule:

1.DILUTION FACTOR > 1 – for when the dilution factor for the results associated with DT_TEST.DILUTION_FACTOR >1

 

The Apply Remark for this rule in the DQM Starter QAPP when an exception is encountered is: “The Dilution Factor for this result was greater than 1.”

 

Exceptions

 

DQM will evaluate the dilution factor in DT_TEST.DILUTION_FACTOR for all sample_type_code(s), and result_type_codes in the dataset and will create an exception when the dilution factor >1.

•If RT_DQM_CHECK_PARAM.NON_DETECT_ONLY = N, DQM will create an exception for all analytes where DT_TEST.DILUTION_FACTOR >1.

•If RT_DQM_CHECK_PARAM.NON_DETECT_ONLY = Y, DQM will create an exception for all analytes where DT_RESULT.DETECT_FLAG = N and DT_TEST.DILUTION_FACTOR >1.

 

When the dilution factor field in DT_TEST.DILUTION_FACTOR >1, an exception is added for the Rule = DILUTION FACTOR >1.

 

An example remark saved to dt_result.dqm_remark for this exception is:

 

“The Dilution Factor for this result was greater than 1.”

 

Errors

 

An error occurs when DT_TEST.DILUTION_FACTOR is null or non-numeric for any of the tests contained in the dataset in the DQM Event. An error message will be created for all results associated with the test with the dilution factor that is null or non-numeric.

 

An example error message is: "The DILUTION FACTOR column is NULL or not numeric at (sys_sample_code: Sample1, analytic_method: SW8260, cas_rn: 100-41-4)."