ICIS-NPDES Biosolids Facility Data Download Summary

The Enforcement and Compliance History Online (ECHO) website incorporates biosolids program data submitted by NPDES Biosolids Program permit holders to the states or EPA via the US EPA Central Data Exchange (CDX). The data download reflects compliance information about facilities in the biosolids program. Biosolids data submitted electronically through NetBiosolids after March 31, 2018 are available through the Biosolids Annual Report Search. See Biosolids Laws and Regulations for information about biosolids regulations.


Source Data Description

The data are stored in the EPA Office of Enforcement Compliance Assurance, Integrated Compliance Information System (ICIS), where they are extracted by ECHO. The data downloads are comprised of five comma-separated values (CSV) files with data about facilities in and compliance with the NPDES Biosolids Program. 

The universe of NPDES Biosolids facilities in ECHO includes permits where the:

  • NPDES ID has a Biosolids permit component,
  • NPDES ID has an "L" as the third character,
  • NPDES ID has a Biosolids violation,
  • NPDES ID has a Biosolids official or unofficial inspection, or
  • NPDES ID has a Biosolids formal or informal enforcement action.

Top of Page

ICIS-NPDES Biosolids Data Elements

Note: Primary keys for each table are indicated by asterisks (*).

NPDES Biosolids Permits (NPDES_BIOSOLIDS_PERMITS.csv)

Element Name Data Type Size (Byte)
NPDES_ID* VarChar2 30
REGISTRY_ID Number  
CWP_NAME VarChar2 100
CWP_STREET VarChar2 100
CWP_CITY VarChar2 100
CWP_STATE VarChar2 3
CWP_ZIP VarChar2 10
CWP_COUNTY VarChar2 10
CWP_EPA_REGION Number  
CWP_INDIAN_CNTRY_FLG VarChar2 3
CWP_TRIBAL_LAND_CODE VarChar2 3
CWP_VERSION_NMBR Number  
CWP_PERMIT_STATUS_CODE VarChar2 3
CWP_PERMIT_STATUS_DESC VarChar2 100
CWP_PERMIT_TYPE_CODE VarChar2 3
CWP_PERMIT_TYPE_DESC VarChar2 100
CWP_EXPIRATION_DATE Date  
CWP_FACILITY_TYPE_INDICATOR VarChar2 5
CWP_MAJOR_MINOR_STATUS_FLAG VarChar2 3
MASTER_EXTERNAL_PERMIT_NMBR VarChar2 30
ISSUING_AGENCY VarChar2 5
CWP_ISSUE_DATE Date  
CWP_EFFECTIVE_DATE Date  
CWP_TERMINATION_DATE Date  
PERMIT_COMPONENTS VarChar2 30
BIOSOLIDS_FLAG VarChar2 1

NPDES Biosolids Single Event Violations (SEVs) (NPDES_BIOSOLIDS_SEV_VIOLATIONS.csv)

