ICIS-NPDES Download Summary and Data Element Dictionary

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

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.

CodeViolation TypeDescriptionGenerated by
D80DMR Non-ReceiptRequired monitoring DMR value overdueSystem
D90DMR Non-ReceiptLimited value overdueSystem
E90EffluentReported DMR value exceeds maximum or average limit value or is below minimum limit valueSystem
C10ScheduleSchedule event reported lateSystem
C20ScheduleSchedule event achieved late but reportedSystem
C30ScheduleSchedule event not achieved but reportedSystem
C40ScheduleSchedule not achieved and not reportedSystem
VariousSingle EventAny manually determined violationUser

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 fieldsTables
1NPDES_ID or EXTERNAL_PERMIT_NMBRAll Tables
2REGISTRY_ID or FACILITY_UINICIS_FACILITIES, NPDES_INSPECTIONS, NPDES_INFORMAL_ENFORCEMENT_ACTIONS
3NPDES_VIOLATION_ID{NPDES_PS_VIOLATIONS, NPDES_CS_VIOLATIONS, NPDES_SE_VIOLATIONS, NPDES_EFF_VIOLATIONS}*, NPDES_VIOLATION_ENFORCEMENTS
4VERSION_NMBRICIS_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 NameData TypeLength
ICIS_FACILITY_INTEREST_IDNum22
NPDES_ID1Char30
FACILITY_UIN2Char12
FACILITY_TYPE_CODEChar3
FACILITY_NAMEChar80
LOCATION_ADDRESSChar50
SUPPLEMENTAL_ADDRESS_TEXTChar50
CITYChar60
COUNTY_CODEChar5
STATE_CODEChar2
ZIPChar14
GEOCODE_LATITUDEChar10
GEOCODE_LONGITUDEChar11
IMPAIRED_WATERSChar20

Top of Page

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

Element NameData TypeLength
ACTIVITY_IDNum22
EXTERNAL_PERMIT_NMBR1Char9
VERSION_NMBRNum22
FACILITY_TYPE_INDICATORChar10
PERMIT_TYPE_CODEChar3
MAJOR_MINOR_STATUS_FLAGChar1
PERMIT_STATUS_CODEChar3
TOTAL_DESIGN_FLOW_NMBRNum22
ACTUAL_AVERAGE_FLOW_NMBRNum22
STATE_WATER_BODYChar12
STATE_WATER_BODY_NAMEChar50
WBD_HUC12Char48
PERMIT_NAMEChar120
AGENCY_TYPE_CODEChar3
ORIGINAL_ISSUE_DATEDate7
ISSUE_DATEDate7
ISSUING_AGENCYChar100
EFFECTIVE_DATEDate7
EXPIRATION_DATEDate7
RETIREMENT_DATEDate7
TERMINATION_DATEDate7
PERMIT_COMP_STATUS_FLAGChar1
DMR_NON_RECEIPT_FLAGChar1
RNC_TRACKING_FLAGChar1
MASTER_EXTERNAL_PERMIT_NMBRChar9
TMDL_INTERFACE_FLAGChar1
PRETREATMENT_INDICATOR_CODEChar3
EDMR_AUTHORIZATION_FLAGChar1

Top of Page

Permit Components (NPDES_PERM_COMPONENTS.csv)

Element NameData TypeLength
EXTERNAL_PERMIT_NMBR1Char9
COMPONENT_TYPE_CODEChar3
COMPONENT_TYPE_DESCChar100

Permit Feature Coordinates (NPDES_PERM_FEATURE_COORDS.csv)

Element NameData TypeLength
EXTERNAL_PERMIT_NMBR1Char9
PERM_FEATURE_NMBRChar4
PERM_FEATURE_IDNum 
LATITUDE_MEASURENum10
LONGITUDE_MEASURENum11

NAICS Code (NPDES_NAICS.csv)

Element NameData TypeLength
NPDES_ID1Char30
NAICS_CODEChar6
NAICS_DESCChar100
PRIMARY_INDICATOR_FLAGChar1

SIC Code (NPDES_SICS.csv)

