12/10/2013 1

Instructions for Submitting Data Corrections

Introduction

EPA seeks comments on hazardous air pollutant (HAP) emissions and other model input data 

that we used to assess risks from selected industrial major source categories, as required by 

section 112(f) of the Clean Air Act. The source of this information is the National Emissions 

Inventory (NEI), updated with data collected by EPA’s Office of Air Quality Planning and 

Standards. For more information about the National Emissions Inventory (NEI), please go to:

http://www.epa.gov/ttn/chief/eiinformation.html.

1

The Microsoft Access file will enable you to review and suggest revisions to HAP emissions and 

other descriptive information associated with all facilities in a single Maximum Achievable 

Control Technology (MACT) category. Instructions for using this file to review the data, revise 

the data, and submit revisions to EPA are outlined below. Section 6 lists specific steps for 

submitting your final changes to the EPA. Section 7 of this document defines important terms 

(e.g., MACT, SIC, SCC, etc.) and all data elements found in this file. The complete outline for 

this document is listed below:

1. Application Overview

2. View Summary Data

a. Options

i. MACT HAP Emissions

ii. State County MACT Emissions

iii. Facility MACT HAP Emissions

iv. All Data

b. Filter Data

3. Revise Data

a. Revise Emission Fields

b. Revise Stack Fields

 

1

 Underlined text in this document indicates hyperlinks to text both inside and outside the document.
12/10/2013 2

c. Revise Process Fields

d. Revise Facility Information

e. Add Data to an Existing Facility

4. Add a Facility

5. Review Revisions

6. Submit Revisions

7. Term Definitions

Please note that the category-specific files contain all emissions data for the facilities identified 

as belonging to a MACT category. Thus, some of the emissions may be from processes NOT 

associated with the MACT category of interest. The column labeled “MACT Code” indicates if 

the HAP pollutant emissions are associated with the MACT category of interest or another 

MACT category at the facility. For example, if the MACT code is labeled 0107-2, the emissions 

are described as being associated with “Industrial/Commercial/Institutional Boilers & Process 

Heaters – gas.” These are shown to provide a complete dataset for the facility and/or to help the 

reviewer spot additional processes which should be assigned to the MACT category.

1. Application Overview

When this Microsoft Access file opens you are presented with a “Main Page” containing five

buttons:

1. View Summary Data

2. Revise Data

3. Review Revisions

4. Submit Revisions

5. Exit Database

After reading these instructions, you should select the “View Summary Data” button to view 

summary data before making revisions or adding any facilities to this file. After reviewing the 

current data for your MACT category, you can proceed to the “Revise Data” forms. After 

making corrections to this file, you should review your corrections and then submit your 

revisions to EPA as outlined on the “Submit Revisions” form.
12/10/2013 3

2. View Summary Data

After selecting and clicking the “View Summary Data” button, the form displays national level 

summary data for all pollutants associated with the MACT category of interest. You can sort the 

columns in ascending or descending order if you wish to see the highest or lowest emissions 

and/or if you want to sort by pollutant name alphabetically. This form also provides buttons that 

allow you to change the aggregation level (“Options”) of the data and/or filter by pollutant

(“Filter Data”).

a. Options – These buttons allow you to view summary data at varying levels of detail. 

When you click these buttons, new forms open with data level and filter buttons 

appropriate to the dataset displayed. These buttons and their accompanying forms are 

as follows:

i. MACT HAP Emissions (View National Data Form) – Discussed 

above, this form displays national level summary data for all pollutants 

associated with the MACT category of interest. This is the default 

form that opens when you select “View Summary Data” on the “Main 

Page.”

ii. State County MACT Emissions (View State, County, MACT, 

HAP, and Emissions Data Form) – All emissions for the MACT

category are shown at the county – pollutant level. This form would 

allow you, for example, to find your county and view total emissions 

by pollutant from the MACT category. After viewing emissions at the 

county level, you might want to view all facilities in the county to 

determine where high (or low) emissions values for a given pollutant

are originating. To do this, proceed to the Facility MACT HAP

Emissions data level.

iii. Facility MACT HAP Emissions (View Facility, MACT, HAP, and 

Emissions Data Form) – Total emissions by pollutant are shown for 
12/10/2013 4

all processes at all facilities assigned to this MACT category. The 

