ICIS-NPDES DMR Summary and Data Element Dictionary

The Enforcement and Compliance History Online (ECHO) system incorporates Discharge Monitoring Report (DMR) data submitted by NPDES permit holders to the states or directly to EPA via the US EPA Central Data Exchange (CDX). This compendium of DMR data identifies the permit conditions or limits for each water discharge location, the actual values, identified by the permittee, for each monitored pollutant that was discharged, and whether the amounts discharged exceeded the permit limits. DMR data are stored in the EPA Office of Enforcement Compliance Assurance, Integrated Compliance Information System (ICIS), where it is extracted by ECHO.


DMR Description 

The download data comprises comma-separated value files, one for each fiscal year since 2009, available in individual zip files. Each zip file is named npdes_dmrs_fyxxxx.zip and each CSV is named npdes_dmr_fyxxxx.csv, where xxxx is the fiscal year (e.g., npdes_dmrs_fy2014.zip).

The data contained in the download file is comprised of selected data columns from the following ICIS tables:

SchemaTable
IDEA_ICISICIS_DMR
IDEA_ICISICIS_DMR_EVENT
IDEA_ICISICIS_DMR_FORM
IDEA_ICISICIS_DMR_FORM_PARAMETER
IDEA_ICISICIS_DMR_FORM_VALUE
IDEA_ICISICIS_DMR_VALUE
IDEA_ICISICIS_LIMIT
IDEA_ICISICIS_LIMIT_SET
IDEA_ICISICIS_LIMIT_SET_SCHEDULE
IDEA_ICISICIS_LIMIT_SET_STATUS
IDEA_ICISICIS_LIMIT_VALUE
IDEA_ICISICIS_PERMIT
IDEA_ICISICIS_PERM_FEATURE
IDEA_ICISICIS_DMR_PARAMETER

Top of Page


ICIS-NPDES Data Elements 

NPDES DMR (NPDES_DMR_FYxxxx.csv) 

Element NameData TypeLength
ACTIVITY_IDNumber22
EXTERNAL_PERMIT_NMBRVarChar29
VERSION_NMBRNumber22
PERM_FEATURE_IDNumber22
PERM_FEATURE_NMBRVarChar230
PERM_FEATURE_TYPE_CODEVarChar23
LIMIT_SET_IDNumber22
LIMIT_SET_DESIGNATORVarChar22
LIMIT_SET_SCHEDULE_IDNumber22
LIMIT_IDNumber22
LIMIT_BEGIN_DATEDate7
LIMIT_END_DATEDate7
NMBR_OF_SUBMISSIONNumber22
NMBR_OF_REPORTNumber22
PARAMETER_CODEVarChar25
PARAMETER_DESCVarChar2100
MONITORING_LOCATION_CODEVarChar23
STAY_TYPE_CODEVarChar21
LIMIT_VALUE_IDNumber22
LIMIT_VALUE_TYPE_CODEVarChar23
LIMIT_VALUE_NMBRNumber22
LIMIT_UNIT_CODEVarChar22
LIMIT_UNIT_DESCVarChar213
STANDARD_UNIT_CODEVarChar22
STANDARD_UNIT_DESCVarChar213
LIMIT_VALUE_STANDARD_UNITSNumber22
STATISTICAL_BASE_CODEVarChar23
STATISTICAL_BASE_TYPE_CODEVarChar23
LIMIT_VALUE_QUALIFIER_CODEVarChar23
OPTIONAL_MONITORING_FLAGChar1
LIMIT_SAMPLE_TYPE_CODEVarChar23
LIMIT_FREQ_OF_ANALYSIS_CODEVarChar25
STAY_VALUE_NMBRNumber22
LIMIT_TYPE_CODEVarChar23
DMR_EVENT_IDNumber22
MONITORING_PERIOD_END_DATEDate7
DMR_SAMPLE_TYPE_CODEVarChar23
DMR_FREQ_OF_ANALYSIS_CODEVarChar25
REPORTED_EXCURSION_NMBRNumber 
DMR_FORM_VALUE_IDNumber22
VALUE_TYPE_CODEVarChar23
DMR_VALUE_IDNumber22
DMR_VALUE_NMBRNumber22
DMR_UNIT_CODEVarChar22
DMR_UNIT_DESCVarChar213
DMR_VALUE_STANDARD_UNITSNumber22
DMR_VALUE_QUALIFIER_CODEVarChar23
VALUE_RECEIVED_DATEDate7
DAYS_LATENumber22
NODI_CODEVarChar23
EXCEEDANCE_PCTNumber22
NPDES_VIOLATION_IDNumber22
VIOLATION_CODEVarChar25
RNC_DETECTION_CODEVarChar23
RNC_DETECTION_DATEDate7
RNC_RESOLUTION_CODEVarChar23
RNC_RESOLUTION_DATEDate7

