DT_SAMPLE

DT_FIELD_SAMPLE

DT_TEST

DT_RESULT

DT_RESULT_QC

DT_CHAIN_OF_CUSTODY

DT_FIELDQC_BATCH_PARTNER

DT_TEST_BATCH

AT_TEST_BATCH_ASSIGN

RT_DQM_CONTROL_LIMITS

RT_HOLDING_TIME

RT_DQM_CHECK_PARAM

RT_ANALYTE

RT_MATRIX

RT_MTH_ANL_GROUP_MEMBER

RT_UNIT

RT_UNIT_CONVERSION_FACTOR

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Every Check

DT_RESULT

REPORTABLE_RESULT

GlobalParameters:

reportable_result

RESULT_TYPE_CODE

GlobalParameters:
result_type_code

DT_TEST_BATCH

TEST_BATCH_TYPE

GlobalParameters:

test_batch_type

Database Relationship Parent Tables

Related Columns

RT_ANALYTIC_METHOD

ANALYTIC_METHOD

RT_FRACTION

FRACTION

RT_PREP_METHOD

PREP_METHOD

RT_PRESERVATIVE

PRESERVATIVE

RT_RESULT_TYPE

RESULT_TYPE_CODE

RT_SAMPLE_TYPE

SAMPLE_TYPE_CODE

RT_TEST_BATCH_TYPE

TEST_BATCH_TYPE

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Batch Completeness

DT_SAMPLE

SAMPLE_TYPE_CODE

non_qc_sample_type and

required_qc_samples

DT_TEST

ANALYTIC_METHOD

ANALYSIS_DATE

                              Associations

DT_TEST

TEST_ID

DT_TEST_BATCH

TEST_BATCH_ID

AT_TEST_BATCH_ASSIGN

TEST_ID

TEST_BATCH_ID

TEST_BATCH_TYPE

Check Parameters

sample type(s) for non-QC samples in each test batch for the Batch Completeness Check

non_qc_sample_type

(in RT_DQM_CHECK_PARAM)

maximum number of non-QC samples in each test batch (if no method is specified, sets the default value)

max_number_non_qc_samples

sample types of required QC samples in each test batch (if no method is specified, sets the default value)

required_qc_samples

maximum number of hours between analysis runs for each test batch

max_analysis_hours

sample_type(s) for the Batch Completeness Check

sample_type_code

result_type(s) for the Batch Completeness Check

result_type_code

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Dilution Factor

DT_SAMPLE

SAMPLE_TYPE_CODE

sample_type_code

DT_RESULT

DILUTION_FACTOR

RESULT_TYPE_CODE

result_type_code

DETECT_FLAG

non_detect_only

Check Parameters
(in RT_DQM_CHECK_PARAM)

sample type(s) for Dilution Factor  check

sample_type_code

result type(s) for Dilution Factor check

result_type_code

Y/N option to only review results with
DETECT_FLAG = N

non_detect_only

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Dissolved vs Total

DT_SAMPLE

SAMPLE_TYPE_CODE

sample_type_code

DT_TEST

ANALYTIC_METHOD

FRACTION

DT_RESULT

CAS_RN

RESULT_TYPE_CODE

result_type_code

REPORTING_DETECTION_LIMIT
or

QUANTITATION_LIMIT

or

METHOD_DETECTION_LIMIT

detection_limit

Check Parameters
(in RT_DQM_CHECK_PARAM)

multiplier used with detection limit in the RPD check to test for results > multiplier*detection limit

multiplier

upper control limit multiplier used with detection limit in the absolute difference check for testing results > AD_multiplier_CL*detection limit

AD_multiplier_CL

multiplier used for non-detect results =AD_multiplier_DL*detection limit

AD_multiplier_DL

upper cutoff multiplier used with the detection limit in the absolute difference rule for testing results > AD_multiplier_UCO*detection limit

AD_multiplier_UCO

upper control limit for testing RPD > RPD_CL

RPD_CL

upper cutoff for testing RPD > UCO

RPD_UCO

the detection limit column to use for Dissolved vs Total check

detection_limit

fraction(s) for the dissolved results

dissolved_fraction

fraction(s) for the total results

total_fraction

sample type(s) for Dissolved vs Total check

sample_type_code

result type(s) for Dissolved vs Total check

result_type_code

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Estimated results
(MQL < X < PQL)

DT_SAMPLE

SAMPLE_TYPE_CODE

sample_type_code

DT_RESULT

DETECT_FLAG

METHOD_DETECTION_LIMIT

RESULT_NUMERIC

RESULT_TYPE_CODE

result_type_code

REPORTING_DETECTION_LIMIT
or

QUANTITATION_LIMIT

estimated_detection_limit

RT_ANALYTE

ORGANIC_YN

Check Parameters
(in RT_DQM_CHECK_PARAM)

sample type(s) for Estimated Results  check

sample_type_code

result type(s) for Estimated Results check

result_type_code

Detection limit column to use when checking for Estimated Results -
reporting_detection_limit or quantitation_limit Column(s)

