DQM Check for Batch Completeness

<< Click to Display Table of Contents >>

Navigation:  Professional > DQM > DQM Checks >

DQM Check for Batch Completeness

The DQM Check for Batch Completeness evaluates a batch of samples to determine if the batch contains all the defined list of Quality Control (QC)samples; if the batch does not exceed a defined number of non-Quality Control samples; and if the analysis times for all samples in the batch are within a defined period of time.

 

Check

Check name is EarthSoft.DQM.BatchCompleteness.

 

Parameters

There are four parameters:

1.non_qc_sample_type = the sample_type for all non-QC samples to be included in the count for the max_number_non_qc_samples parameter (default = “N”)

2.max_number_non_qc_samples = the maximum number of non-QC samples to be included in a batch. This parameter uses both the analytic_method and param_value columns. This parameter may be repeated as needed to differentiate different maximum numbers of non-QC samples required for each analytical method.

a.analytic_method - if the same maximum number of non-QC samples applies to all analytical methods, leave this field null (default). Should there be an analytic method with a different value for the maximum number of non-QC samples, populate the analytic_method column with the applicable analytical method.

b.param_value = maximum number of non-QC samples in a batch (default = 20)

3.required_qc_samples = the list of sample types for all QC samples required to be included in a batch. This parameter uses both the analytic_method and param_value columns. This parameter may be repeated as many times as needed to differentiate different QC sample_types required for each analytical method.

a.analytic_method – if the same QC samples are required to be included in an analytical batch for all methods, leave this field null (default). Should there be an analytic method with different QC sample_types, populate the analytic_method column with the applicable analytical method.

b.param_value = QC sample_types required for the method.

4.max_analysis_hours = the maximum acceptable number of hours elapsed between the analysis of all samples in the batch.

 

Notes:

The default value is used if there is no record in RT_DQM_CHECK_PARAM for an input parameter.

 

Rules

 
There are three rules:
 

1.NUMBER OF SAMPLES EXCEEDED for when the number of non-QC Samples is exceeded in a batch

2.QC SAMPLE MISSING for when a required QC sample type is missing from a batch

3.ANALYSIS TIME EXCEEDED for time between analysis of all samples in the batch is exceeded

 

Errors

 

An error is added if more than one analytical method is assigned to a batch. If this condition is found, the batch will not be evaluated.

 

Exceptions

 

DQM will first evaluate method-specific criteria, where specified, and then evaluate the remainder of the batch against non-method-specific criteria for all remaining methods.

 

When a count of all non-QC sample types > max_number_non_qc_samples, an exception is added for Rule = NUMBER OF SAMPLES EXCEEDED.

 

When a QC sample_type is not contained in a batch, an exception is added for Rule = QC SAMPLE MISSING.

 

When the difference between the minimum and maximum date and time of analysis of all samples in the batch > max_analysis_hours, an exception is added for Rule = ANALYSIS TIME EXCEED.

 

 

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Batch Completeness

DT_SAMPLE

SAMPLE_TYPE_CODE

non_qc_sample_type


RT_ANALYTIC_METHOD

ANALYTIC_METHOD

max_number non_qc_samples,

required_qc_samples


DT_RESULT

RESULT_TYPE_CODE

batch_result_types

                              Associations

DT_TEST

TEST_ID



DT_TEST_BATCH

TEST_BATCH_ID



AT_TEST_BATCH_ASSIGN

TEST_ID




TEST_BATCH_ID