The Enforcement and Compliance History Online (ECHO) system incorporates data from the Integrated Compliance Information System National Pollutant Discharge Elimination System (ICIS-NPDES).

• ICIS-NPDES Description
• Guidance on ICIS-NPDES Downloads
• ICIS-NPDES Data Elements by Table
• ICIS-NPDES Data Element Definitions

---

ICIS-NPDES Description

ICIS-NPDES is an information management system maintained by the Office of Compliance to track permit compliance and enforcement status of facilities regulated by the National Pollutant Discharge Elimination System (NPDES) under the Clean Water Act (CWA). ICIS-NPDES is designed to support the NPDES program at the state, regional, and national levels.

ICIS-NPDES records included in the download files are those with any permit status code value for the current permit record. The ICIS-NPDES Master General Permits file include the current and historical permit records. ICIS-NPDES records (for all permit types except Master General Permits) includes the following data types:

• Permit facility data
• Inspection information
• Permit schedule violations
• Effluent violations
• Compliance schedule violations
• Single Event violations
• Enforcement actions

The violation data includes system-generated records. ICIS automatically generates three basic types of violations: schedule violations, effluent violations, and DMR non-receipt violations. For each of these three types of violations, there are one or two automatic processes that serve to generate the violations. For each type, there is a process that runs when certain data related to requirements or permittee performance are entered or edited. For schedule violations and DMR non-receipt violations, there are also processes that run nightly. In addition to these automatically generated violations, users can manually enter single event violations. The table below lists the specific types of violations that may be generated by ICIS or manually entered.

Code	Violation Type	Description	Generated by
D80	DMR Non-Receipt	Required monitoring DMR value overdue	System
D90	DMR Non-Receipt	Limited value overdue	System
E90	Effluent	Reported DMR value exceeds maximum or average limit value or is below minimum limit value	System
C10	Schedule	Schedule event reported late	System
C20	Schedule	Schedule event achieved late but reported	System
C30	Schedule	Schedule event not achieved but reported	System
C40	Schedule	Schedule not achieved and not reported	System
Various	Single Event	Any manually determined violation	User

Limited enforcement action data are provided from ICIS FE&C where a NPDES program interest linkage exists. More detailed information about linked enforcement actions can be obtained from the ICIS FE&C download files, by using the Enforcement Action Identifier (ENF_IDENTIFIER).

Top of Page

---

Guidance on ICIS-NPDES Downloads

Only certain data elements from ICIS-NPDES are incorporated into ECHO and a subset of these are provided in the download format. This document contains a list of these data elements, as well as available definitions. The data element table in Section 1.2 presents the ICIS-NPDES data elements in related groups that parallel the data's relationships.

There are two sets of download data. One ZIP file contains a single comma-separated value file for Effluent Violations (NPDES_EFF_VIOLATIONS.csv); the other ZIP file contains 10 comma-separated value files. Data were selected based on a single criterion: that the ICIS-NPDES Permit Status (PERMIT_STATUS) for the current permit version is equal to any non-null value. The files may contain repeating data fields, which will cause records to repeat the key field(s), e.g., NPDES_ID, where a permit has multiple values of the repeating field(s).

Key field columns are present in all CSV files and may be used to join and relate data between files. The following table describes how the tables may be joined:

Key fields		Tables
1	NPDES_ID or EXTERNAL_PERMIT_NMBR	All Tables
2	REGISTRY_ID or FACILITY_UIN	ICIS_FACILITIES, NPDES_INSPECTIONS, NPDES_INFORMAL_ENFORCEMENT_ACTIONS
3	NPDES_VIOLATION_ID	{NPDES_PS_VIOLATIONS, NPDES_CS_VIOLATIONS, NPDES_SE_VIOLATIONS, NPDES_EFF_VIOLATIONS}*, NPDES_VIOLATION_ENFORCEMENTS
4	VERSION_NMBR	ICIS_PERMITS, NPDES_EFF_VIOLATIONS

* NPDES_VIOLATION_ID is a unique identifier for violations in ICIS-NPDES. The ICIS-NPDES data downloads provide violations in four tables by type, and as such, the violations in these tables represent unique records and cannot be joined. However, NPDES_VIOLATION_ID may be used to join to the NPDES_VIOLATION_ENFORCEMENTS table, which describes the EPA civil enforcement action, if any, resulting from a violation.

Top of Page

---

ICIS-NPDES Data Elements by Table

Facility (ICIS_FACILITIES.csv)

Element Name	Data Type	Length
ICIS_FACILITY_INTEREST_ID	Num	22
NPDES_ID1	Char	30
FACILITY_UIN2	Char	12
FACILITY_TYPE_CODE	Char	3
FACILITY_NAME	Char	80
LOCATION_ADDRESS	Char	50
SUPPLEMENTAL_ADDRESS_TEXT	Char	50
CITY	Char	60
COUNTY_CODE	Char	5
STATE_CODE	Char	2
ZIP	Char	14
GEOCODE_LATITUDE	Char	10
GEOCODE_LONGITUDE	Char	11
IMPAIRED_WATERS	Char	20

Top of Page

Permit (ICIS_PERMITS.csv) and Master General Permit (ICIS_MASTER_GENERAL_PERMITS.csv)

