Data Reporting

Water Plant / Distribution MOR (5002)

This report includes the Chlorine Residual QOR Report data and replaces the requirement to submit this form on paper as soon as a full quarter of results have been submitted.

• Water Systems Instructions for completing the Water Plant/Distribution System MOR
• Paper Form PDF - Excel - These files are only to be used when submitting hardcopy forms to the district office
• Excel Spreadsheet Form Updated for December 13, 2011 Version - This form may also be downloaded in eDWR and may be used for electronic reporting.

Surface Water Treatment Rule MOR (5109)

• Instructions for Completing the Surface Water Treatment Plant Disinfection, Turbidity (CFE, IFE) and Total Organic Carbon MOR
• Paper Form PDF - Excel - These files are only to be used when submitting hardcopy forms to the district office
• Excel Spreadsheet Form Updated for December 13, 2011 Version - This form may also be downloaded in eDWR and may be used for electronic reporting.

Ground Water Rule Plant MOR (5109)

• Instructions
• Paper Form PDF - Excel - These files are only to be used when submitting hardcopy forms to the district office.  Note: This is for Compliance with the Ground Water Rule

Microbiological/Coliform SSR (Form 5211)

• Instructions for completing the a Coliform Sample Submission Report (SSR)
• Paper Form PDF - Doc
• Excel Spreadsheet Form This form may also be downloaded in eDWR and may be used for electronic reporting.

Chemical SSR (Form 5019)

• Instructions
  • Paper Forms
    • Generic Sample Submission Report (SSR) PDF - Doc
  • Excel Spreadsheet Form Updated for December 12, 2011 Version - This form may also be downloaded in eDWR and may be used for electronic reporting.
  • Reporting Limits for Chemical Analytes (Appendix B to OAC Rule 3745-89-03) 
  • Nitrate Reporting Procedure 
  • Reporting tips 
• List of methods and corresponding codes
• List of PWS' State Facility Codes and Associated Sample Monitoring Points

Lead and Copper Reports

Note: The following are only available as paper forms

• Checklist for Completing Lead and Copper Sample Monitoring Requirements PDF
• Instructions for Collection of Lead & Copper Samples by Residents PDF
• Instructions for Form 5105 with appendix PDF
• Drinking Water Lead and Copper Monitoring Report (Form 5105 with appendix) PDF - Word
• Worksheet for 90th Percentile Calculation Excel
• Consumer Notice of Tap Water Result (Community) PDF - Word
• Consumer Notice of Tap Water Result (Nontransient Noncommunity) PDF - Word
• Verification of Lead Consumer Notice Issuance PDF - Word

If your system has exceeded a lead or copper action level, the following forms are available for use:

Note: The following are only available as paper forms. 

• Lead Public Education Brochure Template Word
• Water Quality Parameter Monitoring Report and Entry Point Lead and Copper Monitoring Report with Instructions (Form 5108) PDF
• Template for Lead Public Education after Exceedance (Community) PDF - Word
• Template for Lead Public Education after Exceedance (NTNC and Certain Community) PDF - Word
• Verification Form for Lead Public Education (Community) PDF - Word
• Verification Form for Lead Public Education (NTNC) PDF - Word

LT-2 Reports

For Meeting LT2 Only:

• Two Stage Lime Softening
• Bag and Cartridge Filters
• Bank Filtration
• Combined Filter Performance
• Individual Filter Performance
• Presedimentation
• Secondary Filtration Credit MOR

For Meeting LT2 and Surface Water Rules:

UV Forms and Instructions:

• MOR and MOLs For UV: Intensity Setpoint
• MOR and MOLs For UV: Calculated Dose
• MOR Instructions For UV
• MOL Instructions For UV: Calculated Dose
• MOL Instructions For UV: Intensity Setpoint 
• MOL Instructions For Completing UV off Specification Worksheet
• MOL Instructions For Completing UV Sensor Calibration Worksheet

Membrane Forms and Instructions:

• Membrane MOR Form
• Instructions for Membrane MOR
• Membrane MOL Form
• Instructions for Membrane MOL

Filter Backwash Rule

• Filter Backwash Recycling Rule Recordkeeping Form

