Document ID: EPA-HQ-OW-2003-0074-0266
Agency: epa
Document Type: Supporting & Related Material
Title: 
Posted Date: 2003-12-24T05:00Z

PCSLoads2000
Data
Dictionary
Prepared
for:

U.
S.
Environmental
Protection
Agency
Engineering
and
Analysis
Division
Office
of
Water
1200
Pennsylvania
Avenue,
NW
Washington
DC
20460
Prepared
by:

ERG,
Inc.
14555
Avion
Parkway
Suite
200
Chantilly,
VA
20151­
1102
12
December
2003
EPA
Contract
No.
68­
C02­
095
Work
Assignment
1­
05
Table
of
Contents
1.0
Introduction
...................................................................................................................
3
2.0
Table
Descriptions
.........................................................................................................
3
3.0
Query
Descriptions
......................................................................................................
11
3
1.0
Introduction
This
data
element
dictionary
provides
documentation
of
the
data
contained
in
the
PCSLoads2000
Microsoft
Access
database
used
for
the
analysis
of
Permit
Compliance
System
(
PCS)
data.
A
description
of
the
analysis,
as
well
as
a
summary
of
the
data,
is
provided
in
the
report
entitled
Development
of
PCS
Loads,
dated
August
13,
2003.
A
copy
of
the
database
is
included
in
the
public
docket
(
DCN
00577,
Section
2.1.2).

This
database
includes
data
downloaded
from
the
EPA
mainframe
PCS
database
in
March
2003
for
reporting
year
2000.
As
further
study
was
conducted
on
the
PCS
data,
some
corrections
were
made.
A
summary
of
the
corrections
is
included
as
an
addendum
to
the
August
2003
report.

Section
2
provides
a
listing
of
all
the
tables
in
the
PCSLoads2000
database,
as
well
as
field
names
and
field
descriptions
for
each
table.
Section
3
includes
a
listing
and
description
of
the
primary
queries
run
with
the
PCSLoads2000
database.

2.0
Table
Descriptions
The
tables
included
in
the
PCSLoads2000
database
are
listed
below.
A
brief
description
of
the
table
is
followed
by
a
listing
of
the
field
names
and
field
descriptions.
Several
of
the
tables
include
data
extracted
from
the
PCS
mainframe
database.
These
tables
are
PCS2000,
PCSFAC,
PRAM_
CODES,
and
SIC_
CODES.
Further
explanation
of
PCS
variables
can
be
found
in
the
Permit
Compliance
System
Data
Element
Dictionary
(
DCN
00356,
Section
2.1.2).
The
remaining
tables
were
generated
for
use
in
screening
industrial
discharges
for
the
Clean
Water
Act
(
CWA)
preliminary
Effluent
Guidelines
Program
Plan
for
2004/
2005.

