Required Detection Limit Check

The DQM Check for Required Detection Limit compares the "reporting detection limit" of each result to a client specified "project required detection limit" for each analyte.

Check

Check name is EarthSoft.DQM.RequiredDetectionLimit = Required Detection Limit.

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

Five parameters are specifically available for this Check. None of these parameters allow for input of analyte-specific or method-specific PARAM_VALUEs. However the check itself requires the population of REQUIRED_DETECT_LIMIT and REQUIRED_DETECT_LIMIT_UNIT columns of the RT_DQM_CONTROL_LIMITS table for each Analytic Method and/or CAS_RN.

1.detection_limit_column – To allow the user to specify which DT_RESULT column to use as the "reporting detection limit":

oREPORTING_DETECTION_LIMIT

oMETHOD_DETECTION_LIMIT or

oQUANTITATION_LIMIT

2.sample_type_code – Defaults to "N".

3.result_type_code – Defaults to "TRG".

4.non-adjusted_only – Defaults to "N". Selection of "Y" will exclude results with a dilution factor > 1 from this check.

5.non_detect_only – Defaults to "Y". Selection of "N" will include results with DETECT_FLAG =Y in this check.

Notes:

•Default parameter values listed above refer to the value provided in the DQM Starter QAPP.xlsx.

•The RT_DQM_CONTROL_LIMITS.METHOD_ANALYTE_GROUP_CODE for REQUIRED_DETECT_LIMIT and REQUIRED_DETECT_LIMIT_UNIT must be null or it must be a dataset selection on the Start Event Form.

Rules

There is one rule and it is "EXCEEDS REQUIRED DETECTION LIMIT".

Exceptions

Qualify a result if:

•DT_RESULT.REPORTING_DETECTION_LIMIT (or .METHOD_DETECTION_LIMIT or .QUANTITATION_LIMIT, depending on which column is specified by the detection_limit_column parameter) > RT_DQM_CONTROL_LIMITS.REQUIRED_DETECT_LIMIT

To enable this check to run, "project required detection limits" will need to be entered in the REQUIRED_DETECT_LIMIT and REQUIRED_DETECT_LIMIT_UNIT columns of the RT_DQM_CONTROL_LIMITS table for each Analytic Method and/or CAS_RN in the analytic results of the database.

Errors

In the Errors tab of the DQM Event Review Form these errors may be listed:

•"One of the required rules for this check is not present in the RT_DQM_RULE table."
If you receive this error, the QAPP can be updated following the How to Update Existing QAPPs documentation page.

•"The value in the {0} column is null or not numeric at" DT_RESULT.REPORTING_DETECTION_LIMIT (or .METHOD_DETECTION_LIMIT or .QUANTITATION_LIMIT, depending on which column is specified by the detection_limit_column parameter).

•"The REQUIRED_DETECTION_LIMIT column in RT_DQM_CONTROL_LIMITS is NULL for SYS_SAMPLE_CODE = 'XXX'; ANALYTIC_METHOD = 'YYY'; CAS_RN = 'ZZZ'"
RT_DQM_CONTROL_LIMITS.REQUIRED_DETECT_LIMIT is null or not numeric for the record listed. The check will be skipped for this record.

•"The DILUTION_FACTOR column is NULL or not numeric at SYS_SAMPLE_CODE = 'XXX'; ANALYTIC_METHOD = 'YYY'; CAS_RN = 'ZZZ'"
DILUTION_FACTOR is null or non-numeric when non_adjust_only =Y for the record listed. The check will be skipped for this record.