Title: Electronic Exchange of Drinking Water Lab Data
1Electronic Exchange of Drinking Water Lab Data
- Presented by Mike Matsko
- NJDEP
- Exchange Network Users Meeting
- April 18, 2006
2eDWR Project Background
- Project was initiated and funded as a 2002
Exchange Network Challenge Grant - 5 Participating States NH, ME, NJ, RI, and VT
- Project consisted of 2 Phases
- Phase 1 March 2003 to December 2004
- Phase 2 December 2005 to December 2005
3eDWR Project Objectives
- Flow SDW data into our State SDWIS system from
Laboratories - Refine the e-DWR schema to support the data
reporting requirements - Develop a set of modular laboratory files that
could be used by other environmental data flows - Develop a scalable submission receiving system
that can be used for easily leveraged for
additional data flows
4eDWR Project Phases
- Phase 1
- Schema Development
- EDI Converter - eDWR XML file conversion to
Sampling via EDI - Stakeholder Survey - Laboratory Readiness for
eDWR system - Best Practices Document - eDWR system
recommendations - Implementation Strategy
- Security
- Account Management
- Submission gt Validation gt Feedback
- Phase 2
- Develop a system to support a Lab to State data
exchange
5eDWR System Development Steps
- Used Phase 1 outputs
- Purchased E2 software from enfoTech Consulting,
Inc. - Consolidated paper forms to web forms
- Revised business process
- NJDEP portal integration
- Develop system detail design document
6What is E2?
- Secure web based system to conduct e-business
over the Internet - Designed by enfoTech to improve data quality and
reduce resources - An intelligent data exchange server that
- Receives reports submitted by regulated
facilities - Evaluates reports for meeting reporting
requirements - Uploads reports to NJDEP for compliance
assessment - Uses Exchange Network web services and XML for
data exchange
7E2 Capabilities for Labs and Water Systems
- Laboratories
- Submit new and revised drinking water reports
- View meaningful validation results on-line
- Save partially completed reports
- View and print all previous submissions
- View status of all submissions and receive email
notification - Water Systems
- Authorize a Lab to submit data on their behalf
- View submissions and status of all reports
submitted on their behalf - Submit new and revised annual water utilization
reports - View meaningful validation results on-line
- Save partially completed reports
- View and print all previous submissions
- View status of all submissions and receive email
notification
8E2 Submission Options
- Web Form Entry A user can data enter each
sample using an Online Entry Form and receive
immediate validation feedback. - Copy / Paste from Excel Offline data
preparation and then copy the data from a
spreadsheet program and paste the data into an
online form for conversion to XML. Validation
feedback is provided via email after E2 has
processed the data. - XML File Upload A user can upload an XML file
or a ZIP file containing one XML file based on
the eDWR schema. Validation feedback is provided
via email after the E2 has processed the data. - MS Excel XML Template A user can download and
populate an Excel file that will generate a valid
XML file for upload. - Note Not all NJDEP forms are available for
electronic submission.
9E2 User Types
- Laboratory User
- Associated with only 1 Certified Laboratory
- Submit only Lab Data for multiple Water Systems
- Water System User
- Associated with 1 or more Water Systems
- Submit only MOR Data for Water Systems
- 1 user account could be both a laboratory and
water system user
10E2 User Roles
- Laboratory Report Preparer
- Laboratory Report Certifier
- Laboratory Administrator
- Authorize Users to Prepare / Certify Lab Reports
for their Lab - Water System Report Preparer
- Water System Report Certifier
- Water System Administrator
- Authorize Users to Prepare / Certify Annual Water
Utilization Reports for their Water System - Authorize NO Laboratories to Prepare / Certify
Lab Reports - Authorize ALL Laboratories to Prepare / Certify
Lab Reports - Authorize Specific Laboratories to Prepare /
Certify Lab Reports
11Lab User Getting Started
12(No Transcript)
13(No Transcript)
14(No Transcript)
15(No Transcript)
16(No Transcript)
17(No Transcript)
18(No Transcript)
19(No Transcript)
20(No Transcript)
21(No Transcript)
22(No Transcript)
23(No Transcript)
24(No Transcript)
25(No Transcript)
26(No Transcript)
27(No Transcript)
28(No Transcript)
29(No Transcript)
30(No Transcript)
31(No Transcript)
32(No Transcript)
33(No Transcript)
34(No Transcript)
35(No Transcript)
36(No Transcript)
37(No Transcript)
38Water System User Getting Started
39(No Transcript)
40(No Transcript)
41(No Transcript)
42(No Transcript)
43Submission System Benefits
- Improve data quality
- Reduce reporting costs
- Reduce reporting burden
- Report status on-line
- Greater control of data quality for Labs and
Water Systems - Decrease State costs
- Improve Agency effectiveness with faster response
for data analyses, compliance, and
decision-making
44E2 Next Steps
- System release for drinking water reporting
- Private Well Testing Act data submissions
- New Jersey Quantitative Limit data submissions
- Volunteer Water Monitoring data submissions
- State to EPA data exchange
- State to State data exchange
45eDWR Submission System
46New Jersey Architecture
Web Servers - Sun v480, Solaris 9 OS, SunOne Web
Server 6.x, Server Certificate/SSL App. Servers -
Sun v480, Solaris 9 OS, SunOne Application Server
7 EE, Server Certificate/SSL Database Servers -
Dell PowerEdge 6650, Red Hat Enterprise Linux AS
v2.1, ORACLE 9i Note In addition to the HW
represented here, there is a box in the Secure
access layer that acts as a reverse proxy so our
Node can talk directly to other Nodes.
Without the reverse proxy, NJDEP would not be
able to use NAAS.