Call Brian Tarver, Division of Drinking and Ground Water, Central Office at (614) 728-1740 direct, (614) 752-2752 main, or email at brian.tarver@epa.state.oh.us

The Water system's and Laboratory's Responsible Officials and Operators need to have an account, a PIN and Service Authorization. Additional users may be delegated by the Responsible Official to enter or submit data on their behalf. These additional user need an eBusiness account and if they are submitting, they will need their own PIN.

In order to start using eDWR you will need to complete the following three steps:

1. Create an account on the eBusiness center.  Go to: https://ebiz.epa.ohio.gov/login.jsp  and select the link "Create New Account". It will ask you to create a User ID and a password.  Enter your name, address, email and phone number.  At the bottom will be a "Submit" button.   You may now log into the eBusiness center with the password and user id that you just created.
2. Second you will need a PIN.
   
   1. Log in to the eBusiness Center, scroll down about half way down the page to the section that says "My Tasks".  There will be a link to create or apply for a new PIN.  Click that link.
   2. It will then ask you to re-enter your email address and ask and answer five security questions.  
   3. At the bottom will be a "submit" button.
   4. This page will have a link labeled "Division of Drinking and Ground Waters". Open and print the PDF document.  This is your PIN form.  This form will need to be signed in front of a Notary and mailed in to the Ohio EPA.  This PIN is your signature, so do not share it.  If someone else needs to be allowed to submit, they will need their own account and PIN.
3. You will need to be associated to your PWS. 
   
   1. From the home page, there is a list of "Services" near the top of the page. 
   2. Select the view/edit link under the facilities column in the same row as eDrinking Water Reports.
   3. Select add facility. 
   4. Enter the PWS ID in the first search box, labeled Regulatory Program ID and Click Search. 
   5. Select the “Agency Core ID” link.
   6. This will return to where you started, but with the PWS or Lab in the list at the bottom. 
   7. Click Next button.
   8. Check the Check Box for Certify/Submit, then click the "Submit eDWR Service Request" button.
   9. The next screen will have a link to download or open a form.  Click the link labeled "Division of Drinking and Ground Waters" and Open the document, Print the document and follow the printed instructions.
   10. Print, Sign and Fax it to (614) 644-2909 Attention Brian Tarver or mail it to:

Ohio EPA, Division of Drinking and Ground Waters
PO Box 1049
Columbus, OH 43216-1049

In order to submit reports, you must have a PIN. Please note, that your PIN is your electronic signature. Do not share your PIN with other users. If another person need to be able to report your data, they will need their own account and PIN. The responsible Official may then Delegate them the rights to submit.

1. Log in to the eBusiness Center, scroll down about half way down the page to the section that says "My Tasks".  There will be a link to create or apply for a new PIN.  Click that link.
2. It will then ask you to re-enter your email address and ask and answer five security questions.  
3. At the bottom will be a "submit" button.
4. This page will have a link labelled "Division of Drinking and Ground Waters". Open and print the PDF document.  This is your PIN form.  This form will need to be signed in front of a Notary and mailed in to the Ohio EPA.  This PIN is your signature, so do not share it.  If someone else needs to be allowed to submit, they will need their own account and PIN.

You will need to be associated to your PWS in order to be able to report data for your system. 

1. From the home page, there is a list of "Services" near the top of the page. 
2. Select the view/edit link under the facilities column in the same row as eDrinking Water Reports.
3. Select add facility. 
4. Enter the PWS ID in the first search box, labeled Regulatory Program ID and Click Search. 
5. Select the “Agency Core ID” link.
6. This will return to where you started, but with the PWS or Lab in the list at the bottom. 
7. Click Next button.
8. Check the Check Box for Certify/Submit, then click the "Submit eDWR Service Request" button.
9. The next screen will have a link to download or open a form.  Click the link labeled "Division of Drinking and Ground Waters" and Open the document, Print the document and follow the printed instructions.
10. Print, Sign and Fax it to (614) 644-2909 Attention Brian Tarver or mail it to:

Ohio EPA, Division of Drinking and Ground Waters
PO Box 1049
Columbus, OH 43216-1049

Delegation:

