Jump to main content.


Effluent Charts Help

Effluent Charts allows you to create charts, tables, and data downloads of permitted effluent limits, releases, and violations over time for Clean Water Act (CWA) discharge permits issued under the National Pollutant Discharge Elimination System (NPDES). Information about NPDES discharge measurement is available under "CWA/NPDES Compliance Status" in the ECHO Data Dictionary.

Here you can find help with the following topics:

Getting to the Charts
Viewing the Charts
Viewing and Downloading Data
Custom Searches
Reporting Errors
Data Considerations
Data Dictionary

Getting to the Charts

There are two ways to arrive at a page of effluent charts:

Viewing the Charts
Clicking on any of the links highlighted above will take you to a page of charts for your selected permit and parameters. At the top of the page is a table showing the search criteria: image of top of chart page, showing selection criteria and Download, Revise Search, and Report Error buttons Revise search will take you to a custom search form with all of your previous selections in place, so you can revise them and search again. The Download and Report Error buttons are explained below.

Below the list of search criteria is a table of information about the selected permit: Below that is the series of effluent charts, grouped by parameter. Each chart shows all of the effluent measures, permitted limits, and effluent violations for the given dates, for a single permit, discharge point, parameter, monitoring location, and sampling period. The charts show different violation data for ICIS-NPDES permits, reflecting the different information stored about violations in those systems.

ICIS-NPDES records violation data for each permitted limit: up to three concentrations (identified as concentrations 1, 2, and 3; typically specified in the permit as minimum, average, and maximum concentrations) and two quantities (quantities 1 and 2; typically average and maximum) for each outfall, parameter, monitoring location, and monitoring period. The charts for ICIS-NPDES permits show these violation data in separate quantity and concentration violation plots above the corresponding effluent plots:

Viewing and Downloading Data
From a CWA Effluent Report page:

The Download button at the top of the Detail page will allow you to download the data from just that table.

The Data Dictionary describes the contents of effluent data tables and downloads.

Custom Searches
Clicking on either the "Custom Output" link in a Detailed Facility Report, or the "Revise Search" button on a page of effluent charts, will take you to an effluent data query form prefilled with information about that permit: image of a query form

The update form button is enabled when you enter a new, valid (9 letters and digits) NPDES permit ID. If you click on it, the form will be refilled with information associated with that permit.

Under "Select charts", the Charts with violations button selects only charts that include at least one effluent violation. All selects all of the charts for which there is some data available, whether or not they include violations.

Under Monitoring locations and Outfall types, the Effluents only checkboxes select only the monitoring locations or outfall types associated with effluent discharges. All selects all outfall types or monitoring locations, not just those associated with effluent discharges.

part of a query form, showing \

When you've made your selections, click on any Search button to create the page of charts.

Reporting Errors
If you believe that some of the information in an effluent report, table, or download is in error, you may report your findings from Effluent Charts:

The error reporting form will ask for your contact information, in order to keep you informed of progress in addressing your report, and a description of the problem. Please include enough information to allow EPA to identify the data in question and to evaluate your comment.

\

Once you submit the report, it will be entered into EPA's Integrated Error Correction Process. You will receive an immediate acknowledgement, and status updates as EPA determines how to address the report (see Error Correction Performance Standards).

Data Considerations
The CWA Effluent Charts only show effluent data and violations, and compliance schedule violations (late or missing discharge monitoring reports (DMRs)). They do not show single-event violations (other types of permit violations, often the result of inspection findings).

Under certain circumstances, Effluent Charts may appear to be missing effluent, limit, or violation data. There are several reasons for this apparent lack of information, which may be broken into the following cases:

Numeric limits are present without measurement data or violations. This can occur in some cases for non-major permits. Without this functionality, missing measurements will not result in violations.

Effluent measurements are present without corresponding numeric limits. This may reflect a condition where "monitoring only" is either optional or required.

No limit or measurement data are shown for a specific time period. Lack of limit or measurement data may be due to seasonal limits or optional monitoring. Lack of measurement data for required monitoring will generate violations, unless DMR non-receipt tracking is turned off.

Data Dictionary

This section describes the format and contents of effluent data downloads. For general information about CWA/NPDES discharge measurement, please see the ECHO Data Dictionary.

Effluent data downloads are returned as rows in text format, with the same set of fields in each row. The first row contains the field names. Field values are separated by commas, and enclosed in quotes if they should be treated as text. The rows are returned in a hierarchically sorted order, first by permit ID, then by pipe ID, parameter, monitoring location, period, and date.

Table 1 below lists the fields present in each row of a data download. Key fields, which identify each level of the data hierarchy, are shown in bold face. Other, non-key fields describe attributes that depend on the key value at each level of the hierarchy; for example, the name or description of a pipe or parameter. Key field values are repeated in each row of the download, while non-key values are returned only with the first occurrence of each key value, and left empty after that.

