RPD Lab vs Field Check

<< Click to Display Table of Contents >>

Navigation:  Professional > DQM > DQM Checks >

RPD Lab vs Field Check

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 the REPORTABLE_RESULT, RESULT_TYPE_CODE and TEST_BATCH_TYPE parameters from Global Parameters. There are six other parameters:

lab_field_cas_rns – DT_RESULT.CAS_RN of the Lab result in the CAS_RN column; DT_RESULT.CAS_RN of the Field result in the PARAM_VALUE column.

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

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

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

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

 

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 is one (1) rule and the first steps are:

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

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

c) Process both results using this rule:

o"LAB FIELD RPD"

oCalculate RPD and:

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 is different or NULL, qualify the results if RPD> RPD_CONTROL_LIMIT_OTHER.

 

The equation for RPD = 100 * ABS_VAL(resultField - resultLab) / (0.5 * ABS_VAL(resultField + resultLab)).

 

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.