NetDMR Presentation Exchange Network Conference Brandon Harris Texas Commission on Environmental Quality April 30,

1. 1 NetDMR Presentation Exchange Network ConferenceBrandon HarrisTexas Commission on Environmental QualityApril 30, 2008

2. 2 Agenda Overview Functionality How you can use NetDMR? Preview Questions?

3. 3 Overview What is NetDMR? Web application that NPDES facilities may use to electronically enter, sign and then submit their Discharge Monitoring Reports (DMRs) to the NPDES permitting authority CROMERR APPROVED (States will still need to get Attorney General Certification, but OECA has already received approval – one of only three systems) NetDMR can also provide the data to ICIS-NPDES to meet certain NPDES permit reporting requirements. The Regulatory Authority (State, Region, Tribal Nation or EPA) that issued the permit approves specific facilities to report using NetDMR. Primary funding TX and IL Exchange Network Grants CT Supplemental Environmental Project (SEP) that was established as part of a negotiated settlement of a joint federal and state enforcement action Many, many, many hours spent by EPA staff, participating state staff, and contractors Built via contract through ECOS and ERG ERG Project Manager - Grace Kitzmiller

4. 4 Organization Project Organization Steering Committee Brandon Harris, Texas CEQ Mike Garretson, Illinois EPA J.R. Hodel, West Virginia DEP Oswald Inglese, Connecticut DEP Andrew Battin, US EPA – OEI David Hindin, US EPA – OECA Elaine Brenner, US EPA – OW At least 9 Other States, EPA HQ/Regional staff, and permittees are involved in review of project materials and testing.

5. 5 Schedule Schedule Project Planning and Organization – May 2006 – Complete Requirements Documentation – February 2007 – Complete Design (Including CROMERR) – December 2007 – Complete Testing – August 2008 Release 1: Create Account, Request Access User acceptance testing: April 4 - April 31, 2008 Release 2: Administration and Edit DMRs User acceptance testing: May 28 – June 20, 2008 Release 3: Sign and Submit DMRs User acceptance testing: July 15 – August 8, 2008 Production Activities TBD EPA planning installation in CDX environment and will operate and maintain it as component of ICIS-NPDES for any interested state using ICIS-NPDES TX CEQ planning installation in TX environment (tentatively set for April 2009)

6. 6 Architecture NetDMR Architecture Java-based web interface JBoss server Tested with both PostgreSQL (open source database) and Oracle 10g databases Four data flows: Basic Permit Data Flow, Empty Slot Data Flow, DMR Data Flow, Error Message Data Flow Code Availability Open source code base!!! Code will be distributed under an open source license Available to download along with documentation when Version 1 Released (scheduled for August 2008) ECOS or Exchange Network site

7. 7 Functionality Two Major Components JAVA application available to the regulated community and regulatory authority Manage Accounts CROMERR compliance (approved checklist – www.epa.gov/cromerr) NPDES Facilities Submit and electronically Sign DMRs View DMR Copy of Records Exchange Network Components (4 Data Flows) Basic Permit Data pull from ICIS-NPDES (permit number, responsible party, dates, etc Empty Slot Data pull from ICIS-NPDES (data necessary to create blank DMR specific to a permit) DMR data “push” to ICIS-NPDES (after DMRs are completed, NetDMR will “gather” them and submit to CDX for processing and ultimate storage in ICIS-NPDES Error Message Data flow from ICIS-NPDES and CDX to NetDMR (to communicate any issues/errors)

8. 8 Functionality – Regulatory Authority System Administrator Deploys NetDMR NetDMR initiates basic permit data flow from ICIS-NPDES Internal Administrator Customizes NetDMR and communicates availability to permittees Permittee requests an account, requests signatory and permit administrator access to a permit, completes and mails the Subscriber Agreement to the Regulatory Authority Internal Administrator reviews subscriber agreement and approves Signatory request NetDMR initiates empty slot data flow for that permit Permittee signatory communicates to their staff that edit and read only access requests can be made

9. 9 Other staff at permittee facility request edit and read only access Permit Administrator/Signatory approve edit and read only requests Permittee staff enter DMR data, sign, and submit a DMR NetDMR creates and stores the Copy of Record (COR) for the DMR NetDMR forwards DMR data to ICIS-NPDES, EPA's central repository for DMR data through EPA's Central Data Exchange using data flow specifications currently under review by the Exchange Network. Permittees can retrieve and download CORs at any time using NetDMR Functionality – Permittee

10. 10 Functionality – CROMERR and Security Communications with NetDMR are secured by a password, responses to security questions, and use of SSL communications. SSL is commonly used by on-line banking sites. NetDMR has received approval from EPA that it meets the requirements of the Cross-Media Electronic Reporting Rule (CROMERR). For more information about CROMERR and the approved NetDMR Checklist for the EPA installation, see http://epa.gov/cromerr/. States or other entities wanting to install their own version of NetDMR or use the EPA version will STILL NEED TO SUBMIT A CROMERR APPLICATION packet to EPA.

11. 11 Functionality Summary

12. 12 Functionality – Network Data Flows

13. 13 How Can States Use NetDMR? State may find the OECA NetDMR CROMERR checklist helpful as an example in pursuing their own CROMERR approvals from EPA Checklist available at www.epa.gov/cromerr Three Ways for a State to Use NetDMR State Locally Hosts NetDMR Using the ICIS-NPDES Data Flows State obtains code (Fall 2008, from the Exchange Network website) State responsible for all installation costs, and all operation and maintenance costs. State coordinates testing of NetDMR with EPA (CDX and ICIS-NPDES). EPA will be ready to support this use of NetDMR in 2009. State Uses U.S. EPA Hosted and Maintained NetDMR (federal instance). Any state using ICIS-NPDES, can decide to authorize its NPDES facilities to use NetDMR. EPA operates and maintains NetDMR as part of ICIS. State responsible to authorizing particular facilities to use NetDMR. States participate in planning enhancements to NetDMR as part of ICIS-NPDES governance process. U.S. EPA (federal instance) expected to be in production in 2009. State Adopts NetDMR to Connect Directly to State NPDES Information System State modifies NetDMR to connect to the state’s NPDES information system. This replaces the four NetDMR ICIS-NPDES flows with internal state data feeds. Map data flows to the state system instead of ICIS-NPDES State responsible for all operation and maintenance costs. States provide EPA with DMR data thru their normal processes.

14. 14 Preview Login Page External User Edit DMR Sign and Submit View Errors Internal User System Administrator Permit Administrator

15. 15 NetDMR Login Page

16. 16

17. 17

18. 18

19. 19

20. 20

21. 21

22. 22

23. 23 Questions?

24. 24 CROMERR GENERAL NOTE: State implementations of this system will require review and approval by EPA. To the extent that a State has adopted the system as described in this application, EPA review of that system will be largely a formality. Where a State chooses to deviate from the system as described in this application, those deviations will be the subject of more thoroughgoing review and analysis by EPA.