Radio Chemistry Tracer Recovery Check

<< Click to Display Table of Contents >>

Navigation:  DQM > DQM Checks >

Radio Chemistry Tracer Recovery Check

Check

Parameters

Rules

Errors

 

The DQM Check for Radio Chemistry Tracer Recovery will qualify results if tracer sample recoveries fall outside Quality Control (QC)  limits. (Note that DT_RESULT_QC must be populated for this check to function).

 

Check

 

Check name is EarthSoft.DQM.RadChemTracerRecovery = Radiochemistry Tracer Recovery.

 

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

 

Two parameters are available for this check. None of these parameters allow for input of analyte-specific PARAM_VALUEs.  The SecondTracer parameter requires input of an analytical method.

1.Result_type_code_tracer – Defaults to "TRA".

2.SecondTracer – If “Y”, then a second tracer must fail the test before results are qualified. This parameter depends on the value entered in the ANALYTIC_METHOD column. Defaults to “N” if no parameter entered.

 

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

 

Rules

 

There are six rules:

1.REC > UCL = DT_RESULT_QC.QC_SPIKE_RECOVERY > DT_RESULT_QC.QC_SPIKE_UCL.

2.ASSO DETECTS OF REC > UCL.

3.ASSO NON-DETECTS OF REC > UCL.

4.REC < LCL = DT_RESULT_QC.QC_SPIKE_RECOVERY < DT_RESULT_QC.QC_SPIKE_LCL.

5.ASSO DETECTS OF REC < LOW_CUTOFF.

6.ASSO NON-DETECTS OF REC < LOW_CUTOFF.

 

For tracer results:

Associated results are found using DT_TEST.TEST_ID.

Different qualifiers may be specified for those associated results with a detected concentration, and for those without (i.e. non-detect).

 

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.

"Tracer LCL/UCL IS Not Numeric."
       If you receive this error, the check will be skipped.

"Spike Duplicate Recovery data missing from DT_RESULT_QC for either {0} or {1} and {2}."
       If you receive this error, the check will be skipped.