Element Name	Data Type	Length
ACTIVITY_ID	Num	22
EXTERNAL_PERMIT_NMBR1	Char	9
VERSION_NMBR	Num	22
FACILITY_TYPE_INDICATOR	Char	10
PERMIT_TYPE_CODE	Char	3
MAJOR_MINOR_STATUS_FLAG	Char	1
PERMIT_STATUS_CODE	Char	3
TOTAL_DESIGN_FLOW_NMBR	Num	22
ACTUAL_AVERAGE_FLOW_NMBR	Num	22
STATE_WATER_BODY	Char	12
STATE_WATER_BODY_NAME	Char	50
RAD_WBD_HUC12S	Char	48
PERMIT_NAME	Char	120
AGENCY_TYPE_CODE	Char	3
ORIGINAL_ISSUE_DATE	Date	7
ISSUE_DATE	Date	7
ISSUING_AGENCY	Char	100
EFFECTIVE_DATE	Date	7
EXPIRATION_DATE	Date	7
RETIREMENT_DATE	Date	7
TERMINATION_DATE	Date	7
PERMIT_COMP_STATUS_FLAG	Char	1
DMR_NON_RECEIPT_FLAG	Char	1
RNC_TRACKING_FLAG	Char	1
MASTER_EXTERNAL_PERMIT_NMBR	Char	9
TMDL_INTERFACE_FLAG	Char	1
PRETREATMENT_INDICATOR_CODE	Char	3
EDMR_AUTHORIZATION_FLAG	Char	1

Top of Page

Permit Components (NPDES_PERM_COMPONENTS.csv)

Element Name	Data Type	Length
EXTERNAL_PERMIT_NMBR1	Char	9
COMPONENT_TYPE_CODE	Char	3
COMPONENT_TYPE_DESC	Char	100

Permit Feature Coordinates (NPDES_PERM_FEATURE_COORDS.csv)

Element Name	Data Type	Length
EXTERNAL_PERMIT_NMBR1	Char	9
PERM_FEATURE_NMBR	Char	4
PERM_FEATURE_ID	Num
LATITUDE_MEASURE	Num	10
LONGITUDE_MEASURE	Num	11

NAICS Code (NPDES_NAICS.csv)

Element Name	Data Type	Length
NPDES_ID1	Char	30
NAICS_CODE	Char	6
NAICS_DESC	Char	100
PRIMARY_INDICATOR_FLAG	Char	1

SIC Code (NPDES_SICS.csv)

Element Name	Data Type	Length
NPDES_ID1	Char	30
SIC_CODE	Char	4
SIC_DESC	Char	100
PRIMARY_INDICATOR_FLAG	Char	1

Inspections (NPDES_INSPECTIONS.csv)

Element Name	Data Type	Length
REGISTRY_ID2	Char	50
NPDES_ID1	Char	30
ACTIVITY_ID	Num	22
ACTIVITY_TYPE_CODE	Char	3
COMP_MONITOR_TYPE_CODE	Char	3
COMP_MONITOR_TYPE_DESC	Char	100
STATE_EPA_FLAG	Char	1
ACTUAL_END_DATE	Date	7
ACTUAL_BEGIN_DATE	Date	7

Top of Page

QNCR Historic Compliance (NPDES_QNCR_HISTORY.csv)

Element Name	Data Type	Length
NPDES_ID1	Char	9
YEARQTR	Char	5
HLRNC	Char	1
NUME90Q	Num	22
NUMCVDT	Num	22
NUMSVCD	Num	22
NUMPSCH	Num	22

Permit Schedule Violations (NPDES_PS_VIOLATIONS.csv)

Element Name	Data Type	Length
NPDES_ID1	Char	30
NPDES_VIOLATION_ID3	Num	22
PERM_SCHEDULE_EVENT_ID	Num	22
VIOLATION_TYPE_CODE	Char	1
VIOLATION_CODE	Char	5
VIOLATION_DESC	Char	100
SCHEDULE_EVENT_CODE	Char	5
SCHEDULE_EVENT_DESC	Char	100
SCHEDULE_DATE	Date	7
RNC_DETECTION_CODE	Char	3
RNC_DETECTION_DESC	Char	100
RNC_DETECTION_DATE	Date	7
RNC_RESOLUTION_CODE	Char	3
RNC_RESOLUTION_DESC	Char	100
RNC_RESOLUTION_DATE	Date	7
ACTUAL_DATE	Date	7
REPORT_RECEIVED_DATE	Date	7

Compliance Schedule Violations (NPDES_CS_VIOLATIONS.csv)

Element Name	Data Type	Length
NPDES_ID1	Char	30
NPDES_VIOLATION_ID3	Num	22
VIOLATION_TYPE_CODE	Char	1
COMP_SCHEDULE_EVENT_ID	Num	22
COMP_SCHEDULE_NMBR	Num	3
VIOLATION_CODE	Char	5
VIOLATION_DESC	Char	100
SCHEDULE_EVENT_CODE	Char	5
SCHEDUE_EVENT_DESC	Char	100
SCHEDULE_DATE	Date	7
ACTUAL_DATE	Date	7
RNC_DETECTION_CODE	Char	3
RNC_DETECTION_DESC	Char	100
RNC_DETECTION_DATE	Date	7
RNC_RESOLUTION_CODE	Char	3
RNC_RESOLUTION_DESC	Char	100
RNC_RESOLUTION_DATE	Date	7
REPORT_RECEIVED_DATE	Date	7

Top of Page

Single Event Violations (NPDES_SE_VIOLATIONS.csv)

Element Name	Data Type	Length
NPDES_ID1	Char	9
NPDES_VIOLATION_ID3	Num	22
VIOLATION_TYPE_CODE	Char	1
VIOLATION_CODE	Char	5
VIOLATION_DESC	Char	476
SINGLE_EVENT_VIOLATION_DATE	Date	7
SINGLE_EVENT_END_DATE	Date	7
SINGLE_EVENT_VIOLATION_COMMENT	Char	4000
SINGLE_EVENT_AGENCY_TYPE_CODE	Char	3
RNC_DETECTION_CODE	Char	3
RNC_DETECTION_DESC	Char	100
RNC_DETECTION_DATE	Date	7
RNC_RESOLUTION_CODE	Char	3
RNC_RESOLUTION_DESC	Char	100
RNC_RESOLUTION_DATE	Date	7

