EDD Data Requirements for DQM Checks

<< Click to Display Table of Contents >>

Navigation:  DQM >

EDD Data Requirements for DQM Checks

Whether setting up a format or EDD specification for laboratories or troubleshooting lab data missing errors after running a DQM Event, the information that follows is intended to help the DQM user obtain the data needed to run the desired checks using DQM.

 

This Excel1 table, also available for download here, shows which fields are required in the EQEDD for each DQM Check.

 

dqm-reqfieldsbycheckmatrix_zoom45

 

Color Code Legend:

In LabSample_v1

In TestResults_v1 and TestResultsQC_v1

In TestResultsQC_v1

In TestBatch_v1

 

Symbolic Legend:

* As defined by the PARAM_VALUE for the PARAM_CODE for the check for the detection limit.

** Order of automated association first done using DT_FIELDQC_BATCH_PARTNER, then DT_SAMPLE.FIELD_SDG and lastly DT_SAMPLE.CHAIN_OF_CUSTODY, using the first association found.

*** Order of automated association first done using DT_FIELDQC_BATCH_PARTNER, then DT_SAMPLE.CHAIN_OF_CUSTODY, and lastlly DT_SAMPLE_FIELD_SDG, using the first association found.

+ If using lab limits to evaluate data.

++ If DQM is performing a calculation.

 

 

The below tables, available for download here, show the additional fields that are required in the EQEDD for each DQM Check.

 

These fields are required for all DQM checks:

 

EQEDD Table

Field Name

TestResults_v1

reportable_result

result_type_code

TestResultsQC_v1

reportable_result

result_type_code

TestBatch_v1

test_batch_type

 

 

Required EQEDD fields by Check:

 

Check

EQEDD Table

Field Name

Batch Completeness


LabSample_v1

sample_type_code

TestResults_v1

lab_anl_method_name

analysis_date

test_type

TestResultsQC_v1

lab_anl_method_name

analysis_date

test_type

TestBatch_v1

test_batch_id

Dilution Factor


LabSample_v1

sample_type_code

TestResults_v1

dilution_factor

detect_flag

Dissolved Total


LabSample_v1

sample_type_code

TestResults_v1

lab_anl_method_name

cas_rn

total_or_dissolved

reporting_detection_limit*

Estimated Results


LabSample_v1

sample_type_code

TestResults_v1

detect_flag

result_value

method_detection_limit

reporting_detection_limit*

Field Blank Contamination


LabSample_v1

sample_type_code

sample_matrix_code

sample_delivery_group**

TestResults_v1

lab_anl_method_name

prep_method

cas_rn

total_or_dissolved

detect_flag

result_value

result_unit

reporting_detection_limit*

Holding Times


LabSample_v1

sample_type_code

sample_matrix_code

sample_date

TestResults_v1

lab_anl_method_name

lab_matrix_code

leachate_date; if needing to check for holding times involving leachates

prep_date

analysis_date

preservative_date;
if needing to check for holding times involving addition of preservatives

preservative

TestResultsQC_v1

lab_anl_method_name

lab_matrix_code

leachate_date; if needing to check for holding times involving leachates

prep_date

analysis_date

preservative_date;
if needing to check for holding times involving addition of preservatives

preservative

Lab Blank Contamination


LabSample_v1

sample_type_code

sample_matrix_code

TestResults_v1

lab_anl_method_name

prep_method

cas_rn

total_or_dissolved

detect_flag

result_value

result_unit

reporting_detection_limit*

TestResultsQC_v1

lab_anl_method_name

prep_method

cas_rn

total_or_dissolved

detect_flag

result_value

result_unit

reporting_detection_limit*

Numeric Results


TestResults_v1

result_value

result_unit

Percent Solids


LabSample_v1

sample_type_code

sample_matrix_code

TestResults_v1

percent_moisture

percent_moisture

Preservative


LabSample_v1

sample_type_code

TestResults_v1

lab_anl_method_name

preservative

detect_flag

TestResultsQC_v1

lab_anl_method_name

preservative

detect_flag

Relative Percent Difference


LabSample_v1

sample_type_code

sample_matrix_code

parent_sample_code

TestResults_v1

lab_anl_method_name

prep_method

cas_rn

detect_flag

result_value

reporting_detection_limit*

TestResultsQC_v1

lab_anl_method_name

prep_method

cas_rn

detect_flag

result_value

reporting_detection_limit*

IF USING LAB LIMITS TO EVALUATE DATA

 

qc_rpd

qc_rpd_cl

IF DQM IS NEEDED TO CALCULATE RPD

qc_spike_recovery

qc_dup_spike_recovery

TestBatch_v1

test_batch_id

Relative Percent Difference Field


