Electronic Reporting Requirements for Water Quality Data

The Regulations of Connecticut State Agencies section 19-13-B102(h)(4) establishes that public water systems are required to submit the results of required samples in a format and manner prescribed by the department. The Department has prescribed that the results of all samples must be submitted electronically as outlined below not later than 9 calendar days after the end of each month during which the samples were collected. Connecticut has transitioned to electronic reporting via the Compliance Monitoring Data Portal.

Compliance Monitoring Portal (CMDP) 

The CMDP is an online reporting application that that allows certified laboratories and public water systems to report compliance monitoring data directly to the Drinking Water Section. The CMDP is maintained by the Environmental Protection Agency (EPA) and is available in two versions: Pre-Production (Testing) and Production (Compliance).

CMDP Pre-Production

The Pre-Production environment allows reporters to get familiar with the CMDP and serves as a testing environment. All reporters must register to use CMDP Pre-Production and complete the recommended testing prior to receiving approval to report compliance data through CMDP Production. Section 2.3 of the CMDP Registration User Guide, available in the CMDP Help Center, provides a step by step registration sequence for Laboratory (Lab) and Public Water System (PWS) Administrators. All Lab and PWS Administrators must be approved by a State CMDP Administrator prior to accessing the CMDP. Lab and PWS Administrators will then be able to approve additional CMDP users for their organizations following Section 2.4 of the CMDP Registration User Guide.

To begin the registration process, all users must request access through EPA CROMERR Shared Services (SCS): https://usepa.servicenowservices.com/sdwisprogram?id=cmdp_homepage.

CMDP Production

Upon successfully testing and demonstrating that accurate compliance monitoring data can be reported using CMDP Pre-Production, Lab and PWS Administrators will be invited to request access to CMDP Production. All reporters will follow the same process to register for CMDP Production by creating a new set of credentials and requesting access to the production application. The Lab or PWS Administrator will then coordinate with a State CMDP Administrator to establish a final date to switch from EDI reporting to reporting through CMDP Production.

CMDP Reporting Options

The CMDP offers operationally flexibility by providing a number of options for reporting compliance data to the DWS. Reporters can use any use any of the following combination of methods to report the data:

• XML File Uploads – XML files can be generated by a reporter and manually uploaded into the CMDP. Information related to the structure and requirements of the CMDP XML Schema is available in the Sample Data Dictionary in the CMDP Help Center
• Online Data Entry (Web Forms) – Reporters can enter compliance data into online forms and submit the data through the CMDP. Use of the Online Data Entry forms is documented in the CMDP User Manual in the CMDP Help Center
• Offline Excel Templates – Reporters can enter compliance data into Excel worksheets and generate a properly formed XML for upload into the CMDP. The latest Excel worksheets can be downloaded directly from the CMDP and the CMDP Help Center.
• Web Services – XML files can be generated by a reporter and be automatically uploaded into the CMDP using Web Services. Information related to the CMDP XML Schema and the use of Web Services is available in the Sample Data Dictionary and the CMDP-LIMS Interface Control Document in the CMDP Help Center.

CMDP State Administrators

Contact the following CMDP Administrators if you have any questions or need assistance:

Robert Baran - robert.baran@ct.gov

Sachin Patel - sachin.patel@ct.gov

Reference Materials

• Analyte Codes and Analyte Groups - List of available analyte codes used for reporting and a summary of analyte groups used in CT.
• Laboratory Standard Methods and Analyte Pairings - List of the available codes paired with the appropriate Standard Method Code for reporting. Please contact a CMDP Administrator if a pairing is not listed.
• Mapping SDWIS EDI to CMDP XML - A mapping document that relates current EDI reporting elements to CMDP reporting elements.
• CMDP Quick Reference Guide - Supplemental instructions and clarification for reporting requirements specific to Connecticut.
• Electronic Reporting Update – A presentation delivered at the November 29, 2016 AWWA Lab Operations Meeting

Commercial Laboratories Reporting through the CMDP

Laboratories that are currently submitting water quality data to the DWS in the approved format can be found below. This is not an endorsement of any of the laboratories and is for informational purposes only.

Monthly Operating Reports (MORs)

Monthly Operating Reports (MORs), such as Treatment Effluent Logs, Surface Water Treatment Packages and Ground Water Rule Residual Disinfectant Compliance Monitoring reports, must be reported on the forms provided . In order for the Department to efficiently review and process the data in these reports, only one treatment facility per compliance period should be included in each report. In addition, do not divide each page of the Surface Water Treatment Package into separate files.

All files should be named so they can be easily identified as follows:

Treatment Logs:                     CTXXXXXXX_WSFID_MONTHYEAR

Surface Water Reports:         CTXXXXXXX_WSFID_MONTHYEAR_SWTR

Ground Water Compliance:  CTXXXXXXX_WSFID_MONTHYEAR_GWR

Failure to follow these guidelines may result in the files being rejected and returned for correction.

All MORs must be emailed to drinking.water@ct.gov for processing. 

Instructions for submitting Surface Water Reports and Ground Water Compliance Monitoring Reports through the CMDP will be provided in the future.