DQM Data Sources

<< Click to Display Table of Contents >>

EQuIS 7  >>  Professional > Modules > DQM >

DQM Data Sources

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. Related tables are the same color.

 

Table List

DT_SAMPLE

DT_FIELD_SAMPLE

DT_TEST

DT_RESULT

DT_RESULT_QC

DT_CHAIN_OF_CUSTODY

DT_TEST

DT_TEST_BATCH

AT_TEST_BATCH_ASSIGN

DT_FIELDQC_BATCH_PARTNER

RT_ANALYTE

RT_HOLDING_TIME

RT_MATRIX

RT_UNIT

RT_MTH_ANL_GROUP_MEMBER

RT_DQM_CONTROL_LIMITS

 

 

Standard Checks

 

 

 

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Estimated results (MQL < x < PQL)

DT_RESULT

METHOD_DETECTION_LIMIT

 

 

 

RESULT_NUMERIC

 

 

 

REPORTING_DETECTION_LIMIT

 

 

 

REPORTABLE_RESULT

GlobalParameters: reportable_result

 

 

RESULT_TYPE_CODE

GlobalParameters: result_type_code

 

 

 

 

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Field Blank Contamination

DT_SAMPLE

SAMPLE_TYPE_CODE

xxxBlankSampleType - 3 types

 

DT_RESULT

DETECT_FLAG

 

 

 

RESULT_NUMERIC

 

 

 

RESULT_UNIT

 

 

 

REPORTABLE_RESULT

GlobalParameters: reportable_result

 

 

RESULT_TYPE_CODE

GlobalParameters: result_type_code

Field Blank Associations

DT_FIELD_SAMPLE

FIELD_SDG

 

 

DT_CHAIN_OF_CUSTODY

CHAIN_OF_CUSTODY

 

 

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

Check Parameters

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.

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

 

 

 

 

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Lab Blank Contamination

DT_SAMPLE

SAMPLE_TYPE_CODE

xxxBlankSampleType - 2 types

 

DT_RESULT

DETECT_FLAG

 

 

 

RESULT_NUMERIC

 

 

 

RESULT_UNIT

 

 

 

REPORTABLE_RESULT

GlobalParameters: reportable_result

 

 

RESULT_TYPE_CODE

GlobalParameters: result_type_code

Lab Blank Associations

DT_TEST

LAB_SDG

 

 

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

Check Parameters

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.

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

 

 

 

 

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Trip Blank Contamination

DT_SAMPLE

SAMPLE_TYPE_CODE

xxxBlankSampleType - 2 types

 

DT_RESULT

DETECT_FLAG

 

 

 

RESULT_NUMERIC

 

 

 

RESULT_UNIT

 

 

 

REPORTABLE_RESULT

GlobalParameters: reportable_result

 

 

RESULT_TYPE_CODE

GlobalParameters: result_type_code

Trip Blank Associations

DT_CHAIN_OF_CUSTODY

CHAIN_OF_CUSTODY

 

 

DT_FIELD_SAMPLE

FIELD_SDG

 

Check Parameters

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.

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

 

 

 

 

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

 

 

RT_MATRIX

MEDIUM_CODE

 

 

DT_FIELDQC_BATCH_PARTNER

QC_SAMPLE_ID

 

 

DT_RESULT

RESULT_NUMERIC

 

 

 

REPORTING_DETECTION_LIMIT

 

 

 

or QUANTIFICATION_LIMIT (if REPORTING_DETECTION_LIMIT is NULL)

 

 

 

or METHOD_DETECTION_LIMIT (if above are both NULL)

 

 

 

REPORTABLE_RESULT

GlobalParameters: reportable_result

 

 

RESULT_TYPE_CODE

GlobalParameters: result_type_code

 

RT_DQM_CONTROL_LIMITS

FIELD_DUP_RPD_CL - if populated, this control limit overrides check parameter control limits

 

 

Check Parameters

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

 

 

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)

Holding Times

RT_HOLDING_TIME

Various

 

 

RT_MATRIX

MEDIUM_CODE

 

 

DT_SAMPLE

SAMPLE_DATE

 

 

DT_TEST

LEACHATE_DATE 

 

 

 

PREP_DATE 

 

 

 

ANALYSIS_DATE

 

 

DT_RESULT

REPORTABLE_RESULT

GlobalParameters: reportable_result

 

 

RESULT_TYPE_CODE

GlobalParameters: result_type_code

 

Check Parameters

multiplier to set Gross Exceedance of Holding Times

GrossRejectFactor

 

 

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

useRuleQualifiers

 

 

 

 

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Lab versus Field RPD

DT_SAMPLE

MATRIX_CODE

 

 

RT_MATRIX

MEDIUM_CODE

 

 

DT_RESULT

CAS_RN

 

 

 

RESULT_NUMERIC

 

 

 

REPORTABLE_RESULT

GlobalParameters: reportable_result

 

 

RESULT_TYPE_CODE

GlobalParameters: result_type_code

 