column labeled “MACT Code” indicates if the HAP pollutant 

emissions are associated with the MACT category or another MACT 

category at the facility. For example, if the MACT code is labeled 

0107-2, the emissions are described as being associated with 

“Industrial/Commercial/ Institutional Boilers & Process Heaters –

gas.” These are shown to provide a complete dataset for the facility

and/or to help you spot additional processes which should be assigned 

to the MACT category.

After viewing emissions at the facility level, you might want to view all data 

associated with that facility to make sure that latitude/longitudes, stack 

parameters, Source Classification Codes (SCC), Standard Industrial Classification 

(SIC) codes, North American Industry Classification System (NAICS) codes, and 

other descriptive information are correct. To view this information, select the “All 

Data” button.

iv. All Data (View All Data Form) – Detailed records are shown for all 

facilities included in this MACT category. This detail includes process 

level HAP emissions, SCCs, stack parameters, latitude/longitudes and 

address information.

b. Filter Data – These buttons allow you to filter the current dataset by different 

attributes. The available filters change depending upon the detail level of the

displayed data (e.g., the county level filter is not available on the national level 

summary form, but is available at the State County MACT level). You can choose 

one filter after another to progressively narrow down the data to records of interest. 

For example, on the State County MACT Emissions level, you can filter by state and 

then by pollutant. The filters available on each data level are:
12/10/2013 5

National Data – Pollutant filter.

State County MACT Emissions – Pollutant, state, and county filters.

Facility MACT HAP Emissions – Facility, pollutant, state, county, and 

MACT code filters.

All Data – Facility, pollutant, state, county, and MACT code filters.

Filters can be removed by clicking the “Remove Filter” Button. Clicking “Remove 

Filter” removes all filters applied and returns the dataset to its original form.

After viewing emissions at the facility level, proceed to “Revise Data” on the “Main 

Page” if there any omissions or errors that need correction. 

3. Revise Data

When you select “Revise Data” the “Reviewer Information” form first opens. You must 

complete this form before continuing. This form collects contact information on the reviewer:

Name

Organization

Phone Number

Email Address

Please note: If you suggest changes to or add emissions values you will need to provide 

additional documentation for these emission revisions to the docket. (See Section 6 for more

information.)

The “Reviewer Information” form will appear every time you return to the revised data forms, 

however, your contact information will be saved in the drop down list and you can readily select 

your email address from the list. The “Facility Selection” form opens and allows the user to 

select a facility for revision. The name of the facility and address information are shown in the 

selection list as multiple facilities may have similar names. At this point, you can select one of 

five actions: “Revise Data for Selected Facility,” “Add a Facility,” “Add Data to an Existing 
12/10/2013 6

Facility,” “Export Facility Data to an Excel File,” or “Back to Main.” The “Add a Facility”

button is discussed in Section 4; the rest are described below.

Revise Data for Selected Facility – Selecting this button opens a form which allows you

to select the specific data attributes to be revised. These attributes are:

a. Revise Emissions Fields – Selecting this option brings up data fields relevant 

to the emissions value. Fields that can be revised here are: start date, end date, 

routine emissions (tons per year), and pollutant code. If an emissions value is 

changed, the start date, end date, control measure information, and emissions 

calculation method code must be updated as well. For EPA to better 

understand current control measures that are in operation, we are requesting 

that reviewers indicate the type of control measure associated with each unit. 

You can indicate if the process is controlled (check box for Yes), select a 

control measure from the drop down list, and provide additional information 

in the comment field. If the control measure information is not provided, the 

emission process will be considered uncontrolled. You can also indicate that 

the HAP emissions value should be deleted, and provide a reason for this 

deletion. Please note that you can only enter data into the revision fields. The 

remaining fields are locked. When you are finished making your changes, 

select “Save Records” at the bottom of the form to save your revisions and 

move to another form. 

Please note: If you suggest changes to or add emissions values, you will need 

to provide additional documentation for these emission revisions. (See Section 

6 for more information.)

b. Revise Stack Fields – Selecting this option brings up data fields relevant to 

the emissions release point. Fields that can be revised here are stack height, 

stack diameter, stack temperature, exit gas velocity, exit gas flow rate, the 

emission release point type (stack vs. fugitive), fugitive length, fugitive width, 
12/10/2013 7

