Appendix A-1: Field Mapping for the Area Source Data: CEMS Backgrnd Database Table

Field Name

Does Field Represent 

Reported or 

Standardized Data?

Description

FacilityID Standardized This identifier relates each record to a unique facility using a two-letter state abbreviation and abbreviated facility name.

CombustorID Standardized

This contains a unique identifier assigned to each combustion unit. For units with an identifier representing multiple 

combustion units a note is provided in the IDNote field

Source Reported This field identifies the source of the data as CEMS or SmallGasCEMS.

Pollutant Reported This field identifies the pollutant being monitored as CO, NOx, SO2, Opacity, or PM.

TypControl Reported This field contains the Control Device Configuration for 30-day CEMS period (drop-down menu provided)

Standardized TypControl Standardized This is a field which standardizes the terms used for pollution control devices.

TypOpRate Reported This field contains the typical operating rate during the 30-day CEMS period (MMBtu/hr)

UpsetsDuringTypOperations Reported This field gives space for a description of any operational upsets during 30-day CEMS period.

TypFuel Reported This field gives the typical fuel mix utilized during 30-day CEMS period.

Common Fuel Standardized This field shows the standardized fuel type for TypFuel.

TypFuelRate Reported This field contains the typical fuel rate during the CEMS period.

TypFuelRateUnits Reported This field gives the units for typical fuel rate.

Standardized FuelRate Standardized This field shows the standardized rate for TypFuelRate.

Standardized FuelRateUnits Standardized This field shows the standardized rate units for TypFuelRateUnits.

FuelRate Conversion Eq Used Standardized This field shows the ID of the conversion equation used to standardize the TypFuelRate.

MaxFuel Reported This field gives the fuel Maximum 6-minute average.

Common MaxFuel Standardized This field shows the standardized fuel type for MaxFuel.

MaxFuelRate Reported This field gives the fuel rate at Maximum 6-minute average.

MaxFuelRateUnits Reported This field gives the units for the fuel rate at Maximum 6-minute average.

UpsetsDuringMaxOperations Reported This field gives space for a description of any operational upsets during maximum 6-minute period.

MaxControl Reported This field gives the control device configuration used during the maximum 6-minute average.

MaxOpRate Reported This field provides the operating rate during the maximum 6-minute average.

Original CombustorID Reported This is a QA field showing the original Unit ID.

Note Standardized This field provides space for additional information.

A-1 Page 1
Appendix A-2: Field Mapping for the Area Source Data: EmissionsTest Background Info Database Table

Field Name

Does Field Represent 

Reported or 

Standardized Data?

Description

FacilityID Standardized This identifier relates each record to a unique facility using a two-letter state abbreviation and abbreviated facility name.

CombustorID_common Standardized

This contains a unique identifier assigned to each combustion unit. For units with an identifier representing multiple 

combustion units a note is provided in the IDNote field

ControlDevice Reported This identifier lists any add-on Pollution Control Device.

Standardized ControlDevice Standardized This is a field which standardizes the terms used for pollution control devices.

TestID Reported This field contains an identifying sample number for tracking emission test results.

TestDate_common Reported This field shows the date of the emission test.

Steam Reported This field reports the steam output rate from the combustion unit at the time of the emission test.

SteamUnit Reported This field gives the steam output rate unit.

SteamUnitOther Reported

This field provides space for steam output rate alternative unit information. Should correspond to an "Other" response in the 

"Steam Unit" field.

Standardized Steam Standardized This field converts steam output to standard units.

Standardized Steam Unit Standardized This field shows the standardized steam output unit (1000 lb/hr)

SteamLocation Reported This field indicates if testing was done either upstream or downstream of control device.

SteamNote Reported This field provides space for additional information on steam output.

THI_Value Reported This value gives the total heat input.

THI_Unit Reported This field reports the unit for the total heat input.

Standardized THI_Value Standardized This field converts total heat input to standard units.

Standardized THI_Unit Standardized This field shows the standardized THI unit. (mmBtu/hr)

THI_UnitOther Reported

This field provides space for total heat input alternative unit information. Should correspond to an "Other" response n the 

"THI_Unit"

THI_Location Reported This field Indicates if testing is done upstream or downstream or control device.

THI_Note Reported This field provides space for additional total heat input information.

DryOrWet Reported This field indicates the basis on which testing is measured, wet or dry.

DryOrWetNote Reported This field provides space for additional basis information.

CO2_Value Reported This field gives the CO2 emission value for the Test ID.

CO2_Unit Reported This field provides the unit related to the CO2 pollutant value.

CO2_Method Reported This field idicates the CO2 Test Method used to determine the CO2 value.

CO2_Location Reported This field indicates if CO2 sample taken before or after control device.

CO2_Note Reported This field provides space for additional CO2 emission information

O2_Value Reported This field gives the O2 emission value for the Test ID.

Standardized O2_Value Standardized This field is a field converting O2 emissions to a numeric value with standard units.

O2_Unit Reported This field provides the unit related to the O2 emission value.

O2_Method Reported This field indicates the O2 Test Method used to determine the O2 value.

O2_Location Reported This field indicates if the O2 sample was taken before or after control device.

O2_Note Reported This field provides space for additional O2 Information.

Moisture Reported This field gives the percent of moisture in the exhaust.

A-2 Page 1
Appendix A-2: Field Mapping for the Area Source Data: EmissionsTest Background Info Database Table

Field Name

Does Field Represent 

Reported or 

Standardized Data?

Description

Standardized_Moisture Standardized This field converts the moisture value to standardized units of percent.

MoistureNote Reported This field provides space for additional moisture information.

ExhaustFlow Reported This field gives the exhaust flow rate.

Standardized_ExhaustFlow Standardized This field converts the exhaust flowrate to a standard unit.

ExhaustFlowUnit Reported This field gives the original exhaust flowrate units.

ExhaustFlowNote Reported This field provides space for additional exhaust flowrate information.