Facilities
included
in
PCS
may
be
classified
as
major
or
minor,
depending
on
the
size
of
the
facility
and
the
amount
of
water
discharged
from
the
facility.
For
the
majority
of
PCS
analyses,
only
major
facilities
were
investigated.
4
40
CFR
Parts
and
SIC
Groups
This
table
relates
point
source
categories
to
regulations
listed
in
40
CFR
by
part
number.
In
the
case
where
SIC
codes
are
not
associated
with
a
regulation,
the
point
source
category
field
is
populated
with
a
2­
or
4­
digit
SIC
code
and
the
40
CFR
Part
field
is
populated
with
the
name
of
that
SIC
group.
Number
of
Records:
88
Field
Name
Field
Description
40
CFR
Part
40
Code
of
Federal
Regulations
Part,
2­
digit
SIC
grouping,
or
4­
digit
SIC
grouping
Point
Source
Category
Point
Source
Category,
2­
digit
SIC
group,
or
4­
digit
SIC
group
PCS2000
This
table,
which
provides
discharge
information
for
each
facility
reporting
to
PCS,
is
the
output
of
the
Effluent
Data
Statistics
(
EDS)
program
on
EPA's
mainframe
PCS
database.
EDS
uses
raw
data
reported
to
PCS
to
calculate
pollutant
discharge
in
kilograms
and
flow
discharge
in
million
gallons
per
year
for
each
discharge
pipe
at
each
facility
(
majors
and
minors).
Number
of
Records:
277,101
Field
Name
Field
Description
DSCH
Discharge
Pipe
KGYE
Load,
in
kilograms
per
year
for
pollutants
and
million
gallons
per
year
for
flow
MLOC
Monitoring
Location
NPID
NPDES
Permit
Number
PRAM
PCS
Parameter
Code
Year
Measurement
Year
5
PCSFAC
This
table
provides
facility
information,
including
geographical
information,
for
all
facilities
(
majors
and
minors)
reporting
to
PCS.
The
data
in
this
table
were
downloaded
from
EPA's
mainframe
PCS
database.
Number
of
Records:
54,203
Field
Name
Field
Description
CITY
Facility
City
CSDN
Consolidated
System
Facility
Identifier,
an
EPA
identification
number
FHBC
Facility
USGS
Hydrologic
Basin
Code
FLLC
Facility
Latitude/
Longitude
Code
of
Accuracy
MADI
Major/
Minor
Indicator
(
M
indicates
a
major
discharger)

NAME
Facility
Name
NLAT
Facility
Latitude
NLONG
Facility
Longitude
NPID
NPDES
Permit
Number
RWAT
Receiving
Water
SIC
4­
digit
Standard
Industrial
Classification
Code
PCS_
Master_
List
This
table
provides
estimated
discharge
information
by
chemical
for
every
major
facility
reporting
to
PCS.
It
contains
chemical
name,
pounds
discharged,
and
toxic
weighed
pound
equivalents
for
each
chemical
reported.
The
data
in
this
table
are
calculated
using
the
data
in
the
PCS2000,
PCSFAC,
SUPERCAS,
and
TWF
REQUESTS
tables.
Number
of
Records:
85,683
6
Field
Name
Field
Description
CAS
Chemical
Abstracts
Service
Number
LBSYE
Load
in
pounds
per
year
(
for
year
2000)

NPID
NPDES
Permit
Number
PRAM
PCS
Parameter
Code
PRAM_
NAME
Parameter
Name
SIC
4­
digit
Standard
Industrial
Classification
Code
ToxicWt(
lbs)
Sum
of
Toxic
Weighted
Pound
Equivalents
by
Facility
(
for
year
2000)

Point
Source
Ranking
Sum
This
table
provides
estimated
discharge
information
by
chemical
and
discharge
pipe
for
each
major
facility
in
both
pounds
per
year
and
kilograms
per
year.
Number
of
Records:
139,507
Field
Name
Field
Description
CAS
Chemical
Abstracts
Service
Number
DSCH
Discharge
Pipe
KGYE
Load,
in
kilograms
per
year
for
pollutants
and
millions
of
gallons
per
year
for
flow
LBSYE
Load
in
pounds
per
year
(
for
year
2000)

NPID
NPDES
permit
number
Point
Source
Category
Point
Source
Category,
2­
digit
SIC
group,
or
4­
digit
SIC
group
PRAM
PCS
Parameter
Code
SIC
4­
digit
Standard
Industrial
Classification
Code
ToxLBS
Sum
of
Toxic
Weighted
Pound
Equivalents
by
discharge
pipe
(
for
year
2000)
7
Point
Source
Ranking
Sum
­
MF
and
MPM
fixed
This
table
provides
estimated
discharge
information
by
chemical
and
discharge
pipe
for
each
major
facility
in
both
pounds
per
year
and
kilograms
per
year,
with
corrections
made
to
the
Metal
Finishing
and
Metal
Products
&
Machinery
(
MP&
M)
point
source
categories
to
eliminate
double
counting.
EPA
determined
it
would
be
inappropriate
to
double
count
pollutant
loadings
for
these
point
source
categories
because
the
final
MP&
M
rule
at
§
438.1(
b)
specifically
excludes
both
metal­
bearing
wastewaters
and
wastewaters
subject
to
other
effluent
guidelines
(
e.
g.,
Metal
Finishing).
EPA
developed
a
methodology
to
distribute
the
pollutant
loadings
by
allocating
only
organic
chemical
releases
to
the
MP&
M
point
source
category
and
all
other
releases
to
the
Metal
Finishing
point
source
category.
Number
of
Records:
133,765
Field
Name
Field
Description
CAS
Chemical
Abstracts
Service
Number
DSCH
Discharge
Pipe
KGYE
Load,
in
kilograms
per
year
for
pollutants
and
in
millions
of
gallons
per
year
for
flow.

