Background:

Data Element Dictionary:

Database Table Name: Table name in the database that corresponds to the information in a specific set of information.

Description: General description of the type of data contained within the database table.

Database Table Name: Table name in the database that corresponds to the information in a specific set information.

Database Field Name:

Field Type Text: Specified data type of the field name (e.g., text, numeric, memo).

Field Description: Description of the field name.

Ash Transport Water Loadings Model Data Element Dictionary - Summary

4/19/2013

The primary purpose of the Ash Transport Water Loadings Model (DCN SE02899) is to calculate the plant-specific pollutant loadings for the treatment of 

ash transport water being evaluated as part of the Steam Electric Effluent Limitations Guidelines. As part of the pollutant loadings calculations, average 

effluent concentrations for fly ash, bottom ash, and combined ash ponds were developed. The average effluent concentration for each type of ash pond 

is calculated in the loadings model.

The Incremental Costs and Pollutant Removals for the Proposed Effluent Guidelines and Standards for the Steam Electric Power Generating Point 

Source Category (DCN SE01964) provides a detailed description of the calculations used to estimate the average effluent concentrations for each type of 

ash pond. The report also provides a description of how combined ash pond loadings were broken out into fly ash and bottom ash loadings. The report 

also describes the calculations used to estimate plant-specific pollutant loadings for each technology option. These calculations are executed in the 

queries contained within the database. The database also includes a listing of the specific sampling data used to calculate the average effluent 

concentrations for each type of pond.

This MS Excel file is the data element dictionary that provides a description of the data elements contained within the Ash Transport Water Loadings 

Model. The elements of the dictionary include: 

Tables: Provides a listing of all tables found within the Ash Transport Water Loadings Model along with a short description of the type of data 

contained within the table.

Field Names: Provides a list of all individual data fields found within the Ash Transport Water Loadings Model. The fields are organized by

table name.

Field name within a database table that corresponds to a specific data element in the loadings model. Field names 

can be repeated for the same type of information being entered (i.e., Plant_ID).

Database Table Name Description

Ash Input Table Plant-level ash pond loadings input table used to calculate pollutant 

loadings. The table includes pond-level ash sluice discharge flow 

rates.

Ash Pond Information - Sampling General information for those ash pond sampled by EPA.

Ash Pond Loads - Calculated Calculated analyte-level ash pond loadings. Includes loadings for 

fly ash ponds, bottom ash ponds, and combined ash ponds.

Ash Pond Sampling Data Ash pond sampling data collected by EPA.

Bottom Ash MW Data Plant-level data for all generating units generating bottom ash. 

Includes count of generating units and total wet bottom ash 

generated.

Combined Ash Pond Types Analyte-level ash pond loadings for all combined ash ponds. 

Includes breakout of combined pond loadings for fly ash and 

bottom ash.

Combined Ash Pond Types - Separated with 

Updated Loads and TWPE

Takes the breakout of combined ash pond loadings from Combined 

Ash Pond Types table and includes the loadings as separate 

records for fly ash loadings and bottom ash loadings for each plant 

with a combined ash pond.

Concentrations for Load Calculations - 

Sampling

Subset of EPA ash pond sampling data used to calculate loadings 

concentration.

Data 01 - Ash Pond Sampling Data mg/L Subset of EPA ash pond sampling data used to calculate loadings 

concentration, includes identifier fields to combine data with other 

data sources.

Data 01 - Ash Sampling Data - Updated Updated data from Data 01 - Ash Pond Sampling data mg/L to 

exclude all results with a null concentration.

Data 02 - EPRI Data mg/L Ash pond sampling data from EPRI used to calculate loadings 

concentration.

Data 03 - Form 2C Data mg/L Ash pond sampling data from Form 2C used to calculate loadings 

concentration.

Data 03 - Form 2C Data mg/L Updated Updated data from Data 03 - Form 2C Data mg/L to exclude all 

results with a null concentration.

Data 04 - TDD 1982 Table V-32 Data mg/L Ash pond sampling data from the 1982 TDD Table V-32 used to 

calculate loadings concentration.

Data 05 - TDD 1982 Table V-33 Data mg/L Ash pond sampling data from the 1982 TDD Table V-33 used to 

calculate loadings concentration.

Data 06 - TDD 1982 Table V-34 Data mg/L Ash pond sampling data from the 1982 TDD Table V-34 used to 

calculate loadings concentration.

Data 07 - Master Table Master table of all ash pond sampling data used to calculate 

loadings concentration.

EAD - Master Table - No Combined Calculated analyte-level ash pond loadings by EIA ID. This table 

includes combined ash pond loadings broken out into the loads 

associated with fly ash or bottom ash.

EPRI Data Table of unaltered ash pond sampling data from EPRI.

FA and BA Percentages Analyte-level breakout of combined ash loadings.

Fly Ash MW Data Plant-level data for all generating units generating fly ash. Includes 

count of generating units and total wet fly ash generated.

