Radio Chemistry Relative Error Ratio Check

<< Click to Display Table of Contents >>

Navigation:  DQM > DQM Checks >

Radio Chemistry Relative Error Ratio Check

Check

Parameters

Rules

Errors

 

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

 

Check

 

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

 

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

 

Nine parameters are available for this check. None of these parameters allow for analyte-specific or method-specific PARAM_VALUEs.

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

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

3.Rer_control_limit_other – Control limit for other samples. Defaults to 1.

4.Rer_control_limit_soil – Control limit for soil samples. Defaults to 1.

5.Rer_control_limit_water – Control limit for water samples. Defaults to 1.

6.Sample_type_RadChem_Dup – Defaults to "FD".

7.Rer_upper_cutoff_soil – Upper control limit for soil samples.  Defaults to 2.

8.Rer_upper_cutoff_water – Upper control limit for water samples.  Defaults to 2.

9.Rer_upper_cutoff_other – Upper control limit for other samples.  Defaults to 2.

 

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

 

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 which rule is used depends on the DETECT_FLAG for the child result (i.e. DT_SAMPLE.SAMPLE_TYPE = sample_type_radchem_dup). For example, the first and third rules are applied to the pair when the child result is a detect (DETECT_FLAG=Y).  The second and fourth rules are applied to the pair when the child result is a non-detect (DETECT_FLAG=N).

 

The DETECT_FLAG for the result being qualified determines whether the QUALIFIER or ND_QUALIFIER from the applicable RT_DQM_RULE is used.

 

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

 

 

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

5."Radio Chemistry Duplicate Parent Sample missing."
If you receive this error, the check is skipped on the radio chemistry duplicate pair. There may be more than one radio chemistry duplicate pair in the dataset and if both samples are present, the check will run on the other pair.