LBSYE
Load
in
pounds
per
year
(
for
year
2000)

NPID
NPDES
permit
number
Point
Source
Category
Point
Source
Category,
2­
digit
SIC
group,
or
4­
digit
SIC
group
PRAM
PCS
Parameter
Code
SIC
4­
digit
Standard
Industrial
Classification
Code
ToxLBS
Sum
of
Toxic
Weighted
Pound
Equivalents
by
discharge
pipe
(
for
year
2000)

PRAM_
CODES
This
table
relates
PCS
parameter
codes
to
parameter
descriptions.
This
table
was
downloaded
from
EPA's
mainframe
PCS
database
(
PCS
Table
ID
160).
Number
of
Records:
3,146
8
Field
Name
Field
Description
PRAMCODE
PCS
Parameter
Code
PRAMDESC
Parameter
Name
PSC_
Toxic_
Wt_
Ranking
This
table
provides
the
sum
of
toxic
weighted
pound
equivalents
for
each
point
source
category
and
either
the
2­
digit
SIC
grouping
or
the
4­
digit
SIC
grouping
for
the
year
2000.
Number
of
Records:
82
Field
Name
Field
Description
40
CFR
Part
40
Code
of
Federal
Regulations
Part,
2­
digit
SIC
grouping,
or
4­
digit
SIC
grouping
Point
Source
Category
Point
Source
Category,
2­
digit
SIC
group,
or
4­
digit
SIC
group
SumofToxLBS
Toxic
Weighted
Pound
Equivalents
(
for
year
2000)
for
a
point
source
category
or
SIC
group
TypeofGroup
Indicates
if
a
group
is
a
Point
Source
Category
(
PSC),
a
2­
digit
SIC
grouping
(
SIC),
or
a
4­
digit
SIC
grouping
(
SIC4)