Form 2C Data Table Table of unaltered ash pond sampling data from Form 2C.

Make Final Loads Table - No Combined Calculated analyte-level ash pond loadings by Plant ID. This table 

includes combined ash pond loadings broken out into the loads 

associated with fly ash or bottom ash.
OW_EIAIDs Crosswalk between EPA OW plant identification number from the 

Steam Electric Survey and U.S. Energy Information Administration 

(EIA) identification number.

POTW Removals Analyte-level list of publically owned treatment works (POTW) 

removals.

Prams for Loads Analysis Analyte name crosswalk for the various sampling data sources.

TDD 1982 Table V-32 Data Table of unaltered ash pond sampling data from 1982 TDD Table V32.

TDD 1982 Table V-33 Data Table of unaltered ash pond sampling data from 1982 TDD Table V33.

TDD 1982 Table V-34 Data Table of unaltered ash pond sampling data from 1982 TDD Table V34.

TWFs Analyte-level list of toxic weighting factors (TWFs).

Update Prams w TWFs Analyte name and TWF crosswalk for the various sampling data 

sources.
EPA-HQ-OW-2009-0819-DRAFT-2189

Database Table Name Database Field Name Field Type Text Field Description

Ash Input Table plant_id Number (Double) Unique EPA Office of Water Survey plant identification number.

Ash Input Table EIA ID Number (Double) Unique plant identification code associated with the U.S. Energy Information Administration.

Ash Input Table System_ID Text Pond system identification number, assigned in the Steam Electric Survey.

Ash Input Table Influent Text Type of ash sluice, fly ash sluice, bottom ash sluice, or combined ash sluice.

Ash Input Table Pond Type Text Type of ash pond, fly ash pond, bottom ash pond, or combined ash pond.

Ash Input Table Ash Flow (GPD) over 365 

days

Number (Double) Flow rate, in gallons per day, for the influent identified. Flow rate is based on data provided in the 

Steam Electric Survey and normalized for operation over 365 days.

Ash Input Table surfwater_name Text Name of the surface water where ash sluice is discharged.

Ash Input Table Ash Flow CBI Text Flag to indicate the confidential business information status of the plant-level ash sluice flow rate.

Ash Input Table cbi_Effluents (Part D) Text Confidential business information flag for the table of influent data in Part D of the Steam Electric 

Survey.

Ash Input Table cbi_Influents (Part D) Text Confidential business information flag for the table of effluent data in Part D of the Steam Electric 

Survey.

Ash Input Table cbi_ash_sluice (Part C) Text Confidential business information flag for the ash sluice flow data in Part C of the Steam Electric 

Survey.

Ash Input Table cbi_surfwater (Part A) Text Confidential business information flag for surface water information in Part A of the Steam Electric 

Survey.

Ash Input Table cbi_outfall_flow_tbl (Part A) Text Confidential business information flag for outfall flow data in Part A of the Steam Electric Survey.

Ash Input Table cbi_conversion Text Confidential business information flag for ash conversion information in Part C of the Steam Electric 

Survey.

Ash Input Table Calculated Ash Flow Text Flag to indicate ash flows calculated by EPA.

Ash Input Table Indirect_Discharger Yes/No Flag to identify plants discharging ash sluice to a publically owned treatment works (POTW).

Ash Input Table No_Cost Yes/No Flag to identify plants not incurring compliance costs for ash.

Ash Input Table Wet Scrubber Flag Yes/No Flag to identify plants operating wet scrubbers.

Ash Input Table Retire? Yes/No Indicator for whether the plant is planning to retire.

Ash Pond Information - Sampling SAMPLE Text Numeric code associated with each sample.

Ash Pond Information - Sampling Sampling Date Date/Time Date of the sample.

Ash Pond Information - Sampling Plant Name Text Name of the plant sampled.

Ash Pond Information - Sampling Flow Rate (gpm) Number (Double) Flow rate, in gallons per minute, of ash sluice flow sampled.

Ash Pond Loads - Calculated EIA ID Number (Double) Unique plant identification code associated with the U.S. Energy Information Administration.

Ash Pond Loads - Calculated Ash Flow CBI Text Flag to indicate the confidential business information status of the plant-level ash sluice flow rate.

Ash Pond Loads - Calculated plant_id Number (Double) Unique EPA Office of Water Survey plant identification number.

Ash Pond Loads - Calculated System_ID Text Pond system identification number, assigned in the Steam Electric Survey.

Ash Pond Loads - Calculated Influent Text Type of ash sluice, fly ash sluice, bottom ash sluice, or combined ash sluice.

Ash Pond Loads - Calculated Pond Type Text Type of ash pond, fly ash pond, bottom ash pond, or combined ash pond.

Ash Pond Loads - Calculated Ash Flow (GPD) over 365 

days

Number (Double) Flow rate, in gallons per day, for the influent identified. Flow rate is based on data provided in the 

Steam Electric Survey and normalized for operation over 365 days.

