DQM Data Sources

<< Click to Display Table of Contents >>

Navigation:  DQM >

DQM Data Sources

Standard Checks

Lab Data Audit Checks

Radiochemistry

 

The table below shows the data sources used by each DQM Check.

 

(The DQM Settings tables are outlined in the help article Getting Started with DQM).

 

The table is color-coded and organized to demonstrate relationships between the DQM checks, tables, parameters, and associations. The table key is provided below. Similar types of tables are the same color.

 

Table List

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

 

During the Start Event process, the SQL query that creates the dataset that is run through every check includes the Global Parameters listed in the Table below. Some checks (e.g. Spike Recovery and Surrogate Recovery) add additional RESULT_TYPE_CODEs. Some checks have an individual check parameter to filter to a specific RESULT_TYPE_CODE.

 

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

 

Additionally, during the Start Event process, the SQL query that creates the dataset that is run through every DQM check includes looking at DETECT_FLAG in DT_RESULT to determine which qualifier to be applied to results for any Rule exceptions or Associated Results of QC Samples with Rule exceptions. For DQM Checks that the DQM code looks at DETECT_FLAG in DT_RESULT for additional reasons, the DT_RESULT Table and DETECT_FLAG columns are included in the listing for each DQM check in the tables that follow.

 

The following Reference Tables must be populated with appropriate values in the "Related Columns" in order for DQM to use the "Column(s)" of the same name referenced in a check.

 

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

 

*Applicable to EQuIS DQM version 7.21.2 and later versions

 

Standard Checks

 

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
(in RT_DQM_CHECK_PARAM)

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

non_qc_sample_type

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

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

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

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
(in RT_DQM_CHECK_PARAM)

lab-field cas_rn pairs for comparison

lab_field_cas_rns

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

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)

 

 

 

 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)

 

 

 

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)

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

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

AD_multiplier_DL

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

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

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

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)

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

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

acceptable_variance_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

detection limit column to use in Field RSD calculation value tests

field_dup_detection_limit

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

sample type(s) for MS Replicate samples

sample_type_MSD

result type(s) for MS Replicate  samples

result_type_MSD

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

compare_to_calculated_MSD

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

acceptable_variance_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

 

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Repeated Results from Two
Methods

DT_RESULT

SAMPLE_ID

 

 

CAS_RN

 

 

FRACTION

 

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)

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

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

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

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)

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
(in RT_DQM_CHECK_PARAM)

sample type(s) for samples to be included in the Preservative Check

sample_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

 

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





DQM Check

DQM Check

DQM Check

DQM Check

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


 


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
(in RT_DQM_CHECK_PARAM)

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

checkDefaultUnits

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

unit_type

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






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
(in RT_DQM_CHECK_PARAM)

rer_control_limit_soil applied to samples whose matrix_code has this medium_code in rt_matrix

medium_code_soil

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 this 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

 

 


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