Element Name Data Type Size (Byte)
SOURCE_ID* VarChar2 30
EPA_SYSTEM VarChar2 10
VIOLATION_DESC VarChar2 100
NPDES_VIOLATION_ID* Number  
REGISTRY_ID VarChar2 50
QTR1_STATUS VarChar2 30
QTR1_VALUE VarChar2 30
QTR2_STATUS VarChar2 30
QTR2_VALUE VarChar2 30
QTR3_STATUS VarChar2 30
QTR3_VALUE VarChar2 30
QTR4_STATUS VarChar2 30
QTR4_VALUE VarChar2 30
QTR5_STATUS VarChar2 30
QTR5_VALUE VarChar2 30
QTR6_STATUS VarChar2 30
QTR6_VALUE VarChar2 30
QTR7_STATUS VarChar2 30
QTR7_VALUE VarChar2 30
QTR8_STATUS VarChar2 30
QTR8_VALUE VarChar2 30
QTR9_STATUS VarChar2 30
QTR9_VALUE VarChar2 30
QTR10_STATUS VarChar2 30
QTR10_VALUE VarChar2 30
QTR11_STATUS VarChar2 30
QTR11_VALUE VarChar2 30
QTR12_STATUS VarChar2 30
QTR12_VALUE VarChar2 30
QTR13_STATUS VarChar2 30
QTR13_VALUE VarChar2 30
MNTH1_STATUS VarChar2 30
MNTH1_VALUE VarChar2 30
MNTH2_STATUS VarChar2 30
MNTH2_VALUE VarChar2 30
MNTH3_STATUS VarChar2 30
MNTH3_VALUE VarChar2 30
MNTH4_STATUS VarChar2 30
MNTH4_VALUE VarChar2 30
MNTH5_STATUS VarChar2 30
MNTH5_VALUE VarChar2 30
MNTH6_STATUS VarChar2 30
MNTH6_VALUE VarChar2 30
MNTH7_STATUS VarChar2 30
MNTH7_VALUE VarChar2 30
MNTH8_STATUS VarChar2 30
MNTH8_VALUE VarChar2 30
MNTH9_STATUS VarChar2 30
MNTH9_VALUE VarChar2 30
MNTH10_STATUS VarChar2 30
MNTH10_VALUE VarChar2 30
MNTH11_STATUS VarChar2 30
MNTH11_VALUE VarChar2 30
MNTH12_STATUS VarChar2 30
MNTH12_VALUE VarChar2 30
MNTH13_STATUS VarChar2 30
MNTH13_VALUE VarChar2 30
MNTH14_STATUS VarChar2 30
MNTH14_VALUE VarChar2 30
MNTH15_STATUS VarChar2 30
MNTH15_VALUE VarChar2 30
MNTH16_STATUS VarChar2 30
MNTH16_VALUE VarChar2 30
MNTH17_STATUS VarChar2 30
MNTH17_VALUE VarChar2 30
MNTH18_STATUS VarChar2 30
MNTH18_VALUE VarChar2 30
MNTH19_STATUS VarChar2 30
MNTH19_VALUE VarChar2 30
MNTH20_STATUS VarChar2 30
MNTH20_VALUE VarChar2 30
MNTH21_STATUS VarChar2 30
MNTH21_VALUE VarChar2 30
MNTH22_STATUS VarChar2 30
MNTH22_VALUE VarChar2 30
MNTH23_STATUS VarChar2 30
MNTH23_VALUE VarChar2 30
MNTH24_STATUS VarChar2 30
MNTH24_VALUE VarChar2 30
MNTH25_STATUS VarChar2 30
MNTH25_VALUE VarChar2 30
MNTH26_STATUS VarChar2 30
MNTH26_VALUE VarChar2 30
MNTH27_STATUS VarChar2 30
MNTH27_VALUE VarChar2 30
MNTH28_STATUS VarChar2 30
MNTH28_VALUE VarChar2 30
MNTH29_STATUS VarChar2 30
MNTH29_VALUE VarChar2 30
MNTH30_STATUS VarChar2 30
MNTH30_VALUE VarChar2 30
MNTH31_STATUS VarChar2 30
MNTH31_VALUE VarChar2 30
MNTH32_STATUS VarChar2 30
MNTH32_VALUE VarChar2 30
MNTH33_STATUS VarChar2 30
MNTH33_VALUE VarChar2 30
MNTH34_STATUS VarChar2 30
MNTH34_VALUE VarChar2 30
MNTH35_STATUS VarChar2 30
MNTH35_VALUE VarChar2 30
MNTH36_STATUS VarChar2 30
MNTH36_VALUE VarChar2 30
MNTH37_STATUS VarChar2 30
MNTH37_VALUE VarChar2 30
MNTH38_STATUS VarChar2 30
MNTH38_VALUE VarChar2 30
MNTH39_STATUS VarChar2 30
MNTH39_VALUE VarChar2 30
AGENCY VarChar2 6
VIOLATION_CODE VarChar2 5
TOTAL_QTRS_VIO Number  
TOTAL_MNTHS_VIO Number  
VIOLATION_TYPE VarChar2 50

NPDES Biosolids Inspections (NPDES_BIOSOLIDS_INSPECTIONS.csv)