1. To Delegate, log into the eBusiness center.  From the home page select the “View/Edit” link under the delegations column in the same row as eDrinking Water Reports
2. Select the “Add User” Link beside the PWS listed.
3. Select the “Add Account” link
4. Enter the user’s name OR user id and click search
5. Select his name and click next
6. Click Delegate
7. Select either the Prepare/Review or the Certify/Submit privilege. (this is where you can decide what rights he or she has) Click Submit.
8. Enter your PIN and security answer and click submit.

eBusiness home page:

1. Links: These will be on all pages and will take you to the State of Oho home page, Ohio EPA home page or to log out of the eBusiness Center
2. eBusiness Home:  This link will be on all pages and will return you to this main page
3. Account: This will always indicate your userid for the account logged into the eBusiness Center
4. Available Services: These are currently all of the available services or programs that can be accessed. The eDrinking Water Reports link will take you into eDWR.
5. Facilities: This link is for managing, adding, deleting and requesting water system and laboratory associations to your account.
6. Delegations: This link allows Responsible Officials to delegate access to additional user accounts to prepare or certify reports.
7. My Tasks: Lists all reports that are currently in process or submitted.

Create a new Plant Distribution MOR: (Download Instructions)

1. Log into eDWR
2. Select eDrinking Water Reports.
3. Select Create New Reports from the Water System Menu, and select a PWS from the “Water System Reports” drop-down. 
   Go to 4A for Online Entry or 4B for Excel File

4A: Online Entry – Select “Entry” for the MOR to be created

• Select STU from dropdown list
• Reporting Period – Select month 
• Reporting Lab ID – Lab Cert number of lab conducting analysis on this report, or lab ID of the PWS, or 8000.
• SAVE – Note: Select the reporting period BEFORE Saving
• Select “Entry” for each section of the report to completed
• Submit

4B: Excel File with XML Upload - Select “Excel” for the MOR to be created

• Download and Save the Excel File (.xls)
• Open Excel File and when prompted select “enable Macros”
• Complete the MOR and save the Excel file.
• Select Generate XML, save the XML file.
• Select Upload XML Reports

5. Supply PIN and certify the data entered.

6. Submit

7.Select “View Submissions” and verify that the report has been Accepted. Rejected reports must be corrected and re-submitted.

Create a new Lab Submission: (Download Instructions and Reporting Tips)

1. Log into eDWR
2. Select eDrinking Water Reports.
3. Select Create New Reports on the Laboratory Menu, the user selects a laboratory from the “Drinking Water Reports” drop-down.  Select the “Lab-B” for microbiological Submissions or “Lab-C” for Chemistry results.
4. The user previews and prepares eDWR file in accordance with reporting requirements using one of these methods.
   1. Step 4A: Completing the online entry web form and submitting the report.
   2. Step 4B: Copying and pasting data into the online web form.
   3. Step 4C: Using the Microsoft Excel Template to generate an XML file for upload.
5. Supply PIN and certify the data entered.
6. Submit
7. Select “View Submissions” and verify that the report has been Accepted.  Rejected reports must be corrected and re-submitted.

Once you have created your eBusiness account you will need to navigate to several different areas of the eBusiness Center and eDWR. The following pdf documents will show how to get around in the system.

• eBusiness Home Page
• eDWR Menu options

If you have an eBusiness account and are associated to your PWS, you can view any sample that your lab has submitted.

1. Log into eDWR
2. Go into eDrinking water reports
3. On the left side Menus, select "View Lab Submission" (should be the first item under the Water System Menus)
4. Select the water system and date range, if necessary, and click “Go". This will display the list of all reports labs have submitted for you.
5. In order to open and view the report, select the "View Lab Reports" tab at the top right and then select the "View" icon next to the report. By default you will be on "View Lab Submissions", this does not allow you to view the report.
6. Report opens in a new window.  Drag the corner of the window wider in order to display the entire report.

How do I Print My MOR report?

1. Log into eDWR
2. Go into eDrinking water reports
3. On the left side Menus, select "View Submission" (should be the last item under the Water System Menus)
4. Select the water system and date range, if necessary, and click “Go”
5. Select the View icon next to the report you need to view
6. Report opens in a new window.  Drag the corner of the window wider in order to display the entire report.
7. Print this report by either Right Clicking over the MOR and select Print Preview or select the File Menu and Print Preview.
8. Change the paper format from Portrait (vertical) to Landscape (horizontal) view [3rd icon from the top left]
9. Print