Ash Pond Loads - Calculated surfwater_name Text Name of the surface water where ash sluice is discharged.

Ash Pond Loads - Calculated Calculated Ash Flow Text Flag to indicate ash flows calculated by EPA.

Ash Pond Loads - Calculated Analyte Name Text Name of analyte.

Ash Pond Loads - Calculated CAS Text Analyte-specific Chemical Abstracts Service (CAS) number.

Ash Pond Loads - Calculated AvgOfConcentration Number (Double) Average analyte concentration.

Ash Pond Loads - Calculated UNITS Text Units associated with AvgOfConcentration field.

Ash Pond Loads - Calculated Quantity (kg/day) Number (Double) Mass, in kg/day, of analyte discharged.

1 of 9
EPA-HQ-OW-2009-0819-DRAFT-2189

Database Table Name Database Field Name Field Type Text Field Description

Ash Pond Loads - Calculated Load (LBY) Number (Double) Mass, in lb/day, of analyte discharged.

Ash Pond Loads - Calculated Current TWF Number (Double) Current toxic weighting factor.

Ash Pond Loads - Calculated TWPE Number (Double) Calculated toxic weighted pound equivalent.

Ash Pond Sampling Data Plant Name Text Name of plant.

Ash Pond Sampling Data EPISODE Text Numeric code associated with each EPA sampling episode.

Ash Pond Sampling Data SAMPLE Text Numeric code associated with each sample.

Ash Pond Sampling Data ANALYTE Text Name of analyte measured.

Ash Pond Sampling Data CAS_NO Text Analyte-specific Chemical Abstracts Service (CAS) number.

Ash Pond Sampling Data Concentration Number (Double) Analyte concentration.

Ash Pond Sampling Data UNITS Text Units associated with Concentration field.

Ash Pond Sampling Data PROCEDURE Text Field identifying whether the AMOUNT reflects the total or dissolved analyte concentration. For the 

influent samples where the laboratory conducted a biphasic separation due to high solids content, this 

field identifies whether the AMOUNT reflects the filtrate, solids, or calculated total analyte 

concentration.

Ash Pond Sampling Data Sampling Date Date/Time Date of the sample.

Bottom Ash MW Data Bottom Ash Text Flag to identify whether all units producing bottom ash are included (i.e., "total").

Bottom Ash MW Data plant_id Number (Double) Unique EPA Office of Water Survey plant identification number.

Bottom Ash MW Data seunit_id Text Count of generating units producing bottom ash.

Bottom Ash MW Data ST_capacity Number (Double) Total steam turbine capacity for generating units producing bottom ash.

Bottom Ash MW Data btm_wetanddry Text Flag to indicate plants conveying bottom ash both wet and dry.

Bottom Ash MW Data btm_produced_wet_dpy Number (Double) Plant-level total wet bottom ash production rate in days per year.

Bottom Ash MW Data btm_produced_dry_dpy Number (Double) Plant-level total dry bottom ash production rate in days per year.

Combined Ash Pond Types EIA ID Number (Double) Unique plant identification code associated with the U.S. Energy Information Administration.

Combined Ash Pond Types Ash Flow CBI Text Flag to indicate the confidential business information status of the plant-level ash sluice flow rate.

Combined Ash Pond Types plant_id Number (Double) Unique EPA Office of Water Survey plant identification number.

Combined Ash Pond Types System_ID Text Pond system identification number, assigned in the Steam Electric Survey.

Combined Ash Pond Types Influent Text Type of ash sluice, fly ash sluice, bottom ash sluice, or combined ash sluice.

Combined Ash Pond Types Pond Type Text Type of ash pond, fly ash pond, bottom ash pond, or combined ash pond.

Combined Ash Pond Types Ash Flow (GPD) over 365 

days

Number (Double) Flow rate, in gallons per day, for the influent identified. Flow rate is based on data provided in the 

Steam Electric Survey and normalized for operation over 365 days.

Combined Ash Pond Types Calculated Ash Flow Text Flag to indicate ash flows calculated by EPA.

Combined Ash Pond Types Analyte Name Text Analyte name.

Combined Ash Pond Types CAS Text Analyte-specific Chemical Abstracts Service (CAS) number.

Combined Ash Pond Types AvgOfConcentration Number (Double) Average analyte concentration.

Combined Ash Pond Types UNITS Text Units associated with AvgOfConcentration field.

Combined Ash Pond Types Quantity (kg/day) Number (Double) Mass, in kg/day, of analyte discharged.

Combined Ash Pond Types Load (LBY) Number (Double) Mass, in lb/day, of analyte discharged.

Combined Ash Pond Types Current TWF Number (Double) Toxic weighting factor.

Combined Ash Pond Types TWPE Number (Double) Calculated annual toxic weighted pound equivalent.

Combined Ash Pond Types Sluice Stream Text Type of ash, bottom ash or fly ash.

Combined Ash Pond Types Fly Ash LBY Number (Double) Load, in pounds per year, associated with fly ash.