CWA Enforcement Actions (NPDES_FORMAL_ENFORCEMENT_ACTIONS.csv)

Element Name	Data Type	Length
NPDES_ID1	Char	30
ENF_IDENTIFIER	Char	25
ACTIVITY_ID	Num	22
ACTIVITY_TYPE_CODE	Char	3
ENF_TYPE_CODE	Char	7
ENF_TYPE_DESC	Char	100
AGENCY	Char	5
SETTLEMENT_ENTERED_DATE	Date	7
FED_PENALTY_ASSESSED_AMT	Num	22
STATE_LOCAL_PENALTY_AMT	Num	22

Top of Page

CWA Informal Enforcement Actions (NPDES_INFORMAL_ENFORCEMENT_ACTIONS.csv)

Element Name	Data Type	Length
NPDES_ID1	Char	30
REGISTRY_ID2	Char	50
AGENCY	Char	5
ACTIVITY_ID	Num	22
ACTIVITY_TYPE_CODE	Char	3
ACTIVITY_TYPE_DESC	Char	100
ENF_TYPE_CODE	Char	7
ENF_TYPE_DESC	Char	100
ACHIEVED_DATE	Date	7
ENF_IDENTIFIER	Char	25
OFFICIAL_FLG	Char	1

Top of Page

Effluent Violations (NPDES_EFF_VIOLATIONS.csv)

Element Name	Data Type	Length
NPDES_ID1	Char	9
VERSION_NMBR	Num	22
ACTIVITY_ID	Num	22
NPDES_VIOLATION_ID3	Num	22
PERM_FEATURE_NMBR	Char	30
PERMIT_ACTIVITY_ID	Num	22
LIMIT_SET_DESIGNATOR	Char	2
MONITORING_LOCATION_CODE	Char	3
DMR_FORM_VALUE_ID	Num	22
DMR_VALUE_NMBR	Num	22
DMR_VALUE_ID	Num	22
DMR_PARAMETER_ID	Num	22
NODI_CODE	Char	3
ADJUSTED_DMR_VALUE_NMBR	Num	22
LIMIT_VALUE_STANDARD_UNITS	Num	22
VIOLATION_TYPE_CODE	Char	6
VIOLATION_TYPE_DESC	Char	100
VIOLATION_CODE	Char	5
VIOLATION_DESC	Char	100
PARAMETER_CODE	Char	5
PARAMETER_DESC	Char	100
STANDARD_UNIT_CODE	Char	2
STANDARD_UNIT_DESC	Char	13
MONITORING_PERIOD_END_DATE	Date	7
NMBR_OF_REPORT	Num	2
EXCEEDANCE_PCT	Num	22
VALUE_QUALIFIER_CODE	Char	3
UNIT_CODE	Char	2
VALUE_RECEIVED_DATE	Date	7
DAYS_LATE	Num	22
ADJUSTED_DMR_STANDARD_UNITS	Num	22
LIMIT_ID	Num	22
DMR_VALUE_STANDARD_UNITS	Num	22
VALUE_TYPE_CODE	Char	3
RNC_DETECTION_CODE	Char	3
RNC_DETECTION_DESC	Char	100
RNC_DETECTION_DATE	Date	7
RNC_RESOLUTION_CODE	Char	3
RNC_RESOLUTION_DESC	Char	100
RNC_RESOLUTION_DATE	Date	7
STATISTICAL_BASE_CODE	Char	3
STATISTICAL_BASE_MONTHLY_AVG	Char	1
STATISTICAL_BASE_SHORT_DESC	Char	10

Violation Enforcement Actions (NPDES_VIOLATION_ENFORCEMENTS.csv)

This table links civil CWA enforcement actions to specific violations.

Element Name	Data Type	Length
NPDES_VIOLATION_ID3	Num	22
VIOLATION_CODE	Char	5
VIOLATION_DESC	Char	100
ACTIVITY_ID	Num	22
ACTIVITY_TYPE_DESC	Char	100
ENF_IDENTIFIER	Char	25
ACTIVITY_TYPE_CODE	Char	3

Top of Page

---

ICIS-NPDES Data Element Definitions

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

ACHIEVED_DATE

The date on which an Informal Enforcement Action is achieved. For an informal action based on only oral notification, it is the date the regulated entity actually received such notification.

ACTIVITY_ID

The unique identifier for an activity performed at or related to a particular site.

ACTIVITY_TYPE_CODE

A code describing the type of civil enforcement activity. Valid values are:

Code	Description
AIF	Administrative, Informal
AFR	Administrative, Formal
JDC	Judicial

ACTIVITY_TYPE_DESC

Full text description for ACTIVTY_TYPE_CODE.

ACTIVITY_OUTCOME_CODE

Contains a code describing the outcome of the inspection.

ACTIVITY_OUTCOME_DESC

Full text description for ACTIVITY_OUTCOME_CODE.

ACTUAL_DATE

The date on which the activity/milestone was conducted or achieved. Date format is MM/DD/YYYY.

ACTUAL_END_DATE

Identifies the calendar date of the listed inspection (MM/DD/YYYY).

ADJUSTED_DMR_STANDARD_UNITS

The Adjusted DMR value expressed in standard units as calculated by the system.

ADJUSTED_DMR_VALUE_NMBR

The Adjusted DMR value number reported on the DMR if an effluent trade(s) has taken place for a Limit parameter that has at least one effluent trade partner.

AGENCY

Identifies the agency lead (S = State, E = EPA) for the listed enforcement action.

AGENCY_TYPE_CODE

