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.
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; |
||
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; |
||
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 |
|
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.