test_report_samplingPK,FK1 facility_idPK,FK1 report_idPK sampling_port_idpoint_differpoint_descriptionbefore_SO2_devicepoint_orientationnormal_bypass_percenttesting_bypass_percentfg_fractionHg_emission_limitsPK,FK1 facility_idPK stack_idHg_emlimit_1Hg_emlimit_units_1Hg_emlimit_2Hg_emlimit_units_2Hg_emlimit_3Hg_emlimit_units_3Hg_emlimit_4Hg_emlimit_units_4fuel_shipment_samplesPK,FK1 facility_idPK,FK1 shipment_idPK sample_idamount_fuelamount_fuel_unitstotal_sulfurash_contentheating_valueheating_unitschlorinechlorine_unitsfluorinefluorine_unitsdata_provideddata_other_specifiedsupplier_typesupplier_namesupplier_addresssupplier_citysupplier_statesupplier_ziplab_namelab_addresslab_citylab_statelab_zipanalysis_copiesfacility_other_materialsPK,FK1 facility_idPK other_materialpermitted_burnactually_burnother_quantityother_quantity_unitsother_notercra_utilizercra_explainfacility_coal_utilizedPK,FK1 facility_idPK coal_typepercentage_masspercentage_btusynfuel_typecoal_notecem_data_pollutantsPK,FK1 facility_idPK,FK1 time_periodPK pollutant_nameboiler_additivesPK,FK1 facility_idPK,FK1 boiler_idPK boiler_additiveadditive_otheradditive_onlineHg_cem_hourlyPK,FK1 facility_idPK stack_idPK collection_datePK collection_hourHg_total_emissionsHg_total_fluegasHg_total_fluegas_unitsHg_total_emission_factorHg_elemental_emissionsHg_elemental_fluegasHg_elemental_fluegas_unitsHg_elemental_emission_factorHg_oxidized_emissionsHg_oxidized_fluegasHg_oxidized_fluegas_unitsHg_oxidized_emission_factorfluegas_flowratefluegas_temperatureheat_inputaverage_loadoperating_timemoisture_fractionf_factoroperational_statuscertified_yncommentscontrol_technologiesPK,FK1 facility_idPK,FK1 configuration_idPK,FK1 component_idPK control_idproject_titleproject_typevendor_namevendor_contactvendor_phonevendor_addressvendor_cityvendor_statevendor_zipactual_start_dateprojected_start_dateend_datesorbentchemical_additiveinjection_pointHAP_emission_reductionHAP_emission_rateHAP_emission_rate_unitsHAP_achieved_reductionHAP_achieved_rateHAP_achieved_rate_unitsfeed_ratefeed_rate_unitsconfiguration_componentsPK,FK1 facility_idPK,FK1 configuration_idPK component_idordercomponent_typeport_nearfacility_controlsPK,FK1 facility_idPK control_idcontrol_groupcontrol_typecontrol_otherlegacy_controlcontrol_onlinecontrol_offlineNOx_reagentreagent_otherNOx_ammoniaSO2_sorbentother_sorbentSO2_scrubber_additiveboiler_control_NOxPK,FK1 facility_idPK,FK1 boiler_idPK NOx_typeNOx_otherNOx_onlinetest_reportsPK,FK1 facility_idPK report_idreport_typeother_typereport_descriptionreport_begin_datereport_end_datebefore_controlduring_deviationdeviation_reportsHg_cem_dailyFK1 facility_idstack_idcollection_datecollection_end_dateHg_total_emissionsHg_total_fluegasHg_total_fluegas_unitsHg_total_emission_factorHg_elemental_emissionsHg_elemental_fluegasHg_elemental_fluegas_unitsHg_elemental_emission_factorHg_oxidized_emissionsHg_oxidized_fluegasHg_oxidized_fluegas_unitsHg_oxidized_emission_factorHg_emission_ratefluegas_flowratefluegas_temperatureheat_inputaverage_loadoperating_timemoisture_fractionf_factorfacility_sampling_portsPK,FK1 facility_idPK sampling_port_idconfigurationsPK,FK1 facility_idPK configuration_idmisc_control_configurationsPK,FK1,FK2 facility_idPK,FK1 misc_control_idPK,FK2 configuration_idfacility_stacksPK,FK1 facility_idPK stack_idstack_heightstack_diameterstack_gas_velocityconfiguration_pollutantsPK,FK1 facility_idPK,FK1 configuration_idPK pollutant_namepermit_type_1emlimit_1emlimit_units_1avg_period_1emlimit_2emlimit_units_2avg_period_2emlimit_3emlimit_units_3avg_period_3emlimit_4emlimit_units_4avg_period_4emlimit_5emlimit_units_5avg_period_5emlimit_detailstest_methodemrateemrate_unitsguarantee_levellevel_explainreq_monitoringreq_recordkeepingreq_reportingcontrol_coal_ranksPK,FK1 facility_idPK,FK1 configuration_idPK,FK1 component_idPK,FK1 control_idPK coal_typeboiler_control_SO2PK,FK1 facility_idPK,FK1 boiler_idPK SO2_typeSO2_otherSO2_onlinemisc_controlsPK,FK1 facility_idPK misc_control_idcontrol_descriptiontest_report_configurationsPK,FK1,FK2 facility_idPK,FK2 report_idPK,FK1 configuration_idfacility_unitsPK,FK1 facility_idPK unit_idtest_report_fuel_typesPK,FK1 facility_idPK,FK1 report_idPK,FK1 fuel_idPK fuel_typepercentage_massvolpercentage_btuother_typesampling_runsPK,FK1 facility_idPK,FK1 report_idPK,FK1 sampling_port_idPK run_idstart_datetimeend_datetimeunit_loadnet_generationfg_moisture_contentfg_flow_ratefg_flow_rate_unitsstandard_temperaturestandard_pressurenormal_temperaturenormal_pressurefg_oxygen_contentfg_CO2_contentfg_temperaturefg_pressureHg_loitest_methodrun_commentsfuel_idfuel_unit_loadfuel_flow_ratefuel_ashfuel_heating_valuefuel_sulfursampling_run_fuelPK,FK1 facility_idPK,FK1 report_idPK,FK1 sampling_port_idPK,FK1 run_idPK fuel_pollutantfuel_concfuel_conc_unitsfuel_conc_NDfuel_conc_MDLcontrol_costsPK,FK1 facility_idPK,FK1 configuration_idPK,FK1 component_idPK,FK1 control_idboiler_retrofitboiler_new_installtotal_capital_investmenttotal_operating_costsbase_yearCBIboiler_fuelsPK,FK1 facility_idPK,FK1 boiler_idPK fuel_typePK fuel_yearpercentage_massvolpercentage_btuother_typeunit_boilersPK,FK1 facility_idPK,FK1 unit_idPK boiler_idfuel_sample_pollutantsPK,FK1 facility_idPK,FK1 shipment_idPK,FK1 sample_idPK fuel_pollutantpollutant_concpollutant_conc_unitspollutant_conc_NDpollutant_conc_MDLfacility_informationPK facility_idutility_codelegal_owner_namelegal_operator_namelegal_address_typelegal_addresslegal_citylegal_statelegal_zipplant_namephysical_addressphysical_cityphysical_statephysical_zipmailing_addressmailing_citymailing_statemailing_zipRFA_small_entityff_fired_coalff_fired_oilff_fired_ngasff_fired_petcokeff_fired_otherff_permitted_coalff_permitted_oilff_permitted_ngasff_permitted_petcokeff_permitted_otherdeviation_reportingcontinuous_emissionscem_providedfacility_notefacility_oil_utilizedPK,FK1 facility_idPK oil_typepercentage_volumepercentage_btuother_typeboiler_informationPK,FK1 facility_idPK boiler_idboiler_typeboiler_otherbottom_designprimary_fueldesign_fuelheat_inputmax_heat_inputMWe_capacityMWe_net_capacitydesign_gross_efficiencyoperating_gross_efficiencydesign_gross_thermal_efficiencyoperating_gross_thermal_efficiencydesign_pressureoperating_pressuredesign_tempoperating_tempdesign_reheat_multipledesign_reheat_temp1design_reheat_temp2operating_reheat_multipleoperating_reheat_temp1operating_reheat_temp2hours_operatedavg_capacity_factorapplicable_NSPSretirement_yearretirement_year_CBINOx_controlSO2_controlcombustion_additivestest_report_fuelsPK,FK1 facility_idPK,FK1 report_idPK fuel_idsampling_run_pollutantsPK,FK1 facility_idPK,FK1 report_idPK,FK1 sampling_port_idPK,FK1 run_idPK pollutant_nameconcconc_unitsconc_NDconc_MDLconc2conc2_unitsemission_rateemission_rate_unitsemission_rate_NDemission_rate_MDLemission_factoremission_factor_unitsemission_factor_NDemission_factor_MDLrun_pollutant_commentfuel_shipmentsPK,FK1 facility_idPK shipment_idshipment_dateamount_receivedamount_unitsfuel_typestate_countryother_countrycountycoal_seamshipment_methodfuel_shipment_configurationsPK,FK1,FK2 facility_idPK,FK1 shipment_idPK,FK2 configuration_idcontrol_pollutantsPK,FK1 facility_idPK,FK1 configuration_idPK,FK1 component_idPK,FK1 control_idPK pollutant_namecem_dataPK,FK1 facility_idPK time_periodcem_period_description

# Parent Table

PK ParentKey

OtherField1

OtherField2 Child Table 1

PK,FK1 ParentKey

PK Child1Key

I1 ChildOther1 Primary Key(s) are at top of table,

above the line.

PK indicates Primary Key

FK indicates Foreign Key



# Child Table 2

PK Child2Key

FK1 ParentKey Arrow Points to parent table

FK – Foreign Key (field is linked to a key field in another table)

IE – Field is part of an index



# Legend for Entity Relationship Diagram

Field Attributes