ExhaustTemp Reported This field gives the exhaust temperature.

Standardized_ExhaustTemp Standardized This field converts the exhaust temperature to a standard unit.

Standardized_ExhaustTempUnit Standardized This field shows the standardized exhaust temp unit (F).

ExhaustTempUnit Reported This field provides the original unit for Exhaust Temperature

ExhaustTempNote Reported This field provides space for additional exhaust temperature information.

SourceTab Reported

This field identifies the EmissionTestSprdsheet tab of the 2008 Combustion Survey Emission Test in which the data 

originated.

Original CombustorID_common Reported This is a QA field showing the original Unit ID.

Note Standardized This field provides space for additional information.

A-2 Page 2
Appendix A-3: Field Mapping for the Area Source Data: EmissionsTest Fuel Data Database Table

Field Name

Does Field Represent 

Reported or 

Standardized Data?

Description

FacilityID Standardized This identifier relates each record to a unique facility using a two-letter state abbreviation and abbreviated facility name.

CombustorID_common Standardized

This contains a unique identifier assigned to each combustion unit. For units with an identifier representing multiple 

combustion units a note is provided in the IDNote field

TestID Reported This field contains an identifying sample number for tracking emission test results.

TestDate_common Reported This field shows the date of the emission test.

FuelParameter_Type Reported This field identifies the parameter type being recorded.

Common Fuel Standardized This field shows the standardized fuel name.

FuelParameter_TypeOther Reported This field identifies the other parameter type.

FuelParameter_Value Reported This field gives the numerical value of the parameter type being detailed.

FuelParameter_Unit Reported This field provides the unit for the parameter value chosen from menu.

Standardized Fuel Rate Standardized This field shows the fuel rate converted to standard units.

Standardized Fuel Rate Units Standardized This field shows the standard fuel rate units. (Mbtu/hr)

FuelParameter_UnitOther Reported

This field provides alternative parameter value unit information. Should correspond to an "Other" response in the 

"FuelParameter_Unit" field.

FuelParameter_Method Reported This field provides the method used to determine the parameter value.

FuelParameter_Note Reported The field provides space for additional parameter information.

SourceTab Reported

This field identifies the EmissionTestSprdsheet tab of the 2008 Combustion Survey Emission Test in which the data 

originated.

Original CombustorID_common Reported This is a QA field showing the original Unit ID.

Note Standardized This field provides space for additional information.

A-3 Page 1
Appendix A-4: Field Mapping for the Data: Control Device Database Table

Field Name

Does Field Represent 

Reported or 

Standardized Data?

Description

FacilityID Standardized This identifier relates each record to a unique facility using a two-letter state abbreviation and abbreviated facility name.

UnitID Standardized

This contains a unique identifier assigned to each combustion unit. For units with an identifier representing multiple 

combustion units a note is provided in the IDNote field

ControlDevice Reported This field indicates the presense of an add-on pollution control device.

Standardized ControlDevice Standardized This is a field which standardizes the terms used for pollution control devices.

YearInstalled Reported This field gives the installation year of control device.

Upgrade Reported This field indicates if the control device has been upgraded. (Yes=True/No=False)

UpgradeCompliance Reported This field indicates if the control device was upgraded to comply with 40 CFR 63 Subpart DDDDD. (Yes=True/No=False) 

RemovedAdded Reported If the control device was upgraded, this field indicates if the original was removed or upgraded (Yes=True/No=False)

PriorDevice Reported If upgraded, this field identifies the prior device. (drop-down menu provided) 

Standardized PriorDevice Standardized This is a field which standardizes the terms used for the pollution control devices used prior to current controls.

upgradedate_currentdevice Reported This field gives the date of upgrade to current device.

upgradedate_piordevice Reported This field gives the date of original device installation (mm/yyyy).

CommonControl Reported This field indicates if the control device is used for multiple combustion units? (Yes=True)

CommonControlUnits Reported This field gives the control units utilizing the control device, if yes is answered in the CommonControl field.

CPMS_None Reported This field indicates if there is No Continuous Parameter Monitoring System (CPMS).

CPMS_PressureDrop Reported This field gives the CPMS measures pressure drop.

CPMS_FlowRate Reported This field gives the CPMS measures flowrate.

CPMS_Voltage Reported This field gives the CPMS Voltage measurement.

CPMS_Other Reported This field indicates if there is another CPMS parameter being measured.

CPMS_OtherExp Reported This field allows space to explain the CPMS parameter referred to in the CPMS_Other field.

Original UnitID Reported This is a QA field showing the original Unit ID.

Note Standardized This field provides space for additional information.

A-4 Page 1
Appendix A-5: Field Mapping for the Data: Emissions Test And CEMS Installed Database Table

Field Name

Does Field Represent 

Reported or 

Standardized Data?

Description

FacilityID Standardized This identifier relates each record to a unique facility using a two-letter state abbreviation and abbreviated facility name.

UnitID Standardized

This contains a unique identifier assigned to each combustion unit. For units with an identifier representing multiple 

combustion units a note is provided in the IDNote field

StartupFuel Reported This field shows the fuel used to start the unit.

Fuel Reported Shows the main fuel burned in the combustion unit.

EmissionTest Reported This field indicates the availability of an emission test. (Yes=True/No=False)

EmissionTestLoc Reported This field indications the location where available emission test occurred.

SO2_Test Reported This field indicates the presense of an SO2 CEM. (Yes=True/No=False)

SO2_Monitor Reported This field indicates whether or not SO2 is monitored for Regulatory Purposes. (Yes=True/No=False)

SO2_Record Reported This field indicates if the SO2 CEMS is recorded. (Yes=True/No=False)

SO2_Save Reported This field indicates if the SO2 CEMS data are saved (Yes=True/No=False)

NOx_Test Reported This field indicates if there is a NOx CEM installed. (Yes=True/No=False)