Element NameData TypeLength
NPDES_ID1Char30
SIC_CODEChar4
SIC_DESCChar100
PRIMARY_INDICATOR_FLAGChar1

Inspections (NPDES_INSPECTIONS.csv)

Element NameData TypeLength
REGISTRY_ID2Char50
NPDES_ID1Char30
ACTIVITY_IDNum22
ACTIVITY_TYPE_CODEChar3
COMP_MONITOR_TYPE_CODEChar3
COMP_MONITOR_TYPE_DESCChar100
STATE_EPA_FLAGChar1
ACTUAL_END_DATEDate7
ACTUAL_BEGIN_DATEDate7

Top of Page

QNCR Historic Compliance (NPDES_QNCR_HISTORY.csv)

Element NameData TypeLength
NPDES_ID1Char9
YEARQTRChar5
HLRNCChar1
NUME90QNum22
NUMCVDTNum22
NUMSVCDNum22
NUMPSCHNum22

Permit Schedule Violations (NPDES_PS_VIOLATIONS.csv)

Element NameData TypeLength
NPDES_ID1Char30
NPDES_VIOLATION_ID3Num22
PERM_SCHEDULE_EVENT_IDNum22
VIOLATION_TYPE_CODEChar1
VIOLATION_CODEChar5
VIOLATION_DESCChar100
SCHEDULE_EVENT_CODEChar5
SCHEDULE_EVENT_DESCChar100
SCHEDULE_DATEDate7
RNC_DETECTION_CODEChar3
RNC_DETECTION_DESCChar100
RNC_DETECTION_DATEDate7
RNC_RESOLUTION_CODEChar3
RNC_RESOLUTION_DESCChar100
RNC_RESOLUTION_DATEDate7
ACTUAL_DATEDate7
REPORT_RECEIVED_DATEDate7

Compliance Schedule Violations (NPDES_CS_VIOLATIONS.csv)

Element NameData TypeLength
NPDES_ID1Char30
NPDES_VIOLATION_ID3Num22
VIOLATION_TYPE_CODEChar1
COMP_SCHEDULE_EVENT_IDNum22
COMP_SCHEDULE_NMBRNum3
VIOLATION_CODEChar5
VIOLATION_DESCChar100
SCHEDULE_EVENT_CODEChar5
SCHEDUE_EVENT_DESCChar100
SCHEDULE_DATEDate7
ACTUAL_DATEDate7
RNC_DETECTION_CODEChar3
RNC_DETECTION_DESCChar100
RNC_DETECTION_DATEDate7
RNC_RESOLUTION_CODEChar3
RNC_RESOLUTION_DESCChar100
RNC_RESOLUTION_DATEDate7
REPORT_RECEIVED_DATEDate7

Top of Page

Single Event Violations (NPDES_SE_VIOLATIONS.csv)

Element NameData TypeLength
NPDES_ID1Char9
NPDES_VIOLATION_ID3Num22
VIOLATION_TYPE_CODEChar1
VIOLATION_CODEChar5
VIOLATION_DESCChar476
SINGLE_EVENT_VIOLATION_DATEDate7
SINGLE_EVENT_END_DATEDate7
SINGLE_EVENT_VIOLATION_COMMENTChar4000
SINGLE_EVENT_AGENCY_TYPE_CODEChar3
RNC_DETECTION_CODEChar3
RNC_DETECTION_DESCChar100
RNC_DETECTION_DATEDate7
RNC_RESOLUTION_CODEChar3
RNC_RESOLUTION_DESCChar100
RNC_RESOLUTION_DATEDate7

CWA Enforcement Actions (NPDES_FORMAL_ENFORCEMENT_ACTIONS.csv)

Element NameData TypeLength
NPDES_ID1Char30
ENF_IDENTIFIERChar25
ACTIVITY_IDNum22
ACTIVITY_TYPE_CODEChar3
ENF_TYPE_CODEChar7
ENF_TYPE_DESCChar100
AGENCYChar5
SETTLEMENT_ENTERED_DATEDate7
FED_PENALTY_ASSESSED_AMTNum22
STATE_LOCAL_PENALTY_AMTNum22

Top of Page

