Document ID: EPA-HQ-OW-2009-0596-2542
Agency: epa
Document Type: Supporting & Related Material
Title: 
Posted Date: 2010-12-06T05:00Z

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<!-- saved from url=(0045)http://www.epa.gov/enviro/html/pcs/adhoc.html -->
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><!-- EPA Template version 3.2.1, 28 June 2006 --><head><meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
	<title>EPA | Envirofacts | PCS | Customized Query Engine</title>
	<meta name="DC.title" content="">
	<meta name="DC.description" content="">
	<meta name="keywords" content="">
	<meta name="DC.Subject" content="">
	<meta name="DC.type" content="">
	<!-- For date metadata, use the format YYYY-MM-DD -->
	<meta name="DC.date.modified" content="">
	<meta name="DC.date.created" content="">
	<meta name="DC.date.reviewed" content="">

	<meta name="DC.language" content="en">
	<meta name="DC.creator" content="">

	<link rel="schema.DC" href="http://purl.org/dc/elements/1.1/">
	<link rel="meta" href="http://www.epa.gov/labels.rdf" type="application/rdf+xml" title="ICRA labels">
	<meta http-equiv="Content-Style-Type" content="text/css">
	

	<style type="text/css" media="screen">@import 'http://www.epa.gov/epafiles/s/epa.css';</style>
	<!--[if lt IE 7]>
		<link rel="stylesheet" type="text/css" href="http://www.epa.gov/epafiles/s/ie.css" />
	<![endif]-->
	<link rel="stylesheet" type="text/css" media="print" href="./US EPA 2010a_files/print.css">
	<script type="text/javascript" async="" src="./US EPA 2010a_files/notice.js"></script><script type="text/javascript" async="" src="./US EPA 2010a_files/foresee-trigger.js"></script><script type="text/javascript" src="./US EPA 2010a_files/epa-core.js"></script>
	<script type="text/javascript" src="./US EPA 2010a_files/extra.js"></script>
<script src="./US EPA 2010a_files/foresee-surveydef.js" type="text/javascript" id="foresee-surveydef"></script><script src="./US EPA 2010a_files/foresee-dhtml-popup.js" type="text/javascript" id="foresee-dhtml-popup"></script><link rel="stylesheet" media="screen" type="text/css" href="./US EPA 2010a_files/foresee-dhtml.css"></head>
<body>
<p class="skip"><a id="skiptop" href="http://www.epa.gov/enviro/html/pcs/adhoc.html#content" title="Jump to main content.">Jump to main content.</a></p>

<div id="header"> <!-- START EPA HEADER -->

	<div id="logo"><a href="http://www.epa.gov/" title="US EPA home page"><img src="./US EPA 2010a_files/logo_epaseal.gif" alt="[logo] US EPA" width="100" height="111"></a></div>

	<div id="areaname"> <!-- START AREA NAME -->
		<p>Water Discharge Permits (PCS)</p>
	</div> <!-- END AREA NAME -->

	<!-- START SEARCH CONTROLS -->
	<form id="EPAsearch" method="get" action="http://nlquery.epa.gov/epasearch/epasearch">
		<!-- START AREA SPECIFIC LINKS AND SEARCH BOX  -->
		<!-- CHANGE links to point to your own recent additions and contact pages -->
		<!-- REMOVE recent additions link if your area doesn't have one -->
		<p><a href="http://www.epa.gov/enviro/html/whats_new.html">Recent Additions</a> | <a href="http://www.epa.gov/enviro/html/pcs/pcs_feedback.html">Contact Us</a>
			<span class="search"><strong>Search:</strong>
			<input name="typeofsearch" id="EPAall" type="radio" value="epa"><label for="EPAall">All EPA</label>
			<input name="typeofsearch" id="Areaall" type="radio" value="area" checked="checked"><label for="Areaall">This Area</label>
			<input name="querytext" id="searchbox" value="">
			<input name="submit" id="searchbutton" type="submit" value="Go">
			<input type="hidden" name="fld" value="envirofw">
			<input type="hidden" name="areaname" value="Envirofacts Data Warehouse">
			<input type="hidden" name="areacontacts" value="/enviro/html/ef_feedback.html">
			<!-- AREA ADVANCED SEARCH URL HERE (OPTIONAL) -->
			<input type="hidden" name="areasearchurl" value="">
			<!-- THE REMAINING HIDDEN INPUTS ARE USED BY THE SEARCH ENGINE - DO NOT EDIT -->
			<input type="hidden" name="result_template" value="epafiles_default.xsl">
			<input type="hidden" name="filter" value="samplefilt.hts"></span>
		</p>