fugitive angle, latitude and longitude, and North American Datum. You can 

also enter a general comment on the revision. Please note that you can only 

enter data into the revision fields. The remaining fields are locked. When you 

are finished making your changes, select “Save Records.”

c. Revise Process Fields – Selecting this option brings up data fields relevant to 

the process. Fields that can be revised here are MACT code and SCC. You

can also enter a general comment on the revision. You only enter data into the 

revision fields. The remaining fields are locked. When you are finished 

making your changes, select “Save Records.”

d. Revise Facility Information – Selecting this option brings up data fields that 

describe the facility. Fields that can be revised here are: tribal code, county 

name, facility registry identifier, facility category code (major source or 

area/synthetic minor source subject to the rule), facility name, location

address, city, state, and zip code. You can also enter a general comment on the 

revision, indicate that the facility should be removed from the NEI if it has 

permanently closed and when it closed, or indicate the facility should be 

removed from the MACT category. Please note that you can only enter data 

into the revision fields. The remaining fields are locked. When you are 

finished making your changes, select “Save Records.”

e. No Revisions – Select this button to indicate you have reviewed the facility 

data and have no revisions. You cannot select this button if you have made 

revisions to the facility. After you make this selection, you will not be able to 

make revisions to the facility data. 

Add Data to an Existing Facility – Selecting the “Add Data to an Existing Facility” 

button opens a form which shows all the current HAP emissions for the selected facility. 

You should scroll to the last row to enter any missing pollutant data. All data fields 
12/10/2013 8

should be filled in. You can select “RTR13,” 2013 Risk and Technology Review (RTR) 

data, as the source. When you are finished making your changes, select “Save Records.”

Export Facility Data to an Excel File – Selecting this option allows you to export the 

facility data to an Excel file if it facilitates your review of the original NEI facility and 

emissions data. After clicking this button, you will be asked to which local directory2you 

would like to save the file. If you select this option after making revisions, your revised 

records will be included. 

Other Options – You also have the option of selecting a different facility, returning to the 

Main Page, reviewing your changes, or preparing the file to submit your changes to EPA.

4. Add a Facility 

When you select “Add a Facility” on the “Revise Data” form button a new form opens with a 

single blank record. You can add a facility to this MACT category and enter the HAP emissions 

and associated descriptive facility and emission release point information. This information 

includes: tribal code; county name; facility category code (major or area); facility name; location 

address city, state, and zip code; SIC code; NAICS code; SCC; MACT code; pollutant;

emissions values; stack parameters; and latitude/longitude. You may also enter appropriate 

identifiers: facility registry identifier, unit ID, process ID, and emission release point ID. 

Required fields are noted. If you add emissions for a process that is not associated with the 

MACT category, please select the appropriate MACT code (from the drop down list) or indicate 

that it is not a MACT-associated process. When you are finished making your changes, select 

“Save Records.” To create additional emission unit, process, and HAP emissions records, now 

select “Add Data to an Existing Facility” and continue with your data entry.

5. Review Revisions

When you open the “Review Revisions” form, you can export your suggested revisions to 

Microsoft Excel so that you can print and review them. This form contains five buttons:

 

2

 Please note: this directory should already exist on your PC. The program will not create new subdirectories.
12/10/2013 9

1. View Emissions Revisions;

2. View Facility Revisions;

3. Export Revisions to Excel File; 

4. Submit Revisions; and 

5. Back to Main

After selecting options 1 or 2, the corresponding form will open which will display the selected 

revisions. The Emissions Revisions form contains all additions and revisions entered under the 

Revise Emissions Fields, Revise Process Fields, and Revise Stack Fields forms as described 

above. The Facility Revisions form contains all additions and revisions entered under “Revise 

Facility Information” form. You can export these revisions by clicking the “Export Revisions to 

Excel file” button. After clicking this button, you will be asked to which local directory3you 

would like to save the file. The selected revisions will then be exported to a Microsoft Excel 

spreadsheet. 

You should print out these spreadsheets, review them, and make corrections as necessary. To 

make corrections, return to the appropriate revision form (as described under Revise Data). Any 

previously revised data will appear in the revise data forms.

6. Submit Revisions

Upon completion of all additions and corrections, or acceptance of the data with no revisions,