A three character code indicating the type of organization issuing or granting a permit. Valid code values are:

Code	Description
ST6	State
MN6	Municipal
CT6	County
RG6	Regional
EP6	U.S. EPA
EC6	EPA Contractor
EO6	Other - EPA
IN6	Interstate
LC6	Local
OF6	Other Federal
SC6	State Contractor
SO6	Other - State
TR6	Tribal
UN6	Unknown from Conversion
SE6	Senior Environmental Employment (SEE) Inspector
OT6	Other
CR6	Contractor

ACTUAL_AVERAGE_FLOW_NMBR

The flow that a permitted feature actually had at the time of application., expressed as millions of gallons per day (MGD).

CITY

A 60 character field that contains the name of the city in which the facility is located.

COMP_MONITOR_TYPE_CODE

Contains a code describing the type of inspection that was conducted.

COMP_MONITOR_TYPE_DESC

Full text description of COMP_MONITOR_TYPE_CODE.

COMP_SCHEDULE_EVENT_ID

(Compliance Schedule Event ID) The unique identifier of the Compliance Schedule Event to which the Violation is associated; it is only used for Schedule Violations of a Final Order.

COMP_SCHEDULE_NMBR

A 2-digit number which in combination with the Schedule Type and NPDES ID uniquely identifies a Compliance Schedule.

COMPONENT_TYPE_CODE

A 3-character code describing the permit component(s) associated with the NPDES Permit Program Area.

COMPONENT_TYPE_DESC

Description of the permit component(s) associated with the NPDES Permit Program Area.

COUNTY_CODE

A five digit field that contains the FIPS county code in which the facility is located, used in conjunction with the facility state code. A list of codes and descriptions can be found at 2017 FIPS Codes for Counties.

Top of Page

DAYS_LATE

The system-generated number of days the Discharge Monitoring Report value was late (as compared to the DMR_DUE_DATE) in ICIS.

DMR_FORM_VALUE_ID

The sequence ID identifying the DMR Form Value.

DMR_NON_RECEIPT_FLAG

The flag indicating whether the permit is subject to the DMR run. Value is (Y)es or No (null value). DMR_PARAMETER_ID - The system-generated unique identifier for the DMR parameter to which the DMR value belongs.

DMR_VALUE_ID

The system-generated unique identifier for the DMR value.

DMR_VALUE_NMBR

The DMR value number reported on the DMR form.

DMR_VALUE_STANDARD_UNITS

The DMR value expressed in standard units as calculated by the system.

EDMR_AUTHORIZATION_FLAG

This indicates whether DMRs for the Permit may be submitted electronically.

EFFECTIVE_DATE

The date the permit became effective or is scheduled to become effective (MM/DD/YYYY).

ENF_IDENTIFIER

The unique identifying number of the Enforcement Action as referred to by the Court where the action was filed; the Enforcement Action Identifier. This element is commonly referred to as the case number.

ENF_TYPE_CODE

A code describing which enforcement action was taken in response to a violation.

ENF_TYPE_DESC

A text description of the ENF_TYPE_CODE value.

EXCEEDENCE_PCT

The system-generated percent by which the DMR value (or Adjusted Value) exceeded its Limit (or stay) value.

EXPIRATION_DATE

The date the permit expired or is scheduled to expire (MM/DD/YYYY).

EXTERNAL_PERMIT_NMBR

See NPDES_ID

FACILITY_NAME

An 80-character field that contains the name of the facility.

FACILITY_UIN

The number assigned by the Facility Registry Service (FRS) that is used to associate facility records from multiple environmental database systems that are known or believed to represent the same facility.

FACILITY_TYPE_CODE

A 3-character code indicating ownership type of the facility.

Code	Description
CNG	County Government
COR	Corporation
CTG	Municipality
DIS	District
FDF	Federal Facility (U.S. Government)
GOC	GOCO (Gov Owned/Contractor Operated)
IND	Individual
MWD	Municipal or Water District
MXO	Mixed Ownership (e.g., Public/Private)
NON	Non-Government
POF	Privately Owned Facility
SDT	School District
STF	State Government
TRB	Tribal Government
UNK	Unknown

FACILITY_TYPE_INDICATOR

A 10-character code indicating the facility as either a POTW, non-POTW, or federal entity.

FED_PENALTY_ASSESSED_AMT

The dollar amount of federal civil penalties assessed or agreed to at a formal enforcement action. Where the enforcement case results in multiple settlements, this represents the sum of penalty amounts for all of the settlements.

GEOCODE_LATITUDE

The latitude of the facility or permit holder as maintained in ICIS-NPDES. 

GEOCODE_LONGITUDE

The longitude of the facility or permit holder as maintained in ICIS-NPDES.

HLRNC (Historic Noncompliance)

An historic tracking of the latest reported QNCR value (LRNC) at the end of a quarter. HLRNC is a reconciliation of the current quarter automatic and manual QNCR values. The Historic Noncompliance field is derived by HLRNC and corresponds to the quarter indicated by HQRTR. Valid code values are:

