Estimated Results Check

<< Click to Display Table of Contents >>

Navigation:  Professional > DQM > DQM Checks >

Estimated Results Check

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 the reportable_result and test_batch_type parameters from Global Parameters.

There are three other parameters:

1.estimated_detection_limit    

a.defaults to "reporting_detection_limit"

b.can be changed to "quantitation limit"

2.sample_type_code

a.defaults to "N"

3.result_type_code

a.defaults to "TRG"
 

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

 

An error is listed in the Errors tab of the DQM Event Review Form if:

METHOD_DETECTION_LIMIT, REPORTING_DETECTION_LIMIT, QUANTITATION_LIMIT or RESULT_NUMERIC is NULL

There is an error when DETECTION_LIMIT_UNIT is converted to RESULT_UNIT

The QAPP you are using is not using the most up-to-date version

 

Example Error Messages
 

{FIELDNAME} is NOT Numeric! So, Estimated Result check cannot be completed for Sample, Method, CAS_RN.

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}.

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.