MEMORANDUM

TO:    Brian Shrager/SPPD

FROM:   Eastern Research Group, Inc.

DATE:    November 2011

SUBJECT: Revised (November 2011) Data Dictionary for Boiler, Process Heater, and Other

Combustion Unit Survey Databases

1.0 INTRODUCTION

This memorandum discusses the changes since the promulgation of the March, 2011

final rule (76 FR 15608) in the structure of the databases containing responses from boilers and

indirect‐fired process heaters at major and area sources of hazardous air pollutant (HAP)

emissions.  A discussion of the structures of the databases used for the development of the

promulgated rule is provided in the memorandum, “Revised Data Dictionary for Boiler, Process

Heater, and Other Combustion Unit Survey Databases” in the docket.1 This memorandum only

discusses the changes in database structure, and incorporates the docketed memorandum

from the promulgated rule by reference.

This memorandum is divided into the following sections:

1.0 Introduction

2.0 Summary of Changes to Database Structure

3.0 References

Appendix A: Updated Field Mapping for Survey Results Database

Appendix B: Updated Field Mapping for Emissions Database
2.0 SUMMARY OF CHANGES TO DATABASE STRUCTURE

The structure of several database tables described in the docketed memorandum,

“Revised Data Dictionary for Boiler, Process Heater, and Other Combustion Unit Survey

Databases” have changed since the promulgation of the March, 2011 rule.1 An updated

mapping of the individual fields in each database table is provided in Appendices A and B.  

Appendix A contains field mapping for the updated version of the Survey Database Containing

Results of the 2008 Questionnaire for Boilers, Process Heaters, and Other Combustion Units.2

Appendix B contains field mapping for the updated version of the Emissions Database for

Boilers and Process Heaters Containing Stack Test, CEM, and Fuel Analysis Data.3 As specified in

the docketed memorandum, inventory and lookup tables are not included in the field mappings

in Appendices A and B since the procedures used in their development are described in other

memoranda.

One additional database table was created to hold emissions data for the sum of eight

selected metallic HAP (TSM8).  For a given source and test, TSM8 emissions are equivalent to

the sum of the emissions of arsenic (As), beryllium (Be), cadmium (Cd), chromium (Cr), lead

(Pb), manganese (Mn), nickel (Ni), and selenium (Se).  Since the proposed reconsideration of

the Major Source Industrial, Commercial, and Institutional Boiler and Process Heater NESHAP

contains regulatory provisions for TSM8, a separate database table was created containing

TSM8 emissions data.  The table is named, “Data:  TSM8” and a mapping of the fields in this

table is provided in Appendix B‐13.
3.0 REFERENCES

1. McClutchey, S., and G. Gibson, ERG.  Revised Data Dictionary for Boiler, Process Heater,

and Other Combustion Unit Survey Databases.  January 2011.

2. Survey Database containing Results of the 2008 Questionnaire for Boilers, Process

Heaters, & Other Combustion Units (ICR No. 2286.01) (Version 3).

3. Emissions Database for Boilers and Process Heaters Containing Stack Test, CEM, & Fuel

Analysis Data Reported under ICR No. 2286.01  & ICR No. 2286.03 (Version 7).
APPENDIX A

Updated Field Mapping for Survey Results Database

(See Excel Spreadsheet)
APPENDIX B

Updated Field Mapping for Emissions Database

(See Excel Spreadsheet)