NOx_Monitor Reported This field indicates if NOx is monitored for Regulatory Purposes (Yes=True/No=False)

NOx_Record Reported This field indicates if the NOx CEMS data are recorded. (Yes=True/No=False)

NOx_Save Reported This field indicates if the NOx CEMS data are saved. (Yes=True/No=False)

CO_Test Reported This field indicates the presense of an CO CEM. (Yes=True/No=False)

CO_Monitor Reported This field indicates if CO is monitored for Regulatory Purposes. (Yes=True/No=False)

CO_Record Reported This field indicates if the CO CEMS data are recorded? (Yes=True/No=False)

CO_Save Reported This field indicates if the CO CEMS data are saved? (Yes=True/No=False)

O2_Test Reported This field indicates the presense of an O2 CEM installed? (Yes=True/No=False)

O2_Monitor Reported This field indicates if the O2 is monitored for Regulatory Purposes (Yes=True/No=False)

O2_Record Reported This field indicates if O2 CEMS data are recorded? (Yes=True/No=False)

O2_Save Reported This field indicates that O2 CEMS data are saved? (Yes=True/No=False)

PM_Test Reported This field indicates the presense of PM CEM. (Yes=True/No=False) 

PM_Monitor Reported This field indicates if PM is monitored for regulatory purposes. (Yes=True/No=False)

PM_Record Reported This field indicates if PM CEMS data are recorded? (Yes=True/No=False)

PM_Save Reported This field indicates if PM CEMS data are saved? (Yes=True/No=False) 

VOC_Test Reported This field indicates the presense of a VOC CEM? (Yes=True/No=False)

VOC_Monitor Reported This field states if VOC is monitored for regulatory purposes. (Yes=True/No=False) 

VOC_Record Reported This field indicates if the VOC CEMS data are recorded? (Yes=True/No=False) 

VOC_Save Reported This field indicates if the VOC CEMS data are saved? (Yes=True/No=False)

Original UnitID Reported This is a QA field showing the original Unit ID.

Note Standardized This field provides space for additional information.

A-5 Page 1
Appendix A-6: Field Mapping for the Data: Facility Database Table

Field Name

Does Field Represent 

Reported or 

Standardized Data?

Description

FacilityID Standardized This identifier relates each record to a unique facility using a two-letter state abbreviation and abbreviated facility name.

Facility Name Reported This field gives the name of the facility responding to the survey.

2a_Phys_Address Reported This field gives the facility's physical street address.

2b_Phys_City Reported This field gives the facility's physical city.

2c_Phys_State Reported This field gives the facility's physical state.

2d_Phys_Zip Reported This field gives the facility's physical zip code.

2e_Phys_County Reported This field gives the facility's physical county.

3a_ContactName Reported This field provides the first and last name of facility contact

3b_ContactTitle Reported This field provides the professional title of contact person.

3c_Telephone Reported This field provides the contact person phone number with extension.

3d_Fax Reported This field lists the fax number for the contact person.

3e_E-mail Reported This field gives the e-mail address for contact person.

4_FacilityLegalName Reported

This field contains the legal name of the facility, if different form the name given in the "Facility Name" field. If the field is left 

null, it is updated to Facility ID.

5_AffectedSector Reported This field indicates if the affected sector is public, private, or not-for-profit.

6_MajororArea Reported This field indicates if the facility is major source of HAPs. (True=Major/False=Area)

7a1_NumberCompanyEmployees Reported

This field provides the number of employees in the company. This field only needs to be answered if the affected sector is 

private.

7a2_NumberFacilityEmployees Reported

This field provides the number of employees at the facility. This field only needs to be answered if the affected sector is 

private.

7b1_Population Reported This field gives the population of local public entity. This field only needs to be answered if the affected sector is public.

8_Small Entity Reported This field answers the question "Is this facility a small entity?" with Yes, No, or Unknown.

9_NAICS Reported This field gives the 3-digit NAICS.

A-6 Page 1
Appendix A-7: Field Mapping for the Data: FuelAnalysis Background Information Database Table

Field Name

Does Field Represent 

Reported or 

Standardized Data?

Description

FacilityID Standardized This identifier relates each record to a unique facility using a two-letter state abbreviation and abbreviated facility name.

Fuel_Material Reported This field lists the fuel or material for which analysis is included.

Common Fuel Standardized This field shows the standardized fuel name.

FM_originate Reported This field indicates the origin of fuel or material as either on-site or off-site.

FM_analysisavailable Reported This field indicates the availability of fuel analysis. (True=available)

A-7 Page 1
Appendix A-8: Field Mapping for the Data: GCP and CombustionControls Database Table

Field Name

Does Field Represent 

Reported or 

Standardized Data?

Description

FacilityID Standardized This identifier relates each record to a unique facility using a two-letter state abbreviation and abbreviated facility name.

UnitID Standardized

This contains a unique identifier assigned to each combustion unit. For units with an identifier representing multiple 

combustion units a note is provided in the IDNote field

AirTrimControl Reported This field describes the Air Trim Control - Oxygen, Carbon Monoxide, Neither or Unknown

UnitNumber Reported This field gives the number of units associated with the UnitID.

ScheduledTuneUp Reported This field reports if tune ups are scheduled. (True=Yes/False=No)

ScheduledTuneUp_freq Reported This field reports the frequency of tune-ups.

FuelSystemInspectClean Reported This field reports if the fuel system is subject to inspection/cleaning. (True=Yes/False=No)

FuelSystemInspectClean_freq Reported This field reports the frequency of Fuel System Inspection/Cleaning.

SurfaceInspectCleanRecondition Reported This field reports if surface inspection/cleaning/reconditioning is done. (True=Yes/False=No)

SurfaceInspectCleanRecondition_fr

eq Reported This field reports the frequency of Surface Inspection/Cleaning/Reconditioning.

CkElectricalandCombCtrl Reported This field reports if electrical and combustion control checks are done. (True=Yes/False=No)