Element Name Data Type Size (Byte)
REGISTRY_ID VarChar2 30
NPDES_ID* VarChar2 30
ACTIVITY_ID* Number  
ACTIVITY_TYPE_CODE VarChar2 3
ACTUAL_BEGIN_DATE Date  
ACTUAL_END_DATE Date  
STATE_EPA_FLAG VarChar2 1
REGION_CODE VarChar2 2
ACTIVITY_STATUS_CODE VarChar2 3
COMP_MONITOR_CATEGORY_CODE VarChar2 3
OBSERVED_DEFICIENCY_FLAG VarChar2 1
COMP_MONITOR_TYPE_CODE VarChar2 3
COMP_MONITOR_TYPE_DESC VarChar2 1000
CMS_FLAG Char 1
COMP_MONITOR_ID VarChar2 28
ACTIVITY_TYPE_DESC VarChar2 100

NPDES Biosolids Informal Enforcement Actions (NPDES_BIOSOLIDS_INFML_ENF_ACTIONS.csv)

Element Name Data Type Size (Byte)
OBJECTID Number 38
NPDES_ID* VarChar2 30
REGISTRY_ID VarChar2 30
ACTIVITY_ID* Number  
AGENCY VarChar2 5
REGION_CODE Char 2
ACTIVITY_TYPE_CODE VarChar2 3
ENF_TYPE_CODE VarChar2 7
ENF_TYPE_DESC VarChar2 100
ACHIEVED_DATE Date  
ENF_IDENTIFIER VarChar2 25
OFFICIAL_FLG Char 1

NPDES Biosolids Formal Enforcement Actions (NPDES_BIOSOLIDS_FORMAL_ACTIONS.csv)

Element Name Data Type Size (Byte)
OBJECTID Number 38
NPDES_ID* VarChar2 30
ACTIVITY_ID* Number 6
STATUTE_CODE VarChar2 15
LAW_SECTION_CODE VarChar2 100
CASE_NAME VarChar2 25
CASE_ID VarChar2 100
CASE_TYPE VarChar2 4000
ENF_SUMMARY_TEXT VarChar2 100
ACTIVITY_NAME VarChar2 2
REGION_CODE VarChar2 5
LEAD_AGENCY Date  
ISSUE_DATE VarChar2 12
REGISTRY_ID Date  
SETTLEMENT_DATE Number  
STATE_LOCAL_PENALTY_AMT Number  
FED_PENALTY_ASSESSED_AMT Number  
SEP_COST_AMT Number  
INJUNCTIVE_RELIEF Number  
NUMBER_SETTLEMENTS Number  
COST_RECOVERY_AMT Number  
ACTIVITY_TYPE_CODE VarChar2 3


Top of Page


Data Element Definitions

