DQM Check for Surrogate Recovery

<< Click to Display Table of Contents >>

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

DQM Check for Surrogate Recovery

The DQM Check for Surrogate Recovery will qualify results if surrogate recoveries fall outside Quality Control (QC) limits.

 

Notes:

The QC_SPIKE_RECOVERY column or both of the QC_SPIKE_ADDED and QC_SPIKE_MEASURED columns must be populated in DT_RESULT_QC for this check to function.

If the sample is a duplicate sample, then DQM will look first in QC_DUP_SPIKE_RECOVERY (or QC_DUP_SPIKE_ADDED and QC_DUP_SPIKE_MEASURED). If those columns do not contain data, then QC_SPIKE_RECOVERY (or QC_SPIKE_ADDED and QC_SPIKE_MEASURED) are checked.

For duplicate samples, QC_DUP_SPIKE_RECOVERY can be substituted for all references to QC_SPIKE_RECOVERY below.

Control limits for this check are determined as described in the RT_DQM_CONTROL_LIMITS section of this page.

 

Check name is EarthSoft.DQM.SurrogateRecovery = Surrogate Recovery.

 

This check uses the REPORTABLE_RESULT, RESULT_TYPE_CODE and tEST_BATCH_TYPE parameters from Global Parameters. There are three other parameters:

result_type_code_surrogate – Defaults to “SUR”.

secondSurrogate – If “Y”, then a second surrogate must fail the same rule (e.g., REC > UCL) before Associated Results are qualified; depends on ANALYTIC_METHOD. Defaults to “N” if no parameter is found in DQM Settings for the analytic method of the surrogate in question.

asso_acid_base_yn – Defaults to "N" if not found. The DQM Demo EDD has this parameter set to "Y".

 

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 are nine rules and for results with DT_RESULT.RESULT_TYPE_CODE = result_type_code_surrogate:

 

Rule #

Rule Description

Result Types

DQM_RULE

1

% Recovery > Upper Control Limit (UCL)

Surrogate Results

REC > UCL

2

Associated Results with Detection

ASSO. DETECTS OF REC > UCL

3

Associated Non-Detect Results

ASSO. NDS OF REC > UCL

4

Lower Control Limit (LCL) > % Recovery > = Low_Cutoff

Surrogate Results

LCL > REC > LOW_CUTOFF

5

Associated Results with Detection

ASSO. DETECTS OF LCL > REC > LOW_CUTOFF

6

Associated Non-Detect Results

ASSO. NDS OF LCL > REC > LOW_CUTOFF

7

% Recovery<Low_Cutoff

Surrogate Results

REC < LOW_CUTOFF

8

Associated Results with Detection

ASSO. DETECTS OF REC < LOW_CUTOFF

9

Associated Non-Detect Results

ASSO. NDS OF REC < LOW_CUTOFF

 

Exceptions

If surrRecovery > surr_ucl, then qualify spike result and any associated result with a detected concentration.

If surr_lco = < surrRecovery < surr_lcl, then qualify spike result and any associated result.

If surrRecovery < surr_lco, then qualify spike result and any associated result.

 

Calculations

 

Where table is not indicated, it is DT_RESULT_QC.  RT_DQM_CONTROL_LIMITS is discussed in more detail here.

 

If QC_SPIKE_RECOVERY is Numeric,

othen surrRecovery = QC_SPIKE_RECOVERY

oelse surrRecovery = 100 * QC_SPIKE_MEASURED / QC_SPIKE_ADDED

If RT_DQM_CONTROL_LIMITS.SURR_REC_LOWER_CUTOFF is Numeric,

othen surr_lco = RT_DQM_CONTROL_LIMITS.SURR_REC_LOWER_CUTOFF

oelse surr_lco = RT_HOLDING_TIME.LOWER_SURROGATE_CUTOFF

If RT_DQM_CONTROL_LIMITS.SURR_RECOVERY_LCL is Numeric,

othen surr_lcl = RT_DQM_CONTROL_LIMITS.SURR_RECOVERY_LCL

oelse surr_lcl = QC_SPIKE_LCL

If RT_DQM_CONTROL_LIMITS.SURR_RECOVERY_UCL is Numeric,

othen surr_ucl = RT_DQM_CONTROL_LIMITS.SURR_RECOVERY_UCL

oelse surr_ucl = QC_SPIKE_UCL

 

Associations

Associated results are found using DT_TEST.TEST_ID.

Different qualifiers may be specified for those associated results with a detected concentration, and for those without (i.e. non-detect).

If secondSurrogate = “Y”, then a second surrogate must fail the same rule (e.g. REC > UCL) before Associated Results are qualified; depends on ANALYTIC_METHOD -- defaults to “N” if no parameter is found in DQM Settings for the analytic method of the surrogate in question.

For some surrogates, such as acid and base surrogates for analytic method SW8270, a more specific list of Associated Results is desired. To accommodate this scenario, DQM uses a special DQM_QAPP_CODE for defining the associations so that the numerous records do not need to be repeated for each DQM QAPP (otherwise, these records would need to be duplicated for each surrogate). To create a surrogate-specific list of CAS_RNs to associate, enter the following for each analyte to be associated. If the new Surrogate Recovery check parameter asso_acid_base_yn = 'Y' and the RT_DQM_CONTROL_LIMITS table contains at least one QAPP_SURR_ASSO_CAS_RN record with SURR_ASSO_CAS_RN equal to the surrogate with a recovery outside of control limits, then only those CAS_RNs will be associated with the failing surrogate.

oDQM_QAPP_CODE = 'QAPP_SURR_ASSO_CAS_RN'

oMATRIX_CODE

oANALYTIC_METHOD

oRESULT_TYPE_CODE = 'TRG'

oCAS_RN = the CAS_RN of analyte to be associated

oSURR_ASSO_CAS_RN = the CAS_RN of the surrogate

 

Errors

 

Where table is not indicated, the table is DT_RESULT_QC.

If QC_SPIKE_RECOVERY, QC_SPIKE_ADDED, and QC_SPIKE_MEASURED are all NULL or Not Numeric, then add error and skip result.

If QC_SPIKE_RECOVERY is NULL or Not Numeric, and either QC_SPIKE_ADDED or QC_SPIKE_MEASURED are also NULL or Not Numeric, then add error and skip result.

If the Lower Control Limit or the Upper Control Limit is NULL or Not Numeric in both RT_DQM_CONTROL_LIMITS and DT_RESULT_QC, then add error and skip result.

If the Surrogate Recovery Lower Cutoff is NULL or Not Numeric in both RT_DQM_CONTROL_LIMITS and RT_HOLDING_TIME, then add warning and process result using zero for the lower cutoff value.