You are here
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
- 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.
Active facilities are those currently in operation. Major/federally-reportable are facilities for which states must submit compliance and enforcement data to EPA. 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.
Minor/not federally-reportable are facilities for which states are not required to submit data to EPA. EPA is therefore not able to verify the accuracy or comparability of data for these permits, although the Agency tracks their names and locations and may have some data about their inspections and enforcement activity.
ICIS-NPDES records included in the download files are those with any permit status code value for the current permit record. ICIS-NPDES 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).
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:
* 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.
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 |
Permit (ICIS_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 |
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 |
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 | 36 |
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 |
ACTIVITY_OUTCOME_CODE | Num | 22 |
ACTIVITY_OUTCOME_DESC | Char | 100 |
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 | 6 |
VIOLATION_TYPE_DESC | Char | 100 |
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 |
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 | 6 |
VIOLATION_TYPE_DESC | Char | 100 |
COMP_SCHEDULE_EVENT_ID | Num | 22 |
COMP_SCHEDULE_NMBR | Num | 22 |
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 |
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 | 6 |
VIOLATION_CODE | Char | 5 |
VIOLATION_DESC | Char | 100 |
SINGLE_EVENT_VIOLATION_DATE | Date | 7 |
SINGLE_EVENT_BEGIN_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 | 20 |
ACTIVITY_ID | Num | 22 |
ACTIVITY_TYPE_CODE | Char | 3 |
ACTIVITY_TYPE_DESC | Char | 100 |
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 |
CWA Informal Enforcement Actions (NPDES_INFORMAL_ENFORCEMENT_ACTIONS.csv)
Element Name | Data Type | Length |
---|---|---|
NPDES_ID1 | Char | 30 |
REGISTRY_ID2 | Char | 36 |
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 | 20 |
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 | 4 |
PERMIT_ACTIVITY_ID | Num | 22 |
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 |
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 |
MONITORING_PERIOD_END_DATE | Date | 7 |
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 |
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 | 20 |
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_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 | 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.
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 2010 FIPS Codes for Counties.
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 or not 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 each data system. The FRS lat/long is from the EPA Locational Reference Tables (LRT) file which represents the "best" value for the latitude and longitude coordinates.
GEOCODE_LONGITUDE - The longitude of the facility or permit holder as maintained in each data system. The FRS lat/long is from the EPA Locational Reference Tables (LRT) file.
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 non-compliance |
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 minor discharger not subject to mandatory reporting |
V | NC-NON-RNC VIOLATIONS | Non-RNC Violations |
W | UNKNOWN | Unknown QNCR Status – minor 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 minors. DMR data is not required data entry for minor 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 waterbody 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.
LIMIT_ID - The unique identifier for a limit parameter record.
LOCATION_ADDRESS - The street address of the facility.
MAJOR_MINOR_STATUS_FLAG - A 1-character code that designates the facility as a major discharger (M), minor discharger (N), or that no data is available (null value), such as for unpermitted facilities.
MASTER_EXTERNAL_PERMIT_NMBR - This is the unique identifier for the Master General Permit for a General Permit Covered Facility.
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 website.
NAICS_DESC - The corresponding description of North American Industry Classification System (NAICS) code.
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 code value PARAMETER_CODE.
PERM_FEATURE_NMBR - 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).
PERMIT_TYPE_CODE - The unique code identifying the type of permit. Valid code values are:
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 |
PERMIT_TYPE_DESC - Text description for PERMIT_TYPE_CODE.
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).
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 |
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 codes are no longer collected by some EPA programs. A list of codes can be found at https://www.osha.gov/pls/imis/sicsearch.html.
SIC_DESC - The corresponding description of the Standard Industrial Classification (SIC) code.
SINGLE_EVENT_VIOLATION_DATE - The date of a single event violation (MM/DD/YYYY).
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 |
AVG | 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, non-monthly average, or neither for purposes of calculating RNC.
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.
VERSION_NMBR - The version of the permit when a modification or reissuance is applied to the permit.
VIOLATION_CODE - Violation code describing both automatically and manually detected violations.
VIOLATION_DESC - Text description of the code value for 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 |
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.