Check Parameters

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

medium_code_soil

 

RT_DQM_CONTROL_LIMITS

Various - if populated these control limits override the check parameter control limits

 

Blank Spikes

DT_SAMPLE

SAMPLE_TYPE_CODE

sample_type_LCSD

 

 

MATRIX_CODE

 

 

DT_RESULT

RESULT_TYPE_CODE

 

 

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_TEST

TEST_ID

 

 

DT_TEST_BATCH

TEST_BATCH_ID

 

 

AT_TEST_BATCH_ASSIGN

TEST_ID

 

 

 

TEST_BATCH_ID

 

Matrix Spikes

DT_SAMPLE

SAMPLE_TYPE_CODE

sample_type_MSD

 

 

MATRIX_CODE

 

 

DT_RESULT

RESULT_TYPE_CODE

 

 

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_SAMPLE

PARENT_SAMPLE_CODE

 

Lab Duplicates

DT_SAMPLE

SAMPLE_TYPE_CODE

sample_type_Orig_Dup

 

 

MATRIX_CODE

 

 

DT_RESULT

RESULT_TYPE_CODE

 

 

 

RESULT_NUMERIC

 

 

 

REPORTING_DETECTION_LIMIT

 

 

 

or QUANTIFICATION_LIMIT (if REPORTING_DETECTION_LIMIT is NULL)

 

 

 

or METHOD_DETECTION_LIMIT (if above are both NULL)

 

 

Check Parameters

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

multiplierSoil

 

 

enter sample_type_code(s) in param_value and matching result_type_code(s) in remark.

sample_result_type_1

 

 

enter sample_type_code(s) in param_value and matching result_type_code(s) in remark.

sample_result_type_2

 

 

enter sample_type_code(s) in param_value and matching result_type_code(s) in remark.

sample_result_type_3

 

 

 

 

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Repeated Results

DT_RESULT

SAMPLE_ID

 

 

 

ANALYTIC_METHOD

 

 

 

CAS_RN

 

 

 

FRACTION

 

 

 

 

 

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

Various

 

Blank Spikes

DT_SAMPLE

SAMPLE_TYPE_CODE

sample_type_blank_spike

Matrix Spikes

DT_SAMPLE

SAMPLE_TYPE_CODE

sample_type_matrix_spike

 

RT_ANALYTE

ORGANIC_YN

 

Blank Spikes and Matrix Spikes

DT_RESULT

RESULT_TYPE_CODE

result_type_code_spike

 

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)

 

 

 

or

 

 

 

QC_DUP_SPIKE_RECOVERY

 

 

 

or 100 * QC_DUP_SPIKE_MEASURED / QC_DUP_SPIKE_ADDED (if QC_DUP_SPIKE_RECOVERY is NULL)

 

 

 

QC_SPIKE_LCL  and  QC_SPIKE_UCL  (if RT_DQM_CONTROL_LIMITS columns are NULL)

 

Blank Spike Associations

DT_TEST

TEST_ID

 

 

DT_TEST_BATCH

TEST_BATCH_ID

 

 

AT_TEST_BATCH_ASSIGN

TEST_ID

 

 

 

TEST_BATCH_ID

 

Matrix Spike Associations

DT_SAMPLE

PARENT_SAMPLE_CODE

 

 

Check Parameters

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

multiplier

 

 

 

 

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Surrogate Recovery

DT_RESULT

RESULT_TYPE_CODE

result_type_code_surrogate

 

RT_DQM_CONTROL_LIMITS

SURR_REC_LOWER_CUTOFF and SURR_RECOVERY_LCL and SURR_RECOVERY_UCL

 

 

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_HOLDING_TIME

LOWER_SURROGATE_CUTOFF  (if RT_DQM_CONTROL_LIMITS column is NULL)

 

Associations

DT_TEST

TEST_ID

 

 

Check Parameters

Y = check for second Surrogate Recovery exceedance before qualifying data

secondSurrogate

 

 

 

 

 

 

 

 

 

 

 

 

Lab Data Audit Checks

 

 

 

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Numeric Results

DT_RESULT

RESULT_NUMERIC

 

 

 

RESULT_UNIT

 

Check Parameters

 

This parameter can have any name and there can be more than one.  The REMARK column will determine which units are checked.

param_example

 

 

 

 

DQM Check

Table(s)

Column(s)

Check Parameter(s)

Percent Solids

DT_TEST

PERCENT_MOISTURE

 

 

Check Parameters

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

 

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

 

 

 

 

 

 

 

 

 

 

 

 

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

 

 

RT_MATRIX

MEDIUM_CODE

 

 

DT_FIELDQC_BATCH_PARTNER

QC_SAMPLE_ID

 

 

DT_RESULT

RESULT_NUMERIC

 

 

 

UNCERTAINTY

 

 

 

RESULT_ERROR_DELTA

 

 

Check Parameters

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

 

 

 

 

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

 

 

Check Parameters

Y = check for second Tracer Recovery exceedance before qualifying data

secondTracer