Estimated Results Check

<< Click to Display Table of Contents >>

Navigation:  DQM > DQM Checks >

Estimated Results Check

Check

Parameters

Rules

Exceptions

Errors

 

The DQM Check for Estimated Results checks for sample results between the method detection limit and the reporting limit or the quantitation limit.

 

Check

Check name is EarthSoft.DQM.EstimatedResults = Estimated Results.

 

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.estimated_detection_limit – The default is "reporting_detection_limit". It can be changed to "quantitation_limit".

2.sample_type_code – The default is "N".

3.result_type_code – The default is "TRG".

 

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

 

Rules

 
There are two rules and they are:

1.MDL=<RESULT<RL (INORGANIC)

2.MDL=<RESULT<RL (ORGANIC)

 

Exceptions

 

Qualify a result IF:

DETECT_FLAG = 'Y' and

If estimated_detection_limit = "reporting_detection_limit" then

oMETHOD_DETECTION_LIMIT <= RESULT_NUMERIC <REPORTING_DETECTION_LIMIT

Else if estimated_detection_limit = "quantitation_limit" then

oMETHOD_DETECTION_LIMIT <= RESULT_NUMERIC < QUANTITATION_LIMIT

Match each qualified result’s CAS_RN to RT_ANALYTE.CAS_RN

oFor results with RT_ANALYTE.ORGANIC_YN = ‘N’, use Rule #1

oFor results with RT_ANALYTE.ORGANIC_YN <> ‘N’, use Rule #2

 

Errors

 

In the Errors tab of the DQM Event Review Form, these example error messages may be listed:

1."{FIELDNAME} is NOT Numeric! So, Estimated Result check cannot be completed for Sample, Method, CAS_RN."
METHOD_DETECTION_LIMIT, REPORTING_DETECTION_LIMIT, QUANTITATION_LIMIT or RESULT_NUMERIC is NULL.

2."There is an error when detection_limit_unit ({FIELDNAME}) is converted to result_unit ({FIELDNAME}) for {FIELDNAME}! So, Estimated Result check cannot be completed for {FIELDNAME}."
Possibly missing a unit conversion for converting DETECTION_LIMIT_UNIT to RESULT_UNIT.

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