Top of Page


DMR Data Element Definitions 

The following is a list of the data elements and ICIS-derived elements that appear in the NPDES DMR download.

ACTIVITY_ID - A system-generated identifier for an activity performed at or related to a specific site. This ID can be used to uniquely identify a permit version in ICIS.

DAYS_LATE - The system-generated number of days a DMR value was submitted late. It is calculated as the difference between the Value Received Date and the DMR Due Date. For example, if a DMR with a monitoring period end date of June 30, 2018 had a DMR Due Date of August 31, 2018, and the value was received on October 1, 2018, the days late would be 31 (10/1/2018 − 8/31/2018).

DMR_EVENT_ID - A system-generated identifier for a DMR Event.

DMR_FORM_VALUE_ID - A system-generated identifier for the DMR value.

DMR_FREQ_OF_ANALYSIS_CODE - A code indicating how often the permittee analyzed the sampled data. This is the Frequency of Analysis reported for a parameter on a DMR form. For a complete list of codes and descriptions, download the Frequency of Analysis Reference Table (CSV) (4.8 K).

DMR_SAMPLE_TYPE_CODE - A code identifying the sampling method used to provide the values for a parameter on a DMR form. For a complete list of codes and descriptions, download the Sample Type Reference Table (CSV) (1.7 K).

DMR_UNIT_CODE - A code identifying the unit of measure used for the quantity or concentration measurement (DMR_VALUE_NMBR) on the DMR.

DMR_UNIT_DESC - The short description of the unit of measure used for the quantity or concentration measurement (DMR_VALUE_NMBR) on the DMR.

DMR_VALUE_ID - A system-generated identifier for the DMR value.

DMR_VALUE_NMBR - The DMR value number reported on the DMR form.

DMR_VALUE_QUALIFIER_CODE - The code identifying the DMR value operator (for example, <, T, >, E, =). For more information on qualifier code definitions, see the table below.

CodeDescription

<

Less Than

<=

Less Than or Equal To

>

Greater Than

>=

Greater Than or Equal To

=

Equals

T

Too Numerous to Count

E

Estimated

DMR_VALUE_STANDARD_UNITS - The DMR value expressed in standard units, as calculated by the system. Corresponding units are provided in STANDARD_UNIT_CODE/STANDARD_UNIT_DESC.

EXCEEDENCE_PCT - The system-generated percentage by which the DMR value, or adjusted value, exceeded its limit value.

EXTERNAL_PERMIT_NMBR - The unique identifier for a permit.

LIMIT_BEGIN_DATE - The date when a limit takes effect for a specific parameter within a limit set.

LIMIT_END_DATE - The date when a limit stops being in effect for a specific parameter within a limit set.

LIMIT_ID - The system-generated identifier for a parameter limit.