CkElectricalandCombCtrl_freq Reported This field reports the frequency of Electrical and Combustion Control Checks.

TestExhaustGases Reported This field reports if there is testing of exhaust gases. (True=Yes/False=No)

TestExhaustGases_freq Reported This field reports the frequency of Exhaust Gas Testing.

COlevelAdjustment Reported This field reports if CO levels are adjusted. (True=Yes/False=No)

ValveInspection Reported This field reports if valves are inspected. (True=Yes/False=No)

ValveInspection_freq Reported This field reports the frequency of Valve Inspections.

RefractoryInspection Reported This field reports if refractory inspections are performed. (True=Yes/False=No)

RefractoryInspection_freq Reported This field reports the frequency of Refractory Inspection.

FanCleanInspect Reported This field reports fan cleaning/inspection. (True=Yes/False=No)

FanCleanInspect_freq Reported This field reports the frequency of Fan Cleaning/Inspection.

FeedWaterInspect Reported This field reports the inspection of feed water. (True=Yes/False=No)

FeedWaterInspect_freq Reported This field reports the frequency of Feed Water Inspection.

GCP_OpTrainRecord Reported This field reports if a Good Combustion Practices Operation Training Record is kept. (True=Yes/False=No)

GCP_OpTrainRecord_freq Reported This field reports the frequency of Good Combustion Practices Operation Training Recordkeeping.

GCP_MaintenanceKnowledge Reported This field reports the use of Good Combustion Practices Maintenance Knowledge. (True=Yes/False=No)

GCP_MaintenanceKnowledge_freq Reported This field reports the frequency of utilizing GCP Maintenance Knowledge.

GCP_MaintenancePractices Reported This field reports the us of Good Combustion Practices Maintenance Practices. (True=Yes/False=No)

GCP_MaintenancePractices_freq Reported This field reports the frequency with which GCP Maintenance Practices are used.

GCP_FuelAirRatio Reported This field reports the use of Good Combustion Practices Fuel/Air Ratios. (True=Yes/False=No)

GCP_FuelAirRatio_freq Reported This field reports the frequency with which GCP Fuel/Air Ratio is checked.

A-8 Page 1
Appendix A-8: Field Mapping for the Data: GCP and CombustionControls Database Table

Field Name

Does Field Represent 

Reported or 

Standardized Data?

Description

GCP_AutoO2andCOtrimcontrols Reported This field reports the use of Good Combustion Practices Auto O2 and CO trim controls. (True=Yes/False=No)

GCP_FurnaceResTimeandTemp Reported This field reports the use of Good Combustion Practices Furnace Residence Time and Temperature. (True=Yes/False=No)

GCP_FurnaceResTimeandTemp_fre

q Reported This field reports the frequency with which GCP Furnace Residence Time and Temperature are checked.

GCP_FuelQualandHandling Reported This field reports the use of Good Combustion Practices Fuel Quality and Handling. (True=Yes/False=No)

GCP_FuelQualandHandling_freq Reported This field reports the frequency of using GCP Fuel Quality and Handling procedures.

GCP_LiquidAtomization Reported This field reports the use of Good Combustion Practices Proper Liquid Atomization. (True=Yes/False=No)

GCP_LiquidAtomization_freq Reported This field reports the frequency of GCP Liquid Atomization

GCP_FuelDistributionCombZone Reported This field reports the use of Good Combustion Practices Proper Fuel Distribution Combustion Zone. (True=Yes/False=No)

GCP_FuelDistributionCombZone_fr

eq Reported This field reports the frequency of GCP Fuel Distribution Combustion Zone

GCP_CombustionAirDistribution Reported This field reports the use of Good Combustion Practices Combustion Air Distribution (True=Yes/False=No)

GCP_CombustionAirDistribution_fr

eq Reported This field reports the frequency with which GCP Combustion Air Distribution is used.

GCP_FlyAshReinjection Reported This field reports the use of Good Combustion Practices Fly Ash Reinjection. (True=Yes/False=No)

GCP_DrierFuel Reported This field reports on the Good Combustion Practices of using drier fuel. (True=Yes/False=No)

GCP_FuelDistributioninFirebox Reported This field reports on the Good Combustion Practice of proper Fuel Distribution. (True=Yes/False=No)

GCP_Co-firing Reported This field reports on the Good Combustion Practice of Co-Firing fuels (True=Yes/False=No)

GCP_lowNOxBurners Reported This field reports on the Good Combustion Practice using Low Nox Burners (True=Yes/False=No)

Adjustments Reported

This field reports the adjustment of CO, CO2, or other gas necessary to calculate combustion efficiency and make necessary 

adjustments to the combustion system.

COLimit_UnitandCorrection Reported This field reports the CO limit applicable to the unit or group of units.

GasFuel Reported This field reports the fuel combusted in the unit or group of units.

AverageTime Reported This field reports the averaging time for the CO limit.

AverageTimeOther Reported This field reports if other information was entered about the CO limit averaging time.

SourceTab Reported Indicates the Survey AnswerKey tab in which the data originated

Original UnitID Reported This is a QA field showing the original Unit ID.

Note Standardized This field provides space for additional information.

A-8 Page 2
Appendix A-9: Field Mapping for the Data: Materials Combusted Database Table

Field Name

Does Field Represent 

Reported or 

Standardized Data?

Description

FacilityID Standardized This identifier relates each record to a unique facility using a two-letter state abbreviation and abbreviated facility name.

UnitID Standardized

This contains a unique identifier assigned to each combustion unit. For units with an identifier representing multiple 

combustion units a note is provided in the IDNote field

StartupFuel Reported This field lists any alternative fuel used at startup for the combustion unit.

Common StartupFuel Standardized This field gives the standardized startup fuel type.

Startups Reported This field indicates the number of unit startups per year.

StartupLength Reported This field gives the typical length of startup time in hours.

Fuel Reported This field lists the fuels or materials combusted by the unit.