Combined Ash Pond Types Fly Ash TWPE Number (Double) TWPE associated with fly ash.

Combined Ash Pond Types Bottom Ash LBY Number (Double) Load, in pounds per year, associated with bottom ash.

Combined Ash Pond Types Bottom Ash TWPE Number (Double) TWPE associated with bottom ash.

2 of 9
EPA-HQ-OW-2009-0819-DRAFT-2189

Database Table Name Database Field Name Field Type Text Field Description

Combined Ash Pond Types - Separated with 

Updated Loads and TWPE

EIA ID Number (Double) Unique plant identification code associated with the U.S. Energy Information Administration.

Combined Ash Pond Types - Separated with 

Updated Loads and TWPE

Ash Flow CBI Text Flag to indicate the confidential business information status of the plant-level ash sluice flow rate.

Combined Ash Pond Types - Separated with 

Updated Loads and TWPE

plant_id Number (Double) Unique EPA Office of Water Survey plant identification number.

Combined Ash Pond Types - Separated with 

Updated Loads and TWPE

System_ID Text Pond system identification number, assigned in the Steam Electric Survey.

Combined Ash Pond Types - Separated with 

Updated Loads and TWPE

Influent Text Type of ash sluice, fly ash sluice, bottom ash sluice, or combined ash sluice.

Combined Ash Pond Types - Separated with 

Updated Loads and TWPE

Pond Type Text Type of ash pond, fly ash pond, bottom ash pond, or combined ash pond.

Combined Ash Pond Types - Separated with 

Updated Loads and TWPE

Ash Flow (GPD) over 365 

days

Number (Double) Flow rate, in gallons per day, for the influent identified. Flow rate is based on data provided in the 

Steam Electric Survey and normalized for operation over 365 days.

Combined Ash Pond Types - Separated with 

Updated Loads and TWPE

Calculated Ash Flow Text Flag to indicate ash flows calculated by EPA.

Combined Ash Pond Types - Separated with 

Updated Loads and TWPE

Analyte Name Text Analyte name.

Combined Ash Pond Types - Separated with 

Updated Loads and TWPE

CAS Text Analyte-specific Chemical Abstracts Service (CAS) number.

Combined Ash Pond Types - Separated with 

Updated Loads and TWPE

AvgOfConcentration Number (Double) Average analyte concentration.

Combined Ash Pond Types - Separated with 

Updated Loads and TWPE

UNITS Text Units associated with AvgOfConcentration field.

Combined Ash Pond Types - Separated with 

Updated Loads and TWPE

Quantity (kg/day) Number (Double) Mass, in kg/day, of analyte discharged.

Combined Ash Pond Types - Separated with 

Updated Loads and TWPE

Load (LBY) Number (Double) Mass, in lb/day, of analyte discharged.

Combined Ash Pond Types - Separated with 

Updated Loads and TWPE

Current TWF Number (Double) Current toxic weighting factor.

Combined Ash Pond Types - Separated with 

Updated Loads and TWPE

TWPE Number (Double) Calculated annual toxic weighted pound equivalent.

Combined Ash Pond Types - Separated with 

Updated Loads and TWPE

Sluice Stream Text Type of ash, bottom ash or fly ash.

Combined Ash Pond Types - Separated with 

Updated Loads and TWPE

Fly Ash LBY Number (Double) Load, in pounds per year, associated with fly ash.

Combined Ash Pond Types - Separated with 

Updated Loads and TWPE

Fly Ash TWPE Number (Double) TWPE associated with fly ash.

Combined Ash Pond Types - Separated with 

Updated Loads and TWPE

Bottom Ash LBY Number (Double) Load, in pounds per year, associated with bottom ash.

Combined Ash Pond Types - Separated with 

Updated Loads and TWPE

Bottom Ash TWPE Number (Double) TWPE associated with bottom ash.

Concentrations for Load Calculations - 

Sampling

EPISODE Text Numeric code associated with each EPA sampling episode.

Concentrations for Load Calculations - 

Sampling

SAMPLE Text Numeric code associated with each sample.

Concentrations for Load Calculations - 

Sampling

UNIT Text Units associated with the AMOUNT and DETLIMIT fields.

Concentrations for Load Calculations - 

Sampling

ANALYTE Text Analyte name.

3 of 9
EPA-HQ-OW-2009-0819-DRAFT-2189

Database Table Name Database Field Name Field Type Text Field Description

Concentrations for Load Calculations - 

Sampling

CAS_NO Text Analyte-specific Chemical Abstracts Service (CAS) number.

Concentrations for Load Calculations - 

Sampling

METHOD Text Analytical method used to measure the concentration.

Concentrations for Load Calculations - 

Sampling

AMOUNT Decimal Analyte concentration.

Concentrations for Load Calculations - 

Sampling

DETLIMIT Decimal Detection limit.

Concentrations for Load Calculations - 

Sampling

