<< Click to Display Table of Contents >> Navigation:  DQM > DQM Checks > Repeated Results Check

 

The DQM Check for Repeated Results checks for any instances where more than one result was reported for a given sample, method, analyte, and fraction and allows the user to select which result is reportable. There are two methods to check for repeated results.

 

Check for Repeated Results – Single Method

 

Check if two or more results exist for the same sample/method/fraction/analyte.

 

Two parameters (listed below) are available for this check. None of these parameters allow analyte-specific or method-specific PARAM_VALUEs.

 

1. result_type_code – the result type(s) of the results to be included in this check. The default value is “TRG”.

2. sample_type_code – the sample type(s) of the samples to be included in this check. The default value is “N”.

 

Check

 

Check name is EarthSoft.DQM.RepeatedResults.

 

Parameters

 

This check uses three Global Parameters:

1.reportable_result – DT_RESULT.REPORTABLE_RESULT values to include in DQM datasets

2.result_type_code – DT_RESULT.RESULT_TYPE_CODE to include in DQM datasets

3.test_type_batch – AT_TEST_BATCH_ASSIGN.TEST_BATCH_TYPE to include in DQM dataset

 

Rules

 

There is one rule:
REPEATED RESULTS = two or more results in DT_RESULT are listed as Exceptions if there is more than one result with the same:

a.SAMPLE_ID,

b.ANALYTIC_METHOD,

c.CAS_RN, and

d.FRACTION.

 

This data can exist if the lab submits the INITIAL result package and a RETEST or REANALYSIS result package for the same set of samples.

 

DQM will allow the user to mark one package as REPORTABLE_RESULT = "Yes", and the other one as REPORTABLE_RESULT = 'No", by using the steps outlined below.

 

Check for Repeated Results – Multiple Methods

 

Check if two or more results exist for the same sample, fraction, analyte.

 

Check name is EarthSoft.DQM.RepeatedResultsTwoMethods.

 

This check uses the REPORTABLE_RESULT, result_type_code, and TEST_BATCH_TYPE parameters from Global Parameters.

 

Two parameters (listed below) are available for this check. None of these parameters allow analyte-specific or method-specific PARAM_VALUEs.

 

1. result_type_code – the result type(s) of the results to be included in this check. The default value is “TRG”.

2. sample_type_code – the sample type(s) of the samples to be included in this check. The default value is “N”.

 

There is one rule:
REPEATED RESULTS - TWO METHODS = two or more results in DT_RESULT listed as Exceptions if there is more than one result with the same:

a.SAMPLE_ID,

b.CAS_RN, and

c.FRACTION.

 

This data can exist if two or more methods containing the same analytes are run on the same set of samples.

 

DQM will allow the user to mark one package as REPORTABLE_RESULT = "Yes", and the other one as REPORTABLE_RESULT = 'No", by using the steps outlined below.

 

Steps to Change REPORTABLE_RESULT

 

On the DQM Process Event Form:

•Select the Exceptions by Check tab.

•Select Repeated Results in the Check drop-down list.

•Use the column filter to show only the results to retain as reportable. For example:

▪TEST_TYPE = REANALYSIS or

▪ANALYTIC_METHOD = SW8260.

•Delete all of the R's from the APPLY_QUALIFIER column by:

▪Leaving the yellow text box empty, and

▪Clicking the Update Apply Q button.

•Save the Event.

 

On the Complete Event Form:

•Check the Change Reportable Result option (and others as appropriate).

•Click the Save button.

 

By default* this will change DT_RESULT.REPORTABLE_RESULT to "No" for those results saved with the APPLY_QUALIFIER = "R" indicating a Rejected Result.

 

*Users are encouraged to review and customize the Global Parameters via the DQM Settings Form.

 

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.