estimated_detection_limit

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Field Blank Contamination

DT_SAMPLE

SAMPLE_TYPE_CODE

AmbientBlankSampleType,
EquipmentBlankSampleType,
FieldBlankSampleType, and
normal_sample_type

MATRIX_CODE

DT_TEST

ANALYTIC_METHOD

PREP_METHOD

DT_RESULT

CAS_RN

DETECT_FLAG

RESULT_NUMERIC

RESULT_UNIT

REPORTING_DETECTION_LIMIT
or
QUANTITATION LIMIT*

Global Parameters:
non_detect_detection_limit

RT_DQM_CONTROL_LIMITS

BLANK_MULTIPLIER - for each row in table (if populated, this multiplier overrides check parameter
multiplier)

Automatic Associations

DT_RESULT

CAS_RN

and

DT_FIELDQC_BATCH_PARTNER

QC_SAMPLE_ID

SAMPLE_ID

or

DT_FIELD_SAMPLE

FIELD_SDG

or

DT_CHAIN_OF_CUSTODY

CHAIN_OF_CUSTODY

Manual Associations

DT_RESULT

CAS_RN

and

DT_FIELDQC_BATCH_PARTNER

QC_SAMPLE_ID

SAMPLE_ID

Check Parameters
(in RT_DQM_CHECK_PARAM)

multiplier used to evaluate when a result can be set to Non-Detect and Qualifier = 'U' due to blank contamination by a common lab contaminant.
CAS_RN must be populated for each common laboratory contaminant.

common_lab_multiplier

TRUE = add qualifiers to blank result row; FALSE = do not add qualifiers to blank result row

flag_blank

multiplier used to evaluate when a result can be set to Non-Detect and Qualifier = 'U' due to blank contamination

multiplier

Sample Type Code for Ambient Blank

AmbientBlankSampleType

Sample Type Code for Equipment Blank

EquipmentBlankSampleType

Sample Type Code for Field Blank

FieldBlankSampleType

sample type(s) for manual association with field blank samples

normal_sample_types

result_type(s) for the Field Blank Contamination check

result_type_code

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Lab Blank Contamination

DT_SAMPLE

SAMPLE_TYPE_CODE

LabBlankSampleType,
MethodBlankSampleType,
normal_sample_types

MATRIX_CODE

DT_TEST

ANALYTIC METHOD

PREP_METHOD

DT_RESULT

DETECT_FLAG

CAS_RN

RESULT_NUMERIC

RESULT_UNIT

REPORTING_DETECTION_LIMIT

or

QUANTITATION_LIMIT*

Global Parameters:

non_detect_detection_limit

RT_DQM_CONTROL_LIMITS

BLANK_MULTIPLIER -for each row in table (if populated, this multiplier overrides check parameter
multiplier)

Lab Blank Associations

DT_RESULT

CAS_RN

and

DT_TEST

TEST_ID

DT_TEST_BATCH

TEST_BATCH_ID

AT_TEST_BATCH_ASSIGN

TEST_ID

TEST_BATCH_ID

TEST_BATCH_TYPE

test_batch_type

or

DT_TEST

LAB_SDG

Check Parameters