Common Fuel Standardized This field shows the standardized fuel name.

DirectlyFedTo Reported

This field indicates where the fuel is fed. The answers include "B" for boiler, "P" for process heater, "G" for gasifier, or "O" 

for other combustion unit.

FuelUsagePattern Reported This field shows if the pattern of fuel usage is seasonal or annual.

HoursPerYear Reported This field gives the unit operation hours per year.

HeatMin Reported This field gives the Minimum Heat Input in mmBtu/hr for the unit.

HeatMax Reported This field gives the Maximum Heat Input in mmBtu/hr for the unit.

HeatMean Reported This field gives the Mean Heat Input in mmBtu/hr for the unit.

PermitLimitValue Reported This field lists the permitted limit value.

PermitLimitUnit Reported This field gives the unit associated with the permit limit value.

NRC_Fuel Reported This field shows fuels that are occassionally, but not routinely combusted.

Common NRC_Fuel Standardized This field gives the standardized NRC fuel type.

NRC_DirectlyFedTo Reported

This field indicates where fuel is fed. The answers include "B" for boiler, "P" for process heater, "G" for gasifier, or "O" for 

other combustion unit.

NRC_Conditions Reported This field indicates the conditions which lead to the combustion of fuels not routinely combusted.

NRC_HoursPerYear Reported This field provides the hours of fuels not routinely combusted burned per year.

NRC_HeatMin Reported This field gives the Minimum Heat Input of fuel not routinely combusted in mmBtu/hr.

NRC_HeatMax Reported This field gives the Maximum Heat Input of fuel not routinely combusted in mmBtu/hr.

NRC_HeatMean Reported This field gives the Mean Heat Input of fuel not routinely combusted in mmBtu/hr.

NRC_PermitLimitValue Reported This field lists the permitted limit value associated with the NRC.

NRC_PermitLimitUnit Reported This field gives the unit associated with the NRC permit limit value.

UnitIDChange (oldvalue) Reported This QA field shows the original Unit ID.

Note Standardized This field provides space for additional information.

A-9 Page 1
Appendix A-10: Field Mapping for the Data: Non-Fossil Fuels Database Table

Field Name

Does Field Represent 

Reported or 

Standardized Data?

Description

FacilityID Standardized This identifier relates each record to a unique facility using a two-letter state abbreviation and abbreviated facility name.

UnitID Standardized

This contains a unique identifier assigned to each combustion unit. For units with an identifier representing multiple 

combustion units a note is provided in the IDNote field

NonFossilFuelUnits Reported This field indicates the units that fire non-fossil fuels.

NonFossilFuel Reported This field gives the name of the non-fossil fuel burned.

Common Fuel Standardized This field shows the standardized fuel name.

HandlingMethod Reported This field describes the alternative disposal method for non-fossil fuel if not combusted.

CompensatoryFuel Reported This field describes the fuel used to compensate if the facility is not able to burn non-fossil fuel.

CompensateForLostHeat Reported This field describes the alternative to compensate for lost heat if non-fossil fuel isn't combusted.

StopCombustingNFF Reported

This field shows if the facility would be forced to stop burning non-fossil fuel if subject to Sectioln 129 CISWI. 

(True=Yes/False=No)

CoststoComplywith129 Reported This field lists the additional costs to comply with 129.

CostComponents Reported This field provides space to list the additional cost components necessary to comply with 129.

Original UnitID Reported This is a QA field showing the original Unit ID.

Note Standardized This field provides space for additional information.

A-10 Page 1
Appendix A-11: Field Mapping for the Data: Regulatory and Permit Limits Database Table

Field Name

Does Field Represent 

Reported or 

Standardized Data?

Description

FacilityID Standardized This identifier relates each record to a unique facility using a two-letter state abbreviation and abbreviated facility name.

CombustorID Standardized

This contains a unique identifier assigned to each combustion unit. For units with an identifier representing multiple 

combustion units a note is provided in the IDNote field

Pollutant Reported This field identifies the Permitted Pollutant described in the record.

EL Reported This field gives the Numerical Emission Limit.

EL_Units Reported This field gives the Emission Limit Units as lb/mmBtu or Other.

EL_Units_Other Reported This field provides space to give Other Limit Units, where applicable.

EL_FuelAssoc Reported This field indicates the fuel associated with the Emission Limit.

AveragingTime Reported This field gives the averaging time for the limit, such as hourly, 30-day average, etc.

O2orCO2Concentration Reported This field contains the standardized oxygen concentration.

EL_ReflectDDDDD Reported This field indicates emission limits that reflect DDDDD. (True=Yes/False=No)

Note Standardized This field provides space for additional Information

A-11 Page 1
Appendix A-12: Field Mapping for the Data: Stack Database Table

Field Name

Does Field Represent 

Reported or 

Standardized Data?

Description

FacilityID Standardized This identifier relates each record to a unique facility using a two-letter state abbreviation and abbreviated facility name.

UnitID Standardized

This contains a unique identifier assigned to each combustion unit. For units with an identifier representing multiple 

combustion units a note is provided in the IDNote field

SingleStack Reported This field indicates if the stack is used by a single combustion unit. (True=Yes/False=No)

CommonStack Reported This field indicates if the stack is used by multiple combustion units. (True=Yes/False=No)

OtherCombustionUnits Reported

This field provides a list of other combustions units using a stack, if it is a common stack. Should correspond to a "Yes" in the 

Common Stack field.

MultipleStacks Reported This field indicates the use of multiple stacks by a single combustion unit. (True=Yes/False=No).

Original UnitID Reported This is a QA field showing the original Unit ID.

A-12 Page 1
Appendix A-13: Field Mapping for the Data: Unit Design/Operation Database Table

Field Name

Does Field Represent 

Reported or 

Standardized Data?

Description

FacilityID Standardized This identifier relates each record to a unique facility using a two-letter state abbreviation and abbreviated facility name.

UnitID Standardized

