Batch Completeness Check

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

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

Six parameters (listed below) are available for this check. None of these parameters allow analyte-specific PARAM_VALUEs, with the exception of required_qc_samples allowing PARAM_VALUE = "CALC" to exclude the specified analyte; however max_number_non_qc_samples and required_qc_samples allow 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 testing for analysis time exceeded. The default value is “N”.

3.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”)

4.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. If ANALYTIC_METHOD is populated and PARAM_VALUE is null, then that analytic method will be skipped.

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). If ANALYTIC_METHOD is populated and PARAM_VALUE is null, that analytic method will be skipped.

5.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 samples required for each analytical method. If ANALYTIC_METHOD is populated and PARAM_VALUE is null, then that analytic method will be skipped.

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 – List of QC SAMPLE_TYPEs required for the method separated by commas. SAMPLE_TYPEs can be separated by pipes '|' to require any SAMPLE_TYPE from a list, for example "BS|LCS,MB|LB" would require sample types BS or LCS and MB or LB. If populated with the value "CALC", the ANALYTIC_METHOD and/or CAS_RN will be skipped for this check.

6.max_analysis_hours – the maximum acceptable number of hours elapsed between the analysis of all samples in the batch.

Note: Default parameter values listed above refer to the value provided in the DQM Starter QAPP.xlsx.

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

DQM results are found by matching TEST_BATCH_ID and will flag all the results for that TEST_BATCH_ID that match reportable_result and result_type_code.

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 required_qc_samples 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.

Errors

In the Errors Tab of the DQM Event Review Form, these errors may be listed:

1.One of the required rules for this check is not present in the RT_DQM_RULE table.
If this error is received, the check will be skipped. Alternately, the QAPP can be updated following the How to Update Existing QAPPs documentation page.

2.More than one analytic method associated with test batch id.
If this condition is found, the batch will not be evaluated.

3.No analytic methods associated with test batch id.
If this condition is found, the batch will not be evaluated.