Code	Short Description	Long Description
C	COMPLIANT	Not considered in RNC/SNC based on manual review of data by state or EPA region.
D	NC-SNC DMR NON-RECPT	SNC/Category I - reporting violation - non-receipt of DMR
E	NC-SNC EFFLUENT VIOL	SNC/Category I - effluent violations of monthly average limits (Technical Review Criteria and chronic)
N	NC-RNC VIOLTNS ONLY	RNC/Category II - reportable noncompliance
P	RESOLVED PENDING	Resolved Pending - an enforcement action has been issued, and facility compliance with the action is pending final completion
Q	RESOLVED PENDING - CS	Resolved Pending - Compliance Schedule (manual only)
R	RESOLVED	Resolved - the facility has returned to compliance with its permit conditions, either with or without issuance of an enforcement action
S	NC-SNC COMP SCHD VIOL	SNC/Category I - an enforcement action has been issued, and the facility is not meeting its compliance schedule
T	NC-SNC COMP SCHD RPT	SNC/Category I - compliance schedule reporting violation
U	UNDETERMINED	Undetermined QNCR Status - insufficient data, or permitee is a non-major discharger not subject to mandatory reporting
V	NC-NON-RNC VIOLATIONS	Non-RNC Violations
W	UNKNOWN	Unknown QNCR Status – non-major dischargers with a QNCR status of DMR non-receipt status are changed to W, except for states that have agreed to QA the QNCR data for non-majors. DMR data is not required data entry for non-major dischargers.
X	NC-SNC-EF NONMNTH AV	SNC/Category I - effluent violations of non-monthly average limits (Technical Review Criteria and chronic)

ICIS_FACILITY_INTEREST_ID

The system-generated unique ID for identifying the facility interest.

IMPAIRED_WATERS

The impairment class or category of the water body in which the facility is permitted to discharge directly. The data are from the ATTAINS database. Detailed information on the categorization of waters can be found in Section V of the 2006 Integrated Report Guidance.

• 5. Impaired - TMDL needed. Available information indicates that at least one designated use is not being supported and a TMDL is needed (also known as the 303(d) listed waters).
• 4. Impaired - TMDL not needed. Available information indicates that at least one designated use is not being supported, but a TMDL is not needed (see subcategories).
• 4a. TMDL completed. A TMDL has been completed, but impairment still exists.
• 4b. TMDL alternative. Impairment is being addressed by a method other than a TMDL (e.g., stream bank improvements).
• 4c. Non-pollutant causes. Cause of impairment is not a pollutant (e.g., habitat destruction). 

ISSUE_DATE

The date the permit was issued (MM/DD/YYYY).

ISSUING_AGENCY

This is the name of the organization issuing or granting a permit.

LATITUDE_MEASURE

The horizontal position coordinate for the point of discharge location in units of decimal degrees. Latitude and longitude coordinates are not required to be entered into ICIS-NPDES. Searching on coordinates will only return results for permit features that have latitude and longitude data in ICIS-NPDES.

LONGITUDE_MEASURE

The vertical position coordinate for the point of discharge location in units of decimal degrees. ICIS-NPDES does not require Latitude and longitude coordinates to be entered. Searching on coordinates will only return results for permit features that have latitude and longitude data in ICIS-NPDES.

LIMIT_ID

The unique identifier for a limit parameter record.

LIMIT_SET_DESIGNATOR

The alphanumeric field that is used to designate a particular grouping of parameters within a limit set.

LIMIT_VALUE_STANDARD_UNITS

The limit value expressed in standard units, as calculated by the system.

LOCATION_ADDRESS

The street address of the facility.

Top of Page

MAJOR_MINOR_STATUS_FLAG

A 1-character code that designates the facility as a major discharger (M), non-major discharger (N), or that no data is available (null value), such as for unpermitted facilities. Under the Clean Water Act, a major facility is any NPDES facility or activity classified as such by the regional administrator, or in the case of approved state programs, the regional administrator in conjunction with the state director. Major municipal dischargers include all facilities with design flows of greater than one million gallons per day and facilities with EPA/state approved industrial pretreatment programs. Major industrial facilities are determined based on specific ratings criteria developed by EPA/state. Non-major facilities are those not designated as major.

MASTER_EXTERNAL_PERMIT_NMBR

This is the unique identifier for the Master General Permit for a General Permit Covered Facility.

MONITORING_LOCATION_CODE

The code describing the location at which the monitoring requirement (and numeric effluent limit, if limited) applies. One parameter may have several monitoring location requirements pertaining to the same permitted feature. Valid code values are:

Code	Description
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

Top of Page

MONITORING_PERIOD_END_DATE

The date that the monitoring period for the values covered by this DMR Form ends (YYYYMMDD).

NAICS_CODE

The 6-digit North American Industry Classification System (NAICS) code that represents a subdivision of an industry that accommodates user needs in the United States. For detailed information about NAICS and for a crosswalk between NAICS and SIC codes, please check the U.S. Census Bureau websiteExit.

NAICS_DESC

The corresponding description of North American Industry Classification System (NAICS) code.

NMBR_OF_REPORT

The number of months covered by the DMR for which the effluent violation was generated (e.g., monthly = 1, quarterly = 3, semi-annually = 6).

NODI_CODE

The no data indicator (NODI) code indicates the reason that data for an expected DMR value were not submitted by the permittee for a Monitoring Period End Date.

Code	Description
1	Wrong Flow
2	Operation Shutdown
3	Special Report Attached
4	Discharge to Lagoon/Groundwater
5	Frozen Conditions
7	No Influent
8	Other (See Comments)
9	Conditional Monitoring - Not Required This Period
A	General Permit Exemption
B	Below Detection Limit/No Detection
C	No Discharge
D	Lost Sample/Data Not Available
E	Analysis Not Conducted/No Sample
F	Insufficient Flow for Sampling
G	Sampling Equipment Failure
H	Invalid Test
I	Land Applied
J	Recycled - Water-Closed System
K	Natural Disaster
L	DMR Received but not Entered
M	Laboratory Error
N	Not Constructed
Q	Not Quantifiable
R	Administratively Resolved
S	Fire Conditions
V	Weather Related
W	Dry Lysimeter/Well
X	Parameter/Value Not Reported
Z	COVID-19

NPDES_ID

This field contains a NPDES number formatted to define the general permit, the industrial classification, and the sequence number. This NPDES number may reflect either the permit or a facility covered by the permit. This element is also identified as EXTERNAL_PERMIT_NMBR in some download files.