Table 1: Contents of Effluent Data Download Records
Field name Description
PermitID 9-character code that uniquely identifies a permit. Begins with the two-letter abbreviation of the state in which the permit was issued.
DB Names which of the two CWA compliance data systems is the source of data for this permit: ICIS-NPDES.
Name Official or legal name of the permittee
Address Facility location - street address
City Facility location - city
State Facility location - state (2-letter abbreviation)
Zip Facility location - Zip code
Status Whether the permit is currently in force. Permits currently in force will have a value of Effective or Administratively continued (ICIS-NPDES). Permits not in force will have other values such as Pending, Expired, Terminated, or Retired (ICIS-NPDES).
Designation Class of discharger: either major or minor (non-major)
Ownership Type of ownership, e.g. private, municipal, or other government
Pipe 3- or 4-character code that uniquely identifies a single permitted discharge point (also called a pipe or outfall)
Desc Description of the pipe.
Paramtr 5-character code that uniquely identifies a permitted substance or quantity
Name Name of the parameter
Monlocn 1-3-character code that identifies the monitoring location, i.e. the location at which sampling for the parameter is to occur
Name Description of the monitoring location
Period Number of months in the required reporting interval: 1 for monthly, 3 for quarterly, etc.
Date End date of the required monitoring period, as YYYYMMDD
XX_VALQ* Value qualifier: usually empty, but may be < or > to indicate that the reported value is really an upper or lower bound on the true value
XX_VALUE* Reported value of the parameter
XX_UNIT* Units of the reported value
XX_LSENSE* Direction of the permitted limit for this parameter: < or <= indicates an upper limit, > or >= indicates a lower limit
XX_LVAL* Value of the permitted limit for this parameter. XX_LSENSE indicates whether this is an upper or lower limit. Can be empty if only monitoring is required, without a permitted limit.
XX_LUNIT* Units of the limit value
XX_LTYPE* Statistical type of the permitted limit: one of 'min', 'avg', or 'max', to indicate that the smallest, average, or largest of the sample measurements taken within a reporting period are being limited and must be reported.
XX_VLEVEL*I Severity of any alleged violation caused by the reported value:
  • SNC = significant noncompliance
  • RNC = reportable noncompliance
  • effluent = effluent violation, i.e. discharge in excess of permitted limit
  • monitoring/reporting = monitoring or reporting violation
  • (blank) = none
XX_VCODE*I Code that describes the type of an alleged violation:
  • E90 = effluent violation
  • D90 = DMR overdue, with a numeric limit
  • D80 = DMR overdue, monitoring only required
Other codes exist but are rarely used.
XX_RNCCODE*I Code that describes the type of RNC:
  • A = Enforcement Order
  • B = Manual 2A4 - Pass-Through
  • C = Chronic Violation
  • D = Manual Other
  • E = Manual 2F - Permit Narrative
  • F = Manual 2G - Violation of Concern
  • G = Manual 2A1 - Effluent Violation
  • H = Chronic Violation, Non-Monthly Average
  • I = Manual 2A2 - Unauthorized Bypass
  • J = Manual 2A3 - Unpermitted Discharge
  • K = Non-receipt Violation, Non-Monthly Average
  • N = Non-Receipt of DMR/Schedule Report
  • P = Enforcement Order, Non-Monthly Average
  • Q = Manual 2B - Pretreatment
  • R = TRC Limitations Exceeded, Non-Monthly Average
  • S = Schedule Violation
  • T = TRC Limitations Exceeded
  • U = Other Violation with TRC Non-Monthly Average
  • V = Other Violation with TRC
  • W = Manual 2E - Deficient Report
  • X = Manual Other Violation with TRC
  • Y = Manual TRC
  • Z = Manual Chronic
XX_RNCRSLVD*I Code that describes the resolution of RNC:
  • 9 = Manual by Back into Compliance
  • 1 = Unresolved RNC
  • A = Manual Unresolved RNC
  • 3 = Due to Formal Enforcement Action Final Order with Compliance Schedule
  • 4 = In Compliance with Formal Enforcement Action Final Order Requirement
  • 7 = Manual RP - In Compliance with Formal Enforcement Action Order Requirement
  • 8 = Manual Due to Formal Enforcement Action Formal Order
  • 2 = Back into Compliance
  • 5 = Resolved RP by NPDES Closure of Enforcement Action Final Order with Compliance Schedule
  • 6 = Manual Resolution by Enforcement Action
  • B = Manual by EPA/State/Tribal Action
VIOL_LEVELP Severity of the worst alleged violation among the values in this row. See XX_VLEVEL for interpretation.
VIOL_CODEP Code that describes the type of the worst alleged violation among the values in this row. See XX_VCODE for interpretation.
RNC_CODEP Code that describes the type of RNC of the worst violation among the values in this row. See XX_RNCCODE for interpretation.
RNC_RESOLVEDP Code that describes the resolution of RNC for the worst alleged violation among the values in this row. See XX_RNCRSLVD for interpretation.
*Repeating value: occurs once for each XX equal to C1, C2, C3, Q1, Q2. The repeated values describe the up to three concentration-based limits (C1, C2, C3) and two quantity- or mass-based limits (Q1, Q2) that can be established in a permit for each pipe, parameter, monitoring location, and period.
IOnly populated for permits from ICIS-NPDES

Local Navigation


Jump to main content.