PROCEDURE Text Field identifying whether the AMOUNT reflects the total or dissolved analyte concentration. For the 

influent samples where the laboratory conducted a biphasic separation due to high solids content, this 

field identifies whether the AMOUNT reflects the filtrate, solids, or calculated total analyte 

concentration.

Concentrations for Load Calculations - 

Sampling

SCCQUAL Text Analytical qualifier.

Data 01 - Ash Pond Sampling Data mg/L Plant Name Text Name of plant sampled.

Data 01 - Ash Pond Sampling Data mg/L EPISODE Text Numeric code associated with each EPA sampling episode.

Data 01 - Ash Pond Sampling Data mg/L SAMPLE Text Numeric code associated with each sample.

Data 01 - Ash Pond Sampling Data mg/L ANALYTE Text Analyte name.

Data 01 - Ash Pond Sampling Data mg/L CAS_NO Text Analyte-specific Chemical Abstracts Service (CAS) number.

Data 01 - Ash Pond Sampling Data mg/L Concentration Number (Double) Analyte concentration.

Data 01 - Ash Pond Sampling Data mg/L UNITS Text Units associated with Concentration field.

Data 01 - Ash Pond Sampling Data mg/L PROCEDURE Text Field identifying whether the AMOUNT reflects the total or dissolved analyte concentration. For the 

influent samples where the laboratory conducted a biphasic separation due to high solids content, this 

field identifies whether the AMOUNT reflects the filtrate, solids, or calculated total analyte 

concentration.

Data 01 - Ash Pond Sampling Data mg/L Sampling Date Date/Time Date of the sample.

Data 01 - Ash Sampling Data - Updated Source Text Source of the sampling data.

Data 01 - Ash Sampling Data - Updated Plant Identifier Text Unique identifier for each plant sampled.

Data 01 - Ash Sampling Data - Updated Pond Type Text Type of ash pond sampled.

Data 01 - Ash Sampling Data - Updated Plant Name Text Plant name.

Data 01 - Ash Sampling Data - Updated EPISODE Text Numeric code associated with each EPA sampling episode.

Data 01 - Ash Sampling Data - Updated SAMPLE Text Numeric code associated with each sample.

Data 01 - Ash Sampling Data - Updated ANALYTE Text Analyte name.

Data 01 - Ash Sampling Data - Updated CAS_NO Text Analyte-specific Chemical Abstracts Service (CAS) number.

Data 01 - Ash Sampling Data - Updated Concentration Number (Double) Analyte concentration.

Data 01 - Ash Sampling Data - Updated UNITS Text Units associated with Concentration field.

Data 01 - Ash Sampling Data - Updated PROCEDURE Text Field identifying whether the AMOUNT reflects the total or dissolved analyte concentration. For the 

influent samples where the laboratory conducted a biphasic separation due to high solids content, this 

field identifies whether the AMOUNT reflects the filtrate, solids, or calculated total analyte 

concentration.

Data 01 - Ash Sampling Data - Updated Sampling Date Date/Time Date of the sample.

Data 02 - EPRI Data mg/L Source Text Source of the sampling data.

Data 02 - EPRI Data mg/L Plant Identifier Text Unique identifier for each plant sampled.

Data 02 - EPRI Data mg/L Pond Type Text Type of ash pond sampled.

Data 02 - EPRI Data mg/L Analyte Text Analyte name.

Data 02 - EPRI Data mg/L Non-Detect Indicator Text Indicator for samples measured below the detection limit.

Data 02 - EPRI Data mg/L Concentration Number (Double) Analyte concentration.

4 of 9
EPA-HQ-OW-2009-0819-DRAFT-2189

Database Table Name Database Field Name Field Type Text Field Description

Data 02 - EPRI Data mg/L Units Text Units associated with Concentration field.

Data 03 - Form 2C Data mg/L Source Text Source of the sampling data.

Data 03 - Form 2C Data mg/L Plant Identifier Text Unique identifier for each plant sampled.

Data 03 - Form 2C Data mg/L Pond Type Text Type of ash pond sampled.

Data 03 - Form 2C Data mg/L tblForm2CAnalyte_Analyte Text Analyte name.

Data 03 - Form 2C Data mg/L CAS Text Analyte-specific Chemical Abstracts Service (CAS) number.

Data 03 - Form 2C Data mg/L Analyte Name Text Analyte name (abbreviation).

Data 03 - Form 2C Data mg/L Non-Detect Indicator Text Indicator for samples measured below the detection limit.

Data 03 - Form 2C Data mg/L Concentration Number (Double) Analyte concentration.

Data 03 - Form 2C Data mg/L Units Text Units associated with Concentration field.

Data 03 - Form 2C Data mg/L Updated Source Text Source of the sampling data.

Data 03 - Form 2C Data mg/L Updated Plant Identifier Text Unique identifier for each plant sampled.

Data 03 - Form 2C Data mg/L Updated Pond Type Text Type of ash pond sampled.