SIC_
CODES
This
table
is
a
listing
of
all
4­
digit
SIC
codes
reported
in
PCS
and
their
descriptions
as
defined
by
the
1987
Standard
Industrial
Classification
Manual.
This
table
was
downloaded
from
EPA's
mainframe
PCS
database
(
PCS
Table
ID
140).
Number
of
Records:
1,009
Field
Name
Field
Description
SIC
4­
digit
Standard
Industrial
Classification
Code
SICDesc
4­
digit
Standard
Industrial
Classification
Description
9
SIC_
Toxic_
Wt_
Ranking
This
table
includes
total
toxic
weighted
pound
equivalents
for
each
SIC
code.
Number
of
Records:
250
Field
Name
Field
Description
SIC
4­
digit
Standard
Industrial
Classification
Code
SICDesc
4­
digit
Standard
Industrial
Classification
Description
SumofToxLBS
Toxic
Weighted
Pound
Equivalents
(
for
year
2000)
for
a
point
source
category
or
SIC
group
SUPERCAS_
category
This
table
relates
PCS
parameters
to
their
CAS
number
and
parameter
category.
The
parameter
categories
include
biological
parameters
(
BIO),
biological
oxygen
demand
(
BOD),
chemical
oxygen
demand
(
COD),
dissolved
oxygen
(
DO),
flow
(
FLOW),
hydrocarbons
(
HC),
oil
and
grease
(
O&
G),
priority
pollutants
(
PP),
solids
(
SOLIDS),
and
total
suspended
solids
(
TSS).
This
table
also
includes
a
field
indicating
those
parameters
regulated
under
the
MP
&
M
point
source
category.
Number
of
Records:
4,259
Field
Name
Field
Description
CAS
Chemical
Abstracts
Services
Number
Category
Parameter
Category
Included
in
MPM
Indicates
whether
a
parameter
is
included
in
Metal
Products
&
Machinery
point
source
category
PRAM
PCS
Parameter
Code
PRAM_
NAME
Parameter
Name
SUPERCROSSWALK
This
table
relates
4­
digit
SIC
codes
to
point
source
categories,
2­
digit
SIC
groupings,
or
4­
digit
SIC
groupings.
Number
of
Records:
1,016
10
Field
Name
Field
Description
Point
Source
1
The
first
Point
Source
Category,
2­
digit
SIC
group,
or
4­
digit
SIC
group
Point
Source
2
The
second
Point
Source
Category,
2­
digit
SIC
group,
or
4­
digit
SIC
group
Point
Source
3
The
third
Point
Source
Category,
2­
digit
SIC
group,
or
4­
digit
SIC
group
Point
Source
4
The
fourth
Point
Source
Category,
2­
digit
SIC
group,
or
4­
digit
SIC
group
SIC
4­
digit
Standard
Industrial
Classification
Code
SICDesc
4­
digit
Standard
Industrial
Classification
Description
TypeofGroup
Indicates
if
a
group
is
a
Point
Source
Category
(
PSC),
a
2­
digit
SIC
grouping
(
SIC),
or
a
4­
digit
SIC
grouping
(
SIC4)

TWF
REQUESTS
This
table
provides
the
toxic
weighting
factors
(
TWFs)
as
assigned
by
EPA
Office
of
Water's
Engineering
and
Analysis
Division
(
EAD).
The
TWFs
measure
the
toxicity
of
the
pollutant
relative
to
copper,
and
take
into
account
chronic
freshwater
aquatic
criteria
as
well
as
human
health
criteria
based
on
fish
consumption.
Number
of
Records:
1,993
Field
Name
Field
Description
CASNU
Chemical
Abstracts
Service
Number
NAME
Chemical
Name
SYN
Alternate
Name,
Synonym
TRI_
Match
Indicates
whether
a
chemical
is
included
in
TRI
TWF
EAD
Toxic
Weighting
Factor
UPDATE
This
field
indicates
the
date
of
the
most
recent
update
to
the
TWF
11
3.0
Query
Descriptions
The
queries
included
in
PCSLoads2000
are
listed
below.
Included
in
the
query
listing
is
a
brief
description
of
the
purpose
of
each
query.

ci_
Count_
by_
SIC_
minors_
Step1
The
purpose
of
this
query
is
to
group
facilities
from
"
ci_
Toxic_
wt_
Minors"
by
SIC
code.

ci_
Count_
by_
SIC_
minors_
Step2
The
purpose
of
this
query
is
to
count
the
number
of
facilities
for
each
SIC
code
from
"
ci_
Count_
by_
SIC_
minors_
Step1"
query.

ci_
Count_
by_
SIC_
Step1
The
purpose
of
this
query
is
to
group
facilities
from
"
ci_
Toxic_
Wt"
by
SIC
code.

ci_
Count_
by_
SIC_
Step2
The
purpose
of
this
query
is
to
count
the
number
of
facilities
for
each
SIC
code
from
"
ci_
Count_
by_
SIC_
Step1."

ci_
Master_
List
The
purpose
of
this
query
is
to
create
the
"
PCS_
Master_
List"
table
which
includes
all
discharge
information
for
all
major
facilities
in
PCS,
with
the
exception
of
flow.

