DQM Check for Repeated Results

<< Click to Display Table of Contents >>

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

DQM Check for Repeated Results

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.

 

Check name is EarthSoft.DQM.RepeatedResults.

 

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

 

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.

 

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.