NPDES_VIOLATION_ID

The unique identifier for the violation related to a particular site.

NUMCVDT

(Number of Compliance Schedule Violations in Quarter) A count of the number of compliance schedule violations reported in the quarter, defined by YEARQTR.

NUME90Q

(Number of E90 Violations in Quarter) A count of the number of effluent violations (E90) reported in the quarter, defined by YEARQTR.

NUMPSCH

(Number of Permit Schedule Violations in Quarter) A count of the number of permit schedule violations reported in the quarter, defined by YEARQTR.

NUMSVCD

(Number of Single Event Violations in Quarter) A count of the number of single event violations reported in the quarter, defined by PRHQRTR.

PARAMETER_CODE

The unique code identifying the parameter being reported on the DMR.

PARAMETER_DESC

Text description of the PARAMETER_CODE.

PERM_FEATURE_ID

The unique system identifier for a permitted feature.

PERM_FEATURE_NMBR

The 3-digit code representing the permitted outfall or pipe of interest in ICIS-NPDES (e.g., 001). This is the identifier assigned for each location at which permit conditions are being applied.

PERM_SCHEDULE_EVENT_ID

The unique identifier of the Permit Schedule Event to which the Violation is associated; it is only used for Schedule Violations of a Permit.

PERMIT_COMP_STATUS_FLAG

This is a code that indicates whether the permit is currently on or off for compliance tracking purposes. Value is (Y)es or No (null value).

PERMIT_NAME

This is the name of the facility having the National Pollutant Discharge Elimination System (NPDES) permit to discharge pollutants in the waters of the United States.

PERMIT_STATUS_CODE

ICIS-NPDES designates a permit as Effective (EFF), Administratively Continued (ADC), Expired (EXP), Not Needed (NON), Pending (PND), Retired (RET), or Terminated (TRM). Active facilities are those currently in operation (indicated by any status code except NON or TRM).

PERMIT_TYPE_CODE

The unique code identifying the type of permit. Valid code values and descriptions are below.

PERMIT_TYPE_DESC

Text description for PERMIT_TYPE_CODE. Valid code values and descriptions are below.

Code	Description
NPD	NPDES Individual Permit
NGP	NPDES Master General Permit
GPC	General Permit Covered Facility
SNN	State Issued Master General Permit (Non-NPDES)
IIU	Individual IU Permit (Non-NPDES)
SIN	Individual State Issued Permit (Non-NPDES)
APR	Associated Permit Record
UFT	Unpermitted Facility

PRETREATMENT_INDICATOR_CODE

A 1-character code which indicates if the permitted municipality is required to develop a pretreatment program. Valid code values are:

Code	Description
C	Covered
E	EPA
R	Required and Developing
S	State
Y	Approved

PRIMARY_INDICATOR_FLAG

The flag indicating whether the NAICS or SIC code is the primary code for the Facility. Value is (Y)es or No (null value).

REGISTRY_ID

See FACILITY_UIN

RETIREMENT_DATE

The date the permit was retired (YYYYMMDD).

REPORT_RECEIVED_DATE

The date on which the regulatory authority receives a report indicating a scheduled event was completed or the date on which the regulatory authority received the required report (MM/DD/YYYY).

RNC_DETECTION_DATE

The date associated with RNC_DETECTION_CODE (MM/DD/YYYY).

RNC_DETECTION_CODE

Indicates reportable noncompliance (RNC) for a particular violation event. Valid code values are:

Code	Description
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_DESC

Text description of the code value RNC_DETECTION_CODE.

RNC_RESOLUTION_DATE

The date associated with VIORNRC (MM/DD/YYYY).

RNC_RESOLUTION_CODE

A code indicating how RNC was resolved for a particular violation. Valid code values are:

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

RNC_RESOLUTION_DESC

Text description of the code value RNC_RESOLUTION_CODE.

RNC_TRACKING_FLAG

The flag indicating if the RNC tracking is on. Value is (Y)es or No (null value).

SCHEDULE_DATE

The date the compliance schedule or permit schedule event is scheduled to be completed (i.e., the due date).

SCHEDULE_EVENT_CODE

The code indicating the particular event with which the permittee is scheduled to comply.

SCHEDULE_EVENT_DESC

Text description of the code value for SCHEDULE_EVENT_CODE.

SETTLEMENT_ENTERED_DATE

The date of the enforcement action (MM/DD/YYYY). Where multiple settlements are associated with a single enforcement action, this represents the earliest date entered.

SIC_CODE

The 4-digit Standard Industrial Classification (SIC) code that represents the economic activity of a company. Note the NAICS classification system replaced the SIC classification system in 1997. These SIC codes are no longer collected by some EPA programs. A list of codes may be found at the OSHA SIC System Search Exit.

SIC_DESC

The corresponding description of the Standard Industrial Classification (SIC) code.

SINGLE_EVENT_AGENCY_TYPE_CODE

The type of organization issuing or granting the Single Event Violation. The list of codes includes:

Code	Description
EP6	U.S. EPA
ST6	State
OT6	Other - State
OTH	Other
TR6	Tribal
CT6	County
MN6	Municipal
CR6	Contractor
EO6	Other - EPA
SE6	Senior Environmental Employment (SEE) Inspector
EC6	EPA Contractor

SINGLE_EVENT_END_DATE

If the Single Event Violation occurred over multiple days, the date the occurrence ended.

SINGLE_EVENT_VIOLATION_COMMENT

Comments about the Single Event Violation.

SINGLE_EVENT_VIOLATION_DATE

The date of a single event violation (MM/DD/YYYY).

STANDARD_UNIT_CODE