CWA Informal Enforcement Actions (NPDES_INFORMAL_ENFORCEMENT_ACTIONS.csv)

Element NameData TypeLength
NPDES_ID1Char30
REGISTRY_ID2Char50
AGENCYChar5
ACTIVITY_IDNum22
ACTIVITY_TYPE_CODEChar3
ACTIVITY_TYPE_DESCChar100
ENF_TYPE_CODEChar7
ENF_TYPE_DESCChar100
ACHIEVED_DATEDate7
ENF_IDENTIFIERChar25
OFFICIAL_FLGChar1

Top of Page

Effluent Violations (NPDES_EFF_VIOLATIONS.csv)

Element NameData TypeLength
NPDES_ID1Char9
VERSION_NMBRNum22
ACTIVITY_IDNum22
NPDES_VIOLATION_ID3Num22
PERM_FEATURE_NMBRChar30
PERMIT_ACTIVITY_IDNum22
LIMIT_SET_DESIGNATORChar2
MONITORING_LOCATION_CODEChar3
DMR_FORM_VALUE_IDNum22
DMR_VALUE_NMBRNum22
DMR_VALUE_IDNum22
DMR_PARAMETER_IDNum22
NODI_CODEChar3
ADJUSTED_DMR_VALUE_NMBRNum22
LIMIT_VALUE_STANDARD_UNITSNum22
VIOLATION_TYPE_CODEChar6
VIOLATION_TYPE_DESCChar100
VIOLATION_CODEChar5
VIOLATION_DESCChar100
PARAMETER_CODEChar5
PARAMETER_DESCChar100
STANDARD_UNIT_CODEChar2
STANDARD_UNIT_DESCChar13
MONITORING_PERIOD_END_DATEDate7
NMBR_OF_REPORTNum2
EXCEEDANCE_PCTNum22
VALUE_QUALIFIER_CODEChar3
UNIT_CODEChar2
VALUE_RECEIVED_DATEDate7
DAYS_LATENum22
ADJUSTED_DMR_STANDARD_UNITSNum22
LIMIT_IDNum22
DMR_VALUE_STANDARD_UNITSNum22
VALUE_TYPE_CODEChar3
RNC_DETECTION_CODEChar3
RNC_DETECTION_DESCChar100
RNC_DETECTION_DATEDate7
RNC_RESOLUTION_CODEChar3
RNC_RESOLUTION_DESCChar100
RNC_RESOLUTION_DATEDate7
STATISTICAL_BASE_CODEChar3
STATISTICAL_BASE_MONTHLY_AVGChar1
STATISTICAL_BASE_SHORT_DESCChar10

Violation Enforcement Actions (NPDES_VIOLATION_ENFORCEMENTS.csv)

This table links civil CWA enforcement actions to specific violations.