This contains a unique identifier assigned to each combustion unit. For units with an identifier representing multiple 

combustion units a note is provided in the IDNote field

Classification Reported This QA field identifies the combustion device as a boiler, process heater, incinerator, generator, kiln or other.

YearInstalled Reported This field gives the year the combustion device was installed.

Capacity Reported This field lists the Heat Input value for the combustion unit.

CapacityUnit Reported This field gives the Heat Input value units.

Standardized Capacity Standardized This field contains the Heat Input value converted to standardized units.

Standardized CapacityUnit Standardized This field lists the Heat Input unit for the Standardized Capacity field.

Fuel Reported This field gives the type of fuel used in the combustion device.

HeatReleaseRate Reported This field lists the Heat Release Rate in units of Btu per cubic foot.

NSPS Reported This field indicates if the unit is subject to New Source Performance Standards. (True=Yes/False=No).

NSPSYear Reported

This field gives the year in which the combustion unit is subject to New Source Performance Standards. Should correspond 

to a "Yes" response in the NSPS field.

PCD_SteamGen Reported This field indicates that the unit's primary use is steam generation. (True=Yes/False=No)

PCD_SpaceHeat Reported This field indicates that the unit's primary use is space heat generation. (True=Yes/False=No)

PCD_ProcessHeat Reported This field indicates that the unit's primary use is process heat generation. (True=Yes/False=No)

PCD_ElectricityGen Reported This field indicates that the unit's primary use is electricity generation. (True=Yes/False=No)

PCD_WasteIncineration Reported This field indicates that the unit's primary use is waste incineration. (True=Yes/False=No)

PCD_Cogen Reported This field indicates that the unit's primary use is co-generation. (True=Yes/False=No)

PCD_Other Reported This field indicates that the unit has another primary use besides those listed. (True=Yes/False=No)

PCD_OtherExp Reported

This field provides space to explain the unit's secondary use. Should correspond to a "Yes" response in the "PCD_Other" 

field.

ACD_SteamGen Reported This field indicates that the unit's secondary use is steam generation. (True=Yes/False=No)

ACD_SpaceHeat Reported This field indicates that the unit's secondary use is space heat generation. (True=Yes/False=No)

ACD_ProcessHeat Reported This field indicates that the unit's secondary use is process heat generation. (True=Yes/False=No)

ACD_ElectricityGen Reported This field indicates that the unit's secondary use is electricity generation. (True=Yes/False=No)

ACD_WasteIncineration Reported This field indicates that the unit's secondary use is waste incineration. (True=Yes/False=No)

ACD_Cogen Reported This field indicates that the unit's secondary use is co-generation. (True=Yes/False=No)

ACD_Other Reported This field indicates that the unit has another secondary use besides those listed. (True=Yes/False=No)

ACD_OtherExp Reported This field provides space to explain the unit's primary use. Should correspond to a "Yes" response in the "ACD_Other" field.

Blr_Package Reported This field indicates that the combustion device is a shop erected package boiler.

Blr_FieldErected Reported This field indicates that the combustion device is field erected.

Blr_Modular Reported This field indicates that the combustion device was erected partly in a shop and partly in the field.

Blr_WaterTube Reported This field indicates that the combustion device is a water tube boiler.

A-13 Page 1
Appendix A-13: Field Mapping for the Data: Unit Design/Operation Database Table

Field Name

Does Field Represent 

Reported or 

Standardized Data?

Description

Blr_FireTube Reported This field indicates that the combustion device is a fire tube boiler.

Blr_Hybrid Reported This field indicates that the combustion device is a hybrid boiler.

Blr_HybridWater Reported This field indicates that the combustion device is a hybrid water tube boiler.

Blr_HybridFire Reported This field indicates that the combustion device is a hybrid fire tube boiler.

Blr_Tangential Reported This field indicates that the combustion device is a boiler with tangential suspension firing.

Blr_WallFired Reported This field indicates that the combustion device is a boiler with wall-fired suspension firing.

Blr_Combo Reported This field indicates that the combustion device is a boiler with a combination of suspension firing and grate-firing.

Blr_OtherSuspension Reported This field indicates that the combustion device is a boiler with another form of suspension firing.

Blr_OtherSuspensionExp Reported This field explains the suspension firing method utilized by the boiler.

BlrStoker Reported This field indicates that the combustion device is a stoker solid-fuel boiler.

BlrStoker_Spreader Reported This field indicates that the combustion device is a spreader-stoker solid-fuel boiler.

BlrStoker_MassFeed Reported This field indicates that the combustion device is a mass feed solid-fuel boiler.

BlrStoker_ManualFeed Reported This field indicates that the combustion device is a manual-feed solid-fuel boiler.

BlrStoker_Other Reported This field indicates that the combustion device is a stoker boiler of another type.

BlrStoker_OtherExp Reported

This field provides space to explain the type of stoker solid-fuel boiler. Should correspond to a "Yes" response in the 

"BlrStoker_Other" field.

Blr_FluidBed Reported This field indicates that the combustion device is a fluidized-bed solid-fuel boiler.

Blr_FluidBed_Circulating Reported This field indicates that the combustion device is a circulating fluidized-bed solid-fuel boiler.

Blr_FluidBed_Bubbling Reported This field indicates that the combustion device is a bubbling fluidized-bed solid-fuel boiler.

Blr_PulverizedCoal Reported This field indicates that the combustion device is a pulverized coal solid-fuel boiler.

Blr_Cyclone Reported This field indicates that the combustion device is a cyclone boiler.

BlrOtherUnit_FuelCell Reported This field indicates that the combustion device is a fuel-cell solid-fuel boiler.

BlrOtherUnit_SuspBurner Reported This field indicates that the combustion device is a suspension burner solid-fuel boiler.

BlrOtherUnit_SlopedGrate Reported This field indicates that the combustion device is a sloped grate solid-fuel boiler.