I submitted my MOR report but my EPA staff doesn’t have it!
Most of the time this is related to the reporting period on your report.  Make sure you have the right Month and Year that the staff is looking for by viewing the report you submitted to make sure it is the correct report.

1. Log into eDWR
2. Go into eDrinking water reports
3. On the left side Menus, select "View Submission" (should be the last item under the Water System Menus)
4. Select the View icon next to the report you need to view
5. Report opens in a new window.  Drag the corner of the window wider in order to display the entire report.

I have an email receipt for my report but my EPA staff doesn’t have it
Did you check the submission Status of your report?  The email receipt does NOT mean that your report was Accepted.  Users MUST verify the acceptance of their own reports.
To verify that your report was accepted:

1. Go to "View Submissions"
2. The Status column will have either a Green Checkmark indicating the report is accepted or a Red “X” indicating the report was rejected.

Depending on the method you used to report, Online entry or XML upload, follow the steps below to resubmit.
Online Entry:

1. Log into eDWR
2. Go into eDrinking water reports
3. On the left side Menus, select "View Submission" (should be the last item under the Water System Menus)
4. If necessary, change the “Submitted Between” dates so that you can find the reports you need to update and click the “Go” button.
5. Click the "Edit" icon next to the file you need to correct (this creates a Copy of the report).
6. On the left side Menus, select "Retrieve Saved Reports"
7. Click the "Edit" icon next to the file you need to correct. This will take you into the report.
8. Make your corrections
9. Click Next and Click Submit

XML upload:

1. Open your Excel Spreadsheet
2. Make your corrections
3. Generate a new XML file.
4. Log into eDWR
5. Go into eDrinking Water Reports
6. Select Upload XML and re-upload your corrected report.

The status of your submission will indicate whether the report was received or not. A successfully submitted report only means that you uploaded data to Ohio EPA. The status of your report will indicate whether or not we received it or not.
Status:  

• Processed - Green Check Mark indicates your report was submitted, processed and accepted.

• Rejected - Red "X" indicates your report has an error and was not accepted. Your report has not been received. You will need to correct errors and resubmit.  

• Received - Yellow Question Mark indicates that you have uploade/submitted your report, but it has not been processed. This can take up to 45 minutes. If you see this status, check back later to ensure your file was accepted.  

• Resubmitted - Paper icon indicates that this report had an error, but was selected, corrected and re-submitted. 

Update Account Information:
Account information includes your address, email address, phone number and company. Users need to keep this information current.

1. Log into the eBusiness Center.
2. Select  My Account (upper left)
3. Select Update account
4. Edit any out of date information and save.

Update PIN Information:
PIN information includes your security questions and answers as well as your mailing address.

1. Log into the eBusiness Center.
2. Select  My Account (upper left)
3. Select PIN Management – Update PIN holder information
4. Enter your PIN and Security answer
5. Edit any out-of-date information and save.

No, you do not need a new account when you move to a new lab or PWS.  The account and PIN you created are yours, not the system you work for.  You will need to update your account and PIN information. Your company, phone number, email addresses, etc.

Update Account Information:
Account information includes your address, email address, phone number and company. Users need to keep this information current.

1. Log into the eBusiness Center.
2. Select  My Account (upper left)
3. Select Update account
4. Edit any out of date information and save.

Update PIN Information:
PIN information includes your security questions and answers as well as your mailing address.

1. Log into the eBusiness Center.
2. Select  My Account (upper left)
3. Select PIN Management – Update PIN holder information
4. Enter your PIN and Security answer
5. Edit any out-of-date information and save.

The division has a bulk email system for receiving specific kinds of information, updates and rule changes. Specifically for eDWR we have one for Public Water System operators and another for Laboratory information. These are used to update users to any changes to be made to the system or at times when eDWR may not be available.

Go to our Listserve page and select the lists you would like to receive information. This Web page is for individuals interested in getting on electronic mailing lists maintained by Ohio EPA's divisions and offices to receive resources such as division newsletters, fact sheets, training announcements, information on funding opportunities, etc.  For several divisions, this also includes notification of new rules or changes in rules.