(in RT_DQM_CHECK_PARAM

multiplier used to evaluate when a result can be set to Non-Detect and Qualifier = 'U' due to blank contamination by a common lab contaminant. CAS_RN must be populated for each common laboratory contaminant

common_lab_multiplier

TRUE = add qualifiers to blank result row; FALSE = do not add qualifiers to blank result row

flag_blank

multiplier used to evaluate when a result can be set to Non-Detect and Qualifier = 'U' due to blank contamination

multiplier

Sample Type Code for Lab Blank

LabBlankSampleType

Sample Type Code for Method Blank

MethodBlankSampleType

sample type(s) for association with laboratory blank samples

normal_sample_types

result_type(s) for the Field Blank Contamination check

result_type_code

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Field Duplicate RPD

DT_SAMPLE

SAMPLE_TYPE_CODE

sample_type_field_dup

PARENT_SAMPLE_CODE

MATRIX_CODE

DT_FIELDQC_BATCH_PARTNER

QC_SAMPLE_ID

SAMPLE_ID

DT_TEST

ANALYTIC_METHOD

PREP_METHOD

DT_RESULT

CAS_RN

RESULT_NUMERIC

DETECT_FLAG

REPORTING_DETECTION_LIMIT
 OR
QUANTIFICATION_LIMIT (if REPORTING_DETECTION_LIMIT is NULL)
 OR

METHOD_DETECTION_LIMIT (if above are both NULL)

field_dup_detection_limit

RT_DQM_CONTROL_LIMITS

FIELD_DUP_RPD_CL for each row in table- if populated, this control limit overrides check parameter control  limits

RT_MATRIX

MEDIUM_CODE

Field Duplicate Associations

DT_RESULT

CAS_RN

and

DT_SAMPLE

PARENT_SAMPLE_CODE

or

DT_FIELDQC_BATCH_PARTNER

QC_SAMPLE_ID

SAMPLE_ID

Check Parameters
(in RT_DQM_CHECK_PARAM)

rpd_control_limit_soil applied to samples whose matrix_code has this medium_code in rt_matrix

medium_code_soil

rpd_control_limit_water applied to samples whose matrix_code has this medium_code in rt_matrix

medium_code_water

multiplier used in initial test for results with concentrations > multiplier * detection limit

multiplier

multiplier used with detection limit for Soil results with concentrations < multiplier * detection limit

multiplier_soil

multiplier used to define non-detect results =AD_multiplier_DL * detection limit

AD_multiplier_DL

control limit for Other results

rpd_control_limit_other

control limit for Soil results

rpd_control_limit_soil

control limit for Water results

rpd_control_limit_water

Sample Type Code for Field Duplicate sample

sample_type_Field_Dup

detection limit column to use in Field RPD calculation value tests

field_dup_detection_limit

result_type_code

result_type_code

Y/N option to compare calculated RPD to reported RPD for Field Dup samples

compare_to_reported_field_dup

acceptable variance when comparing calculated RPD to reported RPD for Field Dup samples

acceptable_variance_field_dup

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Holding Times

DT_SAMPLE

SAMPLE_DATE

SAMPLE_TYPE_CODE

sample_type_code

MATRIX_CODE

DT_TEST

ANALYTIC_METHOD

MATRIX_CODE

LEACHATE_DATE

PREP_DATE

ANALYSIS_DATE

PRESERVATION_DATE

PRESERVATIVE

DT_RESULT

RESULT_TYPE_CODE

result_type_code

CAS_RN

RT_HOLDING_TIME

Appropriate intervals should be populated for each row in table

RT_MATRIX

MEDIUM_CODE

Check Parameters
(in RT_DQM_CHECK_PARAM)

multiplier to set Gross Exceedance of Holding Times

grossRejectFactor

Y = use qualifiers in DQM Rule; N = use qualifiers in rt_holding_time

useRuleQualifiers

Option to check holding times for Collect to Analysis (preserved) and (Unpreserved)
based upon whether DT_TEST.PRESERVATIVE is populated

check_preserved_single_row

sample type(s) for Holding Times check

sample_type_code

result type(s) for Holding Times check

result_type_code

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Lab versus Field RPD

DT_SAMPLE

SAMPLE_ID

MATRIX_CODE

DT_RESULT

CAS_RN

RESULT_NUMERIC

RT_MATRIX

MEDIUM_CODE

Check Parameters

lab-field cas_rn pairs for comparison

lab_field_cas_rns

(in RT_DQM_CHECK_PARAM)

rpd_control_limit_soil applied to samples whose matrix_code has this medium_code in rt_matrix

medium_code_soil

rpd_control_limit_water applied to samples whose matrix_code has this medium_code in rt_matrix

medium_code_water

control limit for Other results

rpd_control_limit_other

control limit for Soil results

rpd_control_limit_soil

control limit for Water results

rpd_control_limit_water

sample_type(s) for the Lab versus Field RPD

sample_type_code

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Relative Percent Difference (RPD)

RT_MATRIX

MEDIUM_CODE

RT_DQM_CONTROL_LIMITS

CLs for Matrix Spike, Laboratory Control Sample, and Laboratory Duplicate for each row in table - if
populated these control limits override control limits in QC_RPD in the lab EDD.

Blank Spikes

DT_SAMPLE

SAMPLE_TYPE_CODE

sample_type_LCSD

MATRIX_CODE

DT_TEST

ANALYTIC_METHOD

PREP_METHOD

DT_RESULT

CAS_RN

RESULT_TYPE_CODE

sample_result_type_1

DT_RESULT_QC

QC_RPD

or QC_SPIKE_RECOVERY (if QC_RPD is NULL)

and QC_DUP_SPIKE_RECOVERY (if QC_RPD is NULL)

or QC_ORIGINAL_CONC (if use_conc_for_calc is Y)

and QC_DUP_ORIGINAL_CONC (if use_conc_for_calc is Y)

QC_RPD_CL (if RT_DQM_CONTROL_LIMITS column is NULL)

Blank Spike Associations

DT_RESULT

CAS_RN

and

DT_TEST

TEST_ID

DT_TEST_BATCH

TEST_ BATCH_ID

AT_TEST_BATCH_ASSIGN

TEST_ID

TEST_BATCH_ID

TEST_BATCH_TYPE

Matrix Spikes

DT_SAMPLE

SAMPLE_TYPE_CODE

sample_type_MSD

MATRIX_CODE

PARENT_SAMPLE_CO

DT_TEST

ANALYTIC_METHOD

PREP_METHOD

DT_RESULT

CAS_RN

RESULT_TYPE_CODE

sample_result_type_2

DT_RESULT_QC

QC_RPD

or QC_SPIKE_RECOVERY (if QC_RPD is NULL)

and QC_DUP_SPIKE_RECOVERY (if QC_RPD is NULL)

or QC_ORIGINAL_CONC (if use_conc_for_calc is Y)

and QC_DUP_ORIGINAL_CONC (if use_conc_for_calc is Y)

QC_RPD_CL (if RT_DQM_CONTROL_LIMITS column is NULL)

Matrix Spike Associations

DT_RESULT

CAS_RN

and

DT_SAMPLE

PARENT_SAMPLE_CODE

Lab Duplicates

DT_SAMPLE

SAMPLE_TYPE_CODE

sample_type_Orig_Dup

MATRIX_CODE

PARENT_SAMPLE_CODE

DT_TEST

ANALYTIC_METHOD

PREP_METHOD

DT_RESULT

CAS_RN

RESULT_TYPE_CODE

sample_result_type_3

DETECT_FLAG

RESULT_NUMERIC

REPORTING_DETECTION_LIMIT

or QUANTIFICATION_LIMIT (if REPORTING_DETECTION_LIMIT is NULL)

or METHOD_DETECTION_LIMIT (if above are both NULL)

Lab Duplicate Associations

DT_RESULT

CAS_RN

DT_SAMPLE

PARENT_SAMPLE_CODE

and

DT_TEST

TEST_ID

DT_TEST_BATCH

TEST_BATCH_ID

AT_TEST_BATCH_ASSIGN

TEST_ID

TEST_BATCH_ID

Check Parameters
(in RT_DQM_CHECK_PARAM)

acceptable variance when comparing calculated RPD to reported RPD for LCSD samples (%)

acceptable_variance_LCSD

acceptable variance when comparing calculated RPD to reported RPD for MSD samples (%)

acceptable_variance_MSD

acceptable variance when comparing calculated RPD to reported RPD for Lab Dup samples (%)

acceptable_variance_lab_dup

For Lab Duplicates – the multiplier will be used to all sample with a matrix_code that has this medium_code

medium_code_soil

For Lab Duplicates – multiplier used in initial test for results with concentrations > multiplier * detection limit

multiplier

For Lab Duplicates – multiplier used with detection limit for Soil results
with concentrations < multiplier * detection limit

multiplierSoil

For Laboratory Control Sample Duplicates – enter the sample_type_code(s) in param_value and matching sample_type_codes(s) in remark

sample_type_LCSD

For Matrix Spike Duplicates – enter the sample_type_code(s) in param_value
and matching sample_type_codes(s) in remark

sample_type_MSD

For Laboratory Duplicates – enter the sample_type_code(s) in param_value
and matching sample_type_codes(s) in remark

sample_type_Orig_Dup

For Laboratory Control Spike/Laboratory Control Spike Duplicates – enter result_type_code(s) in param_value and matching sample_result_type_code(s) in remark.

sample_result_type_1

For Matrix Spike/Matrix Spike Duplicates – enter result_type_code(s) in param_value
and matching sample_result_type_code(s) in remark.

sample_result_type_2

For Lab Duplicates – enter result_type_code(s) in param_value
and matching sample_result_type_code(s) in remark.

sample_result_type_3

Multiplier used to define non-detect results = AD_multiplier_DL * detection limit

AD_multiplier_DL

test_batch = Use the test_batch_id to associate inorganic results; parent_sample = Use the parent sample to associate inorganic results.

inorganics_asso_method

test_batch = Use the test_batch_id to associate organic results; parent_sample = Use the parent sample to associate organic results.

organics_asso_method

TRUE = Add qualifiers to the QC samples result row; FALSE = Do not add qualifiers to the QC samples result row; QC sample types are configured in the sample_type_LCSD and sample_type_MSD parameters.

flag_QC

Y/N option to compare calculated RPD to reported RPD for LCSD samples

compare_to_calculated_LCSD

Y/N option to compare calculated RPD to reported RPD for MSD samples

compare_to_calculated_MSD

Y/N option to compare calculated RPD to reported RPD for Lab Dup samples

compare_to_reported_lab_dup

Y/N option to try calculated RPD before the reported RPD when running RPD check for LCSD samples

calculated_before_reported_LCSD

Y/N option to try calculated RPD before the reported RPD when running RPD check for MSD samples

calculated_before_reported_MSD

Y/N option to try reported RPD before calculated RPD when running RPD check for Lab Dup samples

reported_before_calculated_lab_dup

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Relative Standard Deviation (RSD)
of Field Duplicate Types

DT_DQM_CONTROL_LIMITS

FIELD_RSD for each row in Table

DT_SAMPLE

SAMPLE_TYPE_CODE

sample_type_field_dup

PARENT_SAMPLE_CODE

MATRIX_CODE

DT_FIELDQC_BATCH_PARTNER

QC_SAMPLE_ID

SAMPLE_ID

DT_TEST

ANALYTIC_METHOD

PREP_METHOD

DT_RESULT

CAS_RN

DETECT_FLAG

RESULT_NUMERIC

REPORTING_DETECTION_LIMIT

field_dup_detection_limit

or QUANTIFICATION_LIMIT (if REPORTING_DETECTION_LIMIT IS NULL)

or METHOD_DETECTION_LIMIT (if above are both NULL)

RESULT_TYPE_CODE

result_type_field_dup

RSD Field Duplicate Types
Associations

DT_RESULT

CAS_RN

and

DT_SAMPLE

PARENT_SAMPLE_CODE  

or

DT_FIELDQC_BATCH_PARTNER

QC_SAMPLE_ID

SAMPLE_ID

Check Parameters for Field
Duplicate Types
(in RT_DQM_CHECK_PARAMETER)

acceptable variance when comparing calculated RSD to reported RSD for Field Replicate samples

acceptable_variance_field_dup

detection limit column to use in Field RSD calculation value tests

field_dup_detection_limit

multiplier used in initial test for results with concentrations > multiplier * detection limit

multiplier

sample type(s) for Field Replicate Samples

sample_type_field_dup

result type(s) for Field Replicate samples

result_type_field_dup

Y/N option to compare calculated RSD to reported RSD for Field Replicate samples

compare_to_reported_field_dup

Y/N option to try reported RSD before calculated RSD when running RSD check
for Field Replicate samples

reported_before_calculated_field_dup

Relative Standard Deviation of
Blank Spike Types

RT_DQM_CONTROL_LIMITS

LCS_RSD for each row in Table

DT_SAMPLE

SAMPLE_TYPE_CODE

MATRIX_CODE

sample_type_LCSD

DT_TEST

ANALYTICAL_METHOD

PREP_METHOD

DT_RESULT

RESULT_TYPE_CODE

result_type_LCSD

CAS_RN

DT_RESULT_QC

QC_RSD

or

QC_SPIKE_RECOVERY (if QC_RSD is NULL) of each recovery in the blank spike sample types

and/or

QC_DUP_SPIKE_RECOVERY (if QC_RSD is NULL)

RSD Blank Spike Types
Association

DT_RESULT

CAS_RN

and

DT_TEST

TEST_ID

DT_TEST_BATCH

TEST_BATCH_ID

AT_TEST_BATCH_ASSIGN

TEST_ID

TEST_BATCH_ID

TEST_BATCH_TYPE

Check Parameters for Blank
Spike Types
(in RT_DQM_CHECK_PARAM)

sample type(s) for LCS Replicate samples

sample_type_LCSD

result type(s) for LCS Replicate samples

result_type_LCSD

Y/N option to compare calculated RSD to reported RSD for LCS Replicate samples

compare_to_calculated_LCSD

acceptable variance when comparing calculated RSD to reported RSD for LCS Replicate samples (%)

acceptable_variance_LCSD

Y/N option to try reported RSD before the calculated RSD when running RSD check
for LCS Replicate samples

reported_before_calculated_LCSD

Relative Standard Deviation of
Matrix Spike Types

RT_DQM_CONTROL_LIMITS

MS_RSD for each row in Table

DT_SAMPLE

SAMPLE_TYPE_CODE

sample_type_MSD

MATRIX_CODE

DT_TEST

ANALYTIC_METHOD

PREP_METHOD

DT_RESULT

RESULT_TYPE_CODE

result_type_MSD

CAS_RN

DT_RESULT_OC

QC_RSD

or

QC_SPIKE_RECOVERY (if QC_RSD is NULL) of each recovery in the blank spike sample types

and/or

QC_DUP_SPIKE_RECOVERY (if QC_RSD is NULL)

RSD Matrix Spike Types
Association

DT_RESULT

CAS_RN

and

 DT_SAMPLE

PARENT_SAMPLE_CODE

Check Parameters
(in RT_DQM_CHECK_PARAM) for
Matrix Spike Types

acceptable variance when comparing calculated RSD to reported RSD
for MS Replicate samples (%)

acceptable_variance_MSD

result type(s) for MS Replicate  samples

result_type_MSD

sample type(s) for MS Replicate samples

sample_type_MSD

TRUE = Add qualifiers to the QC samples result row; FALSE = Do not add qualifiers to the QC samples result row; QC sample types are configured in the sample_type_LCSD and sample_type_MSD parameters.

flag_QC

Y/N option to compare calculated RSD to reported RSD
for MS Replicate samples

compare_to_calculated_MSD

Y/N option to try reported RSD before the calculated RSD
when running RSD check for MS Replicate samples

reported_before_calculated_MSD

Relative Standard Deviation for
Lab Duplicate Types

RT_DQM_CONTROL_LIMITS

LD_RSD for each row in Table

DT_SAMPLE

SAMPLE_TYPE_CODE

sample_type_Orig_Dup

MATRIX_CODE

PARENT_SAMPLE_CODE

DT_TEST

ANALYTIC_METHOD

PREP_METHOD

DT_RESULT

RESULT_TYPE_CODE

result_type_lab_dup

CAS_RN

RESULT_NUMERIC

REPORTING_DETECTION_LIMIT

or QUANTIFICATION_LIMIT (if REPORTING_DETECTION_LIMIT is NULL)

or METHOD_DETECTION_LIMIT (if above are both NULL)

RSD Lab Duplicate Types
Association

DT_RESULT

CAS_RN

DT_SAMPLE

PARENT_SAMPLE_CODE

and

DT_TEST

TEST_ID

DT_TEST_BATCH

TEST_BATCH_ID

AT_TEST_BATCH_ASSIGN

TEST_ID

TEST_BATCH_ID

TEST_BATCH_TYPE

Check Parameters for Lab
Duplicate Types
(in RT_DQM_CHECK_PARAM)

multiplier used in initial test for results with concentrations > multiplier * detection limit

multiplier

sample type(s) for Lab Replicate samples

sample_type_lab_dup

result type(s) for Lab Replicate samples

result_type_lab_dup

Y/N option to compare calculated RSD to reported RSD for Lab Replicate samples

compare_to_reported_lab_dup

acceptable variance when comparing calculated RSD to reported RSD for Lab Replicate samples (%)

acceptable_variance_lab_dup

Y/N option to try reported RSD before calculated RSD when running RSD check for Lab Replicate samples

reported_before_calculated_lab_dup

detection limit column to use in Lab RSD calculation value tests

lab_dup_detection_limit

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Repeated Results

DT_RESULT

SAMPLE_ID

CAS_RN

FRACTION

TEST_TYPE

ANALYTIC_METHOD

Check Parameters

sample type(s) for the Repeated Results check

sample_type_code

(in RT_DQM_CHECK_PARAM)

result type(s) for the Repeated Results check

result_type_code

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Repeated Results from Two  Methods

DT_RESULT

SAMPLE_ID

CAS_RN

FRACTION

Check Parameters

sample type(s) for the Repeated Results check

sample_type_code

(in RT_DQM_CHECK_PARAM)

result type(s) for the Repeated Results check

result_type_code

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Spike Recovery - Multiple Rules

RT_DQM_CONTROL_LIMITS

Lower Cutoff Limit, Lower Control Limit, Upper Control Limit, and Upper Cutoff Limit for each row in table
can be populated for the Matrix Spike and the Laboratory Control Sample

Blank Spikes

DT_SAMPLE

SAMPLE_TYPE_CODE

sample_type_blank_spike

Matrix Spikes

DT_SAMPLE

SAMPLE_TYPE_CODE

sample_type_matrix_spike

PARENT_SAMPLE_CODE

RT_ANALYTE

ORGANIC_YN

Blank Spikes and Matrix Spikes

DT_SAMPLE

MATRIX_CODE

DT_TEST

ANALYTIC_METHOD

PREP_METHOD

DT_RESULT

CAS_RN

RESULT_TYPE_CODE

result_type_code_spike

DT_RESULT_QC

QC_SPIKE_RECOVERY

or

100 * QC_SPIKE_MEASURED / QC_SPIKE_ADDED (Blank Spikes)

or 100 * ((QC_SPIKE_MEASURED-QC_ORIGINAL_CONC) / QC_SPIKE_ADDED) for Matrix Spikes

QC_SPIKE_LCL  and  QC_SPIKE_UCL (if RT_DQM_CONTROL_LIMITS columns are NULL)

QC_DUP_SPIKE_RECOVERY

or

100 * QC_DUP_SPIKE_MEASURED / QC_DUP_SPIKE_ADDED (if QC_DUP_SPIKE_RECOVERY is NULL)

Blank Spike Associations

DT_RESULT

CAS_RN

and

DT_TEST

TEST_ID

DT_TEST_BATCH

TEST_BATCH_ID

AT_TEST_BATCH_ASSIGN

TEST_ID

TEST_BATCH_ID

TEST_BATCH_TYPE

Matrix Spike Associations

DT_RESULT

CAS_RN

and

DT_SAMPLE

PARENT_SAMPLE_CODE

Check Parameters
(in RT_DQM_CHECK_PARAM)

acceptable variance when comparing calculated to reported recovery for LCS samples

acceptable_variance_LCS

acceptable variance when comparing calculated to reported recovery for MS samples

acceptable_variance_MS

multiplier is used to compare original concentration to spike concentration:
do not use QC data if original >  multiplier * spike

multiplier

Result type(s) to be used for the  check

result_type_code_spike

test_batch = Use the test_batch_id to associate inorganic results; parent_sample = Use the parent sample to associate inorganic results.

inorganics_asso_method

test_batch = Use the test_batch_id to associate organic results; parent_sample = Use the parent sample to associate organic results.

organics_asso_method

TRUE = Add qualifiers to the QC samples result row; FALSE = Do not add qualifiers to the QC samples result row; QC sample types are configured in the sample_type_blank_spike and sample_type_matrix_spike parameters.

flag_QC

Y/N option to compare calculated recovery to reported recovery for LCS samples

compare_to_calculated_LCS

Y/N option to compare calculated recovery to reported recovery for MS samples

compare_to_calculated_MS

Y/N option to try calculated recovery before the reported recovery when running Spike Recovery check
for LCS samples

calculated_before_reported_LCS

Y/N option to try calculated recovery before the reported recovery when running Spike Recovery check
for MS samples

calculated_before_reported_MS

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Surrogate Recovery

DT_SAMPLE

MATRIX_CODE

DT_TEST

ANALYTIC_METHOD

PREP_METHOD

DT_RESULT

CAS_RN

RESULT_TYPE_CODE

result_type_code_surrogate

DT_RESULT_QC

QC_SPIKE_RECOVERY

or

100 * QC_SPIKE_MEASURED / QC_SPIKE_ADDED
 (if QC_SPIKE_RECOVERY is NULL)

QC_SPIKE_LCL and QC_SPIKE_UCL

(if RT_DQM_CONTROL_LIMITS columns are NULL)

RT_DQM_CONTROL_LIMITS

SURR_REC_LOWER_CUTOFF,   SURR_RECOVERY_LCL,

SURR_RECOVERY_UCL, and SURR_REC_UPPER_CUTOFF can be populated for each row in the table

SURR_ASSOC_CAS_RN

CAS_RN (if used)

RT_HOLDING_TIME

LOWER_SURROGATE_CUTOFF

(if RT_DQM_CONTROL_LIMITS column is NULL)

Associations

DT_TEST

TEST_ID

RT_DQM_CONTROL_LIMITS

SURR_ASSOC_CAS_RN

CAS_RN if RT_DQM_CHECK_PARAM.ASSO_ACID_BASE_YN = Y

asso_acid_base_yn

Check Parameters
(in RT_DQM_CHECK_PARAM)

Geotechnical Lab Test Status Report (earthsoft-betahelp.azurewebsites.net)Y = check for second Surrogate Recovery exceedance before qualifying data

secondSurrogate

result type(s) for surrogates

result_type_code_surrogate

Y = use the SURR_ASSO_CAS_RN column in RT_DQM_CONTROL_LIMITS to associate acid or base surrogates to specific CAS_RNs

asso_acid_base_n

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Preservative

DT_SAMPLE

SAMPLE_TYPE_CODE

sample_type_code

DT_TEST

ANALYTIC_METHOD

PRESERVATIVE

DT_RESULT

DETECT_FLAG

RT_HOLDING_TIME

ANALYTIC_METHOD

MEDIUM_CODE

PRESERVATIVE

Check Parameters

sample_type(s) for the Preservative check

sample_type_code

(in RT_DQM_CHECK_PARAM)

result_type(s) for the Preservative check

result_type_code

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Trip Blank Contamination

DT_SAMPLE

SAMPLE_TYPE_CODE

AmbientBlankSampleType,
TripBlankSampleType, and
normal_sample_type

MATRIX_CODE

DT_TEST

ANALYTIC_METHOD

PREP_METHOD

DT_RESULT

DETECT_FLAG

CAS_RN

RESULT_NUMERIC

REPORTING_DETECTION_LIMIT
or
QUANTITATION_LIMIT*

Global Parameters:
non_detect_detection_limit

RT_DQM_CONTROL_LIMITS

BLANK_MULTIPLIER - for each row in table (if populated, this multiplier overrides check parameter
multiplier)

Automatic Associations

DT_RESULT

CAS_RN

and

DT_FIELDQC_BATCH_PARTNER

QC_SAMPLE_ID

SAMPLE_ID

or

DT_CHAIN_OF_CUSTODY

CHAIN_OF_CUSTODY

or

DT_FIELD_SAMPLE

FIELD_SDG

Manual Associations

DT_RESULT

CAS_RN

and

DT_FIELDQC_BATCH_PARTNER

QC_SAMPLE_ID

SAMPLE_ID

Check Parameters
(in RT_DQM_CHECK_PARAM)

multiplier used to evaluate when a result can be set to Non-Detect and Qualifier = 'U' due to blank contamination by a common lab contaminant. CAS_RN must be populated for each common laboratory contaminant.

common_lab_multiplier

TRUE = add qualifiers to blank result row; FALSE = do not add qualifiers to blank result row

flag_blank

multiplier used to evaluate when a result can be set to Non-Detect and Qualifier = 'U' due to blank contamination.

multiplier

Sample Type Code for Ambient Blank

AmbientBlankSampleType

Sample Type Code for Trip Blank

TripBlankSampleType

sample type(s) for manual association with trip blank samples

normal_sample_types

result_type(s) for the Trip Blank Contamination check

result_type_code

Lab Data Audit Checks

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Numeric Results

DT_RESULT

RESULT_NUMERIC

RESULT_UNIT

Check Parameters
(in RT_DQM_CHECK_PARAM)

This check is controlled by adding check parameters to RT_DQM_CHECK_PARAM. The parameter can have
any name and there can be more than one.  The REMARK column will determine which units are checked. If
the  PARAM_VALUE includes and begins with “<” the check will test for  values less than the  PARAM_VALUE

param_example

sample_type(s) for the Numeric Results check

sample_type_code

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Percent Solids

DT_SAMPLE

SAMPLE_TYPE_CODE

sample_type_code

MATRIX_CODE

DT_TEST

PERCENT_MOISTURE

Check Parameters
(in RT_DQM_CHECK_PARAM)

Lower Control Limit for Percent Solids check.

lower_control_limit

Lower Warning Limit for Percent Solids check.

lower_warning_limit

All result records are checked if the param_value is NULL for this parameter in rt_dqm_check_param

medium_code

All result records are checked if the param_value is NULL for this parameter in rt_dqm_check_param

sample_type_code

result_type(s) for the Percent Solids check

result_type_code

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Verify Sample Units

DT_RESULT

RESULT_UNIT

RT_UNIT

UNIT_CODE

UNIT_TYPE

RT_MTH_ANL_GROUP_MEMBER

DEFAULT_UNITS

Check Parameters

Y = check default_units in rt_mth_anl_group_member; N = do not check default_units in rt_mth_anl_group_member

checkDefaultUnits

(in RT_DQM_CHECK_PARAM)

This check compares the result units to the rt_unit.unit_codes with these unit_types.

unit_type

sample type(s) for the Verify Sample Units check

sample_type_code

result type(s) for Verify Sample Units check

result_type_code

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Required Detection Limit

DT_SAMLE

SAMPLE_TYPE_CODE

sample_type_code

MATRIX_CODE

DT_RESULT

CAS_RN

DETECT_FLAG

non_detect_only

DILUTION_FACTOR

non_adjusted_only

RESULT_NUMERIC

REPORTING_DETECTION_LIMIT OR QUANTITATION_LIMIT

detection_limit_column

DETECTION_LIMIT_UNIT

RESULT_TYPE_CODE

result_type_code

RT_UNIT

UNIT_CODE

UNIT_TYPE

RT_MTH_ANL_GROUP_MEMBER

DEFAULT_UNITS

Check Parameters
(in RT_DQM_CHECK_PARAM)

The column to use for comparison with the required detection limit.

detection_limit_column

sample type(s) for Required Detection Limit check

sample_type_code

result type(s) for Required Detection Limit check

result_type_code

Y/N option to only review results with DETECT_FLAG = N

non_detect_only

Y/N option to only review results with a dilution factor = 1

non_adjusted_only

Radiochemistry

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Radiochemistry Estimated Results

DT_RESULT

MINIMUM_DETECTABLE_CONC

RESULT_NUMERIC

RESULT_ERROR_DELTA

UNCERTAINTY

Check Parameters

sample_type(s) for the Radiochemistry Estimated Results check

sample_type_code

(in RT_DQM_CHECK_PARAM)

result_type(s) for the Radiochemistry Estimated Results check

result_type_code

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Radiochemistry Relative Error Ratio

DT_SAMPLE

SAMPLE_TYPE_CODE

sample_type_RadChem_Dup

PARENT_SAMPLE_CODE

MATRIX_CODE

DT_FIELDQC_BATCH_PARTNER

QC_SAMPLE_ID (used if DT_SAMPLE.PARENT_SAMPLE_CODE is NULL)

DT_RESULT

CAS_RN

RESULT_NUMERIC

UNCERTAINTY

RESULT_ERROR_DELTA

Associations

DT_RESULT

TEST_ID

and

DT_SAMPLE

PARENT_SAMPLE_CODE

or

DT_FIELDQC_BATCH_PARTNER

QC_SAMPLE_ID

SAMPLE_ID

Check Parameters

rer_control_limit_soil applied to samples whose matrix_code has this medium_code in rt_matrix

medium_code_soil

(in RT_DQM_CHECK_PARAM)

rer_control_limit_water applied to samples whose matrix_code has this medium_code in rt_matrix

medium_code_water

control limit for Other results

rer_control_limit_other

control limit for Soil results

rer_control_limit_soil

control limit for Water results

rer_control_limit_water

Sample _type for the duplicate used in  the Radiochemistry Relative Error Ratio check

Sample_type_RadChem_Dup

upper cutoff for Other results

rer_upper_cutoff_other

upper cutoff for Soil results

rer_upper_cutoff_soil

upper cutoff for Water results

rer_upper_cutoff_water

result_type(s) for the Radiochemistry Relative Error Ratio check

result_type_code

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Radiochemistry Tracer Recovery

DT_RESULT

RESULT_TYPE_CODE

result_type_code_tracer

DT_RESULT_QC

QC_SPIKE_RECOVERY

or

100 * QC_SPIKE_MEASURED / QC_SPIKE_ADDED (if QC_SPIKE_RECOVERY is NULL)

QC_SPIKE_LCL

QC_SPIKE_UCL

Associations

DT_TEST

TEST_ID

DT_TEST_BATCH

TEST_BATCH_ID

AT_TEST_BATCH_ASSIGN

TEST_ID

TEST_BATCH_ID

TEST_BATCH_TYPE

Global Parameters: test_batch_type

Check Parameters
(in RT_DQM_CHECK_PARAM)

Y = check for second Tracer Recovery exceedance before qualifying data

secondTracer

Result_type code for the tracer

result_type_code_tracer