BlrOtherUnit_DutchOven Reported This field indicates that the combustion device is a dutch oven solid-fuel boiler.

BlrOtherUnit_Gasifier Reported This field indicates that the combustion device is a gasifier solid-fuel boiler.

BlrOtherUnit_Other Reported This field indicates that the combustion device is another type of solid-fuel boiler.

BlrOtherUnit_OtherExp Reported

This field provides space to explain the type of solid-fuel boiler. Should correspond to a "Yes" response in the "BlrOtherUnit" 

field.

PH_Package Reported This field indicates if the unit is a shop-erected process heater package unit. (True=Yes/False=No).

PH_FieldErected Reported This field indicates if the unit is a field-erected process heater. (True=Yes/False=No).

PH_FireTube Reported This field indicates if the unit is a fire-tube process heater. (True=Yes/False=No).

PH_WaterTube Reported This field indicates if the unit is a water-tube process heater. (True=Yes/False=No).

PH_ThermalOil Reported This field indicates if the unit is a thermal oil process heater. (True=Yes/False=No).

PH_OtherUnit Reported This field indicates that the unit is another type of process heater. (True=Yes/False=No)

PH_OtherUnitExp Reported

This field provides space to explain the type of process heater. Should correspond to a "Yes" response in the "PH_OtherUnit" 

field.

A-13 Page 2
Appendix A-13: Field Mapping for the Data: Unit Design/Operation Database Table

Field Name

Does Field Represent 

Reported or 

Standardized Data?

Description

PH_FuelCell Reported This field indicates if the unit is a fuel cell process heater. (True=Yes/False=No).

PH_SuspBurner Reported This field indicates if the unit is a suspension burner process heater. (True=Yes/False=No).

PH_SlopedGrate Reported This field indicates if the unit is a slope grateprocess heater. (True=Yes/False=No).

PH_DutchOven Reported This field indicates if the unit is a dutch oven process heater (True=Yes/False=No).

PH_Gasifier Reported This field indicates if the unit is a gasifier process heater. (True=Yes/False=No).

PH_OtherFiring Reported This field indicates if the unit is an unlisted type of process heater. (True=Yes/False=No).

PH_OtherFiringExp Reported

This field provides space to explain how the process heater is fired. Should correspond to a "Yes" response in the 

"PH_OtherFiring" field.

OC_NaturalDraft Reported This field indicates if the combustion unit utilizes natural draft. (True=Yes/False=No).

OC_ForcedDraft Reported This field indicates if the combustion unit utilizes forced draft. (True=Yes/False=No).

OC_Dryer Reported This field indicates if the combustion unit is a dryer. (True=Yes/False=No).

OC_Heater Reported This field indicates if the combustion unit is a heater. (True=Yes/False=No).

OC_Kiln Reported This field indicates if the combustion unit is a kiln. (True=Yes/False=No).

OC_Engine Reported This field indicates if the combustion unit is an engine. (True=Yes/False=No).

OC_Other Reported This field indicates if the combustion unit is another type of unit. (True=Yes/False=No).

OC_OtherExp Reported

This field provides space to explain the type of combustion unit. Should correspond to a "Yes" response in the 

"OC_OtherUnit" field.

OperationHours Reported This field gives operation hours for the combustion unit, in hr/yr

DutyCycle Reported This field indicates if the unit duty cycle is base-loaded, load following or standby.

Seasonal Reported This field indicates if the combustion unit operates seasonally.

Original Unit ID Reported This is a QA field showing the original Unit ID.

Note Standardized This field provides space for additional information.

A-13 Page 3
Appendix A-14: Field Mapping for the Major Source Data: CEMS Backgrnd Database Table

Field Name

Does Field Represent 

Reported or 

Standardized Data?

Description

FacilityID Standardized This identifier relates each record to a unique facility using a two-letter state abbreviation and abbreviated facility name.

CombustorID Reported

This contains a unique identifier assigned to each combustion unit. For units with an identifier representing multiple 

combustion units a note is provided in the IDNote field

Source Reported This field identifies the source of the data as CEMS or SmallGasCEMS.

Pollutant Reported This field identifies the pollutant being monitored as CO, NOx, SO2, Opacity, or PM.

TypControl Reported This field contains the Control Device Configuration for 30-day CEMS period (drop-down menu provided)

Standardized TypControl Standardized This is a field which standardizes the terms used for pollution control devices.

TypOpRate Reported This field contains the typical operating rate during the 30-day CEMS period (MMBtu/hr)

UpsetsDuringTypOperations Reported This field gives space for a description of any operational upsets during 30-day CEMS period.

TypFuel Reported This field gives the typical fuel mix utilized during 30-day CEMS period.

Common Fuel Standardized This field shows the standardized fuel type for TypFuel.

TypFuelRate Reported This field contains the typical fuel rate during the CEMS period.

TypFuelRateUnits Reported This field gives the units for typical fuel rate.

Standardized FuelRate Standardized This field shows the standardized rate for TypFuelRate.

Standardized FuelRateUnits Standardized This field shows the standardized rate units for TypFuelRateUnits.

FuelRate Conversion Eq Used Standardized This field shows the ID of the conversion equation used to standardize the TypFuelRate.

MaxFuel Reported This field gives the fuel Maximum 6-minute average.

Common MaxFuel Standardized This field shows the standardized fuel type for MaxFuel.

MaxFuelRate Reported This field gives the fuel rate at Maximum 6-minute average.

MaxFuelRateUnits Reported This field gives the units for the fuel rate at Maximum 6-minute average.

UpsetsDuringMaxOperations Reported This field gives space for a description of any operational upsets during maximum 6-minute period.

MaxControl Reported This field gives the control device configuration used during the maximum 6-minute average.

MaxOpRate Reported This field provides the operating rate during the maximum 6-minute average.

Original CombustorID Standardized This is a QA field showing the original Unit ID.

Note Standardized This field provides space for additional information.