Data 03 - Form 2C Data mg/L Updated tblForm2CAnalyte_Analyte Text Analyte name.

Data 03 - Form 2C Data mg/L Updated CAS Text Analyte-specific Chemical Abstracts Service (CAS) number.

Data 03 - Form 2C Data mg/L Updated Analyte Name Text Analyte name (abbreviation).

Data 03 - Form 2C Data mg/L Updated Non-Detect Indicator Text Indicator for samples measured below the detection limit.

Data 03 - Form 2C Data mg/L Updated Concentration Number (Double) Analyte concentration.

Data 03 - Form 2C Data mg/L Updated Units Text Units associated with Concentration field.

Data 04 - TDD 1982 Table V-32 Data mg/L Source Text Source of the sampling data.

Data 04 - TDD 1982 Table V-32 Data mg/L Plant Identifier Text Unique identifier for each plant sampled.

Data 04 - TDD 1982 Table V-32 Data mg/L Pond Type Text Type of ash pond sampled.

Data 04 - TDD 1982 Table V-32 Data mg/L Analyte Text Analyte name.

Data 04 - TDD 1982 Table V-32 Data mg/L Non-Detect Indicator Text Indicator for samples measured below the detection limit.

Data 04 - TDD 1982 Table V-32 Data mg/L Concentration Number (Double) Analyte concentration.

Data 04 - TDD 1982 Table V-32 Data mg/L Units Text Units associated with Concentration field.

Data 05 - TDD 1982 Table V-33 Data mg/L Source Text Source of the sampling data.

Data 05 - TDD 1982 Table V-33 Data mg/L Plant Identifier Text Unique identifier for each plant sampled.

Data 05 - TDD 1982 Table V-33 Data mg/L Pond Type Text Type of ash pond sampled.

Data 05 - TDD 1982 Table V-33 Data mg/L Analyte Text Analyte name.

Data 05 - TDD 1982 Table V-33 Data mg/L Non-Detect Indicator Text Indicator for samples measured below the detection limit.

Data 05 - TDD 1982 Table V-33 Data mg/L Concentration Number (Double) Analyte concentration.

5 of 9
EPA-HQ-OW-2009-0819-DRAFT-2189

Database Table Name Database Field Name Field Type Text Field Description

Data 05 - TDD 1982 Table V-33 Data mg/L Units Text Units associated with Concentration field.

Data 06 - TDD 1982 Table V-34 Data mg/L Source Text Source of the sampling data.

Data 06 - TDD 1982 Table V-34 Data mg/L Plant Identifier Text Unique identifier for each plant sampled.

Data 06 - TDD 1982 Table V-34 Data mg/L Pond Type Text Type of ash pond sampled.

Data 06 - TDD 1982 Table V-34 Data mg/L Analyte Text Analyte name.

Data 06 - TDD 1982 Table V-34 Data mg/L Non-Detect Indicator Text Indicator for samples measured below the detection limit.

Data 06 - TDD 1982 Table V-34 Data mg/L Concentration Number (Double) Analyte concentration.

Data 06 - TDD 1982 Table V-34 Data mg/L Units Text Units associated with Concentration field.

Data 07 - Master Table Source Text Source of the sampling data.

Data 07 - Master Table Plant Identifier Text Unique identifier for each plant sampled.

Data 07 - Master Table Pond Type Text Type of ash pond sampled.

Data 07 - Master Table Analyte Name Text Analyte name.

Data 07 - Master Table CAS Text Analyte-specific Chemical Abstracts Service (CAS) number.

Data 07 - Master Table Non-Detect Indicator Binary Indicator for samples measured below the detection limit.

Data 07 - Master Table Concentration Number (Double) Analyte concentration.

Data 07 - Master Table UNITS Text Units associated with Concentration field.

EAD - Master Table - No Combined EIA ID Number (Double) Unique plant identification code associated with the U.S. Energy Information Administration.

EAD - Master Table - No Combined Ash Flow CBI Text Flag to indicate the confidential business information status of the plant-level ash sluice flow rate.

EAD - Master Table - No Combined plant_id Number (Double) Unique EPA Office of Water Survey plant identification number.

EAD - Master Table - No Combined System_ID Text Pond system identification number, assigned in the Steam Electric Survey.

EAD - Master Table - No Combined Influent Text Type of ash sluice, fly ash sluice, bottom ash sluice, or combined ash sluice.

EAD - Master Table - No Combined Pond Type Text Type of ash pond, fly ash pond, bottom ash pond, or combined ash pond.

EAD - Master Table - No Combined Ash Flow (GPD) over 365 

days

Number (Double) Flow rate, in gallons per day, for the influent identified. Flow rate is based on data provided in the 

Steam Electric Survey and normalized for operation over 365 days.

EAD - Master Table - No Combined Calculated Ash Flow Text Flag to indicate ash flows calculated by EPA.

EAD - Master Table - No Combined Analyte Name Text Analyte name.