ci_
Toxic_
Wt
The
purpose
of
this
query
is
to
calculate
TWPE
for
all
chemicals
reported
in
PCS
for
all
major
facilities
with
SIC
codes
listed
in
the
"
PCSFAC"
table.
This
query
is
used
as
a
building
block
for
many
queries.

ci_
Toxic_
wt_
Minors
The
purpose
of
this
query
is
to
calculate
TWPE
for
all
chemicals
reported
in
PCS
for
all
minor
facilities
with
SIC
codes
listed
in
the
"
PCSFAC"
table.

Make
Final
Table
(
10)
not
MF
or
MPM
The
purpose
of
this
query
is
to
append
the
"
Point
Source
Ranking
Sum
­
MF
and
MPM
fixed"
table.
A
listing
of
all
facilities
with
the
exception
of
Metal
Finishing
and
Metal
Products
&
Machinery
facilities,
is
added
to
the
table.

Make
Final
Table
(
8)
MF
The
purpose
of
this
query
is
to
append
a
listing
of
all
Metal
Finishing
facilities
with
their
chemical
discharge
information
to
"
Point
Source
Ranking
Sum
­
MF
and
MPM
fixed."
12
Make
Final
Table
(
9)
MPM
The
purpose
of
this
query
is
to
append
a
listing
of
all
Metal
Products
&
Machinery
facilities
with
their
chemical
discharge
information
to
"
Point
Source
Ranking
Sum
­
MF
and
MPM
fixed."

Make
Final
Table
Collapse
(
12)
MPM
and
MF
fixed
The
purpose
of
this
query
is
to
create
the
"
PSC_
Toxic_
Wt_
Ranking"
table
from
"
Point
Source
Ranking
Sum
­
MF
and
MPM
fixed."
This
query
also
calculates
the
total
TWPE
(
SumofToxLBS)
for
each
40
CFR
Part.

Make
Final
Table
Collapse
(
13)
MPM
and
MF
fixed
by
SIC
The
purpose
of
this
query
is
to
create
"
SIC_
Toxic_
Wt_
Ranking"
from
"
Point
Source
Ranking
Sum
­
MF
and
MPM
fixed".
This
query
also
calculates
total
TWPE
(
SumofToxLBS)
for
each
SIC
code.

Make
Point
Source
Ranking
­
blank
(
1)
The
purpose
of
this
query
is
to
create
a
blank
table
named
"
Point
Source
Ranking
Sum."

Make
Point
Source
Ranking
­
blank
(
7)
MF
and
MPM
The
purpose
of
this
query
is
to
create
a
blank
table
named
"
Point
Source
Ranking
Sum
­
MF
and
MPM
fixed."

Make
Point
Source
Ranking
­
Collapse
(
11)
The
purpose
of
this
query
is
to
return
total
TWPE
for
each
PCS
facility
and
sort
the
results
in
descending
order.

Make
Point
Source
Ranking
­
PS1
(
2)
The
purpose
of
this
query
is
to
append
a
listing
of
all
facilities
with
non­
null
Point
Source
1
and
their
discharges
from
the
"
ci_
Toxic_
Wt"
query
to
the
"
Point
Source
Ranking
Sum"
table.

Make
Point
Source
Ranking
­
PS2
(
3)
The
purpose
of
this
query
is
to
append
a
listing
of
all
facilities
with
non­
null
Point
Source
2
and
their
discharges
from
the
"
ci_
Toxic_
Wt"
query
to
the
"
Point
Source
Ranking
Sum"
table.

Make
Point
Source
Ranking
­
PS3
(
4)
The
purpose
of
this
query
is
to
append
a
listing
of
all
facilities
with
non­
null
Point
Source
3
and
their
discharges
from
the
"
ci_
Toxic_
Wt"
query
to
the
"
Point
Source
Ranking
Sum"
table.

