Workstation System Requirements
CMDP is a web-based application delivered through your web browser. You will need the latest version of Internet Explorer (9 and above), Firefox, or Chrome. (Please note that CMDP has not been tested for compatibility with the Microsoft Edge browser). A screen resolution of 1366 x 768 pixels is recommended.
Using CMDP with SDWIS State
Using CMDP with SDWIS State requires the Latest versions of SDWIS State, XML Sampling and the Data Synchronization Engine (DSE). You can download these from the ASDWA web site.
The DSE is an add-on module installed in the SDWIS State server that interfaces with SDWIS XML Sampling to load sample/sample results and operational data into the SDWIS State Database. In addition, the DSE ensures that certain inventory, legal entity and laboratory certification data are consistent between SDWIS State and CMDP.
Laboratories and water systems can report these samples/sample results and operational data to their Primacy Agency using CMDP:
- Samples/Sample Results type data
- Operational type data
- CFE Turbidity
- IFE Turbidity
- Chlorine Chloramine Entering Distribution System
- Chlorine Chloramine in Distribution System
- Trihalomethane (THHM) and Haloacetic Acids (HAA5)
- Chlorine Dioxide and Chlorite
- Lead and Copper Rule Water Quality Parameters
- Total Organic Carbon
- Ozone Treatment (Bromate)
For the above italicized sample types the data stored in CMDP will not be migrated to SDWIS/STATE until a future version of CMDP is released. In the interim, to migrate these sample results in the Operational Data Category to state primacy agencies for compliance determination, laboratories and water systems may report as Chemicals all of the analytes associated with the italicized items by using a LIMS or by using the Chemicals/Radionuclides web form or templates.
Data Reporting Methods
CMDP supports three methods of reporting data by using:
- Online data entry screens available on the CMDP web site
- Using Microsoft Excel workbook templates (one for samples/sample results data, another for operational data). You download the necessary Excel template from CMDP, enter data into the Excel workbook, and convert the workbook into a file format that you upload to CMDP as a samples job.
- For samples/results data only, using the CMDP Representation State Transfer Application Programming Interface (ReST API) to create samples jobs in CMDP directly from your Laboratory Information Management System (LIMS).
Detailed instructions for using each of these methods are available from this help center.
You can download the unsupported operational data from CMDP, however, you will have to retain these data in some other database of your design. As of the date of this article, there are no plans to modify SDWIS State to include the unsupported operational data types. While SDWIS Prime does house the unsupported operational data types, the requirements for these data will likely change as development continues.
Using CMDP with a System Other than SDWIS State
Primacy agencies can use CMDP with a compliance system other than SDWIS State, however there are some limitations:
- Samples and operational data jobs are manually downloaded from CMDP and then uploaded into the non-SDWIS State compliance system. Note that EPA does not support processes, software and procedures for uploading samples and operational data into a non-SDWIS State system.
- As of the date of this article, CMDP does not support synchronization of inventory, legal entity and laboratory certification data between CMDP and non-SDWIS State compliance systems.
Existing Lab to Primacy Agency Data Flows
Many primacy agencies use SDWIS Lab to State (or similar web site) to collect samples/sample results data using XML files formatted according to the Exchange Network’s eDWR data exchange template. CMDP uses a proprietary data exchange template. Laboratories and water systems will have to modify software used to generate eDWR-formatted files to generate files following the CMDP XML format. EPA is not responsible for the cost of modifying the software laboratories and water systems use to generate CMDP compliant XML files.
Primacy agencies also need to be careful about how they migrate laboratories and water systems from existing electronic reporting to CMDP reporting. For example, primacy agencies should avoid situations where a laboratory or water system reports the same data to the primacy agency through CMDP and through the legacy data flow. This could result in duplication of data and increased effort to correct data errors in the compliance system. CMDP transition plans should carefully consider how and when laboratories and water systems cut over from the legacy to the new CMDP data flow.
Laboratories Reporting to Multiple Primacy Agencies
Large laboratories can have water system customers located in different states, so they will have to keep track of the primacy agencies they deal with and how data are reported. Because CMDP requires that a laboratory submit sample jobs to individual primacy agencies, there could be situations where a laboratory reports data to the incorrect primacy agency. While the CMDP data validation processes will catch these errors, primacy agencies should be aware of this potentiality.
User Provisioning and Authentication
CMDP uses EPA’s Shared CROMERR Services (SCS) to provision and authenticate primacy agency, laboratory and water system users. SCS is a web-based application requiring no software installation on the user and primacy agency side.
Primacy agencies must complete the process and obtain the appropriate authorization for electronic submission of data under the EPA’s Cross Media Electronic Reporting Rule (CROMERR) before using CMDP.
Two CMDP roles for primacy agency users – the state CMDP administrator and state compliance officer – are provisioned and authenticated using SCS. These users will require a separate set of credentials to access SDWIS Prime. USEPA is investigating a single sign-on approach allowing state CMDP administrators and compliance officers to use their SCS credentials to log into SDWIS Prime. An alternative to the single sign-on approach is to move the CMDP administrator and compliance officer functions from the CMDP application to SDWIS Prime in a future software release.