you need to submit your corrections to EPA. First, create a new file containing just the changes. 

To do so, select the “Submit Revisions” button found on the “Main Page” and on the revision 

and review summary data forms. Clicking the “Create Revisions File” button will create a 

spreadsheet file that contains the reviewer’s changes. The file will be assigned a name using the 

following convention: revisions_XXXX_LastName.xls, where XXXX = 4 digit MACT code and 

LastName = reviewer’s last name. You will be prompted to save the new file to a local directory 

of your choice. In addition to submitting the spreadsheet file to the docket, if you corrected or 

added emissions values, you should prepare supporting documentation. This can include source 

test reports, permit information and/or computational information such as emission factors and 

 

3

 Please note: this directory should already exist on your PC. The program will not create new subdirectories.
12/10/2013 10

activity data (throughput). The spreadsheet and supporting documentation must be submitted 

manually to one of the addresses listed in the next paragraph.

Submit your revision database, identified by Docket ID No. EPA-HQ-OAR-2012-0133, by one 

of the following methods:

http://www.regulations.gov: Follow the on-line instructions for submitting 

comments. 

E-mail: a-and-r-docket@epamail.epa.gov. Attention Docket ID No. EPA-HQOAR-2012-0133.

Mail: U.S. Postal Service, send comments to: EPA Docket Center, EPA West (Air 

Docket) Attention Docket ID No. EPA-HQ-OAR-2012-0133, U.S. Environmental 

Protection Agency, Mailcode 2822T, 1200 Pennsylvania Avenue, NW, Washington, 

DC 20460. Please include a total of two copies.

Hand Delivery: U.S. Environmental Protection Agency, EPA West (Air Docket), 

Room 3334, 1301 Constitution Ave., NW, Washington, DC 20004. Attention Docket 

ID No. EPA-HQ-OAR-2012-0133. Such deliveries are only accepted during the 

Docket’s normal hours of operation, and special arrangements should be made for 

deliveries of boxed information.

Instructions: Direct your comments to Docket ID No. EPA-HQ-OAR-2012-0133. The EPA’s 

policy is that all comments received will be included in the public docket without change and 

may be made available online at http://www.regulations.gov, including any personal information 

provided, unless the comment includes information claimed to be confidential business 

information (CBI) or other information whose disclosure is restricted by statute. Do not submit 

information that you consider to be CBI or otherwise protected through www.regulations.gov or 

e-mail. The www.regulations.gov website is an “anonymous access” system, which means EPA 

will not know your identity or contact information unless you provide it in the body of your 

comment.

If you send an e-mail comment directly to EPA without going through www.regulations.gov, 

your e-mail address will be automatically captured and included as part of the comment that is 
12/10/2013 11

placed in the public docket and made available on the Internet. If you submit an electronic 

comment, EPA recommends that you include your name and other contact information in the 

body of your comment and with any disk or CD-ROM you submit. If EPA cannot read your 

comment due to technical difficulties and cannot contact you for clarification, EPA may not be 

able to consider your comment. Electronic files should avoid the use of special characters, any 

form of encryption, and be free of any defects or viruses.

For additional information about EPA’s public docket visit the EPA Docket Center homepage at 

http://www.epa.gov/epahome/dockets.htm. All documents in the docket are listed in the Federal 

Docket Management System index at www.regulations.gov. Although listed in the index, some 

information is not publicly available, i.e., CBI or other information whose disclosure is restricted 

by statute. Certain other material, such as copyrighted material, is not placed on the Internet and 

will be publicly available only in hard copy form. Publicly available docket materials are 

available either electronically through www.regulations.gov or in hard copy at the Air and 

Radiation Docket, EPA/DC, EPA West Building, Room B-102, 1301 Constitution Avenue, NW, 

Washington, DC. The Public Reading Room is open from 8:30 a.m. to 4:30 p.m., Monday 

through Friday, excluding legal holidays. The telephone number for the Public Reading Room is 

(202) 566-1744, and the telephone number for the Air and Radiation Docket is (202) 566-1742.

7. Term Definitions

The table below lists and defines all of the data elements listed in the summary and revision 

forms found in the database.

Data Element Definition

City City where the MACT facility is located

Commenter Email Address Email address for person providing comments

Commenter General Comment A general descriptive comment on the revision

Commenter Name Name of person providing comments

