DQM Check for Required Detection Limit

<< Click to Display Table of Contents >>

Professional > Modules > DQM > DQM Checks >

DQM Check for Required Detection Limit

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

 

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

 

This check uses the REPORTABLE_RESULT and RESULT_TYPE_CODE parameters from Global Parameters.

 

The check will also have the detection_limit_column parameter to allow the user to specify which DT_RESULT column to use as the "reporting detection limit":

REPORTING_DETECTION_LIMIT

METHOD_DETECTION_LIMIT or

QUANTITATION_LIMIT

 

There is one rule, and it is “EXCEEDS REQUIRED DETECTION LIMIT” = 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.

 

An error is added to the Errors tab of the DQM Qualification Report Form 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) is not numeric.

RT_DQM_CONTROL_LIMITS. REQUIRED_DETECT_LIMIT is not numeric.

RT_DQM_CONTROL_LIMITS. REQUIRED_DETECT_LIMIT_UNIT is null.