Radio Chemistry Relative Error Ratio Check

<< Click to Display Table of Contents >>

Navigation:  Professional > DQM > DQM Checks >

Radio Chemistry Relative Error Ratio Check

The DQM Check for Radio Chemistry Relative Error Ratio checks for relative error ratio values for field duplicate sample radio chemistry results that fall outside QC limits.

 

It is important that RT_MATRIX.MEDIUM_CODE be populated for this check to work properly. (Note that DT_RESULT_QC is not used for this check).

 

Notes:

The 'Event Summary' tab does not summarize the correct number of Exceptions for the Radio Chemistry Relative Error Ratio check. However, the correct number of Exceptions are listed in the 'Review Exceptions by Check' tab of the 'Event Review' Form. The 'Event Summary' tab will be fixed in an upcoming build of DQM to show the correct number of Exceptions.

 

Check

 

Check name is EarthSoft.DQM.RadChemRelativeErrorRatio = Radiochemistry Relative Error Ratio.

 

Parameters

 

This check uses the REPORTABLE_RESULT, RESULT_TYPE_CODE and TEST_BATCH_TYPE parameters from Global Parameters. There are nine other parameters:

Medium_code_soil – RT_MATRIX.MEDIUM_CODE for DT_SAMPLE.MATRIX_CODE for soil samples. Defaults to "Soil".

Medium_code_water – RT_MATRIX.MEDIUM_CODE for DT_SAMPLE.MATRIX_CODE for water samples. Defaults to "Water".

Rer_control_limit_other – RPD control limit for other samples. Defaults to 1.

Rer_control_limit_soil – RPD control limit for soil samples. Defaults to 1.

Rer_control_limit_water – RPD control limit for water samples. Defaults to 1.

Sample_type_RadChem_Dup – Defaults to FD.

Rer_upper_cutoff_soil – RPD upper control limit for soil        samples.  Defaults to 2.

Rer_upper_cutoff_water – RPD upper control limit for water samples.  Defaults to 2.

Rer_upper_cutoff_other – RPD upper control limit for other samples.  Defaults to 2.

 

Notes:

The default value is used if there is no record in RT_DQM_CHECK_PARAM for an input parameter.

The default value is used if the PARAM_VALUE is NULL for this parameter in RT_DQM_CHECK_PARAM.

 

Rules

 

There are four rules:

1.RELATIVE ERROR RATIO > CL

2.RELATIVE ERROR RATIO > CL NON_DETECT

3.RELATIVE ERROR RATIO > UCO

4.RELATIVE ERROR RATIO > UCO NON_DETECT

 

The rules are processed the same way, but the qualifier for the first and third rules are applied to results with a detected concentration, and the qualifier for rule two and four are applied to non-detect results.

 

CL = rer_control_limit_[MATRICES]

UCO = rer_upper_cutoff_[MATRICES]

 

Process all results with DT_SAMPLE.SAMPLE_TYPE = SAMPLE_TYPE_RADCHEM_DUP.

Find the parent sample using DT_SAMPLE.PARENT_SAMPLE_CODE or if that value is NULL, then use DT_FIELDQC_BATCH_PARTNER.QC_SAMPLE_ID.

Lookup MEDIUM_CODE = RT_MATRIX.MEDIUM_CODE for DT_SAMPLE.MATRIX_CODE.

Calculate RER = |S - R| / ((S.TPU(1 sigma))^2 + (R.TPU(1 sigma))^2)^0.5 and:

Where S and R = DT_SAMPLE.RESULT_NUMERIC for the sample and the replicate, respectively, and

If DT_RESULT.UNCERTAINTY = "2 sigma", then TPU = DT_RESULT.RESULT_ERROR_DELTA / 1.96.

Otherwise, if DT_RESULT.UNCERTAINTY = "1 sigma", then TPU = DT_RESULT.RESULT_ERROR_DELTA.

 

Then process as follows:

If MEDIUM_CODE = MEDIUM_CODE_SOIL, then qualify the results if

RER  > RER_CONTROL_LIMIT_SOIL or

RER > RER_UPPER_CUTOFF_SOIL

If MEDIUM_CODE = MEDIUM_CODE_WATER, then qualify the results if

RER > RER_CONTROL_LIMIT_WATER or

RER > RER_UPPER_CUTOFF_WATER

If MEDIUM_CODE is different or NULL, qualify the results if

RER > RER_CONTROL_LIMIT_OTHER or

RER > RER_UPPER_CUTOFF_OTHER

 

Then process as follows:

If MEDIUM_CODE = MEDIUM_CODE_SOIL, then qualify the results if RER  > RER_CONTROL_LIMIT_SOIL.

If MEDIUM_CODE = MEDIUM_CODE_WATER, then qualify the results if RER > RER_CONTROL_LIMIT_WATER.

Otherwise, if MEDIUM_CODE is different or NULL, qualify the results if RER > RER_CONTROL_LIMIT_OTHER.

 

Errors

 

In the Errors tab of the DQM Event Review Form, these errors may be listed:

 

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

2."The denominator of RELATIVE ERROR RATIO is 0."
If you receive this error, the check will be skipped.

3."The UNCERTAINTY value of {0} is neither 1 sigma nor 2 sigma."
If you receive this error, the check will be skipped.

4."{FIELDNAME} is NOT Numeric! So, Relative Error Ratio check cannot be completed for Sample, Method, CAS_RN."