•Required EQEDD fields by Check
•Required EFWEDD fields by Check
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 Excel table, also available for download here, shows which fields are required in the EQEDD for each DQM Check.
Note: The Excel table requires a valid license of Microsoft Excel to view. |
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 Section |
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
Batch Completeness |
|
|---|---|
EQEDD Section |
Field Name |
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 |
|
|---|---|
EQEDD Section |
Field Name |
LabSample_v1 |
sample_type_code |
TestResults_v1 |
dilution_factor |
detect_flag |
|
Dissolved Total |
|
|---|---|
EQEDD Section |
Field Name |
LabSample_v1 |
sample_type_code |
TestResults_v1 |
lab_anl_method_name |
cas_rn |
|
total_or_dissolved |
|
reporting_detection_limit* |
|
Estimated Results |
|
|---|---|
EQEDD Section |
Field Name |
LabSample_v1 |
sample_type_code |
TestResults_v1 |
detect_flag |
result_value |
|
method_detection_limit |
|
reporting_detection_limit* |
|
Field Blank Contamination |
|
|---|---|
EQEDD Section |
Field Name |
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 |
|
|---|---|
EQEDD Section |
Field Name |
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 |
|
|---|---|
EQEDD Section |
Field Name |
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 |
|
|---|---|
EQEDD Section |
Field Name |
TestResults_v1 |
result_value |
result_unit |
|
Percent Solids |
|
|---|---|
EQEDD Section |
Field Name |
LabSample_v1 |
sample_type_code |
sample_matrix_code |
|
TestResults_v1 |
percent_moisture |
Preservative |
|
|---|---|
EQEDD Section |
Field Name |
LabSample_v1 |
sample_type_code |
TestResults_v1 |
lab_anl_method_name |
preservative |
|
detect_flag |
|
TestResultsQC_v1 |
lab_anl_method_name |
preservative |
|
detect_flag |
|
Radiochemistry Estimated Results |
|
|---|---|
EQEDD Section |
Field Name |
TestResults_v1 |
detect_flag |
minimum_detectable_conc |
|
result_value |
|
result_error_delta |
|
uncertainty |
|
Radiochemistry Relative Error Ratio |
|
|---|---|
EQEDD Section |
Field Name |
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 |
|
|---|---|
EQEDD Section |
Field Name |
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 |
|
Relative Percent Difference |
|
|---|---|
EQEDD Section |
Field Name |
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 |
|
|---|---|
EQEDD Section |
Field Name |
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 |
|
|---|---|
EQEDD Section |
Field Name |
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 |
|
|---|---|
EQEDD Section |
Field Name |
TestResults_v1 |
sys_sample_code |
lab_anl_method_name |
|
cas_rn |
|
total_or_dissolved |
|
test_type |
|
Repeated Results Two Methods |
|
|---|---|
EQEDD Section |
Field Name |
TestResults_v1 |
sys_sample_code |
cas_rn |
|
total_or_dissolved |
|
Required Detection Limit |
|
|---|---|
EQEDD Section |
Field Name |
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 |
|
|---|---|
EQEDD Section |
Field Name |
LabSample_v1 |
sample_type_code |
sample_matrix_code |
|
TestResults_v1 |
cas_rn |
result_value |
|
TestResultsQC_v1 |
cas_rn |
result_value |
|
Spike Recovery |
|
|---|---|
EQEDD Section |
Field Name |
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 |
|
|---|---|
EQEDD Section |
Field Name |
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 |
|
|---|---|
EQEDD Section |
Field Name |
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 |
|
|---|---|
EQEDD Section |
Field Name |
TestResults_v1 |
result_unit |
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.
Required EFWEDD fields by Check
Batch Completeness |
|
|---|---|
EQEDD Section |
Field Name |
EFW2Sample or EFW2LabSMP |
sample_type_code |
EFW2LabTST |
lab_anl_method_name |
analysis_date |
|
test_type |
|
EFW2LabRES |
reportable_result |
result_type_code |
|
EFW2LabBCH |
test_batch_type |
test_batch_id |
|
Dilution Factor |
|
|---|---|
EQEDD Section |
Field Name |
EFW2Sample or EFW2LabSMP |
sample_type_code |
EFW2LabTST |
dilution_factor |
EFW2LabRES |
reportable_result |
result_type_code |
|
detect_flag |
|
EFW2LabBCH |
test_batch_type |
Dissolved vs Total |
|
|---|---|
EQEDD Section |
Field Name |
EFW2Sample or EFW2LabSMP |
sample_type_code |
EFW2LabTST |
lab_anl_method_name |
total_or_dissolved |
|
EFW2LabRES |
reportable_result |
result_type_code |
|
cas_rn |
|
reporting_detection_limit |
|
EFW2LabBCH |
test_batch_type |
Estimated Results |
|
|---|---|
EQEDD Section |
Field Name |
EFW2Sample or EFW2LabSMP |
sample_type_code |
EFW2LabRES |
reportable_result |
result_type_code |
|
detect_flag |
|
result_value |
|
reporting_detection_limit |
|
method_detection_limit |
|
EFW2LabBCH |
test_batch_type |
Field Blank Contamination |
|
|---|---|
EQEDD Section |
Field Name |
EFW2Sample or EFW2LabSMP |
sample_type_code |
sample_matrix_code |
|
sample_delivery_group |
|
EFW2LabTST |
lab_anl_method_name |
total_or_dissolved |
|
prep_method |
|
EFW2LabRES |
reportable_result |
result_type_code |
|
cas_rn |
|
detect_flag |
|
result_value |
|
result_unit |
|
reporting_detection_limit |
|
EFW2LabBCH |
test_batch_type |
Holding Times |
|
|---|---|
EQEDD Section |
Field Name |
EFW2Sample or EFW2LabSMP |
sample_type_code |
sample_matrix_code |
|
sample_date |
|
EFW2LabTST |
lab_anl_method_name |
lab_matrix_code |
|
analysis_date |
|
prep_method |
|
preservative_date |
|
preservative |
|
leachate_date |
|
prep_date |
|
EFW2LabRES |
reportable_result |
result_type_code |
|
EFW2LabBCH |
test_batch_type |
Lab Blank Contamination |
|
|---|---|
EQEDD Section |
Field Name |
EFW2Sample or EFW2LabSMP |
sample_type_code |
sample_matrix_code |
|
EFW2LabTST |
lab_anl_method_name |
total_or_dissolved |
|
prep_method |
|
EFW2LabRES |
reportable_result |
result_type_code |
|
cas_rn |
|
detect_flag |
|
result_value |
|
result_unit |
|
reporting_detection_limit |
|
EFW2LabBCH |
test_batch_type |
test_batch_id |
|
Numeric Results |
|
|---|---|
EQEDD Section |
Field Name |
EFW2LabRES |
reportable_result |
result_type_code |
|
result_value |
|
result_unit |
|
EFW2LabBCH |
test_batch_type |
Percent Solids |
|
|---|---|
EQEDD Section |
Field Name |
EFW2Sample or EFW2LabSMP |
sample_type_code |
sample_matrix_code |
|
EFW2LabTST |
percent_moisture |
EFW2LabRES |
reportable_result |
result_type_code |
|
EFW2LabBCH |
test_batch_type |
Preservative |
|
|---|---|
EQEDD Section |
Field Name |
EFW2Sample or EFW2LabSMP |
sample_type_code |
EFW2LabTST |
lab_anl_method_name |
preservative |
|
EFW2LabRES |
reportable_result |
result_type_code |
|
detect_flag |
|
EFW2LabBCH |
|
Radiochemistry Estimated Results |
|
|---|---|
EQEDD Section |
Field Name |
EFW2LabRES |
reportable_result |
result_type_code |
|
detect_flag |
|
result_value |
|
minimum_detectable_conc |
|
result_error_delta |
|
uncertainty |
|
EFW2LabBCH |
test_batch_type |
Radiochemistry Relative Error Ratio |
|
|---|---|
EQEDD Section |
Field Name |
EFW2Sample or EFW2LabSMP |
sample_type_code |
sample_matrix_code |
|
parent_sample_code |
|
EFW2LabRES |
reportable_result |
result_type_code |
|
cas_rn |
|
result_value |
|
result_error_delta |
|
uncertainty |
|
EFW2LabBCH |
test_batch_type |
Radiochemistry Tracer Recovery |
|
|---|---|
EQEDD Section |
Field Name |
EFW2LabTST |
lab_anl_method_name |
EFW2LabRES
|
reportable_result |
result_type_code |
|
qc_spike_recovery |
|
qc_spike_lcl |
|
qc_spike_ucl |
|
EFW2LabBCH |
test_batch_type |
Relative Percent Difference (RPD) |
|
|---|---|
EQEDD Section |
Field Name |
EFW2Sample or EFW2LabSMP |
sample_type_code |
sample_matrix_code |
|
parent_sample_code |
|
EFW2LabTST |
lab_anl_method_name |
prep_method |
|
EFW2LabRES |
reportable_result |
result_type_code |
|
cas_rn |
|
detect_flag |
|
result_value |
|
reporting_detection_limit |
|
qc_rpd |
|
qc_rpd_cl |
|
qc_spike_recovery |
|
qc_dup_spike_recovery |
|
EFW2LabBCH |
test_batch_type |
test_batch_id |
|
Field Duplicate RPD |
|
|---|---|
EQEDD Section |
Field Name |
EFW2Sample or EFW2LabSMP |
sample_type_code |
sample_matrix_code |
|
parent_sample_code |
|
EFW2LabTST |
lab_anl_method_name |
prep_method |
|
EFW2LabRES |
reportable_result |
result_type_code |
|
cas_rn |
|
detect_flag |
|
result_value |
|
reporting_detection_limit |
|
EFW2LabBCH |
test_batch_type |
Relative Standard Deviation (RSD) |
|
|---|---|
EQEDD Section |
Field Name |
EFW2Sample or EFW2LabSMP |
sample_type_code |
sample_matrix_code |
|
parent_sample_code |
|
EFW2LabTST |
lab_anl_method_name |
prep_method |
|
EFW2LabRES |
reportable_result |
result_type_code |
|
cas_rn |
|
detect_flag |
|
result_value |
|
reporting_detection_limit |
|
qc_rsd |
|
qc_spike_recovery |
|
qc_dup_spike_recovery |
|
EFW2LabBCH |
test_batch_type |
test_batch_id |
|
Repeated Results |
|
|---|---|
EQEDD Section |
Field Name |
EFW2Sample or EFW2LabSMP |
sys_sample_code |
EFW2LabTST |
lab_anl_method_name |
total_or_dissolved |
|
test_type |
|
EFW2LabRES |
reportable_result |
result_type_code |
|
cas_rn |
|
EFW2LabBCH |
test_batch_type |
Repeated Results from Two Methods |
|
|---|---|
EQEDD Section |
Field Name |
EFW2Sample or EFW2LabSMP |
sys_sample_code |
EFW2LabTST |
total_or_dissolved |
EFW2LabRES |
reportable_result |
result_type_code |
|
cas_rn |
|
EFW2LabBCH |
test_batch_type |
Required Detection Limit |
|
|---|---|
EQEDD Section |
Field Name |
EFW2Sample or EFW2LabSMP |
sample_type_code |
sample_matrix_code |
|
EFW2LabTST |
dilution_factor |
EFW2LabRES |
reportable_result |
result_type_code |
|
cas_rn |
|
detect_flag |
|
result_value |
|
reporting_detection_limit |
|
detection_limit_unit |
|
EFW2LabBCH |
test_batch_type |
Lab vs Field RPD |
|
|---|---|
EQEDD Section |
Field Name |
EFW2Sample or EFW2LabSMP |
sample_type_code |
sample_matrix_code |
|
EFW2LabRES |
reportable_result |
result_type_code |
|
cas_rn |
|
result_value |
|
EFW2LabBCH |
test_batch_type |
Spike Recovery – Multiple Rules |
|
|---|---|
EQEDD Section |
Field Name |
EFW2Sample or EFW2LabSMP |
sample_type_code |
sample_matrix_code |
|
parent_sample_code |
|
EFW2LabTST |
lab_anl_method_name |
dilution_factor |
|
prep_method |
|
EFW2LabRES |
reportable_result |
result_type_code |
|
cas_rn |
|
qc_spike_recovery |
|
qc_dup_spike_recovery |
|
qc_spike_lcl |
|
qc_spike_ucl |
|
qc_original_conc |
|
qc_spike_added |
|
qc_spike_measured |
|
qc_dup_original_conc |
|
qc_dup_spike_added |
|
qc_dup_spike_measured |
|
EFW2LabBCH |
test_batch_type |
test_batch_id |
|
Surrogate Recovery |
|
|---|---|
EQEDD Section |
Field Name |
EFW2Sample or EFW2LabSMP |
sample_matrix_code |
EFW2LabTST |
lab_anl_method_name |
dilution_factor |
|
prep_method |
|
EFW2LabRES |
reportable_result |
result_type_code |
|
cas_rn |
|
qc_spike_recovery |
|
qc_spike_lcl |
|
qc_spike_ucl |
|
EFW2LabBCH |
test_batch_type |
Trip Blank Contamination |
|
|---|---|
EQEDD Section |
Field Name |
EFW2Sample or EFW2LabSMP |
sample_type_code |
sample_matrix_code |
|
chain_of_custody |
|
EFW2LabTST |
lab_anl_method_name |
total_or_dissolved |
|
prep_method |
|
EFW2LabRES |
reportable_result |
result_type_code |
|
cas_rn |
|
detect_flag |
|
result_value |
|
result_unit |
|
reporting_detection_limit |
|
EFW2LabBCH |
test_batch_type |
Verify Sample Units |
|
|---|---|
EQEDD Section |
Field Name |
EFW2LabRES |
reportable_result |
result_type_code |
|
result_unit |
|
EFW2LabBCH |
test_batch_id |