RPD Lab vs Field Check

<< Click to Display Table of Contents >>

Navigation:  DQM > DQM Checks >

RPD Lab vs Field Check

Check

Parameters

Rules

Errors

 

Check for Relative Percent Difference (RPD) values for field and lab results that fall outside Quality Control (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.RPD_Lab_Field = "Lab versus Field RPD".

 

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

 

Six parameters are available for this check. None of these parameters allow for input of method-specific PARAM_VALUEs. However, the lab_field_cas_rns parameter requires the input of CAS_RNs for which an RPD will be determined.

1.lab_field_cas_rns – Populate CAS_RN with the Lab result DT_RESULT.CAS_RN; populate PARAM_VALUE with the Field result DT_RESULT.CAS_RN.

2.medium_code_soil – RT_MATRIX.MEDIUM_CODE for DT_SAMPLE.MATRIX_CODE for soil samples. Defaults to “Soil”.

3.medium_code_water – RT_MATRIX.MEDIUM_CODE for DT_SAMPLE.MATRIX_CODE for water samples. Defaults to “Water”.

4.rpd_control_limit_other – RPD control limit for other samples. Defaults to 25.

5.rpd_control_limit_soil – RPD control limit for soil samples. Defaults to 35.

6.rpd_control_limit_water – RPD control limit for water samples. Defaults to 20.

 

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

 

Rules

 

There is one (1) rule, "LAB FIELD RPD". The first steps are:

a) Find the lab results with DT_RESULT.CAS_RN = lab_field_cas_rns.CAS_RN and then:

b) Find the matching field results with DT_RESULT.CAS_RN = lab_field_cas_rns.PARAM_VALUE.

c) Process both results by calculating the RPD.
RPD = 100 * ABS_VAL(resultField - resultLab) / (0.5 * ABS_VAL(resultField + resultLab)).

oIf the MEDIUM_CODE of DT_SAMPLE.MATRIX_CODE = medium_code_soil, then:

qualify the results if RPD> rpd_control_limit_soil.

oIf the MEDIUM_CODE of DT_SAMPLE.MATRIX_CODE = medium_code_water, then:

qualify the results if RPD> rpd_control_limit_water.

oOtherwise, if MEDIUM_CODE of DT_SAMPLE.MATRIX_CODE is different or NULL, then:

qualify the results if RPD> rpd_control_limit_other.

 

 

Errors

 

In the Errors tab of the DQM Event Review Form, this error 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.