Commenter Organization

Commenter's affiliation - state/local/agency, trade 

association, company, etc.

Commenter Phone Number Phone number for person providing comments

Control Measure In Place Are control measures in place? (Yes or No)

Control Measure 

Select control measure from list provided, and briefly 

describe the control measure 

County Name County name for MACT facility

Data Source Description Descriptive text associated with data source code
12/10/2013 12

Data Element Definition

Data Source Code

Code indicating source of emissions estimate (state, 

EPA, TRI, etc.)

Delete Indicate here if the facility or record should be deleted

Delete Comment Describes the reason for deletion

Emission Calculation Method Code For 

Revised Emissions

Code description of the method used to derive

emissions. For example, CEM, material balance, stack 

test, etc.

Emission Release Point ID

State/local/tribal ID for point/location where emissions 

are released to ambient air

Emission Release Point Type

The code for physical configuration of the release 

point, i.e. vertical, fugitive, etc.

Emission Release Point Type Description Descriptive text for Emission Release Point Type code

Emission Type

Code describing temporal designation of emissions 

reported, i.e., entire period, average weekday, etc.

Emission Unit ID

Unique ID reported consistently over time by 

state/local/tribal agency

Emissions (TPY) Numeric value of emissions in tons/year

End Date

End date of the period in which reported emissions 

occur, e.g., 20111231 = December 31, 2011

EPA Region EPA Regional Code

Exit Gas Flow Rate

Numeric value of stack gas flow rate in actual cubic 

feet per second

Exit Gas Temperature

The temperature of an exit gas stream (degree 

Fahrenheit)

Exit Gas Velocity The velocity of an exit gas stream (feet per second)

Facility Category Desc Definition associated with Facility Category Code

Facility Category

Code indicating if HAP emitting facility is major or 

area

Facility Name The name of the facility of the MACT facility

Facility Registry Identifier

The ID number assigned by the EPA Facility Registry 

System

FIPS 5 digit code assigned to state and county

Fugitive Width (N-S) (ft)

Dimension of the source in the north-south (y-) 

direction, commonly referred to as width

Fugitive Angle (degrees)

Release angle (clockwise from true North); orientation 

of the y-dimension relative to true North, measured 

positive for clockwise starting at 0 degrees (maximum 

89 degrees); will assume 0 degrees if it is not provided 

in data submittal

Fugitive Length (E-W) (ft)

Dimension of the source in the east-west (x-) direction, 

commonly referred to as length

HAP Category Name

Broader grouping to which an individual chemical 

compound is assigned to by EPA. For example, “lead 

and compounds” contains all pollutants containing 

lead.
12/10/2013 13

Data Element Definition

Latitude (decimal degrees)

Latitude measure in decimal degrees of the angular 

distance on a meridian north or south of the equator. 

Positive (+) data point for N America. Include (+) 

sign, Ex. +78.123456. For point sources this represents 

the center of the source; for fugitive sources this is the 

southwest corner if the fugitive angle is zero, or the 

western most corner if the fugitive angle is greater 

than zero.

Location Address Physical street address for MACT facility

Location Default Flag

Code that indicates source of locational coordinates. 

For example, SITEAVG indicates site average.

Longitude (decimal degrees)

Longitude measure in decimal degrees of the angular 

distance on a meridian east or west of the prime 

meridian. Negative (-) data point for N America. 

Include (-) sign, Ex. -123.234561. For point sources 

this represents the center of the source; for fugitive 

sources this is the southwest corner if the fugitive 

angle is zero, or the western most corner if the fugitive 

angle is greater than zero.

MACT Code

Code assigned to Maximum Achievable Control 

Technology regulated sources. Identifies one or more 

similar processes that cause hazardous air pollutant 

emissions that are subject to a MACT determination.

MACT Source Category Descriptive text associated with MACT code.

MACT Flag

Describes how MACT Code was assigned. Codes are 

as follows:

- EFIG-BASED – MACT Code assigned by U.S. EPA 

Emission Factor and Inventory Group (emissions data 

provided by various sources);

- SPPD-BASED – MACT Code assigned by U.S. EPA 

Sector Policies and Programs Division (SPPD) 

(emissions data usually provided by SPPD);

- FACILLIST-* – MACT code assigned to facilities

