<< Click to Display Table of Contents >> Navigation:  DQM > DQM Checks > Estimated Results Check

•Check

•Parameters

•Rules

•Exceptions

•Errors

•Warnings

 

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

 

 

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.

 

Warnings

 

In the Review Exceptions by Check Tab, the following may appear as a warning:  

•"X results were NOT processed for Estimated Results due to NULL value in the ORGANIC_YN column of the RT_ANALYTE table for '<CAS_RN>' analyte". This warning shows that RT_ANALYTE.ORGANIC_YN = NULL for the indicated analyte and so the check has been skipped.