LIMIT_FREQ_OF_ANALYSIS_CODE - A code for how often the permittee must analyze the sampled data. For a list of all codes and descriptions, download the Frequency of Analysis Reference Table (CSV) (4.8 K). Note: When opening the file in Excel, values may display as dates due to the formatting (E.g., "01/30" describes monthly frequency sampling, but may display in Excel as "30-Jan".). Values should display correctly when opening as a text file. 

LIMIT_SAMPLE_TYPE_CODE - The sampling method required by the permit to provide values on the DMR for the limit. For a complete list of codes and descriptions, download the Sample Type Reference Table (CSV) (1.7 K).

LIMIT_SET_DESIGNATOR - The alphanumeric field used to designate a particular grouping of parameters within a limit set. For more information on limit sets, download the Limit Sets Technical Specification (DOC) (61 pp, 3.1 MB).

LIMIT_SET_ID - The system-generated identifier for a limit set. For more information on limit sets download the Limit Sets Technical Specification (DOC) (61 pp, 3.1 MB).

LIMIT_SET_SCHEDULE_ID - The system-generated identifier for a limit set schedule.

LIMIT_TYPE_CODE - The code indicating whether a limit is an enforceable limit (ENF) or an alert limit (ALR). Alert limits do not result in effluent violations when exceeded. Alert limits are also referred to as benchmark thresholds.

LIMIT_UNIT_CODE - The code representing the unit of measure used for quantity or concentration limits (LIMIT_VALUE_NMBR).

LIMIT_UNIT_DESC - The short description of the unit of measure used for the limit value (LIMIT_VALUE_NMBR).

LIMIT_VALUE_ID - The system-generated identifier for the Limit Value.

LIMIT_VALUE_NMBR - The limit value number from the permit or enforcement action. If this value is blank or null, the DMR includes report-only monitoring, meaning there is no limit, alert, benchmark, or threshold value.

LIMIT_VALUE_QUALIFIER_CODE - The code identifying the limit value operator (for example, <, T, >, E, =). For more information on qualifier code definitions, see the table below.

CodeDescription

<

Less Than

<=

Less Than or Equal To

>

Greater Than

>=

Greater Than or Equal To

=

Equals

T

Too Numerous to Count

E

Estimated

LIMIT_VALUE_STANDARD_UNITS - The limit value expressed in standard units, as calculated by the system. Corresponding units are provided in STANDARD_UNIT_CODE/STANDARD_UNIT_DESC. If this value is blank or null, the DMR includes report-only monitoring, meaning there is no limit, alert, benchmark, or threshold value.

LIMIT_VALUE_TYPE_CODE - The indicator of the limit value type, such as Quantity 1 or Concentration 2.

MONITORING_LOCATION_CODE - The code for the monitoring location where the monitoring requirement, and any applicable effluent limit, applies. One parameter may have multiple monitoring location requirements for the same permitted feature. Valid code values are:

CodeDescription

0

Intake

1

Effluent Gross

2

Effluent Net

3

Intake Public Water

4

Pretreatment, Process Complete

5

Upstream Monitoring

6

Downstream Monitoring

7

Intake from Stream

8

Other Treatment, Process Complete

9

Phosphate Removal, Process Complete

A

Disinfection, Process Complete

AP

Alternate Process

B

Prior to Disinfection

C

Nitrogen, Removal Complete

D

Tertiary/Advanced Process Complete

E

Secondary/Biological Process Complete

EG

Effluent Gross

F

Primary/Preliminary Process Complete

G

Raw Sewage Influent

H

During Manufacturing

I

Intake from Well

IN

Allowed Increase

J

Intermediate Treatment, Process Complete

K

Percent Removal

L

Digestor

N

In Aeration Unit

O

See Comments

P

See Comments

Q

See Comments

R

See Comments

RS

Beneficial Reuse

RW

Receiving Water

S

See Comments

SC

See Comments

SL

Sludge

T

See Comments

U

See Comments

V

See Comments

W

See Comments

X

End of Chlorine Contact Chamber

Z

Instream Monitoring

Y

Effluent Gross (Supplementary)

