Jump to maincontent.

Water Discharge Permits (PCS) Recent Additions | Contact Us Search: All EPA This Area  You are here: EPA Home  Envirofacts  PCS  Customized Query Engine 

# Customized Query Engine This query engine allows you select any data element in PCS to build a tabular report or a Comma Separated Value (CSV) file for downloading. There are four steps to using this query engine: 1. Select one or more of the subjects listed below, one at a time. 2. Select your tables of interest from the subjects selected. 3. Select columns (data elements or fields) from the selected tables. 4. Enter your search criteria to target specific records from the database. The Customized

Query Engine User's Guide will provide you with detailed information on howto use the Query Engine. WARNING: Many PCS tables contain over 1 million rows. Output results greater than 500K (500 thousand bytes) may cause your browser to fail. Please limit your query through specific selection criteria. Note: Microsoft's Internet Explorer browser handles large (greater than 500K) output results better than Netscape's Navigator browser. Pending migration to a new system, the data for the Permit Compliance System (PCS) will remain frozen in Envirofacts for the following states and territories as of the below listed dates: Frozen as of June 6th, 2006: MA,NH,RI,VI,PR,DC,MD,IN,NM,UT,HI,AK,ID Frozen as of

August, 2006: AS,AT,CT,CZ,FM,GA,GB,GU,JA,MH,MP,MT,MW,NE,NI,NN,NV,NY,PA,PW,SD,SR,TT,UM Frozen as of

April 24th, 2008: IL Frozen as of

August 26th, 2008: AR,CA,CO,OK,TN,WI Frozen as of

June 17th, 2009: TX, LA, GM, AL Please refer to the ECHO Clean Water Act Query Screen to retrieve updated data for the states frozen in Envirofacts. Step 1: Start by selecting one subject to be the primary focus of yourquery by clicking on one of the underlined subject names [logo] US EPA

     

     Go

EF/PCS Logo Page 1 of 3 EPA | Envirofacts | PCS | Customized Query Engine

11/19/2010 file://C:\Program Files\Documentum\CTS\docbases\ProDocbase\config\temp_sessions\7960793305379990494\ ...listed below.



### Local Navigation
 Overview  Query  Customized Query  Model  Law  Data Source  Office of Ground

Water and Drinking Water  Contact Us FacilityInformation Address and other location information about the facility. Single Event Violation A table of violations that are characterized as one - time events that occurred on a fixed date, and are associated with one permitted facility. Pipe Schedule -- Outfalls Tables of information about particular discharge points at a permit facility that are governed by effluent limitations and monitoring and submission requirements. EffluentLimits -- Allowable Discharges Tables containing restrictions imposed on quantities, discharge rates, and concentrations of pollutants by the permit. Effluent Measurements/Violations A table of measurements of effluents reported on the Discharge Monitoring Report (DMR). The violations are detected bycomparing the measurement values against the corresponding effluent

limit. PermitEvent A table of events that track the life - cycle of a permit from issuance to expiration. EvidentiaryHearing Event A table of evidentiary hearing events for a facility with a NPDES permit. Pretreatment

Assessment Summary A table of pretreatment assessment reports for a facility with a NPDES permit. Compliance Schedules Activities and associated milestones pertaining to the permit. Compliance Schedule Violation A table of violations that reflect the non - achievement of agiven compliance schedule event including the type of violation and type of resolution. Inspection Tables of recorded official visits to a permit facility. Reference A table providing text descriptions that explain the code meanings for each type and each possible code value contained on PCS tables. Page 2 of 3 EPA | Envirofacts | PCS | Customized Query Engine

11/19/2010 file://C:\Program Files\Documentum\CTS\docbases\ProDocbase\config\temp_sessions\7960793305379990494\ ... EF Home

 EPA Home  Privacy and SecurityNotice  Contact Us http://www.epa.gov/enviro/html/pcs/adhoc.html Print As - Is Last updated on Wednesday, April 14, 2010  Share

 Del.icio.us  Digg  Facebook  StumbleUpon  What is this? Jump to maincontent. Page 3 of 3 EPA | Envirofacts | PCS | Customized Query Engine

11/19/2010 file://C:\Program Files\Documentum\CTS\docbases\ProDocbase\config\temp_sessions\7960793305379990494\ ...