Region 2 Superfund: Electronic Data Deliverable (EDD) Frequent Questions

1. What is the current version of the format file and EDP?
2. How do I update the Valid Values Reference Manual tables to include additional information such as CAS numbers, analytes, prep method, etc.?
3. What is the Data Provider Code?
4. How can I submit EDD data electronically?
5. Where do I go for help correcting errors in the EDP?
6. How do I report QC samples such as field blank, lab blank, equipment blank, trip blank, etc.?
7. What can I do when the values loaded in excel (e.g. Potassium) appear to be a date?
8. Is it required to report the Reporting Detection Limit?
9. How to report the Interpreted Qualifier?
10. What is the file format for Base Map?

---

1. What is the current version of the format file and EDP?
The current version of both the format file and EDP can be found here. To check your version: The format file version is displayed in the status bar in EDP.

2. How do I update the Valid Values Reference Manual tables to include additional information such as CAS numbers, analytes, prep method, etc.?
Please check the online link or your own references for CAS numbers, if the CAS number is not provided in the Valid Values Reference Manual table A15-17 please request one using the online form.

3. What is the Data Provider Code?
The data provider code is an abbreviated company code. For references to company code, lab code and data provider code look in valid value tables: A23 and A17 of the Valid Values Reference Manual. If your company code is not available, please request one using the online form.

4. How can I submit EDD data electronically?
Please refer to the documentation section 2.11 in the Basic Manual “Submitting Your EDD to EPA”, or in section 2.12 in the Comprehensive Manual "Submitting Your EDD to EPA."

5. Where do I go for help correcting errors in the EDP?
Refer to the standalone EDP user’s guide, section 2.6 Finding and resolving error or 2.8 Error Resolution.

6. How do I report QC samples such as field blank, lab blank, equipment blank, trip blank, etc.?
All samples must have a unique sample code. The sample type needs to be FB, LB, EB, TB etc, in order for the sys_loc_code to be null.

7. What can I do when the values loaded in excel (e.g. Potassium) appear to be a date?
Potassium: when load the value in excel, but it appears to be a date, add the ‘ in front of the value to eliminate the error.

8. Is it required to report the Reporting Detection Limit?
If the detect flag = No, Result type = TRG (TARGET, REGULAR RESULT), TIC (TENTATIVELY IDENTIFIED COMPOUND) or SC (SPIKED COMPOUNDS), then the Reporting Detection Limit is required. If the detect flag = No, Result type = SUR (SURROGATE), IS (INTERNAL STANDARDS), then the Reporting Detection Limit is not required.

9. How to report the Interpreted Qualifier?
If Lab Qualifier or Validated Qualifier is populated, the interpreted qualifier is required. Interpreted Qualifier values can be found in Table A-10 from the Valid Values Reference Manual.

10. What is the file format for Base Map?
Base Map should be submitted in “dxf” file format.