</form> <!-- END SEARCH CONTROLS -->

<ul> <!-- BEGIN BREADCRUMBS -->
		<li class="first">You are here: <a href="http://www.epa.gov/">EPA Home</a></li>
		<!-- START AREA BREADCRUMBS -->
		<li><a href="http://www.epa.gov/enviro/index.html">Envirofacts</a></li>
		<li><a href="http://www.epa.gov/enviro/html/pcs/index.html">PCS</a></li>
		<li>Customized Query Engine</li>
		<!-- END AREA BREADCRUMBS -->
</ul> <!-- END BREADCRUMBS -->

</div> <!-- END EPA HEADER -->

<hr class="skip">

<p class="skip"><a name="pagecontents" id="pagecontents"></a><a name="pagetop" id="pagetop"></a></p>

<div id="content"> <!-- BEGIN CONTENT -->
	<!-- EPA SITE-WIDE ANNOUNCEMENTS - DO NOT REMOVE - this code is used for emergency messages -->
	<!-- If this page is a Sub-Office/Sub-Region/Center/Lab/Topic home page, CHANGE "sitewidec" TO "sitewideb" -->
	<p id="sitewidec"></p>
	<!-- BEGIN CONTENT AREA -->

			<a name="pagecontents"></a>

			<!-- BEGIN PAGE NAME -->

			<h1 class="epaPageName">

				<a href="http://www.epa.gov/enviro/html/pcs/index.html">
        <img src="./US EPA 2010a_files/ef_pcs.gif" align="left" alt="EF/PCS Logo" border="0" valign="bottom"></a>

      Customized Query Engine</h1>

			<!-- END PAGE NAME -->

			<!-- BEGIN CONTENT AREA -->

      <p><i>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.</i>

</p><p>There are four steps to using this query engine:

</p><ol>

<li>

Select one or more of the subjects listed below, one at a time.</li>

<li>

Select your tables of interest from the subjects selected.</li>

<li>

Select columns (data elements or fields) from the selected tables.</li>

<li>

Enter your search criteria to target specific records from the database.</li>

</ol>
 <p>
The <a href="http://www.epa.gov/enviro/html/pcs/adhoc_users_guide.html"> Customized Query Engine User's Guide </a> will provide you with detailed

information on how to use the Query Engine.

<br>

</p><p><b>WARNING:  </b>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.  <i>Note:  </i>Microsoft's Internet Explorer
browser handles large (greater than 500K) output results better than Netscape's Navigator browser.

</p><p></p>
<p>
<b>
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:<br>
          Frozen as of June 6th, 2006: MA,NH,RI,VI,PR,DC,MD,IN,NM,UT,HI,AK,ID
<br>          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
<br>          Frozen as of April 24th, 2008: IL
<br>          Frozen as of August 26th, 2008: AR,CA,CO,OK,TN,WI
<br>          Frozen as of June 17th, 2009: TX, LA, GM, AL
</b><br>
<i>Please refer to the <a href="http://www.epa-echo.gov/echo/compliance_report_water.html">ECHO Clean Water Act Query Screen</a> to retrieve updated data for the states frozen in Envirofacts.</i>

</p><hr>

<p><b>Step 1:</b> Start by selecting one subject to be the primary focus of your query by clicking on one of
the underlined subject names listed below.

</p><p> 

</p><table border="" cellpadding="7">

<tbody><tr>

<td valign="TOP"><a href="http://oaspub.epa.gov/enviro/ad_hoc_table_column_select.retrieval_list?table_1=+&selected_subjects=Facility+Information&subject_selection=+&database_type=PCS">Facility

