<< Click to Display Table of Contents >> Navigation: 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 name is EarthSoft.DQM.RPD_Lab_Field = "Lab versus Field RPD".
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. |
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)).
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.
Copyright © 2023 EarthSoft, Inc • Modified: 14 Jan 2022