Electronic Exchange of Drinking Water Lab Data - PowerPoint PPT Presentation

Electronic exchange of drinking water lab data l.jpg
Download
1 / 46

Electronic Exchange of Drinking Water Lab Data. Presented by: Mike Matsko NJDEP Exchange Network Users Meeting April 18, 2006. eDWR Project Background. Project was initiated and funded as a 2002 Exchange Network Challenge Grant 5 Participating States: NH, ME, NJ, RI, and VT

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

Download Presentation

Electronic Exchange of Drinking Water Lab Data

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Electronic exchange of drinking water lab data l.jpg

Electronic Exchange of Drinking Water Lab Data

Presented by: Mike Matsko

NJDEP

Exchange Network Users Meeting

April 18, 2006


Edwr project background l.jpg

eDWR 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


Edwr project objectives l.jpg

eDWR 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


Edwr project phases l.jpg

eDWR 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 > Validation > Feedback

  • Phase 2

    • Develop a system to support a Lab to State data exchange


Edwr system development steps l.jpg

eDWR 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


What is e2 l.jpg

What 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


E2 capabilities for labs and water systems l.jpg

E2 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


E2 submission options l.jpg

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


E2 user types l.jpg

E2 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


E2 user roles l.jpg

E2 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


Lab user getting started l.jpg

Lab User Getting Started


Water system user getting started l.jpg

Water System User – Getting Started


Submission system benefits l.jpg

Submission 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


E2 next steps l.jpg

E2 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


Edwr submission system l.jpg

eDWR Submission System

Questions?


New jersey architecture l.jpg

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


  • Login