Dissolved vs Total Check

This is a Check for Dissolved concentrations that are greater than Total concentrations.

Check

Check name is EarthSoft.DQM.DissolvedVsTotal = Dissolved Vs Total

Parameters

This check uses eleven parameters:

1.Multiplier – Multiplier used with detection limit in the RPD check to test for results > multiplier * detection limit. Defaults to five (5).

2.AD_multiplier_CL – Upper Control Limit Multiplier used with detection limit in the absolute difference check to test for results > AD_multiplier_CL * detection limit. Defaults to 1.

3.AD_multiplier_DL – Multiplier used non-detect results = AD_multiplier_DL * detection limit . Defaults to 1.

4.AD_multiplier_UCO – Upper Cutoff Multiplier used with detection limit in the absolute difference rule to test for results > AD_multiplier_UCO * detection limit. Defaults to zero (0).
Note: Upper Cutoff check is skipped if the parameter value is zero (0).

5.RPD_CL – The Upper Control Limit for the RPD check to test for RPD > RPD_CL. Defaults to zero (0).

6.RPD_UCO – The Upper Cutoff for the RPD check to test for RPD > RPD_UCO. Defaults to 0.
Note: Upper Cutoff check is skipped if the parameter value is zero (0).

7.detection_limit – The detection limit column to use first. Defaults to reporting_detection_limit.
Note: if the detection limit value is null, the check will try to find a non-null detection limit value from one of the other columns.

8.dissolved_fraction –The fraction(s) of dissolved results. Defaults to D.

9.total_fraction – The fraction(s) of total results. Defaults to T.

10.sample_types – Which SAMPLE_TYPE to use. Defaults to N.

11.result_types - Which RESULT_TYPE to use. Defaults to TRG.

Rules

For all rules, the Dissolved Result was greater than the Total Result. The first two rules apply to results that that satisfy this statement:
DT_RESULT.RESULT_NUMERIC >= multiplier * DT_RESULT.REPORTING_DETECTION_LIMIT.

If the result is less than the multiplier * detection limit, then the last two rules will be used.

•DIS > TOT & RPD > CL – The relative percent difference (RPD) between the results was higher than the upper control limit (RPD_CL).

•DIS > TOT & RPD > UCO - The relative percent difference (RPD) between the results was higher than the upper cutoff (RPD_UCO).

•DIS > TOT & ABS DIFF > AD_MULTIPLIER_CL * DL – The absolute difference was greater than the upper control limit AD_Multiplier_CL * Detection Limit.

•DIS > TOT & ABS DIFF > AD_MULT_UCO * DL - The absolute difference was greater than the upper cutoff AD_Multiplier_UCO * Detection Limit.

Exceptions (where table is not indicated, it is DT_RESULT_QC)

Review results with DT_SAMPLE.SAMPLE_TYPE_CODE = sample_types, DT_RESULT.RESULT_TYPE_CODE = result_types, and DT_TEST.FRACTION = dissolved_fraction.

Find the total sample using equal DT_SAMPLE.SYS_SAMPLE_CODE, DT_RESULT.CAS_RN, DT_TEST.ANALYTIC_METHOD and DT_TEST.FRACTION = total_fraction .

TEST #1:

If DT_RESULT.RESULT_NUMERIC for the Dissolved fraction > DT_RESULT.RESULT_NUMERIC for the Total fraction, then proceed with Test 2 and 3. If not, then the check stops on that sample.

TEST #2:

For both samples, is DT_RESULT.RESULT_NUMERIC >= multiplier * DT_RESULT.REPORTING_DETECTION_LIMIT?

•If TRUE, then calculate rpd

•If rpd is not 0 and rpd > rpd_uco, then qualify the results.

•Else if rpd > rpd_cl, then qualify the results.

TEST #3 (if TEST #2 = FALSE):

ABS_DIFF = absolute difference in the dissolved and total concentrations = ABS(dissolved - total).

Detection_Limit = detection limit if it is not null, otherwise the value in the first column that is not NULL:

oDT_RESULT.REPORTING_DETECTION_LIMIT

oDT_RESULT.QUANTITATION_LIMIT

oDT_RESULT.METHOD_DETECTION_LIMIT

•If the ABS_DIFF > AD_multiplier_UCO * Detection_Limit, then qualify the results.

•Else if the ABS_DIFF > AD_multiplier_CL * Detection_Limit, then qualify the results.

oWhere detect_flag = N, the Detection Limit multiplied for the AD_MULTIPLIER_DL is used as the value for the concentration of the non-detected result.

Calculations (where table is not indicated, it is DT_RESULT_QC)

rpd = 100 * ABS_DIFF / (0.5 * (DT_RESULT.RESULT_NUMERIC + DT_RESULT.RESULT_NUMERIC from Total Result)).

Errors (where table is not indicated, it is DT_RESULT_QC)

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

For Laboratory Duplicates the missing data (below) will result in errors:

•If DT_RESULT.REPORTING_DETECTION_LIMIT, DT_RESULT.QUANTITATION_LIMIT, and DT_RESULT.METHOD_DETECTION_LIMIT are NULL then add error and skip result.

Example Error

"The Detection Limit is Not Numeric."