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_SPIKE_MEASURED (if use_conc_for_calc is Y)
|
|
|
|
and QC_DUP_SPIKE_MEASURED (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_SPIKE_MEASURED (if use_conc_for_calc is Y)
|
|
|
|
and QC_DUP_SPIKE_MEASURED (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)
|
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
|
Control limit for comparison of each result’s dilution factor. Results with a dilution factor over the control limit will not be evaluated. Defaults to 5.
|
dilution_factor_control_limit
|
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_SAMPLE
|
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
|