Make
Point
Source
Ranking
­
PS4
(
5)
The
purpose
of
this
query
is
to
append
a
listing
of
all
facilities
with
Point
Source
4
data
13
and
their
discharges
from
the
"
ci_
Toxic_
Wt"
query
to
the
"
Point
Source
Ranking
Sum"
table.

Make
Point
Source
Ranking
­
w/
o
PSC
(
6)
The
purpose
of
this
query
is
to
append
a
listing
of
all
facilities
null
Point
Source
4
and
their
discharges
from
the
"
ci_
Toxic_
Wt"
table
to
the
"
Point
Source
Ranking
Sum"
table.

PCS_
FACS_
SteamElectric
The
purpose
of
this
query
is
to
return
a
list
of
all
facilities
classified
as
Stream
Electric
Power
Generation
and
the
total
TWPE
for
each
facility.

PCS_
FAC_
CFPR
The
purpose
of
this
query
is
to
return
a
list
of
all
facilities
classified
as
Chemical
Formulating,
Packaging,
and
Repackaging
and
the
total
TWPE
for
each
facility.

PCS_
FAC_
Fertilizer
The
purpose
of
this
query
is
to
return
a
list
of
all
facilities
classified
as
Fertilizer
Manufacturing
and
the
total
TWPE
for
each
facility.

PCS_
FAC_
Inorganics
The
purpose
of
this
query
is
to
return
a
list
of
all
facilities
classified
as
Inorganic
Chemicals
Manufacturing
and
the
total
TWPE
for
each
facility.

PCS_
FAC_
NFMM
The
purpose
of
this
query
is
to
return
a
list
of
all
facilities
classified
as
Nonferrous
Metals
Manufacturing
and
the
total
TWPE
for
each
facility.

PCS_
FAC_
OCPSF
The
purpose
of
this
query
is
to
return
a
list
of
all
facilities
classified
as
Organic
Chemicals,
Plastics,
and
Synthetic
Fibers
and
the
total
TWPE
for
each
facility.

PCS_
FAC_
Oremining
The
purpose
of
this
query
is
to
return
a
list
of
all
facilities
classified
as
Ore
Mining
and
Dressing
and
the
total
TWPE
for
each
facility.

PCS_
FAC_
PBST
The
purpose
of
this
query
is
to
return
a
list
of
all
facilities
classified
as
Petroleum
Bulk
Stations
and
Terminals
and
the
total
TWPE
for
each
facility.

PCS_
FAC_
Phosphate
The
purpose
of
this
query
is
to
return
a
list
of
all
facilities
classified
as
Phosphate
Manufacturing
and
the
total
TWPE
for
each
facility.
14
PCS_
FAC_
PR
The
purpose
of
this
query
is
to
return
a
list
of
all
facilities
classified
as
Petroleum
Refining
and
the
total
TWPE
for
each
facility.

PCS_
FAC_
PulpPaperPaperboard_
1
The
purpose
of
this
query
is
to
return
a
list
of
all
facilities
classified
as
Pulp,
Paper,
and
Paperboard
Phase
I
and
the
total
TWPE
for
each
facility.

PCS_
FAC_
PulpPaperPaperboard_
2
The
purpose
of
this
query
is
to
return
a
list
of
all
facilities
classified
as
Pulp,
Paper,
and
Paperboard
Phase
II
and
the
total
TWPE
for
each
facility.

PCS_
FAC_
PulpPaperPaperboard_
3
The
purpose
of
this
query
is
to
return
a
list
of
all
facilities
classified
as
Pulp,
Paper,
and
Paperboard
Phase
III
and
the
total
TWPE
for
each
facility.

PCS_
FAC_
Textile
The
purpose
of
this
query
is
to
return
a
list
of
all
facilities
classified
as
Textile
Mills
and
the
total
TWPE
for
each
facility.

PCS_
FAC_
Timber
The
purpose
of
this
query
is
to
return
a
list
of
all
facilities
classified
as
Timber
Products
Processing
and
the
total
TWPE
for
each
facility.