The code representing the standard unit of measure applicable to quantity or concentration limits and measurements, as entered by the user.

STANDARD_UNIT_DESC

The short description of the standard unit of measure applicable to limit or DMR values.

STATE_CODE

A two-character field that contains the state postal abbreviation for the state in which the facility is located.

STATE_EPA_FLAG

Identifies the agency lead (S = State, E = EPA) for the listed inspection.

STATE_LOCAL_PENALTY_AMT

The dollar amount of state or local civil penalties assessed or agreed to at a formal enforcement action. Where the enforcement case results in multiple settlements, this represents the sum of penalty amounts for all of the settlements.

STATE_WATER_BODY

The state’s code to identify the water body into which the effluent is discharged for a Permitted Feature.

STATE_WATER_BODY_NAME

The state’s name for the water body into which the effluent is discharged for a Permitted Feature.

STATISTICAL_BASE_CODE

The code that defines the statistical analysis to be used for the limit value. Valid code values are:

Type	Code	Long Description
AVG	1A	1 Day Geometric
AVG	1C	12 Day Average
AVG	1D	12 Month Average
AVG	1E	12 Month Daily Water Flow
AVG	1F	120 Day Average
AVG	1G	180 Day Arithmetic Mean
AVG	1H	1 Day Average
AVG	1I	1 Hour Average
AVG	3A	30 Day Geometric Mean
AVG	3B	30 Day Arithmetic
AVG	3C	30 Day Average
AVG	3D	30 Day Geometric
AVG	3F	30 Day Arithmetic Mean
AVG	3G	30 Day Median
AVG	3H	30 Day Average Geometric
AVG	3I	3 Hour Average
AVG	4A	4 Day Average
AV	4D	4 Hour Average
AVG	5B	5 Day Average
AVG	5Y	5 Year Average
AVG	6A	6 Month Median
AVG	6B	6 Hour Mean
AVG	6C	6 Hour Geometric Mean
AVG	6D	6 Month Average
AVG	6E	6 Hour Average
AVG	6F	6 Hour Geometric
AVG	7A	7 Day Average
AVG	7B	7 Day Geometric
AVG	7C	7 Day Median
AVG	7F	7 Day Arithmetic
AVG	7G	7 Day Arithmetic Mean
AVG	7I	7-Day Average Geometric
AVG	9B	90 Day Average
AVG	9D	96 Hour
AVG	A1	Average (Data Migration)
AVG>	AB	Annual Average
AVG	AE	Arithmetic Mean
AVG	AF	Average
AVG	AG	Average Below Detectable
AVG	AGM	Annual Geometric Mean
AVG	AH	Average Value
AVG	AN	Annual Median
AVG	CA	Allowed Concentration
AVG	DA	Daily Geometric Average
AVG	DB	Daily Average
AVG	DF	Daily Median
AVG	DG	Discharge Per Day Average
AVG	DH	Discharge per Day Geometric
AVG	DM	Daily Geometric
AVG	DP	14 Day Average
AVG	G5	5 Day Geometric Mean
AVG	GA	Geometric Mean
AVG	HA	High 7 Day Average
AVG	HB	High Weekly Average
AVG	LA	Logarithmic Mean
AVG	LB	Logarithmic Monthly Median
AVG	M3	Monthly Median
AVG	M4	Monthly Average Geometric
AVG	MC	Mean
AVG	MD	Median
AVG	MK	Monthly Average
AVG	ML	Monthly Geometric
AVG	MM	Monthly Geometric Mean
AVG	NA	Non-Specific Average
AVG	QA	Quarterly Average
AVG	QR	Quarterly Rolling Average
AVG	RA	Rolling Average
AVG	RB	Reported Average
AVG	RE	Indiv 12 Mo Rolling Ave
AVG	RF	Aggregate 12 Mo Rolling Avg
AVG	RM	Aggregate 12 Mo Rolling Median
AVG	SC	Semi-Annual Average
AVG	SD	Single Sample Geometric
AVG	WA	Weekly Average
AVG	WB	Weekly Geometric
AVG	WE	Weekly Average Geometric
AVG	WK	Weekly Geometric Mean
AVG	WL	Well Average
MAX	1B	10% of Samples
MAX	2A	20% of Samples
MAX	2P	2 Hour Peak
MAX	3E	30 Day Maximum
MAX	4B	4 Day Maximum
MAX	4C	48 Hour Maximum
MAX	5A	50th Percentile
MAX	7E	7 Day Maximum
MAX	7H	75th Percentile
MAX	7J	70th Percentile
MAX	8A	80th Percentile
MAX	95P	95th Percentile
MAX	9A	90th Percentile
MAX	9C	90% of Samples
MAX	AC	Annual Maximum
MAX	AX	Annual Average Maximum
MAX	DD	Daily Maximum
MAX	DI	Discharge Per Day Maximum
MAX	EX	Seasonal Maximum
MAX	GX	Maximum Monthly Geometric Mean
MAX	HX	Hourly Avg Maximum
MAX	IA	Instantaneous Maximum
MAX	M0	Maximum Value
MAX	M1	Maximum 30 Day Average
MAX	M2	Maximum Monthly Average
MAX	M6	Maximum (Data Migration)
MAX	MA	Maximum Bdl
MAX	MB	Maximum
MAX	MN	Monthly Maximum
MAX	MQ	Maximum Daily Average
MAX	MR	Maximum Hourly Rate
MAX	MS	Maximum Weekly Average
MAX	MT	Maximum 7 Day Average
MAX	MU	Maximum 7 Day Geometric
MAX	MV	Maximum 7 Day Geo. Avg.
MAX	MW	Maximum Single Sample
MAX	MX	Monthly Geometric Maximum
MAX	NB	Non-Specific Maximum
MAX	QB	Quarterly Maximum
MAX	RD	Rpt Allowed/Rpt Actual
MAX	SA	Single Sample
MAX	SB	Single Mv Conc Sample
MAX	SE	Single Reading
MAX	SF	Successful Readings
MAX	SG	Single Grab
MAX	SX	Semi-Annual Maximum
MAX	VA	Value
MAX	WC	Weekly Maximum
MAX	X1	Positive Results
MAX	XA	Background
MIN	1J	1 Day Minimum
MIN	2E	24 Hour Minimum
MIN	4E	48 Hour Minimum
MIN	7D	7 Day Minimum
MIN	AM	Annual Average Minimum
MIN	BA	Median (Minimum)
MIN	BB	Average (Minimum)
MIN	BC	90Th Percentile (Minimum)
MIN	BD	70Th Percentile (Minimum)
MIN	BE	50Th Percentile (Minimum)
MIN	DC	Daily Minimum
MIN	DE	Daily Average Minimum
MIN	DJ	Discharge Per Day Minimum
MIN	DL	Daily Geometric Minimum
MIN	HM	Hourly Avg Minimum
MIN	IB	Instantaneous Minimum
MIN	IC	Instantaneous Min. Geom
MIN	M5	Minimum (Data Migration)
MIN	ME	Minimum
MIN	MF	Minimum Percent Removal
MIN	MG	Minimum Weekly Average
MIN	MH	Minimum 7 Day Average
MIN	MI	Minimum 7 Day Geo. Ave
MIN	MJ	Monthly Average Minimum
MIN	MO	Monthly Minimum
MIN	MZ	Minimum Value
MIN	NS	Minimum Single Sample
MIN	QC	Quarterly Minimum
MIN	RC	Reported Minimum
MIN	SM	Semi-Annual Minimum
MIN	TM	Monthly Total Minimum
MIN	WD	Weekly Minimum
MIN	YM	Yearly Minimum
TTL	AA	Allowed Load
TTL	AD	Annual Total
TTL	AL	Annual Mass Loading
TTL	BF	Cumulative Total
TTL	DK	Discharge Per Day Total
TTL	DN	Discharged
TTL	ET	Event Total
TTL	LE	Pounds Per Event
TTL	MP	Monthly Total
TTL	MY	Monthly Loading
TTL	QT	Quarterly Total
TTL	ST	Semi-Annual Total
TTL	TA	Total Amount Applied
TTL	TB	Total
TTL	TC	Season To Date Total
TTL	WT	Weekly Total
TTL	YA	Year-To-Date Total