Information</a></td>

<td valign="TOP">Address and other location information about the facility.</td>

</tr>

<tr>

<td valign="TOP"><a href="http://oaspub.epa.gov/enviro/ad_hoc_table_column_select.retrieval_list?table_1=+&selected_subjects=Single+Event+Violation&subject_selection=+&database_type=PCS">

Single Event Violation</a></td>

<td valign="TOP">A table of violations that are characterized as one-time events that occurred on a fixed date, and are associated with one permitted facility.</td>

</tr>

<tr>

<td valign="TOP"><a href="http://oaspub.epa.gov/enviro/ad_hoc_table_column_select.retrieval_list?table_1=+&selected_subjects=Pipe+Schedule+--+Outfalls&subject_selection=+&database_type=PCS">Pipe Schedule -- Outfalls</a></td>

<td valign="TOP">Tables of information about particular discharge points at a permit facility that are governed

 by effluent limitations and monitoring and submission requirements.</td></tr>

<tr>

<td valign="TOP"><a href="http://oaspub.epa.gov/enviro/ad_hoc_table_column_select.retrieval_list?table_1=+&selected_subjects=Effluent+Limits--Allowable+Discharges&subject_selection=+&database_type=PCS">

Effluent Limits--Allowable Discharges</a></td>

<td valign="TOP">Tables containing restrictions imposed on quantities, discharge rates, and concentrations of pollutants by the permit.</td>

</tr>

<tr>

<td valign="TOP"><a href="http://oaspub.epa.gov/enviro/ad_hoc_table_column_select.retrieval_list?table_1=+&selected_subjects=Effluent+Measurements/Violations&subject_selection=+&database_type=PCS">

Effluent Measurements/Violations</a></td>

<td valign="TOP">A table of measurements of effluents reported on the Discharge Monitoring Report (DMR).

The violations are detected by comparing the measurement values against the corresponding effluent limit.</td></tr>

<tr>

<td valign="TOP"><a href="http://oaspub.epa.gov/enviro/ad_hoc_table_column_select.retrieval_list?table_1=+&selected_subjects=Permit+Event&subject_selection=+&database_type=PCS">

Permit Event</a></td>

<td valign="TOP">A table of events that track the life-cycle of a permit from issuance to expiration.</td></tr>

<tr>

<td valign="TOP"><a href="http://oaspub.epa.gov/enviro/ad_hoc_table_column_select.retrieval_list?table_1=+&selected_subjects=Evidentiary+Hearing+Event&subject_selection=+&database_type=PCS">

Evidentiary Hearing Event</a></td>

<td valign="TOP">A table of evidentiary hearing events for a facility with a NPDES permit.</td>

</tr>

<tr>

<td valign="TOP"><a href="http://oaspub.epa.gov/enviro/ad_hoc_table_column_select.retrieval_list?table_1=+&selected_subjects=Pretreatment+Assessment+Summary&subject_selection=+&database_type=PCS">

Pretreatment Assessment Summary</a></td>

<td valign="TOP">A table of pretreatment assessment reports for a facility with a NPDES permit.</td>

</tr>

<tr>

<td valign="TOP"><a href="http://oaspub.epa.gov/enviro/ad_hoc_table_column_select.retrieval_list?table_1=+&selected_subjects=Compliance+Schedules&subject_selection=+&database_type=PCS">Compliance Schedules</a></td>

<td valign="TOP">Activities and associated milestones pertaining to the permit.</td>

</tr>

<tr>

<td valign="TOP"><a href="http://oaspub.epa.gov/enviro/ad_hoc_table_column_select.retrieval_list?table_1=+&selected_subjects=Compliance+Schedule+Violation&subject_selection=+&database_type=PCS">Compliance Schedule Violation</a></td>

<td valign="TOP">A table of violations that reflect the non-achievement of a given compliance schedule event

including the type of violation and type of resolution.</td></tr>

<tr>

<td valign="TOP"><a href="http://oaspub.epa.gov/enviro/ad_hoc_table_column_select.retrieval_list?table_1=+&selected_subjects=Inspection&subject_selection=+&database_type=PCS">

