Transcript Example Slide Title - National Environmental Information

MICHIGAN’S
Electronic Discharge Monitoring
Reporting System (e-DMR)
Michael Beaulac
February 28, 2005
What Are Discharge Monitoring Reports?
Discharge Monitoring
Reports (DMR): daily &
monthly reports submitted to
State water regulators by
facilities (i.e., industry &
municipal WWTP) permitted
(NPDES) to discharge
treated effluent to lakes and
rivers
DMRs include: compliance
limits of all chemical
parameters in the
wastewater effluent for each
permitted facility
July 22, 2015
Footer (Ex: Internal Use Only)
The Paper Burden!
DMRs reportedly the second-largest federal or state
reporting requirement,
following only IRS tax returns
July 22, 2015
Footer (Ex: Internal Use Only)
Why MI needed e-DMR?
Eliminate Manual Data Entry:
State officials manually entered mailed DMRs into state database
Data entered again into EPA's Permit Compliance System
Data coding error rate: 4-10 % (depending on who you believe)
DMR paper backlog: 3 year’s worth
Lack of data access: Staff who needed daily DMRs most
didn’t have access to the paper forms.
July 22, 2015
Footer (Ex: Internal Use Only)
What We Did to Make it Happen
1.
Schema Development
Team assembly
Financial backing (& commitment)
Schema creation
2.
Develop back-end system - NMS
“Bucket” to capture daily DMRs, including water chemistry
Query & reporting capabilities
Enhanced availability for district staff
3.
Testing & Implementation
Facility => State: May 2003
Node Development: Summer – Fall 2003
State => EPA: January 2004
July 22, 2015
Footer (Ex: Internal Use Only)
What We Did to Make it Happen
4. Outreach/Marketing - Communications
Pilot testing – w/Industry reps
Mass Education – w/200 attendees
Web - demo
Project Website
Exchange Network
On-line user manuals
Brochures (targeted)
Presentations
Press events/releases
Incentives/Disincentives
Paper DMRs no longer delivered to facilities
Field inspector site visits
July 22, 2015
Footer (Ex: Internal Use Only)
Michigan e-DMR Data Flow – Big Picture
Michigan e-DMR Data Flow
Internet
Internet
Data Exchange
Facility Users
Data Exchange
E2 Data Collection
System
Data Exchange
NMS Data Repository
CDX
Data Exchange
Michigan
e-Node
EPA Network
Node (CDX)
Complete data flow from:
Permitted Facilities => State => EPA’s
Permit Compliance System!
July 22, 2015
Footer (Ex: Internal Use Only)
Michigan e-DMR Facility-to-State Data Flow
1
User Authentication:
User ID, Password,
PIN
2
Prepare DMR,
Certify, Submit
Retrieve RR based on “Limits”
web
3
4
Upload DMRs, Validate
Process Confirmation
Receipt
Confirmation
E2
Process
Confirmation
NPDES Permittee
DEQ Environment
Michigan State DMZ Zone
July 22, 2015
NMS
Footer (Ex: Internal Use Only)
Inner Network
Michigan e-DMR State-to-CDX Data Flow
1
2
Node query NMS to
retrieve DMR data in
e-DMR XML format
Node calls CDX to authentic
and receive a Security Token
(issed by NAAS) from CDX
4
Node SUBMIT
IDEF file with
ST to CDX
web
3
5
Node calls IDEF
converter to convert
XML to IDEF file
Node invokes
PCS process
confirmation
Success
Confirmation
Node UPDATE
NMS records
to complete
submissions
Upload DMR
NMS database
6
CDX
Michigan
Node
IDEF Converter Tool
DMR in XML
schema
DEQ Environment
Style
Sheet
Converter
DMR in
IDEF
Inner Network
Michigan State DMZ Zone
July 22, 2015
Footer (Ex: Internal Use Only)
PCS
EPA Environment
NPDES Management System (NMS)
& e-DMR System
Client Computers
Client Computers
Client Computers
Client Computers
Client Computers
NMS Users (DEQ Staff)
July 22, 2015
NPDES
Management
System
(NMS)
Database
e-DMR
(E2)
System
Footer (Ex: Internal Use Only)
Client Computers
Internet Users
(Regulated Facilities)
NMS / e-DMR - Scenario
Client Computers
Client Computers
NMS
Database
NMS Users (DEQ Staff)
July 22, 2015
E-DMR (E2)
System
1) DEQ Staff add permit
Limits to NMS for
a Facility
Footer (Ex: Internal Use Only)
Internet Users
(Regulated Facilities)
NMS / e-DMR - Scenario
Client Computers
Client Computers
NMS
Database
NMS Users (DEQ Staff)
July 22, 2015
E-DMR (E2)
System
2) NMS copies Permit limits
to e-DMR System
Footer (Ex: Internal Use Only)
Internet Users
(Regulated Facilities)
NMS / e-DMR - Scenario
Client Computers
Client Computers
NMS
Database
NMS Users (DEQ Staff)
July 22, 2015
E-DMR (E2)
System
3) Facility retrieves their
Limits from e-DMR System
and fills out an e-DMR
document
Footer (Ex: Internal
Use Only)
Internet Users
(Regulated Facilities)
Facility User Login to the e-DMR System…
July 22, 2015
Footer (Ex: Internal Use Only)
Select Which Month’s DMR to Work With…
July 22, 2015
Footer (Ex: Internal Use Only)
…and fill out the DMR Data using the Online Data Entry forms…
July 22, 2015
Footer (Ex: Internal Use Only)
Enter your personal PIN Number and Certify your Submission…
July 22, 2015
Footer (Ex: Internal Use Only)
NMS / e-DMR - Scenario
4) Facility submits their
DMR back to the
e-DMR System
Client Computers
Client Computers
NMS
Database
NMS Users (DEQ Staff)
July 22, 2015
E-DMR (E2)
System
5) e-DMR System sends an
e-mail confirmation
back to facility
Footer (Ex: Internal Use Only)
Internet Users
(Regulated Facilities)
NMS / e-DMR - Scenario
Client Computers
Client Computers
NMS
Database
NMS Users (DEQ Staff)
July 22, 2015
E-DMR (E2)
System
6) e-DMR System sends DMR
data back to NMS
Footer (Ex: Internal Use Only)
Internet Users
(Regulated Facilities)
NMS / e-DMR - Scenario
Client Computers
Client Computers
NMS
Database
NMS Users (DEQ Staff)
July 22, 2015
e-DMR (E2)
System
7) NMS checks e-DMR for
compliance and creates
a violation if necessary
Footer (Ex: Internal Use Only)
Internet Users
(Regulated Facilities)
…and view the status of your submitted DMRs!
July 22, 2015
Footer (Ex: Internal Use Only)
NMS / e-DMR - Scenario
Client Computers
Client Computers
NMS
Database
NMS Users (DEQ Staff)
July 22, 2015
E-DMR (E2)
System
8) DMR data now available
to DEQ Staff for
Evaluation, etc…
Footer (Ex: Internal Use Only)
Internet Users
(Regulated Facilities)
System Architecture
• Target customers: State Agencies
• Client-Server based application
• Developed using Microsoft .NET
Framework 1.0
• Use Integrated Window Authentication
July 22, 2015
Footer (Ex: Internal Use Only)
NMS On-line Queries
July 22, 2015
Footer (Ex: Internal Use Only)
Summary of Discharges Statewide
July 22, 2015
Footer (Ex: Internal Use Only)
Review of Daily Measurements
July 22, 2015
Footer (Ex: Internal Use Only)
Michigan’s Facility Participation Results
July 22, 2015
Footer (Ex: Internal Use Only)
State Water Bureau Benefits
Reduce data coding operators and other staff
resources (but increases help desk need)
Improves data quality: facility => State => EPA
by elimination of data coding errors
Improves the MI wastewater program efficiency
… shifts focus to C & E
Three-year backlog of paper reports eliminated
… and never to appear again!
July 22, 2015
Footer (Ex: Internal Use Only)
State Government
Annual Cost Savings & ROI
Annual Savings: $250,000 - $500,000 (at full
implementation with all 1,180 facilities)
Return on Investment: 3 - 4 years
July 22, 2015
Footer (Ex: Internal Use Only)
Facility Benefits
Annotated Quotes from our Permitted Facilities …
“Saves my compliance admin costs … streamlines the
DMR reporting process”
“… provides immediate feedback of compliance status for
proper actions”
“… will increase the amount of data accessible for trend
analysis”
“… data entry errors are reduced …”
“Time saver … more traceable than paper … immediate
confirmation of receipt”
July 22, 2015
Footer (Ex: Internal Use Only)
Facility Annual Cost Savings
… at least $2,000 saved per facility per year
or $2,360,000*
*(… and this may be low)
July 22, 2015
Footer (Ex: Internal Use Only)
Public Benefits
Increases public access to environmental
information via the web (future scope)
Increases Water Bureau staff’ availability for
better respond to public inquiries (i.e.,
problem solving)
July 22, 2015
Footer (Ex: Internal Use Only)
Upcoming e-Applications









Permitting - (June 2004 – December 2007)
Toxic Release Inventory – (January - February 2005)
Groundwater Reporting - (March 2005)
STORET – (March - April 2005)
Drinking Water Reports - (March 2005)
AWR and Tier II – (Winter 2005/2006)
Homeland Security – (Winter 2005/2006)
Air Quality Reporting – (Winter 2006)
Dry Cleaning – (Winter 2006)
July 22, 2015
Footer (Ex: Internal Use Only)
Further Information
Michael Beaulac
MI Department of Environmental Quality
517-241-7808
[email protected]
Jeff Jones
MI Department of Environmental Quality
517-335-4125
[email protected]
July 22, 2015
Footer (Ex: Internal Use Only)