Element NameData TypeLength
NPDES_VIOLATION_ID3Num22
VIOLATION_CODEChar5
VIOLATION_DESCChar100
ACTIVITY_IDNum22
ACTIVITY_TYPE_DESCChar100
ENF_IDENTIFIERChar25
ACTIVITY_TYPE_CODEChar3

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:
CodeDescription
AIFAdministrative, Informal
AFRAdministrative, Formal
JDCJudicial
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:
CodeDescription
ST6State
MN6Municipal
CT6County
RG6Regional
EP6U.S. EPA
EC6EPA Contractor
EO6Other - EPA
IN6Interstate
LC6Local
OF6Other Federal
SC6State Contractor
SO6Other - State
TR6Tribal
UN6Unknown from Conversion
SE6Senior Environmental Employment (SEE) Inspector
OT6Other
CR6Contractor
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.
CodeDescription
CNGCounty Government
CORCorporation
CTGMunicipality
DISDistrict
FDFFederal Facility (U.S. Government)
GOCGOCO (Gov Owned/Contractor Operated)
INDIndividual
MWDMunicipal or Water District
MXOMixed Ownership (e.g., Public/Private)
NONNon-Government
POFPrivately Owned Facility
SDTSchool District
STFState Government
TRBTribal Government
UNKUnknown
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:
CodeShort DescriptionLong Description
CCOMPLIANTNot considered in RNC/SNC based on manual review of data by state or EPA region.
DNC-SNC DMR NON-RECPTSNC/Category I - reporting violation - non-receipt of DMR
ENC-SNC EFFLUENT VIOLSNC/Category I - effluent violations of monthly average limits (Technical Review Criteria and chronic)
NNC-RNC VIOLTNS ONLYRNC/Category II - reportable noncompliance
PRESOLVED PENDINGResolved Pending - an enforcement action has been issued, and facility compliance with the action is pending final completion
QRESOLVED PENDING - CSResolved Pending - Compliance Schedule (manual only)
RRESOLVEDResolved - the facility has returned to compliance with its permit conditions, either with or without issuance of an enforcement action
SNC-SNC COMP SCHD VIOLSNC/Category I - an enforcement action has been issued, and the facility is not meeting its compliance schedule
TNC-SNC COMP SCHD RPTSNC/Category I - compliance schedule reporting violation
UUNDETERMINEDUndetermined QNCR Status - insufficient data, or permitee is a non-major discharger not subject to mandatory reporting
VNC-NON-RNC VIOLATIONSNon-RNC Violations
WUNKNOWNUnknown 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.
XNC-SNC-EF NONMNTH AVSNC/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:
CodeDescription
0Intake
1Effluent Gross
2Effluent Net
3Intake Public Water
4Pretreatment, Process Complete
5Upstream Monitoring
6Downstream Monitoring
7Intake from Stream
8Other Treatment, Process Complete
9Phosphate Removal, Process Complete
ADisinfection, Process Complete
APAlternate Process
BPrior to Disinfection
CNitrogen, Removal Complete
DTertiary/Advanced Process Complete
ESecondary/Biological Process Complete
EGEffluent Gross
FPrimary/Preliminary Process Complete
GRaw Sewage Influent
HDuring Manufacturing
IIntake from Well
INAllowed Increase
JIntermediate Treatment, Process Complete
KPercent Removal
LDigestor
NIn Aeration Unit
OSee Comments
PSee Comments
QSee Comments
RSee Comments
RSBeneficial Reuse
RWReceiving Water
SSee Comments
SCSee Comments
SLSludge
TSee Comments
USee Comments
VSee Comments
WSee Comments
XEnd of Chlorine Contact Chamber
ZInstream Monitoring
YEffluent Gross (Supplementary)
GWGroundwater
IIIndustrial Influent
IMInternal Monitoring Point
PIPrior to Irrigation
PRPrior to Reuse
LALand 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.
CodeDescription
1Wrong Flow
2Operation Shutdown
3Special Report Attached
4Discharge to Lagoon/Groundwater
5Frozen Conditions
7No Influent
8Other (See Comments)
9Conditional Monitoring - Not Required This Period
AGeneral Permit Exemption
BBelow Detection Limit/No Detection
CNo Discharge
DLost Sample/Data Not Available
EAnalysis Not Conducted/No Sample
FInsufficient Flow for Sampling
GSampling Equipment Failure
HInvalid Test
ILand Applied
JRecycled - Water-Closed System
KNatural Disaster
LDMR Received but not Entered
MLaboratory Error
NNot Constructed
QNot Quantifiable
RAdministratively Resolved
SFire Conditions
VWeather Related
WDry Lysimeter/Well
XParameter/Value Not Reported
ZCOVID-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.
CodeDescription
NPDNPDES Individual Permit
NGPNPDES Master General Permit
GPCGeneral Permit Covered Facility
SNNState Issued Master General Permit (Non-NPDES)
IIUIndividual IU Permit (Non-NPDES)
SINIndividual State Issued Permit (Non-NPDES)
APRAssociated Permit Record
UFTUnpermitted 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:
CodeDescription
CCovered
EEPA
RRequired and Developing
SState
YApproved
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:
CodeDescription
AEnforcement Order
BManual 2A4 - Pass-Through
CChronic Violation
DManual Other
EManual 2F - Permit Narrative
FManual 2G - Violation of Concern
GManual 2A1 - Effluent Violation
HChronic Violation, Non-Monthly Average
IManual 2A2 - Unauthorized Bypass
JManual 2A3 - Unpermitted Discharge
KNon-receipt Violation, Non-Monthly Average
NNon-Receipt of DMR/Schedule Report
PEnforcement Order, Non-Monthly Average
QManual 2B - Pretreatment
RTRC Limitations Exceeded, Non-Monthly Average
SSchedule Violation
TTRC Limitations Exceeded
UOther Violation with TRC Non-Monthly Average
VOther Violation with TRC
WManual 2E - Deficient Report
XManual Other Violation with TRC
YManual TRC
ZManual 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:
CodeDescription
ANC - Manual Unresolved RNC
BRE - Manual by EPA/State/Tribal Action
1NC - Unresolved RNC
2RE - Back into Compliance
3RP - Due to Formal Enforcement Action Final Order with Compliance Schedule
4RP - In Compliance with Formal Enforcement Action Final Order Requirement
5RE - Resolved RP by NPDES Closure of Enforcement Action Final Order with Compliance Schedule
6RE - Manual Resolution by Enforcement Action
7RP - Manual RP - In Compliance with Formal Enforcement Action Order Requirement
8RP - Manual Due to Formal Enforcement Action Formal Order
9RE - 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:
CodeDescription
EP6U.S. EPA
ST6State
OT6Other - State
OTHOther
TR6Tribal
CT6County
MN6Municipal
CR6Contractor
EO6Other - EPA
SE6Senior Environmental Employment (SEE) Inspector
EC6EPA 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:
TypeCodeLong Description
AVG1A1 Day Geometric
AVG1C12 Day Average
AVG1D12 Month Average
AVG1E12 Month Daily Water Flow
AVG1F120 Day Average
AVG1G180 Day Arithmetic Mean
AVG1H1 Day Average
AVG1I1 Hour Average
AVG3A30 Day Geometric Mean
AVG3B30 Day Arithmetic
AVG3C30 Day Average
AVG3D30 Day Geometric
AVG3F30 Day Arithmetic Mean
AVG3G30 Day Median
AVG3H30 Day Average Geometric
AVG3I3 Hour Average
AVG4A4 Day Average
AV4D4 Hour Average
AVG5B5 Day Average
AVG5Y5 Year Average
AVG6A6 Month Median
AVG6B6 Hour Mean
AVG6C6 Hour Geometric Mean
AVG6D6 Month Average
AVG6E6 Hour Average
AVG6F6 Hour Geometric
AVG7A7 Day Average
AVG7B7 Day Geometric
AVG7C7 Day Median
AVG7F7 Day Arithmetic
AVG7G7 Day Arithmetic Mean
AVG7I7-Day Average Geometric
AVG9B90 Day Average
AVG9D96 Hour
AVGA1Average (Data Migration)
AVG>ABAnnual Average
AVGAEArithmetic Mean
AVGAFAverage
AVGAGAverage Below Detectable
AVGAGMAnnual Geometric Mean
AVGAHAverage Value
AVGANAnnual Median
AVGCAAllowed Concentration
AVGDADaily Geometric Average
AVGDBDaily Average
AVGDFDaily Median
AVGDGDischarge Per Day Average
AVGDHDischarge per Day Geometric
AVGDMDaily Geometric
AVGDP14 Day Average
AVGG55 Day Geometric Mean
AVGGAGeometric Mean
AVGHAHigh 7 Day Average
AVGHBHigh Weekly Average
AVGLALogarithmic Mean
AVGLBLogarithmic Monthly Median
AVGM3Monthly Median
AVGM4Monthly Average Geometric
AVGMCMean
AVGMDMedian
AVGMKMonthly Average
AVGMLMonthly Geometric
AVGMMMonthly Geometric Mean
AVGNANon-Specific Average
AVGQAQuarterly Average
AVGQRQuarterly Rolling Average
AVGRARolling Average
AVGRBReported Average
AVGREIndiv 12 Mo Rolling Ave
AVGRFAggregate 12 Mo Rolling Avg
AVGRMAggregate 12 Mo Rolling Median
AVGSCSemi-Annual Average
AVGSDSingle Sample Geometric
AVGWAWeekly Average
AVGWBWeekly Geometric
AVGWEWeekly Average Geometric
AVGWKWeekly Geometric Mean
AVGWLWell Average
MAX1B10% of Samples
MAX2A20% of Samples
MAX2P2 Hour Peak
MAX3E30 Day Maximum
MAX4B4 Day Maximum
MAX4C48 Hour Maximum
MAX5A50th Percentile
MAX7E7 Day Maximum
MAX7H75th Percentile
MAX7J70th Percentile
MAX8A80th Percentile
MAX95P95th Percentile
MAX9A90th Percentile
MAX9C90% of Samples
MAXACAnnual Maximum
MAXAXAnnual Average Maximum
MAXDDDaily Maximum
MAXDIDischarge Per Day Maximum
MAXEXSeasonal Maximum
MAXGXMaximum Monthly Geometric Mean
MAXHXHourly Avg Maximum
MAXIAInstantaneous Maximum
MAXM0Maximum Value
MAXM1Maximum 30 Day Average
MAXM2Maximum Monthly Average
MAXM6Maximum (Data Migration)
MAXMAMaximum Bdl
MAXMBMaximum
MAXMNMonthly Maximum
MAXMQMaximum Daily Average
MAXMRMaximum Hourly Rate
MAXMSMaximum Weekly Average
MAXMTMaximum 7 Day Average
MAXMUMaximum 7 Day Geometric
MAXMVMaximum 7 Day Geo. Avg.
MAXMWMaximum Single Sample
MAXMXMonthly Geometric Maximum
MAXNBNon-Specific Maximum
MAXQBQuarterly Maximum
MAXRDRpt Allowed/Rpt Actual
MAXSASingle Sample
MAXSBSingle Mv Conc Sample
MAXSESingle Reading
MAXSFSuccessful Readings
MAXSGSingle Grab
MAXSXSemi-Annual Maximum
MAXVAValue
MAXWCWeekly Maximum
MAXX1Positive Results
MAXXABackground
MIN1J1 Day Minimum
MIN2E24 Hour Minimum
MIN4E48 Hour Minimum
MIN7D7 Day Minimum
MINAMAnnual Average Minimum
MINBAMedian (Minimum)
MINBBAverage (Minimum)
MINBC90Th Percentile (Minimum)
MINBD70Th Percentile (Minimum)
MINBE50Th Percentile (Minimum)
MINDCDaily Minimum
MINDEDaily Average Minimum
MINDJDischarge Per Day Minimum
MINDLDaily Geometric Minimum
MINHMHourly Avg Minimum
MINIBInstantaneous Minimum
MINICInstantaneous Min. Geom
MINM5Minimum (Data Migration)
MINMEMinimum
MINMFMinimum Percent Removal
MINMGMinimum Weekly Average
MINMHMinimum 7 Day Average
MINMIMinimum 7 Day Geo. Ave
MINMJMonthly Average Minimum
MINMOMonthly Minimum
MINMZMinimum Value
MINNSMinimum Single Sample
MINQCQuarterly Minimum
MINRCReported Minimum
MINSMSemi-Annual Minimum
MINTMMonthly Total Minimum
MINWDWeekly Minimum
MINYMYearly Minimum
TTLAAAllowed Load
TTLADAnnual Total
TTLALAnnual Mass Loading
TTLBFCumulative Total
TTLDKDischarge Per Day Total
TTLDNDischarged
TTLETEvent Total
TTLLEPounds Per Event
TTLMPMonthly Total
TTLMYMonthly Loading
TTLQTQuarterly Total
TTLSTSemi-Annual Total
TTLTATotal Amount Applied
TTLTBTotal
TTLTCSeason To Date Total
TTLWTWeekly Total
TTLYAYear-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:
CodeDescription
CCompliance Schedule Violation
DDMR Violation
PPermit Schedule Violation
SSingle 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:
CodeDescription
Q1Quantity 1
Q2Quantity 2
C1Concentration 1
C2Concentration 2
C3Concentration 3
WBD_HUC12
Hydrologic Unit Code (HUC) 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 code consists 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.

Top of Page