Inspection</a></td>

<td valign="TOP">Tables of recorded official visits to a permit facility.  </td></tr>

<tr>

<td valign="TOP"><a href="http://oaspub.epa.gov/enviro/ad_hoc_table_column_select.retrieval_list?table_1=+&selected_subjects=Reference&subject_selection=+&database_type=PCS">Reference</a></td>

<td valign="TOP">A table providing text descriptions that explain the code meanings for each type and each possible code value

 contained on PCS tables.</td></tr>

</tbody></table>

<center>

			<!-- #EndEditable --><!-- END CONTENT AREA -->
	<!-- BEGIN AREA FOOTER - ADD text/links for area footer within this paragraph tag -->
	<p id="areafooter"></p>
	<!-- END AREA FOOTER -->
</center></div> <!-- END CONTENT -->

<hr class="skip">

<div align="left" id="area-nav"> <!-- BEGIN AREA MAIN NAVIGATION -->
	<h3 class="skip">Local Navigation</h3>
	<ul>
		<li><a href="http://www.epa.gov/enviro/html/pcs/index.html" class="epaSideBarLinks">Overview</a></li>
		<li><a href="http://www.epa.gov/enviro/html/pcs/pcs_query_java.html" class="epaSideBarLinks">Query</a></li>
		<li><a href="./US EPA 2010a_files/US EPA 2010a.htm" class="epaSideBarLinks">Customized Query</a></li>
		<li><a href="http://www.epa.gov/enviro/html/pcs/pcs_subj.html" class="epaSideBarLinks">Model</a></li>
		<li><a href="http://www.epa.gov/enviro/html/laws.html" class="epaSideBarLinks">Law</a></li>
		<li><a href="http://www.epa.gov/enviro/html/data_source.html" class="epaSideBarLinks">Data Source</a></li>
		<li><a href="http://www.epa.gov/OGWDW/" class="epaSideBarLinks">Office of Ground Water  and Drinking Water</a></li>
		<li><a href="http://www.epa.gov/enviro/html/pcs/pcs_feedback.html" class="epaSideBarLinks">Contact Us</a></li>
		<li><a href="http://www.epa.gov/enviro/index.html" class="epaSideBarLinks">EF Home</a></li>
	</ul>
</div> <!-- END AREA MAIN NAVIGATION -->

<hr class="skip">

<div id="footer"> <!-- BEGIN FOOTER -->
<ul id="globalfooter">
		<li><a href="http://www.epa.gov/">EPA Home</a></li>
		<li><a href="http://www.epa.gov/epafiles/usenotice.htm">Privacy and Security Notice</a></li>
		<!-- CHANGE link to point to your own contact page -->
		<li class="last"><a href="http://www.epa.gov/enviro/html/pcs/pcs_feedback.html">Contact Us</a></li>
	</ul>
<p id="url">http://www.epa.gov/enviro/html/pcs/adhoc.html</p><p id="printAsIs"><a href="http://www.epa.gov/enviro/html/pcs/adhoc.html#" title="Print this page as-is.">Print As-Is</a></p><p id="date">Last updated on Wednesday, April 14, 2010</p><ul id="bookmarkList"><li class="post" id="post"><a href="http://www.epa.gov/enviro/html/pcs/adhoc.html#">Share</a><ul id="postList" class="hide"><li class="delicious"><a href="javascript:epaCore.articleShare('delicious');">Del.icio.us</a></li><li class="digg"><a href="javascript:epaCore.articleShare('digg');">Digg</a></li><li class="facebook"><a href="javascript:epaCore.articleShare('facebook');">Facebook</a></li><li class="stumble"><a href="javascript:epaCore.articleShare('stumble');">StumbleUpon</a></li><li class="whatisthis"><a href="javascript:epaCore.articleShare('whatisthis');">What is this?</a></li></ul></li></ul></div> <!-- END FOOTER -->

<p class="skip"><a id="skipbot" href="http://www.epa.gov/enviro/html/pcs/adhoc.html#content" title="Jump to main content.">Jump to main content.</a></p>

</body></html>