listed on MACT category lists compiled by EPA 

(emissions data provided by various sources);

- INDUSTRY-BASED – MACT Code assigned by 

industry.

- NAICS-DEFAULT – MACT Code assigned based 

on NAICS code;

- SCC-DEFAULT – MACT Code assigned based on 

SCC;

- SIC-DEFAULT – MACT Code assigned based on 

SIC code;

- STATE-BASED – MACT Code assigned by state 

agency.

NAICS Code

North American Industry Classification Code. An 

industry classification system, NAICS is erected on a 

production-oriented conceptual framework that groups 

establishments into industries according to similarity 

in the process used to produce goods or services.

NEI Site ID Unique identifier assigned by EPA to NEI Facility

North American Datum

North American Datum (NAD) for longitude and 

latitude coordinates (NAD27 or NAD83). If left blank 

NAD83 is assumed.
12/10/2013 14

Data Element Definition

Pollutant_Code_Desc Descriptive text associated with pollutant code

Pollutant Code Code assigned by EPA to individual pollutants

Process ID

Unique ID reported consistently over time by 

state/local/ tribal agency

REVISED City Enter revised city name here

REVISED County Name Enter revised county name here

REVISED Emission Release Point Type Enter revised Emission Release Point Type here

REVISED Emissions (TPY) Enter revised emissions value here

REVISED End Date Enter revised End Date here

REVISED Exit Gas Flow Rate (cuft/sec) Enter revised Exit Gas Flowrate here

REVISED Exit Gas Temperature (F) Enter revised Exit Gas Temperature here

REVISED Exit Gas Velocity (ft/sec) Enter revised Exit Gas Velocity here

REVISED Facility Category Code Enter revised Facility Category Code here

REVISED Facility Name Enter revised Facility Name here

REVISED Facility Registry Identifier Enter revised Facility Registry Identifier here

REVISED Latitude (decimal degrees) Enter revised Latitude here

REVISED Location Address Enter revised Location Address here

REVISED Longitude (decimal degrees) Enter revised Longitude here

REVISED MACT Code Enter revised MACT Code here

REVISED Pollutant Code Enter revised Pollutant Code here

REVISED SCC Enter revised SCC Code here

REVISED Stack Diameter (ft) Enter revised Stack Diameter here

REVISED Stack Height (ft) Enter revised Stack Height here

REVISED Start Date Enter revised Start Date here

REVISED State Enter revised State here

REVISED Tribal Code Enter revised Tribal Code here

REVISED Zip Code Enter revised Zip Code here

SCC Source Classification Code

SCC Description Descriptive text associated with SCC code

SIC Code

Standard Industrial Classification code. The Standard 

Industrial Classification (abbreviated 'SIC') was a 

United States government system for classifying 

industries by a four-digit code. Established in the 

1930s, it is being supplanted by the six-digit NAICS.

SIC Code Description Descriptive text associated with SIC code

Stack Default Flag

The stack default code is a 5-digit code that indicates 

if and how the stack parameters were defaulted. Each 

digit represents a stack parameter in the following 

order: stack height, exit gas temperature, stack 

diameter, exit gas velocity, and exit gas flowrate. The 

individual digits in the string indicate the source of the 

defaulted parameters: 0= Original Value, 1 = SCC 

Default, 2 = SIC Default, 3 = National Default, 4 = 

Calculated Value, 5 = MACT Default, 6 = State 

Revision, 8 = CAMD Value. Thus, 22222 means all 5 

parameters were defaulted using SIC Default List. 

Stack Default Flag Description Descriptive text associated with Stack Default Flag

Stack Diameter The diameter (in feet) of a stack

Stack Height The height (in feet) of a stack
12/10/2013 15

Data Element Definition

Start Date

Start date of the period in which reported emissions 

occur, e.g., 20050101 = January 1, 2005

State State where MACT facility is located

State Abbreviation Two-character alphabetical code for state

State County FIPs 5 digit code assigned to state and county 

State Facility Identifier

Unique ID number used by a state/local/tribal agency 

to identify a facility

Tribal Code

Code that represent American Indian tribes and 

Alaskan Native entities 

Tribe Name Tribal name

Year Closed

Indicate the year closed if the facility is no longer in 

operation (permanently closed)

Zip Code Zip Code for the MACT facility