EAD - Master Table - No Combined CAS Text Analyte-specific Chemical Abstracts Service (CAS) number.

EAD - Master Table - No Combined AvgOfConcentration Number (Double) Average analyte concentration.

EAD - Master Table - No Combined UNITS Text Units associated with AvgOfConcentration field.

EAD - Master Table - No Combined Quantity (kg/day) Number (Double) Mass, in kg/day, of analyte discharged.

EAD - Master Table - No Combined Load (LBY) Number (Double) Mass, in lb/day, of analyte discharged.

EAD - Master Table - No Combined Current TWF Number (Double) Current toxic weighting factor.

EAD - Master Table - No Combined TWPE Number (Double) Calculated toxic weighted pound equivalent.

EPRI Data Source Text Source of the sampling data.

EPRI Data Plant Identifier Text Unique identifier for each plant sampled.

EPRI Data Pond Type Text Type of ash pond sampled.

EPRI Data Analyte Text Analyte name.

EPRI Data Non-Detect Indicator Text Indicator for samples measured below the detection limit.

6 of 9
EPA-HQ-OW-2009-0819-DRAFT-2189

Database Table Name Database Field Name Field Type Text Field Description

EPRI Data Concentration Number (Double) Analyte concentration.

EPRI Data Units Text Units associated with Concentration field.

FA and BA Percentages CAS Text Analyte-specific Chemical Abstracts Service (CAS) number.

FA and BA Percentages Update Analyte Name Text Uniform analyte name.

FA and BA Percentages Fly Ash Percentage Number (Double) Percentage of fly ash in combined ash ponds.

FA and BA Percentages Bottom Ash Percentage Number (Double) Percentage of bottom ash in combined ash ponds.

Fly Ash MW Data Fly Ash Text Flag to identify whether all units producing fly ash are included (i.e., "total").

Fly Ash MW Data plant_id Number (Double) Unique EPA Office of Water Survey plant identification number.

Fly Ash MW Data seunit_id Text Count of generating units producing fly ash.

Fly Ash MW Data ST_capacity Number (Double) Total steam turbine capacity for generating units producing fly ash.

Fly Ash MW Data fly_wetanddry Text Flag to indicate plants conveying fly ash both wet and dry.

Fly Ash MW Data fly_produced_wet_dpy Number (Double) Plant-level wet fly ash production rate in days per year.

Fly Ash MW Data fly_produced_dry_dpy Number (Double) Plant-level dry fly ash production rate in days per year.

Form 2C Data Table Source Text Source of the sampling data.

Form 2C Data Table Plant Identifier Text Unique identifier for each plant sampled.

Form 2C Data Table Pond Type Text Type of ash pond sampled.

Form 2C Data Table tblForm2CAnalyte_Analyte Text Analyte name.

Form 2C Data Table CAS Number 

Listing_Analyte

Text Analyte name as specified by the Chemical Abstract Service (CAS).

Form 2C Data Table CAS Text Analyte-specific Chemical Abstracts Service (CAS) number.

Form 2C Data Table Analyte Name Text Analyte name (abbreviation).

Form 2C Data Table Non-Detect Indicator Text Indicator for samples measured below the detection limit.

Form 2C Data Table Cocentration Number (Double) Analyte concentration.

Form 2C Data Table Units Text Units associated with Concentration field.

Make Final Loads Table - No Combined EIA ID Number (Double) Unique plant identification code associated with the U.S. Energy Information Administration.

Make Final Loads Table - No Combined Ash Flow CBI Text Flag to indicate the confidential business information status of the plant-level ash sluice flow rate.

Make Final Loads Table - No Combined plant_id Number (Double) Unique EPA Office of Water Survey plant identification number.

Make Final Loads Table - No Combined System_ID Text Pond system identification number, assigned in the Steam Electric Survey.

Make Final Loads Table - No Combined Influent Text Type of ash sluice, fly ash sluice, bottom ash sluice, or combined ash sluice.

Make Final Loads Table - No Combined Pond Type Text Type of ash pond, fly ash pond, bottom ash pond, or combined ash pond.

Make Final Loads Table - No Combined Ash Flow (GPD) over 365 

days

Number (Double) Flow rate, in gallons per day, for the influent identified. Flow rate is based on data provided in the 

Steam Electric Survey and normalized for operation over 365 days.

Make Final Loads Table - No Combined surfwater_name Text Name of the surface water where ash sluice is discharged.

Make Final Loads Table - No Combined Calculated Ash Flow Text Flag to indicate ash flows calculated by EPA.

Make Final Loads Table - No Combined Analyte Name Text Analyte name.

Make Final Loads Table - No Combined CAS Text Analyte-specific Chemical Abstracts Service (CAS) number.

Make Final Loads Table - No Combined AvgOfConcentration Number (Double) Average analyte concentration.

Make Final Loads Table - No Combined UNITS Text Units associated with AvgOfConcentration field.

Make Final Loads Table - No Combined Quantity (kg/day) Number (Double) Mass, in kg/day, of analyte discharged.

