### 304m Data Supporting Petroleum Comment Responses Database Dictionary April 2015

EPA created two databases to present the underlying data referenced in the 2011 and 2012 Annual Review Reports. These data are all publicly available in the dockets supporting EPA’s

Annual Reviews. The DMR database ( DCN 08111

– 304m DMR Data for the Petroleum Refining Industry.accdb) presents PCS and DMR data from 2000

- 2009, the TRI database ( DCN

08112

– 304m TRI Data for the Petroleum Refining Industry.accdb ) presents TRI data from

2004

- 2009 for petroleum refineries . Descriptions of the tables and data elements found in each

database are listed in the tables below. For further information on EPA’s annual review

me thodology, parameter groupings, loads calculations, and TWFs, see Section 3 of EPA’s 2011

Annual Effluent Guidelines Review Report ( EPA

- HQ

- OW

- 2010

- 0824

- 0195 )

.

EPA developed a separate database containing DMR and TRI data from 2007 through 2013,

which wil l be used to complete the Pe troleum Refining Detailed Study . The data are also available by using the DMR Loadings Tool ( http://cfpub.epa.gov/dmr/ ).

Table 1: Description of Tables in the 304m DMR Petroleum Data for Industry Database

Table Name Description

2000 PCS Petroleum Data

2004 PCS Petroleum Data

2007 DMR Petroleum Data

2008 DMR Petroleum Data

2009 DMR Petroleum Data Permit Compliance System ( PCS ) / Integrated Compliance Information System for the National Pollutant Discharge Elimination System (ICIS

NPDES) data for petroleum refineries for reporting years 2000, 2004, 2007, 2008, and 2009

. These tables include SIC code, NPDES ID, facility name and location, parameter code and description, and total pounds and TWPE for each pollutant. See T able 2 for a description of the specific data elements included in these five tables.

Parameter Grouping s This table presents the PCS and ICIS pollutant parameters and descriptions, the pollutant CAS number and the group code and name assigned. For furth er information on parameter groupings see section

3.2.3.2 of the Technical Support Document for the Annual Review of Existing Effluent Guidelines and Identification of Potential New Point Source Categories (2009 Screening

- Level Analysis (SLA) Report) (EPA

- HQ

- OW

- 2008

- 0517

- 0515) 1

. See Table 2 for a description of the specific data elements included in this table.

TWFs Pollutant name, CAS number and toxic weighting factor. For further information on TWFs, see section 3.2.4.1 of the 2009 SLA Report. See

Table 2 for a description of the specific data elements included in this

table.



### Table 2 : Description of Data Elements by Table in the 304m DMR Petroleum Data for Industry Database

1 Available online at: http://water.epa.gov/scitech/wastetech/guide/304m/archive/upload/2009_11_17_guide_304m_2010_tsdexisting
.pdfTable Name Data Element Description

2000 PCS Petroleum Data

2004 PCS Petroleum Data

2007 DMR Petroleum Data

2008 DMR Petroleum Data

2009 DMR Petroleum Dat a PSC Code A three

- digit code that corresponds to an

Effluent Limitations Guideline’s 40 CFR

Part (i.e., 419)

. SIC Code Facility 4

- digit S tandard I ndustrial

C lassification (SIC) code.

NPDES ID Facility National Pollutant Discharge Elimination System (NDPES) permit

number.

Name Facility name. City Facility city.

State Facility state.

Outfall a Point of discharge for a facility. A NPDES permit may have multiple points of discharge.

Parameter Code b A five

- character code in ICIS

- NDPES and PCS that identifies the regulated pollutant parameter in a NPDES permit and specifies both the pollutant name and pollutant form (e.g., dissolved or suspended). Multiple parameters can apply to a single pollutant or CAS

number. Group Code Single pollutant code that represents a group of parameters (e.g., total copper, copper, total copper per batch). Because a NPDES permit may require a facility to measure a pollutant more than one way, EPA groups parameters that represent a single pollutan t based on a hierarchy to avoid double counting. For further

information on parameter groupings see section 3.2.3.2 of the 2009 SLA Report

. Group Name Pollutant name associated with the group code (e.g., copper).

Pounds Annual mass discharge (in units of pounds) of a pollutant to a receiving

stream.

TWPE Annual toxic

- weighted pound equ ivalents (TWPE) of a pollutant released to a receiving stream. TWPE is calculated by multiplying the annual mass discharge (in units of pounds) by the toxic weighting

f actor (TWF).

### Table 2 : Description of Data Elements by Table in the 304m DMR Petroleum Data for Industry Database

Table Name Data Element Description

Parameters Groupings PCS Parameter Code A five

- digit code in PCS that identifies the regulated pollutant parameter in a NPDES permit and specifies both the pollutant name and pollutant form (e.g., dissolved or suspended). Multiple parameters can apply to a single pollutant

or CAS number.

PCS Parameter Description Description/parameter name that corresponds to the five

- digit parameter

code.

ICIS Parameter Code A five

- digit code in ICIS

- NPDES that identifies the regulated pollutant parameter in a NPDES permit and specifies both the pollutant name and pollutant form (e.g., dissolved or suspended). Multiple parameters can apply to a single pollutant or CAS

number.

ICIS Parameter Description Description/parameter name that corresponds to the five

- digit parameter

code.

CAS Number Chemical Abstract Service Number assigned by the American Chemical Society that uniquely identifies a

chemical. Group Code Single pollutant code that represents a group of parameters (e.g., total copper, copper, total copper per batch). Because a NPDES permit ma y require a facility to measure a pollutant more than one way, EPA groups parameters that represent a single pollutant based on a hierarchy to avoid double counting. Group Name Pollutant name associated with the group code (e.g., copper).

TWFs Pollutant Pollutant/parameter name.

CAS Number Chemical Abstract Service Number assigned by the American Chemical Society that uniquely identifies a

chemical.

Current TWF Pollutant toxic weighting factor. Multiply the annual mass (in units of pounds) by

this factor to calculate TWPE.

a

– The 200 0 PCS Petroleum Data table presents annual loadings at the plant

- level; therefore, Outfall is not included

in this table.b

– The 2004 PCS Petroleum Data and 2007 DMR Petroleum Data were processed at the group code and group name level. Therefore, the parameter code data are not included in these data tables. EPA notes that although the 2004 and 2007 DMR data do not include the parameter code, these data were processed using the same methodology

as the 2008 and 2009 DMR data.



### Table 3 : Description of Tables in the 304m TRI Petroleum Data for Industry Database

Table Name Description

2004 TRI Petroleum Data

2005 TRI Petroleum Data

2007 TRI Petroleum Data

2008 TRI Petroleum Data

2009 TRI Petroleum Data TRI data for petroleum refineries for each year specified. Includes

SIC/NAICS Code a

, TRI ID, facility name and location, release code, pollutant CAS number and chemical name, total pounds of pollutant

released

, and total TWPE. See Table 4 for a description of the specific

data elements included in these five tables.

POTW Removals P ublicly owned treatment works (POTW) percent removal for each pollutant. EPA adjusts pollutant loadings reported as transferred to a POTW to account for pollutant removal that occurs at the POTWs prior to discharge to the receiving stream. For further information on POTW Removals, see section 2.4. 2 of the 2009 SLA Report. See Table 4 for a description of the specific data elements include in this table.

TWFs Pollutant name, CAS number and toxic weighting factor. For further

information on TWFs, see section 2.4.3 of the 2009 SLA Report. See Table 4 for a description of the specific data elements include in this

table.

a

– In reporting years 2004 and 2005, facilities reported di s charges to TRI by SIC code. Starting in 2006, facilities reported discharges to TRI by NAICS code.



### Table 4 : Description of Data Elements by Table in the 304m TRI Petroleum Data for Industry Database

Table Name Data Element Description

200 4 TRI Petroleum Data

200 5 TRI Petroleum Data

2007 TRI Petroleum Data

2008 TRI Petroleum Data

2009 TRI Petroleum Data PSC Code A three

- digit code that corresponds to an

Effluent Limitations Guideline’s 40 CFR

Part (i.e., 419).

SIC Code/NAICS Code Facility 4

- digit Standard Industrial Classification (SIC) code, applicable to reporting years 2004 and 2005. Facility 6

- digit North American Industry Classification System (NAICS) code, applicable to reporting years 2007, 2008,

and 2009.

TRI ID Toxics Release Inventory Facility

Identification Number.

FACILITY NAME Facility name.

FACILITY CITY Facility city.

FACILITY STATE Facility state.

### Table 4 : Description of Data Elements by Table in the 304m TRI Petroleum Data for Industry Database

Table Name Data Element Description

Release Code Designates the type of water release reported to TRI. Release Code 3 designates a direct release to surface water. Release Code 6 represents a

transfer to a POTW.

CAS NUMBER Chemical Abstract Service Number assigned by the American Chemical Society that uniquely identifies a

chemical.

CHEMICAL NAME Chemical/pollutant name.

Total Pounds Released Ann ual mass discharge (in units of pounds) of a chemical to a receiving

stream.

TWPE Annual toxic

- weighted pound equivalents (TWPE) of a chemical released to a receiving stream. TWPE is calculated by multiplying the annual load (in units of pounds) by the t oxic weighting factor (TWF).

POTW Removals CAS Number Chemical Abstract Service Number assigned by the American Chemical Society that uniquely identifies a

chemical.

Chemical Name Chemical/pollutant name. POTW Removal (%) Estimated POTW percent removal applied to facility reported transfers of chemicals to POTWs (to account for pollutant removal at the POTW). To estimate the pounds released to surface water after the POTW, EPA uses the following

calculation:

Total Pounds Released = [Transfer to POTW (lbs/year)] x [1

– POTW Removal (%)].

For further information on POTW

removals see section 2.4.2 of the 2009

SLA Report

. TWFs Pollutant Pollutant/parameter name.

CAS Number Chemical Abstract Service Number assigned by the American Chemical Society that uniquely identifies a

chemical.

### Table 4 : Description of Data Elements by Table in the 304m TRI Petroleum Data for Industry Database

Table Name Data Element Description

Current TWF Pollutant toxic weighting factor. Multiply the annual mass (in units of pounds) by

this factor to calculate TWPE.



### Table 5: Description of Tables in the Detailed Study Petroleum Data for Industry

Database

Table Name Description

2007

- 2013 DMR Petroleum

Data DMR data for petroleum refineries for each year specified, as obtained from the DMR Pollutant Loadings Tool a . These tables include NPDES ID, facility name and location, parameter code and description, and total pounds and TWPE for each pollutant. Table 6 for a description of the specific data elements included in these tables.

2007

- 2013 TRI Petroleum

Data TRI data for petroleum refineries for each year specified, as obtained

from the DMR P ollutant Loadings Tool. Includes NAICS Code b , TRI ID, facility name and location, release code, pollutant CAS number and chemical name, total pounds of pollutant released, and total TWPE. See

Table 6 for a description of the specific data elements included in these

tables.

a The DMR Pollutant Loading Tool is available online at: http://cfpub.epa.gov/dmr/

b

– In reporting years 2004 and 2005, facilities reported discharges to TRI by SIC code. Starting in 2006, facilities reported discharges to TRI by NAICS code.



### Table 6: Description of Data Elements by Table in the Detailed Study Petroleum Data for Industry Database

Table Name Data Element Description

2007

- 2013 DMR Petroleum

Data Year The calendar year for the annual pollutant loadings.

NPDES ID Facility National Pollutant Discharge Elimination System (NDPES) permit

number.

Name Facility name. City Facility city.

State Facility state.

Outfall Point of discharge for a facility. A NPDES permit may have multiple points of discharge.

### Table 6: Description of Data Elements by Table in the Detailed Study Petroleum Data for Industry Database

Table Name Data Element Description

Parameter Code A five

- character code in ICIS

- NDPES and PCS that identifies the regulated pollutant parameter in a NPDES permit and specifies both the pollutant name and pollutant form (e.g., dissolved or suspended). Multiple parameters can apply to a single pollutant or CAS

number. Group Code Single pollutant code that represents a group of parameters (e.g., total copper, copper, total copper per batch). Because a NPDES permit may require a facility to measure a pollutant more than one way, EPA groups parameters that r epresent a single pollutant based on a hierarchy to avoid double counting. For further information on parameter groupings see section 3.2.3.2 of the 2009 SLA Report. Group Name Pollutant name associated with the group code (e.g., copper).

Pounds Annua l mass discharge (in units of pounds) of a pollutant to a receiving

stream.

TWPE Annual toxic

- weighted pound equivalents (TWPE) of a pollutant released to a receiving stream. TWPE is calculated by multiplying the annual mass discharge (in units of pounds ) by the toxic weighting factor (TWF).

2007

- 2013 TRI Petroleum

Data Year The calendar year for the annual pollutant loadings.

SIC Code/NAICS Code Facility 6

- digit North American Industry Classification System (NAICS) code.

TRI ID Toxics Release Inventory Facility

Identification Number.

FACILITY NAME Facility name.

FACILITY CITY Facility city.

FACILITY STATE Facility state.

CHEMICAL NAME Chemical/pollutant name.

Total Pounds Released Annual mass discharge (in units of pounds) of a chemical to a receiving

stream.

### Table 6: Description of Data Elements by Table in the Detailed Study Petroleum Data for Industry Database

Table Name Data Element Description

TWPE Annual toxic

- weighted pound equivalents (TWPE) of a chemical released to a receiving stream. TWPE is calculated by multiplying the annual load (in units of pounds) by the toxic weighting factor (TWF).