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