STATISTICAL_BASE_MONTHLY_AVG

The data element indicating whether the statistical base code is a monthly average (A), non-monthly average (N), or neither (null) for purposes of calculating RNC.

STATISTICAL_BASE_SHORT_DESC

A short description for the unit of measure applicable to the limit and DMR values. For a list of all codes and descriptions, download the Statistical Base Code Reference Table (CSV) (10 K).

SUPPLEMENTAL_ADDRESS_TEXT

The name of the supplemental location for the facility.

TERMINATION_DATE

The date the permit was terminated (MM/DD/YYYY).

TMDL_INTERFACE_FLAG

This field indicates whether a Permit has received TMDL information.

UNIT_CODE

The code representing the unit of measure applicable to quantity or concentration limits and measurements as entered by the user on the DMR form.

TOTAL_DESIGN_FLOW_NMBR

This is the flow that a permitted facility was designed to accommodate, expressed as millions of gallons per day (MGD).

VALUE_QUALIFIER_CODE

The direction of the value when an alternate limit value is possible. Values may include less than, greater than, and too numerous, which are currently entered in the DMR value columns.

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 that the regulatory authority receives the DMR. For the end date of the monitoring period associated with the DMR values, please see Monitoring_Period_End_Date.

VERSION_NMBR

The version of the permit when a modification or reissuance is applied to the permit. A "0" indicates the most recent or current permit version.

VIOLATION_CODE

Violation code describing both automatically and manually detected violations.

VIOLATION_DESC

Text description of the VIOLATION_CODE.

VIOLATION_TYPE_CODE

A derived code to differentiate violation records. Valid code values are:

Code	Description
C	Compliance Schedule Violation
D	DMR Violation
P	Permit Schedule Violation
S	Single Event Violation

VIOLATION_TYPE_DESC

Text description of the code value VIOLATION_TYPE_CODE.

VALUE_TYPE_CODE

The indication of the limit value type (e.g., Quantity 1, Concentration 2). Valid code values are:

Code	Description
Q1	Quantity 1
Q2	Quantity 2
C1	Concentration 1
C2	Concentration 2
C3	Concentration 3

RAD_WBD_HUC12S

Displays the Hydrologic Unit Codes (HUC) and names associated with each NPDES permit. There may be multiple codes listed due to multiple outfalls. HUCs are sourced from the Reach Address Database (RAD), which is derived from the USGS Watershed Boundary DatasetExit.

HUCs are used to classify watersheds in the United States and the Caribbean. The codes consist of twelve digits which correspond to six levels of classification:

• Region (first-level, 2-digit HUC)
• Subregion (second-level, 4-digit HUC)
• Basin (third-level, 6-digit HUC)
• Subbasin (fourth-level, 8-digit HUC)
• Watershed (fifth-level, 10-digit HUC)
• Subwatershed (sixth-level, 12-digit HUC)

YEARQTR

(Historic Noncompliance Quarter) Indicates the fiscal year (Oct. – Sept.) and quarter that a value for HLRNC was recorded. The format is YYYYQ, where Q = 1 – 4.

ZIP

A 9-character field that contains the U.S. Postal Zone Improvement Plan (ZIP) code for the area in which the facility is located.