Complete - The Exchange Network

1


NetDMR Presentation

Exchange Network Conference



Brandon Harris

Texas Commission on Environmental Quality




April 30, 2008


TCEQ

2

Agenda

•
Overview

•
Functionality

•
How you can use NetDMR?

•
Preview

•
Questions?



TCEQ

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

TCEQ

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.

TCEQ

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)

TCEQ

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

TCEQ

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)

TCEQ

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

TCEQ

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

TCEQ

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.


TCEQ

11

Functionality Summary

System

Administrator

(Regulatory

Authority User)

Internal

Administrator

(Regulatory

Authority User
)

Signatory/

Permit

Administrator

(Permittee User)


Edit User

(Permittee User)

Read
-
Only User

(Permittee User)

Install and

Customize

NetDMR


Create

Instance


Create Initial

Internal

Administrator

Customize

Instance

Forward URL,

Other Information

to Permittees

Create

Account

Request

Signatory

Access

Sign and Mail

Subscriber

Agreement

Approve

Signatory

Using NetDMR

Interface

Review

Subscriber

Agreement

Inform Staff that

Edit and Read

Only Access

Requests can

be Made

Create

Account

Request

Edit

Access


Edit DMRs


Approve

Access

Requests

Review and

Edit

DMRs

Sign and

Submit

DMRs

Create

Account

Request

Rad
-
Only

Access


View DMRs


Monitor and Maintain Hosted Version of NetDMR

Monitor Instance

TCEQ

12

Functionality
–

Network Data Flows

TCEQ

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

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


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


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


TCEQ

14

Preview

•
Login Page

•
External User

–
Edit DMR

–
Sign and Submit

–
View Errors

•
Internal User

•
System Administrator

•
Permit Administrator

Links to prototypes

http://www2.ergweb.com/projects/netdmr/stakeholders/index.asp

http://www2.ergweb.com/projects/netdmr/stakeholders/docs/netdmr_prototypes/common/login.html

TCEQ

15

NetDMR Login Page

TCEQ

16

Permittee User Home Page

TCEQ

17

Edit DMR
–

Top of Page

TCEQ

18

Edit DMR
–

Bottom of page

TCEQ

19

Sign and Submit Page

TCEQ

20

Internal Administrator Home Page

TCEQ

21

System Administrator Home Page

TCEQ

22

Permit Administrator
–

Home

TCEQ

23

Questions?

TCEQ

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
.



TCEQ