DQM Check for RPD Lab vs Field

<< Click to Display Table of Contents >>

EQuIS 7  >>  Professional > Modules > DQM > DQM Checks >

DQM Check for RPD Lab vs Field

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:

"LAB FIELD RPD"

Calculate RPD and:

If the MEDIUM_CODE of DT_SAMPLE.MATRIX_CODE = MEDIUM_CODE_SOIL, then qualify the results if RPD> RPD_CONTROL_LIMIT_SOIL.

If the MEDIUM_CODE of DT_SAMPLE.MATRIX_CODE = MEDIUM_CODE_WATER, then qualify the results if RPD> RPD_CONTROL_LIMIT_WATER.

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