GW

Groundwater

II

Industrial Influent

IM

Internal Monitoring Point

PI

Prior to Irrigation

PR

Prior to Reuse

LA

Land Application Soil

MONITORING_PERIOD_END_DATE - The date on which the monitoring period covered by this DMR form ends.

NMBR_OF_SUBMISSION - The attribute stores the number of months for submitting DMRs for the limit set (for example, monthly = 1, quarterly = 3, semi-annually = 6). This data element is blank for unscheduled limit sets. It must be greater than or equal to NMBR_OF_REPORT and divisible by NMBR_OF_REPORT.

NMBR_OF_REPORT - The number of months in the monitoring period covered by the DMR, such as monthly = 1, quarterly = 3, or semi-annually = 6.

NODI_CODE - The No Data Indicator (NODI) code indicates why the permittee did not submit numeric data for an expected DMR value for a monitoring period end date. The status column shows whether the code can be used for new or updated DMR submissions (active). Inactive NODI codes are included because they may appear in previously submitted DMRs.

CodeDescriptionStatus

1

Wrong FlowInactive

2

Operation ShutdownActive

3

Special Report AttachedActive

4

Discharge to Lagoon/GroundwaterInactive

5

Frozen ConditionsInactive

6

State-specific No Data Indicator - InvalidActive

7

No InfluentActive

8

Other (See Comments)Inactive

9

Conditional Monitoring - Not Required This PeriodActive

A

General Permit ExemptionActive

B

Below Detection Limit/No DetectionActive

C

No DischargeActive

D

Lost Sample/Data Not AvailableInactive

E

Failed to Sample/Required Analysis Not ConductedActive

F

Insufficient Flow for SamplingActive

G

Sampling Equipment FailureInactive

H

Invalid TestInactive

I

Land AppliedActive

J

Recycled - Water-Closed SystemInactive

K

Natural DisasterInactive

L

DMR Received but not EnteredInactive

M

Laboratory ErrorInactive

N

Not ConstructedActive

P

Laboratory Error or Invalid TestActive

Q

Not QuantifiableActive

R

Administratively ResolvedActive

S

Fire ConditionsInactive

T

Environmental Conditions - Monitoring Not PossibleActive

V

Weather RelatedInactive

W

Dry Lysimeter/WellActive

X

Parameter/Value Not ReportedActive

Y

State-specific No Data Indicator - ValidActive

Z

COVID19 valid Mar - Aug 2020 monitoringInactive

NPDES_VIOLATION_ID - The system-generated identifier for the NPDES violation.

OPTIONAL_MONITORING_FLAG - The flag indicating whether monitoring is optional, but not required, for the DMR value. Effluent violation generation is suppressed for optional columns.

PARAMETER_CODE - The code identifying the parameter monitored and reported on the DMR. 

PARAMETER_DESC - The description of the parameter code. Download the Parameter Reference Table (CSV) (218 K) for the complete list of parameter codes and descriptions and corresponding pollutant codes. Additional fields in this table include:

  • SNC_FLAG - The flag indicating whether the parameter is within pollutant group 1 or 2 or blank for purposes of calculating RNC, SNC, and Category I noncompliance.
  • PERCENT_REMOVAL_FLAG - The flag indicating whether the parameter is a percent removal parameter, used to determine the formula for calculating the parameter’s percent exceedance.
  • PERCENT_EXCEEDENCE_FLAG - The flag indicating whether percent exceedance can be calculated for the parameter.

PERM_FEATURE_ID - A system-generated identifier for the permitted feature.

PERM_FEATURE_NMBR - The identifier assigned to the location where permit conditions are applied.

PERM_FEATURE_TYPE_CODE - The code indicating the type of permitted feature, such as External Outfall or Sum. Valid code values are:

CodeDescription
ARWReceiving Water (Ambient)
CDSCo-disposal Site
DOFDischarge to Offsite Facility
EXOExternal Outfall
INCIncinerator
INFInfluent Structure
INOInternal Outfall
INSIntake Structure
LASLand Application Site
MODMobile Offshore Drilling Unit (MODU)
OTROther
PLAPlatform
SDSSurface Disposal Site
SUBSubsea
SUMSum
WELMonitoring Well

REPORTED_EXCURSION_NMBR - The number of times a limit was exceeded for a parameter, as reported on the DMR form. 

RNC_DETECTION_CODE - The code indicating the reportable noncompliance (RNC) detected for a violation. Valid code values are:

CodeDescription

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

RNC_DETECTION_DATE - The date RNC was detected, either automatically or manually. When ICIS-NPDES detects RNC, the detection date varies depending on the type of violation.

RNC_RESOLUTION_CODE - The code indicating the reportable noncompliance (RNC) resolution for a violation. Note: some resolution codes are for unresolved RNC. Valid code values are:

CodeDescription
1NC - Unresolved RNC
ANC - Manual Unresolved RNC
0RE - Automated Administratively Resolved (DMR Non-Receipt Violations)
2RE - Back into Compliance
5RE - Resolved RP by NPDES Closure of Enforcement Action Final Order with Compliance Schedule
6RE - Manual Resolution by Enforcement Action
9RE - Manual by Back into Compliance
BRE - Manual by EPA/State/Tribal Action
3RP - Due to Formal Enforcement Action Final Order with Compliance Schedule
4RP - In Compliance with Formal Enforcement Action Final Order Requirement
7RP - Manual RP - In Compliance with Formal Enforcement Action Order Requirement
8RP - Manual Due to Formal Enforcement Action Formal Order

RNC_RESOLUTION_DATE - The date RNC was assigned its current resolution status. It can be entered manually or automatically.

STANDARD_UNIT_CODE - The code representing the standard unit of measure used for quantity or concentration limits and DMR measurements. For more information on units displayed, see the STANDARD_UNIT_DESC field. 

STANDARD_UNIT_DESC - The short description of the standard unit of measure used for limit or DMR values.

STATISTICAL_BASE_CODE - The code representing the unit of measure used for limit and DMR values, such as a 30-day average or daily maximum. For a complete list of codes and descriptions, download the Statistical Base Code Reference Table (CSV).

STATISTICAL_BASE_TYPE_CODE - The short description indicating whether the statistical base code is a minimum, average, maximum, or total. For a complete list of codes and descriptions, download the Statistical Base Code Reference Table (CSV).

STAY_TYPE_CODE - The code identifying the type of stay applied to a limit. It indicates whether the limit does not appear on the DMR, is treated as monitor only, or has a stay value in effect during the stay period. The stay limit value is entered in STAY_VALUE_NMBR.

CodeDescription

X

Suppress Effluent Violations

Y

Suppress DMR Non-Receipt Violations

Z

Use Stay Value

STAY_VALUE_NMBR - The numeric limit value imposed during the stay period. If entered, the system uses this value to calculate compliance during the stay period instead of the permit or enforcement action limit value.

VALUE_TYPE_CODE - The indicator of the limit value type, such as Quantity 1 or Concentration 2.

VALUE_RECEIVED_DATE - The date the DMR value was received by the regulatory authority. Note that there may be a delay between the monitoring period associated with the DMR and the date the regulatory authority receives the DMR. For the end date of the monitoring period associated with the DMR values, see Monitoring_Period_End_Date.

VERSION_NMBR - The permit version when a modification or reissuance is applied. The current permit is VERSION_NMBR = 0. The oldest permit version is VERSION_NMBR = 1, the next oldest is VERSION_NMBR = 2, and so on.

VIOLATION_CODE - The code identifying the type of violation(s) associated with the DMR value (D80 = Required Monitoring DMR Value Non-Receipt, D90 = Limited Value Overdue Non-Receipt, E90 = Effluent Violation).