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 

methodology, 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 will be used to complete the Petroleum 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 (ICISNPDES) 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 Table 2 for a description of 

the specific data elements included in these five tables.

Parameter Groupings This table presents the PCS and ICIS pollutant parameters and 

descriptions, the pollutant CAS number and the group code and name 

assigned. For further 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

.pdf
Table Name Data Element Description

2000 PCS Petroleum Data

2004 PCS Petroleum Data

2007 DMR Petroleum Data

2008 DMR Petroleum Data

2009 DMR Petroleum Data

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 Standard Industrial 

Classification (SIC) code.

NPDES ID Facility National Pollutant Discharge 

Elimination System (NDPES) permit 

number.

Name Facility name.

City Facility city.

State Facility state.

Outfalla Point of discharge for a facility. A 

NPDES permit may have multiple points 

of discharge.

Parameter Codeb 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 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 Annual 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). 
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 may 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 2000 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 Codea, 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 Publicly 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 discharges 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

2004 TRI Petroleum Data

2005 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 Annual 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 toxic 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 Toola. 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 Pollutant Loadings Tool. Includes NAICS Codeb, 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 represent 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 Annual 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).