ACHIEVED_DATE
The date of the notice of violation or informal enforcement.
ACTIVITY_ID
An internal numeric key identifier used to uniquely identify enforcement case activities.
ACTIVITY_NAME
The user-created name for an activity.
ACTIVITY_STATUS_CODE
The unique code that identifies the current status of an activity.
ACTIVITY_TYPE_CODE
A three-character code that identifies the type of ICIS activity, which includes general categories such as information requests, inspections, compliance determinations, and enforcement. Activities for formal enforcement actions are limits to two type codes: administrative – formal (AFR) and judicial activities (JDC).
ACTIVITY_TYPE_DESC
Value for ACTIVITY_TYPE_CODE (Activity Type Code).
ACTUAL_BEGIN_DATE
The date on which the facility started the compliance monitoring activity. Date format is MM/DD/YYYY.
ACTUAL_END_DATE
The date on which the facility completed the compliance monitoring activity. Date format is MM/DD/YYYY.
AGENCY
Identifies the agency lead (EPA) for the listed enforcement action.
BIOSOLIDS_FLAG
Y/N field to indicate permits with biosolids program information. Only permits with BIOSOLIDS_FLAG = Y are included in this data download. The universe of NPDES Biosolids Facilities in ECHO includes permits with a biosolids permit component, NPDES IDs with a “L” in the third position of the NPDES ID, NPDES ID has a Biosolids violation, NPDES ID has a Biosolids official or unofficial inspection, or NPDES ID has a Biosolids formal or informal enforcement action.
CASE_ID
 Values typically begin with either two characters (EPA region number, "HQ" (headquarters), “EF” (CAA Eastern Field Office), or “WF” (CAA Western Field Office), followed by the four digit fiscal year in which the action was initiated, followed by a four character sequence identifier. State CASE_ID values do not follow any set format.
CASE_NAME
An alphanumeric field that contains the name assigned to the case by the lead attorney. Generally, the primary defendant's name is used as the case name.
CASE_TYPE
Case types include the following:
  • Judicial Cases – Displays the number of Judicial cases within the search results. Judicial cases are formal lawsuits, typically filed by the U.S. Department of Justice on behalf of EPA.
  • Administrative Formal Cases – Displays the number of Administrative Formal cases within the search results. Administrative formal cases are produced by EPA or a state under its authority, and do not involve a judicial court process.
  • Cases with Federal Penalties – Displays the number of civil cases with federal penalty(ies) assessed greater than $0.
  • Cases with Supplemental Environmental Projects (SEPs) – Displays the number of civil cases with an SEP amount greater than $0.
CMS_FLAG
Displays "Y" if the facility has a compliance monitoring strategy in place. Displays "N" if the facility does not have a compliance monitoring strategy in place. 
COMP_MONITOR_CATEGORY_CODE
Unique code for the compliance monitoring category.
COMP_MONITOR_ID
The unique identifier for the compliance monitoring activity. 
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.
COST_RECOVERY_AMT
For civil enforcement actions, cost recovery is the amount of cost recovery ordered or agreed to be repaid by the responsible party of parties.
CWP_CITY
The name of the city in which the facility is located.
CWP_COUNTY
The name of the county in which the facility is located.
CWP_EFFECTIVE_DATE
The date the permit became effective or is scheduled to become effective (MM/DD/YYYY).
CWP_EPA_REGION
The EPA region where the facility is located. EPA has 10 regional offices that execute programs within several states and territories.
CWP_EXPIRATION_DATE
The date the permit expired or is scheduled to expire (MM/DD/YYYY).
CWP_FACILITY_TYPE_INDICATOR
A code indicating the facility as either a POTW, non-POTW, or federal entity.
CWP_INDIAN_CNTRY_FLG
Displays “Y” if a facility is flagged as being located in Indian Country, based on information from the EPA's Facility Registry Service (FRS).
CWP_ISSUE_DATE
The date the permit was issued (MM/DD/YYYY).
CWP_MAJOR_MINOR_STATUS_FLAG
A 1-character code that designates the facility as a major discharger (M) or non-major discharger (N).
CWP_NAME
The name of the facility on the permit.
CWP_PERMIT_STATUS_CODE
The code indicating the current status of the permit. ICIS-NPDES designates a permit as Effective (EFF), Administratively Continued (ADC), Expired (EXP), Not Needed (NON), Pending (PND), Retired (RET), or Terminated (TRM).
CWP_PERMIT_STATUS_DESC
The description of CWP_PERMIT_STATUS_CODE.
CWP_PERMIT_TYPE_CODE
The unique code identifying the type of permit.
Code Description
APR Associated Permit Record
GPC General Permit Covered Facility
IIU Individual IU Permit (Non-NPDES)
NGP NPDES Master General Permit
NPD NPDES Individual Permit
SIN Individual State Issued Permit (Non-NPDES)
SNN State Issued Master General Permit (Non-NPDES)
UFT Unpermitted Facility
CWP_PERMIT_TYPE_DESC
The description of CWP_PERMIT_TYPE_CODE.
CWP_STATE
A two-character field that contains the state postal abbreviation for the state in which the facility is located.
CWP_STREET
The street address for the facility.
CWP_TERMINATION_DATE
The date the permit was terminated (MM/DD/YYYY).
CWP_TRIBAL_LAND_CODE
Displays “Y” if a facility is flagged as being located in Indian Country, based on information from the EPA's Integrated Compliance Information System (ICIS).
CWP_VERSION_NMBR
The version of the permit when a modification or reissuance is applied to the permit.
CWP_ZIP
A 5- to 9-character field that contains the U.S. Postal Zone Improvement Plan (ZIP) code for the area in which the facility is located.
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_SUMMARY_TEXT
Free text intended to capture additional description of the enforcement action taken. 
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.
EPA_SYSTEM
The EPA data system associated with the violation. 
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.
INJUNCTIVE_RELIEF
The settlement-level sum of the dollar values of injunctive relief. Injunctive relief represents the actions a regulated entity is ordered to undertake to achieve and maintain compliance, such as installing a new pollution control device to reduce air pollution, or preventing emissions of a pollutant in the first place.    
ISSUING_AGENCY
The name of the organization issuing or granting a permit.
ISSUE_DATE
The date the action was issued (MM/DD/YYYY).
LAW_SECTION_CODE
The unique code identifying the law sections cited in the case. 
LEAD_AGENCY
Identifies the lead agency (e.g., EPA, State) issuing the enforcement action.
MASTER_EXTERNAL_PERMIT_NMBR
 The unique identifier for the Master General Permit for a General Permit Covered Facility.
MNTH_STATUS (1-39)
Indicates the compliance history for the violation during a month. For more information, view the Detailed Facility Report Data Dictionary for CWA/NPDES Compliance Status
MNTH_VALUE (1-39)
Indicates the duration of the violation during a month, typically the start and end dates of the violation. Arrows indicate the violation continued during the time period. For more information, view the Detailed Facility Report Data Dictionary for CWA/NPDES Compliance Status
NPDES_ID
A unique 9-character ID assigned for each permit within the National Pollutant Discharge Elimination System (NPDES) program. The ID may contain both letters and numbers and often begins with the two-letter abbreviation for the state in which the facility is permitted.
NPDES_VIOLATION_ID
The unique identifier for the violation related to a particular permit.
NUMBER_SETTLEMENTS
For civil enforcement actions, the number of settlements associated with the case. Most enforcement actions tend to follow a one-case, one-settlement scenario. However, and in particular with judicial actions involving multiple defendants, more than one settlement may result.
OBJECTID
The unique identifier for the table row.
OBSERVED_DEFICIENCY_FLAG
Displays "Y" if a Biosolids deficiency was found during an inspection. Displays "N" if no Biosolids deficiency was found during an inspection. 
OFFICIAL_FLG
Displays "Y" if the action is an official enforcement action. Displays "N" if the action is not official and not included in ECHO facility searches or results. 
PERMIT_COMPONENTS
The permit component(s) associated with the NPDES Permit Program Area.
QTR_STATUS (1-13)
Indicates the compliance history of the violation for the quarter. For more information, view the Detailed Facility Report Data Dictionary for CWA/NPDES Compliance Status
QTR_VALUE (1-13)
Indicates the duration of the violation during a quarter, typically the start and end dates of the violation. Arrows indicate the violation continued during the time period. For more information, view the Detailed Facility Report Data Dictionary for CWA/NPDES Compliance Status
REGION_CODE
The two digit code that represents an EPA region, the EPA designated area that U.S. States, territories, and tribes are assigned to. There are 10 EPA regions.
REGISTRY_ID
The number assigned by the Facility Registry Service (FRS) that is used to associate facility records from multiple environmental database systems that were known or believed to represent the same facility (a.k.a. EPA ID Number, FRS ID).
SEP_COST_AMT
For civil enforcement actions, the total value of all SEPs for all settlements at the enforcement case.
SETTLEMENT_DATE
For federal judicial actions, this is the date the settlement document is signed by the presiding judge and entered by the Clerk of the Court. At that point, the settlement becomes a binding court order. For administrative actions, this is the date that the final order is signed and issued by the enforcement authority.
SOURCE_ID
A unique 9-character ID assigned for each permit within the National Pollutant Discharge Elimination System (NPDES) program, also known as a NPDES_ID. The ID may contain both letters and numbers and often begins with the two-letter abbreviation for the state in which the facility is permitted.
STATE_EPA_FLAG
Identifies the agency lead (S = State, E = EPA) for the listed inspection.
STATE_LOCAL_PENALTY_AMT
The total dollar penalty amount from all settlements to be paid to a state or local enforcement authority that is party to a concluded enforcement action.
STATUTE_CODE
Identifies the primary statute violated and cited in the enforcement action. 
TOTAL_MNTHS_VIO
Indicates the total number of months in noncompliance for the violation record in the table. 
TOTAL_QTRS_VIO
Indicates the total number of quarters in noncompliance for the violation record in the table. 
VIOLATION_CODE
Violation code describing both automatically and manually detected violations.
VIOLATION_DESC
Text description of the VIOLATION_CODE.
VIOLATION_TYPE
Indicates whether the single event violation was identified from an annual report or the result of compliance monitoring. 

Top of Page