PCS_
PRAM_
CFPR_
Step1
The
purpose
of
this
query
is
to
return
a
list
of
all
parameters
and
their
total
TWPE
for
Chemical
Formulating,
Packaging,
and
Repackaging
facilities.

PCS_
PRAM_
CFPR_
Step2
The
purpose
of
this
query
is
to
return
a
list
of
chemicals
discharged
from
all
Chemical
Formulating,
Packaging,
and
Repackaging
facilities,
their
total
TWPE,
and
the
number
of
facilities
reporting
them.

PCS_
PRAM_
Fertilizer_
Step1
The
purpose
of
this
query
is
to
return
a
list
of
all
parameters
and
their
total
TWPE
for
Fertilizer
Manufacturing
facilities.

PCS_
PRAM_
Fertilizer_
Step2
The
purpose
of
this
query
is
to
return
a
list
of
chemicals
discharged
from
all
Fertilizer
Manufacturing
facilities
and
their
total
TWPE
along
with
the
number
of
facilities
reporting
them.
15
PCS_
PRAM_
Inorganics_
Step1
The
purpose
of
this
query
is
to
return
a
list
of
all
parameters
and
their
total
TWPE
for
Inorganic
Chemicals
Manufacturing
facilities.

PCS_
PRAM_
Inorganics_
Step2
The
purpose
of
this
query
is
to
return
a
list
of
chemicals
discharged
from
all
Inorganic
Chemicals
Manufacturing
facilities,
their
total
TWPE,
and
the
number
of
facilities
reporting
them.

PCS_
PRAM_
NonferrousMetalsManufacturing_
Step1
The
purpose
of
this
query
is
to
return
a
list
of
all
parameters
and
their
total
TWPE
for
Nonferrous
Metals
Manufacturing
facilities.

PCS_
PRAM_
NonferrousMetalsManufacturing_
Step2
The
purpose
of
this
query
is
to
return
a
list
of
chemicals
discharged
from
all
Nonferrous
Metals
Manufacturing
facilities,
their
total
TWPE,
and
the
number
of
facilities
reporting
them.

PCS_
PRAM_
OCPSF_
Step1
The
purpose
of
this
query
is
to
return
a
list
of
all
parameters
and
their
total
TWPE
for
Organic
Chemicals,
Plastics,
and
Synthetic
Fibers
facilities.

PCS_
PRAM_
OCPSF_
Step2
The
purpose
of
this
query
is
to
return
a
list
of
chemicals
discharged
from
all
Organic
Chemicals,
Plastics,
and
Synthetic
Fibers
facilities,
their
total
TWPE,
and
the
number
of
facilities
reporting
them.

PCS_
PRAM_
OreMining_
Step1
The
purpose
of
this
query
is
to
return
a
list
of
all
parameters
and
their
total
TWPE
for
Ore
Mining
and
Dressing
facilities.

PCS_
PRAM_
OreMining_
Step2
The
purpose
of
this
query
is
to
return
a
list
of
chemicals
discharged
from
all
Ore
Mining
and
Dressing
facilities,
their
total
TWPE,
and
the
number
of
facilities
reporting
them.

PCS_
PRAM_
PBST_
Step1
The
purpose
of
this
query
is
to
return
a
list
of
all
parameters
and
their
total
TWPE
for
Petroleum
Bulk
Stations
and
Terminals
facilities.

PCS_
PRAM_
PBST_
Step2
The
purpose
of
this
query
is
to
return
a
list
of
chemicals
discharged
from
all
Petroleum
Bulk
Stations
and
Terminals
facilities,
their
total
TWPE,
and
the
number
of
facilities
reporting
them.
16
PCS_
PRAM_
Phosphate_
Step1
The
purpose
of
this
query
is
to
return
a
list
of
all
parameters
and
their
total
TWPE
for
Phosphate
Manufacturing
facilities.