A-14 Page 1
Appendix A-15: Field Mapping for the Major Source Data: EmissionsTest Background Info Database Table

Field Name

Does Field Represent 

Reported or 

Standardized Data?

Description

FacilityID Standardized This identifier relates each record to a unique facility using a two-letter state abbreviation and abbreviated facility name.

CombustorID_common Standardized

This contains a unique identifier assigned to each combustion unit. For units with an identifier representing multiple 

combustion units a note is provided in the IDNote field

ControlDevice Reported This identifier lists any add-on Pollution Control Device.

Standardized ControlDevice Standardized This is a field which standardizes the terms used for pollution control devices.

TestID Reported This field contains an identifying sample number for tracking emission test results.

TestDate_common Reported This field shows the date of the emission test.

Steam Reported This field reports the steam output rate from the combustion unit at the time of the emission test.

SteamUnit Reported This field gives the steam output rate unit.

SteamUnitOther Reported

This field provides space for steam output rate alternative unit information. Should correspond to an "Other" response in the 

"Steam Unit" field.

Standardized Steam Standardized This field converts steam output to standard units.

Standardized Steam Unit Standardized This field shows the standardized steam output unit (1000 lb/hr)

SteamLocation Reported This field indicates if testing was done either upstream or downstream of control device.

SteamNote Reported This field provides space for additional information on steam output.

THI_Value Reported This value gives the total heat input.

THI_Unit Reported This field reports the unit for the total heat input.

Standardized THI_Value Standardized This field converts total heat input to standard units.

Standardized THI_Unit Standardized This field shows the standardized THI unit. (mmBtu/hr)

THI_UnitOther Reported

This field provides space for total heat input alternative unit information. Should correspond to an "Other" response n the 

"THI_Unit"

THI_Location Reported This field Indicates if testing is done upstream or downstream or control device.

THI_Note Reported This field provides space for additional total heat input information.

DryOrWet Reported This field indicates the basis on which testing is measured, wet or dry.

DryOrWetNote Reported This field provides space for additional basis information.

CO2_Value Reported This field gives the CO2 emission value for the Test ID.

CO2_Unit Reported This field provides the unit related to the CO2 pollutant value.

CO2_Method Reported This field idicates the CO2 Test Method used to determine the CO2 value.

CO2_Location Reported This field indicates if CO2 sample taken before or after control device.

CO2_Note Reported This field provides space for additional CO2 emission information

O2_Value Reported This field gives the O2 emission value for the Test ID.

Standardized O2_Value Standardized This field is a field converting O2 emissions to a numeric value with standard units.

O2_Unit Reported This field provides the unit related to the O2 emission value.

O2_Method Reported This field indicates the O2 Test Method used to determine the O2 value.

O2_Location Reported This field indicates if the O2 sample was taken before or after control device.

O2_Note Reported This field provides space for additional O2 Information.

Moisture Reported This field gives the percent of moisture in the exhaust.

A-15 Page 1
Appendix A-15: Field Mapping for the Major Source Data: EmissionsTest Background Info Database Table

Field Name

Does Field Represent 

Reported or 

Standardized Data?

Description

Standardized_Moisture Standardized This field converts the moisture value to standardized units of percent.

MoistureNote Reported This field provides space for additional moisture information.

ExhaustFlow Reported This field gives the exhaust flow rate.

Standardized_ExhaustFlow Standardized This field converts the exhaust flowrate to a standard unit.

ExhaustFlowUnit Reported This field gives the original exhaust flowrate units.

ExhaustFlowNote Reported This field provides space for additional exhaust flowrate information.

ExhaustTemp Reported This field gives the exhaust temperature.

Standardized_ExhaustTemp Standardized This field converts the exhaust temperature to a standard unit.

Standardized_ExhaustTempUnit Standardized This field shows the standardized exhaust temp unit (F).

ExhaustTempUnit Reported This field provides the original unit for Exhaust Temperature

ExhaustTempNote Reported This field provides space for additional exhaust temperature information.

SourceTab Reported

This field identifies the EmissionTestSprdsheet tab of the 2008 Combustion Survey Emission Test in which the data 

originated.

Original CombustorID_common Reported This is a QA field showing the original Unit ID.

Note Standardized This field provides space for additional information.

A-15 Page 2
Appendix A-16: Field Mapping for the Major Source Data: EmissionsTest Fuel Data Database Table

Field Name

Does Field Represent 

Reported or 

Standardized Data?

Description

FacilityID Standardized This identifier relates each record to a unique facility using a two-letter state abbreviation and abbreviated facility name.

CombustorID_common Standardized

This contains a unique identifier assigned to each combustion unit. For units with an identifier representing multiple 

combustion units a note is provided in the IDNote field

TestID Reported This field contains an identifying sample number for tracking emission test results.

TestDate_common Reported This field shows the date of the emission test.

FuelParameter_Type Reported This field identifies the parameter type being recorded.

Common Fuel Standardized This field shows the standardized fuel name.

FuelParameter_TypeOther Reported This field identifies the other parameter type.

FuelParameter_Value Reported This field gives the numerical value of the parameter type being detailed.

FuelParameter_Unit Reported This field provides the unit for the parameter value chosen from menu.

Standardized Fuel Rate Standardized This field shows the fuel rate converted to standard units.

Standardized Fuel Rate Units Standardized This field shows the standard fuel rate units. (Mbtu/hr)

FuelParameter_UnitOther Reported

This field provides alternative parameter value unit information. Should correspond to an "Other" response in the 

"FuelParameter_Unit" field.

FuelParameter_Method Reported This field provides the method used to determine the parameter value.

FuelParameter_Note Reported The field provides space for additional parameter information.

SourceTab Reported

This field identifies the EmissionTestSprdsheet tab of the 2008 Combustion Survey Emission Test in which the data 

originated.

Original CombustorID_common Reported This is a QA field showing the original Unit ID.

Note Standardized This field provides space for additional information.

A-16 Page 1