Make Final Loads Table - No Combined Load (LBY) Number (Double) Mass, in lb/day, of analyte discharged.

Make Final Loads Table - No Combined Current TWF Number (Double) Current toxic weighting factor.

Make Final Loads Table - No Combined TWPE Number (Double) Calculated toxic weighted pound equivalent.

OW_EIAIDs plant_id Number (Double) Unique EPA Office of Water Survey plant identification number.

7 of 9
EPA-HQ-OW-2009-0819-DRAFT-2189

Database Table Name Database Field Name Field Type Text Field Description

OW_EIAIDs eia_id Number (Double) Unique plant identification code associated with the U.S. Energy Information Administration.

POTW Removals CAS # Text Analyte-specific Chemical Abstracts Service (CAS) number.

POTW Removals Chemical Text Chemical name.

POTW Removals POTW Removal Number (Double) Publically Owned Treatment Works removal percentage.

Prams for Loads Analysis Sampling Analyte Text Analyte name as specified in EPA sampling data.

Prams for Loads Analysis Form 2C Analyte Text Analyte name as specified in Form 2C data.

Prams for Loads Analysis Abbreviation Text Analyte name (abbreviation).

Prams for Loads Analysis EPRI Analyte Text Analyte name as specified in EPRI data.

Prams for Loads Analysis Analyte Text Analyte abbreviations.

Prams for Loads Analysis CAS Text Analyte-specific Chemical Abstracts Service (CAS) number.

Prams for Loads Analysis Update Analyte Name Text Analyte name used for loadings output.

TDD 1982 Table V-32 Data Source Text Source of the sampling data.

TDD 1982 Table V-32 Data Plant Identifier Text Unique identifier for each plant sampled.

TDD 1982 Table V-32 Data Pond Type Text Type of ash pond sampled.

TDD 1982 Table V-32 Data Analyte Text Analyte name.

TDD 1982 Table V-32 Data Non-Detect Indicator Text Indicator for samples measured below the detection limit.

TDD 1982 Table V-32 Data Concentration Number (Double) Analyte concentration.

TDD 1982 Table V-32 Data Units Text Units associated with Concentration field.

TDD 1982 Table V-33 Data Source Text Source of the sampling data.

TDD 1982 Table V-33 Data Plant Identifier Text Unique identifier for each plant sampled.

TDD 1982 Table V-33 Data Pond Type Text Type of ash pond sampled.

TDD 1982 Table V-33 Data Analyte Text Analyte name.

TDD 1982 Table V-33 Data Non-Detect Indicator Text Indicator for samples measured below the detection limit.

TDD 1982 Table V-33 Data Concentration Number (Double) Analyte concentration.

TDD 1982 Table V-33 Data Units Text Units associated with Concentration field.

TDD 1982 Table V-34 Data Source Text Source of the sampling data.

TDD 1982 Table V-34 Data Plant Identifier Text Unique identifier for each plant sampled.

TDD 1982 Table V-34 Data Pond Type Text Type of ash pond sampled.

TDD 1982 Table V-34 Data Analyte Text Analyte name.

TDD 1982 Table V-34 Data Non-Detect Indicator Text Indicator for samples measured below the detection limit.

TDD 1982 Table V-34 Data Concentration Number (Double) Analyte concentration.

TDD 1982 Table V-34 Data Units Text Units associated with Concentration field.

TWFs Pollutant Text Analyte name.

TWFs CASNU Text Analyte-specific Chemical Abstracts Service (CAS) number.

TWFs Current TWF Number (Double) Current toxic weighting factor.

TWFs 02/09 TWF Text Toxic weighting factor as of 2/2009

TWFs 11/07 TWF Text Toxic weighting factor as of 11/2007

TWFs 04/06 TWF Number (Double) Toxic weighting factor as of 4/2006

TWFs 12/04 TWF Number (Double) Toxic weighting factor as of 12/2004

TWFs 12/04 no RSC TWF Number (Double) Toxic weighting factor as of 12/2004

TWFs 08/04 TWF Number (Double) Toxic weighting factor as of 8/2004

Update Prams w TWFs Sampling Analyte Text Analyte name as specified in EPA sampling data.

Update Prams w TWFs Form 2C Analyte Text Analyte name as specified in Form 2C data.

Update Prams w TWFs Abbreviation Text Analyte name (abbreviation).

8 of 9
EPA-HQ-OW-2009-0819-DRAFT-2189

Database Table Name Database Field Name Field Type Text Field Description

Update Prams w TWFs EPRI Analyte Text Analyte name as specified in EPRI data.

Update Prams w TWFs Analyte Text Analyte abbreviations.

Update Prams w TWFs CAS Text Analyte-specific Chemical Abstracts Service (CAS) number.

Update Prams w TWFs Current TWF Number (Double) Current toxic weighting factor.

Update Prams w TWFs Updated Name Text Analyte name used for loadings output.

9 of 9