From TEISS To EIS

1. From TEISS To EIS Angelique Luedeker, ITEP/TAMS Center

2. Homework Discussion • Does anyone have questions on how to back-up a TEISS project? • Does anyone have any other questions?

3. Steps of Exporting Data from TEISS and Submitting to EIS • Run QA Check on data with TEISS • Correct formatting flagged by TEISS • Generate EIS QA XML files with TEISS • Submit EIS QA XML files to QA Environment of EIS Gateway • Review QA feedback reports

4. Steps (continued) • Make corrections based on QA feedback reports, if necessary • Regenerate EIS QA XML files with TEISS, if necessary • Resubmit EIS QA XML files to QA Environment and review feedback reports, if necessary • Generate EIS Production XML files with TEISS

5. Steps (continued) • Submit EIS Production XML files to Production Environment of EIS Gateway • Review Production feedback reports

6. A. Run TEISS QA Check • From TEISS menu, select NEI, then QA Check Options

7. A. Run TEISS QA Check (continued) • Specify what pollutant data you want TEISS to include in QA check and click Next button

8. Select source types and locations to check To check everything, leave Validate All selected Otherwise, click Validate Selected, choose source types and locations you want TEISS to check A. Run TEISS QA Check (continued)

9. A. Run TEISS QA Check (continued) • Click on Finish button to view any necessary formatting corrections TEISS has flagged

10. A. Run TEISS QA Check (continued) • Options for correcting formatting • If only a few necessary corrections, can double-click on correction to go directly to it in TEISS project • Use list to find necessary corrections in TEISS project • Print option to print list • Save To File option to generate a text file of list • Can copy list to word processing program to outline action plan

11. A. Run TEISS QA Check (continued) • TEISS generates emissions for a wide range of pollutants, some do not have valid pollutant codes in EIS • Some pollutants might still be of interest to the tribe, even if not accepted by EIS • If many pollutants are no longer valid according to check and you do not want to delete them from your TEISS project, it is okay to leave them in TEISS project • EIS gives you an error (error code 470) but it is okay to ignore only this error since EIS simply does not import these pollutants

12. Click on NEI button on TEISS toolbar (fourth icon on toolbar) Select “Export…” option to get this screen Make any needed adjustments and click Next button B. Generate QA XML Files

13. B. Generate QA XML Files (continued) • Specify where file is saved in this screen, select the “Compress…” option (if not a point file), give file a descriptive name, and click Next button

14. B. Generate QA XML Files (continued)

15. B. Generate QA XML Files (continued) • In this example, we are focusing on nonpoint • Click on Nonpoint tab • Select the “Export Nonpoint Sources” option and give file a descriptive name • Make sure only tribe data is selected • Make sure Submission Type of “QA” is selected on Transmittal Information tab • Must fill in all fields on Transmittal Information tab

16. B. Generate QA XML Files (continued) For example, if Tribal Code is 000, Program System Code:Point=TR000, Other=000 EPA Tribal Codes are in Code list on EIS Gateway

17. B. Generate QA XML Files (continued) • Click on Finish button to view flagged data, then click on the Export to NEI format button to generate file

18. C. Submit to QA Environment • Register for EIS if you do not yet have an account • Instructions located at: http://www.epa.gov/ttn/chief/eis/index.html • Two step process • Step One is to join EIS Community in EPA Portal • Step Two is to complete profile in EIS

19. C. Submit to QA Environment (continued) • Find XML file or zipped file you generated with TEISS • By default, these files go into same folder your TEISS project is in • Zip file if not already zipped • Log on to the Exchange Network Web Client (https://nodewebrss.epa.gov) • For Domain, select IAMLdap, if you do not have an EPA email address

20. C. Submit to QA Environment (continued) • Click on EIS on left side of screen, then use Browse… button to navigate to zipped file, double-click on file to select it

21. C. Submit to QA Environment (continued) • Click on Submit button • You should receive an email from CDX when file was submitted and another email when file has been processed • The second email could take minutes or days depending on how busy the system is

22. C. Submit to QA Environment (continued) • Example of first email from CDX, Transaction Status = Pending

23. C. Submit to QA Environment (continued) • Example of second email from CDX, make sure Transaction Status = Processed

24. D. Review QA Feedback Report • You should receive an email from EIS Gateway system (noreply@epa.gov) acknowledging submission

25. D. Review QA Feedback Report (continued) • Example of email from EIS Gateway, click on link in email to review feedback report

26. D. Review QA Feedback Report (continued) • A spreadsheet comes up with several worksheets

27. D. Review QA Feedback Reports (continued) • Review Statistics worksheet to make sure it is what you expected

28. D. Review QA Feedback Report (continued) • If there are errors other than error code 470 (pollutant code not valid) they must be corrected in TEISS and data must be resubmitted to EIS QA Environment

29. E. Correct Based on QA Feedback Report • Find data in TEISS and make corrections

30. F. Regenerate QA XML Files • Repeat Step B to regenerate QA XML file with TEISS • Use same file name to overwrite initial file or if using a different file name, make sure it indicates that this is corrected file

31. G. Resubmit to QA Environment • Repeat Step C and Step D to resubmit data to QA Environment • When you have a clean QA feedback report (no errors) or only error codes 470, you are ready generate an EIS Production XML file

32. H. Generate Production XML Files with TEISS • Process is nearly identical to generating a QA XML file, Step B • The only difference is you need to modify Submission Type selection of “QA” to “Production” in Transmittal Information tab

33. I. Submit to Production Environment • Complete same steps as submitting to QA Environment, Step C

34. J. Review Production Feedback Report • You should receive an email from EIS Gateway system (noreply@epa.gov) acknowledging submission • Click on link in email to review feedback report

35. J. Review Production Feedback Report (continued) • Verify in Summary worksheet that file was submitted to Production Environment • Verify in Summary worksheet that there are no errors or only error codes 470 • Review Statistics worksheet to make sure it is what you expected

36. Homework due in 5 days: • Run a QA Check on your data with TEISS. • Use Save To File option to generate a text file of initial results. • Email text file to the instructors. • Make any necessary corrections to data in TEISS project.