LabSample_v1

sample_type_code

sample_matrix_code

parent_sample_code; DT_FIELDQC_BATCH partner can be used for association of Field Duplicate Types if preferred

TestResults_v1

lab_anl_method_name

prep_method

cas_rn

detect_flag

result_value

reporting_detection_limit*

TestResultsQC_v1

lab_anl_method_name

prep_method

cas_rn

detect_flag

result_value

reporting_detection_limit*

IF DQM is COMPARING TO THE CALCULATED VALUE

qc_rpd

Relative Standard Deviation


LabSample_v1

sample_type_code

sample_matrix_code

parent_sample_code; DT_FIELDQC_BATCH partner can be used for association of Field Duplicate Types if preferred

TestResults_v1

lab_anl_method_name

prep_method

cas_rn

detect_flag

result_value

reporting_detection_limit*

TestResultsQC_v1

lab_anl_method_name

prep_method

cas_rn

detect_flag

result_value

reporting_detection_limit*

qc_rsd

IF DQM IS NEEDED TO CALCULATE RSD

qc_spike_recovery

qc_dup_spike_recovery

TestBatch_v1

test_batch_id

Repeated Results


TestResults_v1

sys_sample_code

lab_anl_method_name

cas_rn

total_or_dissolved

test_type

Repeated Results Two Methods


TestResults_v1

sys_sample_code

cas_rn

total_or_dissolved

Required Detection Limit


LabSample_v1

sample_type_code

sample_matrix_code

TestResults_v1

cas_rn

detect_flag

dilution_factor

result_value

reporting_detection_limit*

detection_limit_unit

Relative Percent Difference Lab_Field


LabSample_v1

sample_type_code

sample_matrix_code

TestResults_v1

cas_rn

result_value

TestResultsQC_v1

cas_rn

result_value

Spike Recovery


LabSample_v1

sample_type_code

sample_matrix_code

parent_sample_code

TestResults_v1

lab_anl_method_name

prep_method

dilution_factor

cas_rn

TestResultsQC_v1

lab_anl_method_name

prep_method

dilution_factor

cas_rn

qc_spike_recovery

qc_dup_spike_recovery

IF USING LAB LIMITS TO EVALUATE DATA

qc_spike_lcl

qc_spike_ucl

IF DQM IS NEEDED TO CALCULATE RECOVERIES

qc_original_conc

qc_spike_added

qc_spike_measured

qc_dup_original_conc

qc_dup_spike_added

qc_dup_spike_measured

TestBatch_v1

test_batch_id

Surrogate Recovery


LabSample_v1

sample_matrix_code

TestResults_v1

lab_anl_method_name

prep_method

dilution_factor

cas_rn

TestResultsQC_v1

lab_anl_method_name

prep_method

dilution_factor

cas_rn

qc_spike_recovery

IF USING LAB LIMITS TO EVALUATE DATA

qc_spike_lcl

qc_spike_ucl

Trip Blank Contamination


LabSample_v1

sample_type_code

sample_matrix_code

chain_of_custody; association first by DT_FIELDQC_BATCH_PARTNER, else chain_of_custody, else FIELD_SDG in that order

TestResults_v1

lab_anl_method_name

prep_method

cas_rn

total_or_dissolved

detect_flag

result_value

result_unit

reporting_detection_limit**

Verify Sample Units


TestResults_v1

result_unit

Radiochemistry Estimated Results


TestResults_v1

detect_flag

minimum_detectable_conc

result_value

result_error_delta

uncertainty

Radiochemistry Relative Error Ratio


LabSample_v1

sample_type_code

sample_matrix_code

parent_sample_code; can use DT_FIELDQC_BATCH_PARTNER if desired

TestResults_v1

cas_rn

result_value

result_error_delta

uncertainty

Radiochemistry Tracer Recovery


TestResults_v1

lab_anl_method_name

TestResultsQC_v1

lab_anl_method_name

qc_spike_recovery

qc_spike_lcl

qc_spike_ucl

TestBatch_v1

sys_sample_code

cas_rn

lab_anl_method_name

analysis_date

total_or_dissolved

test_batch_type

test_batch_id

 

Color Code Legend  for the EQEDD format:

Red font and underlined are already primary keys AND required fields

Red font and bold are already required fields

Blue font and bold are lookup fields

 

Symbolic Legend:

* As defined by the PARAM_VALUE for the PARAM_CODE for the check for the detection limit.

** Order of automated association first done using DT_FIELDQC_BATCH_PARTNER, then DT_SAMPLE.FIELD_SDG and lastly DT_SAMPLE.CHAIN_OF_CUSTODY, using the first association found.

 

1The Excel table requires a valid license of Microsoft Excel to view.