## 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. **As h 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 analy te-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. BottomAsh MWData 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 Analy te-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 com bined ash pond. Concentrations for Load Calculations - Sam pling 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 analy te-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 Analy te-level breakout of combined ash loadings. Fly Ash MWData 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 analy te-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 OWplant identification number from the SteamElectric Survey

and U.S. Energy

Information Administration (EIA) identification number. POTWRemovals Analy te-level list of publically owned treatment works (POTW) removals. Prams for Loads Analysis Analy te 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 Analy te-level list of toxic weighting factors (TWFs). Update Prams w TW Fs Analy te name and TW F 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 TW F 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 MWData Bottom Ash Text Flag to identify whether all units producing bottom ash are included (i.e., "total"). Bottom Ash MWData plant_id Number (Double) Unique EPA Office of Water Survey plant identification number. Bottom Ash MWData seunit_id Text Count of generating units producing bottom ash. Bottom Ash MWData ST_capacity Number (Double) Total steam turbine capacity for generating units producing bottom ash. Bottom Ash MWData btm_wetanddry Text Flag to indicate plants conveying bottom ash both wet and dry. Bottom Ash MWData btm_produced_wet_dpy Number (Double) Plant-level total wet bottom ash production rate in days per year. Bottom Ash MWData 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 TW F 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 TW F 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 TW F 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 MWData Fly Ash Text Flag to identify whether all units producing fly ash are included (i.e., "total"). Fly Ash MWData plant_id Number (Double) Unique EPA Office of Water Survey plant identification number. Fly Ash MWData seunit_id Text Count of generating units producing fly ash. Fly Ash MWData ST_capacity Number (Double) Total steam turbine capacity for generating units producing fly ash. Fly Ash MWData fly_wetanddry Text Flag to indicate plants conveying fly ash both wet and dry. Fly Ash MWData fly_produced_wet_dpy Number (Double) Plant-level wet fly ash production rate in days per year. Fly Ash MWData 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 TW F 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. POTWRemovals CAS # Text Analyte-specific Chemical Abstracts Service (CAS) number. POTWRemovals Chemical Text Chemical name. POTWRemovals POTWRemoval 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 TW F Number (Double) Current toxic weighting factor. TWFs 02/09 TW F Text Toxic weighting factor as of 2/2009 TWFs 11/07 TW F Text Toxic weighting factor as of 11/2007 TWFs 04/06 TW F Number (Double) Toxic weighting factor as of 4/2006 TWFs 12/04 TW F Number (Double) Toxic weighting factor as of 12/2004 TWFs 12/04 no RSC TW F Number (Double) Toxic weighting factor as of 12/2004 TWFs 08/04 TW F Number (Double) Toxic weighting factor as of 8/2004 Update Prams w TW Fs Sampling Analyte Text Analyte name as specified in EPA sampling data. Update Prams w TW Fs Form 2C Analyte Text Analyte name as specified in Form 2C data. Update Prams w TW Fs 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 TW Fs EPRI Analyte Text Analyte name as specified in EPRI data. Update Prams w TW Fs Analyte Text Analyte abbreviations. Update Prams w TW Fs CAS Text Analyte-specific Chemical Abstracts Service (CAS) number. Update Prams w TW Fs Current TW F Number (Double) Current toxic weighting factor. Update Prams w TW Fs Updated Name Text Analyte name used for loadings output.



### 9 of 9