PCS_
PRAM_
Phosphate_
Step2
The
purpose
of
this
query
is
to
return
a
list
of
chemicals
discharged
from
all
Phosphate
Manufacturing
facilities,
their
total
TWPE,
and
the
number
of
facilities
reporting
them.

PCS_
PRAM_
PR_
Step1
The
purpose
of
this
query
is
to
return
a
list
of
all
parameters
and
their
total
TWPE
for
Petroleum
Refining
facilities.

PCS_
PRAM_
PR_
Step2
The
purpose
of
this
query
is
to
return
a
list
of
chemicals
discharged
from
all
Petroleum
Refining
facilities,
their
total
TWPE,
and
the
number
of
facilities
reporting
them.

PCS_
PRAM_
PulpAndPaperPhaseI_
Step1
The
purpose
of
this
query
is
to
return
a
list
of
all
parameters
and
their
total
TWPE
for
Pulp,
Paper,
and
Paperboard
Phase
I
facilities.

PCS_
PRAM_
PulpAndPaperPhaseI_
Step2
The
purpose
of
this
query
is
to
return
a
list
of
chemicals
discharged
from
all
Pulp,
Paper,
and
Paperboard
Phase
I
facilities,
their
total
TWPE,
and
the
number
of
facilities
reporting
them.

PCS_
PRAM_
PulpAndPaperPhaseII_
Step1
The
purpose
of
this
query
is
to
return
a
list
of
all
parameters
and
their
total
TWPE
for
Pulp,
Paper,
and
Paperboard
Phase
II
facilities.

PCS_
PRAM_
PulpAndPaperPhaseII_
Step2
The
purpose
of
this
query
is
to
return
a
list
of
chemicals
discharged
from
all
Pulp,
Paper,
and
Paperboard
Phase
II
facilities,
their
total
TWPE,
and
the
number
of
facilities
reporting
them.

PCS_
PRAM_
PulpAndPaperPhaseIII_
Step1
The
purpose
of
this
query
is
to
return
a
list
of
all
parameters
and
their
total
TWPE
for
Pulp,
Paper,
and
Paperboard
Phase
III
facilities.

PCS_
PRAM_
PulpAndPaperPhaseIII_
Step2
The
purpose
of
this
query
is
to
return
a
list
of
chemicals
discharged
from
all
Pulp,
Paper,
and
Paperboard
Phase
III
facilities,
their
total
TWPE,
and
the
number
of
facilities
reporting
them.
17
PCS_
PRAM_
SteamElectric_
Step1
The
purpose
of
this
query
is
to
return
a
list
of
all
parameters
and
their
total
TWPE
for
Steam
Electric
Power
Generation
facilities.

PCS_
PRAM_
SteamElectric_
Step2
The
purpose
of
this
query
is
to
return
a
list
of
chemicals
discharged
from
all
Steam
Electric
Power
Generation
facilities,
their
total
TWPE,
and
the
number
of
facilities
reporting
them.

PCS_
PRAM_
Textile_
Step1
The
purpose
of
this
query
is
to
return
a
list
of
all
parameters
and
their
total
TWPE
for
Textile
Mills.

PCS_
PRAM_
Textile_
Step2
The
purpose
of
this
query
is
to
return
a
list
of
chemicals
discharged
from
all
Textile
Mills,
their
total
TWPE,
and
the
number
of
facilities
reporting
them.

PCS_
PRAM_
Timber_
Step1
The
purpose
of
this
query
is
to
return
a
list
of
all
parameters
and
their
total
TWPE
for
Timber
Products
Processing
facilities.

PCS_
PRAM_
Timber_
Step2
The
purpose
of
this
query
is
to
return
a
list
of
chemicals
discharged
from
all
Timber
Products
Processing
facilities,
their
total
TWPE,
and
the
number
of
facilities
reporting
them.

unique_
supercas
The
purpose
of
this
query
is
to
make
a
list
of
all
unique
parameters
from
"
SUPERCAS_
category"
for
use
in
other
queries.