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 of 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.

This MS Excel file is the data element dictionary that provides a description of the data elements contained within the FGD Wastewater Loadings Model. The 

elements of the dictionary include: 

Tables: Provides a listing of all tables found within the FGD Wastewater 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 FGD Wastewater 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).

Flue Gas Desulfurization (FGD) Wastewater Loadings Model Data Element Dictionary - Summary

4/19/2013

The primary purpose of the FGD Wastewater Loadings Model (DCN SE02900) is to calculate the plant-specific pollutant loadings for the technology options 

being evaluated as part of the Steam Electric Effluent Limitations Guideline. As part of the pollutant loadings calculations, average effluent concentrations for 

each technology option were developed. This database also includes calculations used to estimate an average effluent concentration for chemical precipitation, 

biological treatment, and vapor-compression evaporation. The average effluent concentration of FGD settling ponds is calculated in a separate loadings model 

(FGD Settling Pond Concentrations Loadings Model DCN SE02902).

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 of the technology 

options. The report also provides a description of 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 technology option.
Database Table Name Description

Analyte CAS Crosswalk Crosswalk between analyte name and Chemical Abstracts Service (CAS) number

Bio Sample Numbers List of sample numbers from EPA sampling episodes and CWA 308 sampling events for biological 

treatment effluent from plants demonstrating best available technology (BAT).

Conc Data 01: Final Bio Concentration Average biological treatment effluent concentration.

Conc Data 02: Final CP Concentration Average chemical precipitation effluent concentration.

Conc Data 03: Final MVC Concentration Average vapor-compression evaporation effluent concentration.

Conc Data 04: Average Pond Effluent Conc Average FGD settling pond effluent concentration.

CP Sample Numbers List of sample numbers from EPA sampling episodes and CWA 308 sampling events for chemical 

precipitation effluent from plants demonstrating best available technology (BAT).

Data 00: Combined Data A combined listing of all sampling data gathered through EPA's sampling efforts conducted as part of 

the Steam Rulemaking.

Data 01: Bio Data A list of the subset of sampling data for the BAT biological treatment effluent.

Data 01a: Bio Data with Dup Average A list of the biological treatment effluent sampling data with the duplicate samples averaged together.

Data 01b: Bio RPD Sampling data for all biological treatment effluent samples taken on the same day as the duplicate 

samples. This table also includes results for the relative percent difference analysis.

Data 01c: Bio FB A list of the field blank samples associated with biological treatment effluent data. This table also 

includes results for the field blank analysis.

Data 01d: Bio data after Dup and FB All biological treatment effluent data from Data 01a combined with the results from the field blank 

analysis to incorporate any changes to concentrations or qualifiers resulting from the analysis.

Data 01e: Matching Bio Results Listing of all EPA sampling data for analytes that were also included in the industry provided sampling 

data.

Data 01f: Unmatched Bio Results Listing of all EPA sampling data for analytes that were not included in the industry provided sampling 

data.

Data 01g: Bio Conc Data Plant-level average concentrations by sampling event.

Data 01h: Matching Bio Results - Date Avg All data from Data 01e with any results occurring on the same day averaged together.

Data 02: CP Data A list of the subset of sampling data for the BAT chemical precipitation effluent.

Data 02a: CP Data with Dup Average A list of the chemical precipitation effluent sampling data with the duplicate samples averaged together.

Data 02b: CP RPD Sampling data for all chemical precipitation effluent samples taken on the same day as the duplicate 

samples. This table also includes results for the relative percent difference analysis.

Data 02c: CP FB A list of the field blank samples associated with chemical precipitation effluent data. This table also 

includes results for the field blank analysis.

Data 02d: CP data after Dup and FB All chemical precipitation effluent data from Data 02a combined with the results from the field blank 

analysis to incorporate any changes to concentrations or qualifiers resulting from the analysis.
Database Table Name Description

Data 03: MVC Data A list of the subset of sampling data for the BAT vapor-compression evaporation effluent.

Data 03a: MVC FB A list of the field blank samples associated with vapor-compression evaporation effluent data. This 

table also includes results for the field blank analysis.

Data 03b: MVC data after FB All vapor-compression evaporation effluent data from Data 03a combined with the results from the field 

blank analysis to incorporate any changes to concentrations or qualifiers resulting from the analysis.

Duplicate Crosswalk Crosswalk between actual sample number and the duplicate sample number.

EIA_ID Crosswalk between EPA OW plant identification number from the Steam Electric Survey and U.S. 

Energy Information Administration (EIA) identification number.

FGD Cost Matrix Table listing all plants discharging FGD wastewater and the level of wastewater treatment, currently

and for each technology option being evaluated.

FGD_Flow_Data Table of plant-level input data used to calculate pollutant loadings. This table includes FGD wastewater 

flow rate and surface water information.

Loads 01: Baseline Loads Plant-specific analyte-level loadings for the baseline scenario.

Loads 02: CP Loads Plant-specific analyte-level loadings for the chemical precipitation treatment option.

Loads 03: Bio Loads Plant-specific analyte-level loadings for the biological treatment option.

Loads 04: MVC Loads Plant-specific analyte-level loadings for the vapor-compression evaporation treatment option.

MVC Sample Numbers List of sample numbers from EPA sampling episodes and CWA 308 sampling events for vaporcompression evaporation effluent from plants demonstrating best available technology (BAT).

POTW Removal Crosswalk Crosswalk between the analyte name as it's listed in the sampling data and the analyte name as it's 

listed in the POTW data.

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

Qualifiers Reasons Crosswalk between qualifiers and the detailed description.

Sample Numbers with Dates List of all samples collected by EPA as part of the Steam Rulemaking, includes sample numbers, 

descriptions, type of wastewater, and date information.

T1: Mercury EPA Sampling Data All mercury sampling data collected during EPA sampling episodes.

T1: Mercury LTM Data All mercury sampling data collected during CWA 308 sampling activities.

T2: Metals EPA Sampling Data All metals sampling data (except mercury) collected during EPA sampling episodes.

T2: Metals LTM Data All metals sampling data (except mercury) collected during CWA 308 sampling activities.

T3: Classicals EPA Sampling Data All classicals sampling data collected during EPA sampling episodes.

T3: Classicals LTM Data All classicals sampling data collected during CWA 308 sampling activities.

T4: Belews Creek Additional Data All industry-provided sampling data for Belews Creek.

T5: Allen Additional Data All industry-provided sampling data for Allen.

TWF Crosswalk Crosswalk between the analyte name as it's listed in the sampling data and the analyte name as it's 

listed in the TWF table.

TWFs Analyte-level list of toxic weighting factors (TWFs).
EPA-HQ-OW-2009-0819-DRAFT-2188

Database Table Name Database Field Name Field Type Text Field Description

Analyte CAS Crosswalk Analyte Text List of analyte names.

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

Bio Sample Numbers Plant Text Name of plants sampled for biological treatment technology.

Bio Sample Numbers Type Text Type of sampling event (either EPA sampling or Long-Term Monitoring (LTM)).

Bio Sample Numbers Sampling Episode Number Text Numeric code associated with each EPA sampling episode or CWA 308 sampling event used to calculate average biological treatment 

effluent concentration.

Bio Sample Numbers Sample Number Text Numeric code associated with each sample used to calculate average biological treatment effluent concentration.

Bio Sample Numbers Sample Point Text Sampling point identifier. These values correspond to the sampling episode reports for each sampling event.

Bio Sample Numbers Sample Description Text Description of the type of wastewater sampled.

Conc Data 01: Final Bio Concentration ANALYTE Text List of analytes for biological treatment concentration data set.

Conc Data 01: Final Bio Concentration AMOUNT Number (Double) Biological treatment effluent concentration.

Conc Data 01: Final Bio Concentration UNITS Text Units associated with the amount field

Conc Data 01: Final Bio Concentration Treatment Text Type of treatment, flagged as bio. Used for plant-specific loadings calculations.

Conc Data 02: Final CP Concentration ANALYTE Text List of analytes for chemical precipitation concentration data set.

Conc Data 02: Final CP Concentration CAS_NO Text Analyte-specific Chemical Abstracts Service (CAS) number.

Conc Data 02: Final CP Concentration AMOUNT Number (Double) Chemical precipitation effluent concentration.

Conc Data 02: Final CP Concentration UNITS Text Units associated with the amount field

Conc Data 02: Final CP Concentration Treatment Text Type of treatment, flagged as chemical precipitation. Used for plant-specific loadings calculations.

Conc Data 03: Final MVC Concentration ANALYTE Text List of analytes for vapor compression evaporation concentration data set.

Conc Data 03: Final MVC Concentration CAS_NO Text Analyte-specific Chemical Abstracts Service (CAS) number.

Conc Data 03: Final MVC Concentration Avg_MVC Number (Double) Vapor-compression evaporation effluent concentration.

Conc Data 03: Final MVC Concentration UNITS Text Units associated with the Avg_MVC.

Conc Data 03: Final MVC Concentration Treatment Text Type of treatment, flagged as MVC (mechanical vapor compression, also referred to as vapor-compression evaporation). Used for plantspecific loadings calculations.

Conc Data 04: Average Pond Effluent Conc Analyte Text List of analytes for FGD settling pond concentration data set.

Conc Data 04: Average Pond Effluent Conc Amount Number (Double) FGD settling pond effluent concentration. Blank records indicate that no data is available for the specific analyte, resulting in no average 

concentration value.

Conc Data 04: Average Pond Effluent Conc Units Text Units associated with the amount field

Conc Data 04: Average Pond Effluent Conc Treatment Text Type of treatment, flagged as pond. Used for plant-specific loadings calculations.

CP Sample Numbers Plant Text Name of plants sampled for chemical precipitation technology.

CP Sample Numbers Type Text Type of sampling event (either EPA sampling or Long-Term Monitoring (LTM)).

CP Sample Numbers Sampling Episode Number Text Numeric code associated with each EPA sampling episode or CWA 308 sampling event used to calculate average chemical precipitation 

effluent concentration.

CP Sample Numbers Sample Number Text Numeric code associated with each sample used to calculate average chemical precipitation effluent concentration.

CP Sample Numbers Sample Point Text Sampling point identifier. These values correspond to the sampling episode reports for each sampling event.

CP Sample Numbers Sample Description Text Description of the type of wastewater sampled.

Data 00: Combined Data EPISODE Text Numeric code associated with each EPA sampling episode or CWA 308 sampling event.

Data 00: Combined Data SAMPLE Text Numeric code associated with each sample.

Data 00: Combined Data LAB NAME Text Abbreviation for the lab analyzing the sample.

Data 00: Combined Data ANALYTE Text Name of the analyte measured.

Data 00: Combined Data CAS_NO Text Analyte-specific Chemical Abstracts Service (CAS) number.

Data 00: Combined Data METHOD Text Analytical method used to measure the concentration.

Data 00: Combined 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.

Data 00: Combined Data TYPE Text Type of sampling event (either EPA sampling or Long-Term Monitoring (LTM)).

Data 00: Combined Data UNITS Text Units associated with the amount, MDL, RL, and dilution fields.

Data 00: Combined Data AMOUNT Text Analyte concentration.

Data 00: Combined Data MDL Text Method detection limit.

Data 00: Combined Data RL Text Reporting limit.

Data 00: Combined Data DILUTION Text Dilution factor.

Data 00: Combined Data QUALIFIERS Text Analytical qualifiers.

Data 00: Combined Data REASON Memo Explanation for each analytical qualifier.

Data 01: Bio Data EPISODE Text Numeric code associated with each EPA sampling episode or CWA 308 sampling event.

Data 01: Bio Data SAMPLE Text Numeric code associated with each sample. This table only includes those samples associated with biological treatment effluent data.

Data 01: Bio Data LAB NAME Text Abbreviation for the lab analyzing the sample.

Data 01: Bio Data ANALYTE Text Name of the analyte measured.

Data 01: Bio Data CAS_NO Text Analyte-specific Chemical Abstracts Service (CAS) number.

Data 01: Bio Data METHOD Text Analytical method used to measure the concentration.

1 of 11
EPA-HQ-OW-2009-0819-DRAFT-2188

Database Table Name Database Field Name Field Type Text Field Description

Data 01: Bio 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.

Data 01: Bio Data TYPE Text Type of sampling event (either EPA sampling or Long-Term Monitoring (LTM)).

Data 01: Bio Data UNITS Text Units associated with the amount, MDL, RL, and dilution fields.

Data 01: Bio Data AMOUNT Number (Double) Analyte concentration.

Data 01: Bio Data MDL Text Method detection limit.

Data 01: Bio Data RL Text Reporting limit.

Data 01: Bio Data DILUTION Text Dilution factor.

Data 01: Bio Data QUALIFIERS Text Analytical qualifiers.

Data 01: Bio Data REASON Memo Explanation for each analytical qualifier.

Data 01a: Bio Data with Dup Average EPISODE Text Numeric code associated with each EPA sampling episode or CWA 308 sampling event.

Data 01a: Bio Data with Dup Average SAMPLE Text Numeric code associated with each sample. This table includes all data from Data 01: Bio Data with the exception of duplicates.

Data 01a: Bio Data with Dup Average LAB NAME Text Abbreviation for the lab analyzing the sample.

Data 01a: Bio Data with Dup Average ANALYTE Text Name of the analyte measured.

Data 01a: Bio Data with Dup Average CAS_NO Text Analyte-specific Chemical Abstracts Service (CAS) number.

Data 01a: Bio Data with Dup Average METHOD Text Analytical method used to measure the concentration.

Data 01a: Bio Data with Dup Average 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 01a: Bio Data with Dup Average TYPE Text Type of sampling event (either EPA sampling or Long-Term Monitoring (LTM)).

Data 01a: Bio Data with Dup Average UNITS Text Units associated with the AvgofAMOUNT, AvgofMDL, and AvgofRL.

Data 01a: Bio Data with Dup Average AvgOfAMOUNT Number (Double) Analyte concentration. Average concentration for samples collected on the same day (original sample and duplicate sample).

Data 01a: Bio Data with Dup Average AvgOfMDL Number (Double) Method detection limit. Average method detection limit for samples collected on the same day (original sample and duplicate sample).

Data 01a: Bio Data with Dup Average AvgOfRL Number (Double) Reporting limit. Average reporting limit for samples collected on the same day (original sample and duplicate sample).

Data 01b: Bio RPD EPISODE Text Numeric code associated with each EPA sampling episode or CWA 308 sampling event.

Data 01b: Bio RPD SAMPLE Text Numeric code associated with each sample. This table only includes those biological treatment samples associated with original samples 

taken on the same day as duplicate samples.

Data 01b: Bio RPD LAB NAME Text Abbreviation for the lab analyzing the sample.

Data 01b: Bio RPD ANALYTE Text Name of the analyte measured.

Data 01b: Bio RPD CAS_NO Text Analyte-specific Chemical Abstracts Service (CAS) number.

Data 01b: Bio RPD METHOD Text Analytical method used to measure the concentration.

Data 01b: Bio RPD 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 01b: Bio RPD TYPE Text Type of sampling event (either EPA sampling or Long-Term Monitoring (LTM)).

Data 01b: Bio RPD UNITS Text Units associated with the amount, MDL, RL, and dilution fields.

Data 01b: Bio RPD AMOUNT Text Analyte concentration.

Data 01b: Bio RPD MDL Text Method detection limit.

Data 01b: Bio RPD RL Text Reporting limit.

Data 01b: Bio RPD DILUTION Text Dilution factor.

Data 01b: Bio RPD QUALIFIERS Text Analytical qualifiers.

Data 01b: Bio RPD REASON Memo Explanation for each analytical qualifier.

Data 01b: Bio RPD NonDup Amount Number (Double) Analyte concentration associated with the original sample taken on the same day as the duplicate sample.

Data 01b: Bio RPD Dup Amount Number (Double) Analyte concentration associated with the duplicate sample.

Data 01b: Bio RPD Dup Qualifier Text Analytical qualifier associated with the duplicate sample.

Data 01b: Bio RPD Average Number (Double) Average of NonDup Amount and Dup Amount.

Data 01b: Bio RPD Difference Number (Double) Difference between NonDup Amount and Dup Amount.

Data 01b: Bio RPD RPD Number (Double) Relative percent difference.

Data 01b: Bio RPD Loads Qualifier Text New analytical qualifier based on the relative percent difference of the NonDup Amount and Dup Amount.

Data 01c: Bio FB EPISODE Text Numeric code associated with each EPA sampling episode or CWA 308 sampling event.

Data 01c: Bio FB FB SAMPLE Text Numeric code associated with each sample. This table only includes those biological treatment samples associated with field blank 

samples.

Data 01c: Bio FB LAB NAME Text Abbreviation for the lab analyzing the sample.

Data 01c: Bio FB ANALYTE Text Name of the analyte measured.

Data 01c: Bio FB CAS_NO Text Analyte-specific Chemical Abstracts Service (CAS) number.

Data 01c: Bio FB METHOD Text Analytical method used to measure the concentration.

2 of 11
EPA-HQ-OW-2009-0819-DRAFT-2188

Database Table Name Database Field Name Field Type Text Field Description

Data 01c: Bio FB 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 01c: Bio FB TYPE Text Type of sampling event (either EPA sampling or Long-Term Monitoring (LTM)).

Data 01c: Bio FB UNITS Text Units associated with the amount, MDL, RL, and dilution fields.

Data 01c: Bio FB AMOUNT Text Analyte concentration.

Data 01c: Bio FB MDL Text Method detection limit.

Data 01c: Bio FB RL Text Reporting limit.

Data 01c: Bio FB DILUTION Text Dilution factor.

Data 01c: Bio FB QUALIFIERS Text Analytical qualifiers.

Data 01c: Bio FB REASON Memo Explanation for each analytical qualifier.

Data 01c: Bio FB FB_Amount Number (Double) Analyte concentration associated with the field blank sample.

Data 01c: Bio FB NonFB_Amount Number (Double) Analyte concentration associated with the wastewater sample taken on the same day as the field blank.

Data 01c: Bio FB NonFB_Qualifier Text Analytical qualifier associated with the wastewater sample taken on the same day as the field blank.

Data 01c: Bio FB 5xFB Number (Double) Five times the analyte concentration associated with the field blank sample.

Data 01c: Bio FB 10xFB Number (Double) Ten times the analyte concentration associated with the field blank sample.

Data 01c: Bio FB New_Amount Number (Double) New analyte concentration associated with the wastewater sample taken on the same day as the field blank based on the field blank 

analysis.

Data 01c: Bio FB FB Qualifier Text New analytical qualifier associated with the wastewater sample taken on the same day as the field blank based on the field blank analysis.

Data 01c: Bio FB SAMPLE Text Numeric code associated with the biological treatment effluent wastewater sample taken on the same day as the field blank.

Data 01d: Bio data after Dup and FB PLANT Text Plant name.

Data 01d: Bio data after Dup and FB EPISODE Text Numeric code associated with each EPA sampling episode or CWA 308 sampling event.

Data 01d: Bio data after Dup and FB SAMPLE Text Numeric code associated with each sample. This table only includes those samples associated with original samples for biological 

treatment.

Data 01d: Bio data after Dup and FB LAB NAME Text Abbreviation for the lab analyzing the sample.

Data 01d: Bio data after Dup and FB ANALYTE Text Name of the analyte measured.

Data 01d: Bio data after Dup and FB CAS_NO Text Analyte-specific Chemical Abstracts Service (CAS) number.

Data 01d: Bio data after Dup and FB METHOD Text Analytical method used to measure the concentration.

Data 01d: Bio data after Dup and FB 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 01d: Bio data after Dup and FB TYPE Text Type of sampling event (either EPA sampling or Long-Term Monitoring (LTM)).

Data 01d: Bio data after Dup and FB UNITS Text Units associated with the amount field.

Data 01d: Bio data after Dup and FB AMOUNT Number (Double) Analyte concentration. The concentration presented here takes into account the results of the duplicate analysis and the field blank 

analysis.

Data 01d: Bio data after Dup and FB Dup Qualifier Text Analytical qualifier resulting from the duplicate analysis, if applicable.

Data 01d: Bio data after Dup and FB FB Qualifier Text Analytical qualifier resulting from the field blank analysis, if applicable.

Data 01e: Matching Bio Results PLANT Text Plant name.

Data 01e: Matching Bio Results EPISODE Text Numeric code associated with each EPA sampling episode or CWA 308 sampling event.

Data 01e: Matching Bio Results SAMPLE Text Numeric code associated with each sample. 

Data 01e: Matching Bio Results LAB NAME Text Abbreviation for the lab analyzing the sample.

Data 01e: Matching Bio Results ANALYTE Text Name of the analyte measured. This table includes all results for analytes included in EPA sampling, CWA 308 sampling and plant-self 

monitoring.

Data 01e: Matching Bio Results CAS_NO Text Analyte-specific Chemical Abstracts Service (CAS) number.

Data 01e: Matching Bio Results METHOD Text Analytical method used to measure the concentration.

Data 01e: Matching Bio Results 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 01e: Matching Bio Results TYPE Text Type of sampling event (either EPA sampling or Long-Term Monitoring (LTM)).

Data 01e: Matching Bio Results UNITS Text Units associated with the amount field.

Data 01e: Matching Bio Results AMOUNT Number (Double) Analyte concentration.

Data 01e: Matching Bio Results Date Text Date the sample was taken.

Data 01f: Unmatched Bio Results PLANT Text Plant name.

Data 01f: Unmatched Bio Results EPISODE Text Numeric code associated with each EPA sampling episode or CWA 308 sampling event.

Data 01f: Unmatched Bio Results SAMPLE Text Numeric code associated with each sample. 

Data 01f: Unmatched Bio Results LAB NAME Text Abbreviation for the lab analyzing the sample.

Data 01f: Unmatched Bio Results Data 01d: Bio data after Dup and FB_ANALYTE Text Name of the analyte measured. This table includes all results for analytes included in EPA sampling, CWA 308 sampling but not plant-self 

monitoring.

Data 01f: Unmatched Bio Results CAS_NO Text Analyte-specific Chemical Abstracts Service (CAS) number.

Data 01f: Unmatched Bio Results METHOD Text Analytical method used to measure the concentration.

3 of 11
EPA-HQ-OW-2009-0819-DRAFT-2188

Database Table Name Database Field Name Field Type Text Field Description

Data 01f: Unmatched Bio Results 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 01f: Unmatched Bio Results TYPE Text Type of sampling event (either EPA sampling or Long-Term Monitoring (LTM)).

Data 01f: Unmatched Bio Results UNITS Text Units associated with the amount field.

Data 01f: Unmatched Bio Results AMOUNT Number (Double) Analyte concentration.

Data 01f: Unmatched Bio Results T4: Belews Creek Additional Data_ANALYTE Text Date the sample was taken.

Data 01g: Bio Conc Data ANALYTE Text Name of the analyte measured.

Data 01g: Bio Conc Data AMOUNT Number (Double) Analyte concentration. This table includes the plant-level biological treatment effluent concentration.

Data 01g: Bio Conc Data UNITS Text Units associated with the amount field.

Data 01g: Bio Conc Data Plant Text Plant name.

Data 01h: Matching Bio Results - Date Avg PLANT Text Plant name.

Data 01h: Matching Bio Results - Date Avg Date Text Date the sample was taken.

Data 01h: Matching Bio Results - Date Avg 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 01h: Matching Bio Results - Date Avg ANALYTE Text Name of the analyte measured.

Data 01h: Matching Bio Results - Date Avg AvgOfAMOUNT Number (Double) Average concentration for all results taken on the date from Data 01e: Matching Bio Results.

Data 01h: Matching Bio Results - Date Avg UNITS Text Units associated with the AvgofAMOUNT field.

Data 02: CP Data EPISODE Text Numeric code associated with each EPA sampling episode or CWA 308 sampling event.

Data 02: CP Data SAMPLE Text Numeric code associated with each sample. This table only includes those samples associated with chemical precipitation effluent data.

Data 02: CP Data LAB NAME Text Abbreviation for the lab analyzing the sample.

Data 02: CP Data ANALYTE Text Name of the analyte measured.

Data 02: CP Data CAS_NO Text Analyte-specific Chemical Abstracts Service (CAS) number.

Data 02: CP Data METHOD Text Analytical method used to measure the concentration.

Data 02: CP 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.

Data 02: CP Data TYPE Text Type of sampling event (either EPA sampling or Long-Term Monitoring (LTM)).

Data 02: CP Data UNITS Text Units associated with the amount, MDL, RL, and dilution fields.

Data 02: CP Data AMOUNT Number (Double) Analyte concentration.

Data 02: CP Data MDL Text Method detection limit.

Data 02: CP Data RL Text Reporting limit.

Data 02: CP Data DILUTION Text Dilution factor.

Data 02: CP Data QUALIFIERS Text Analytical qualifiers.

Data 02: CP Data REASON Memo Explanation for each analytical qualifier.

Data 02a: CP Data with Dup Average EPISODE Text Numeric code associated with each EPA sampling episode or CWA 308 sampling event.

Data 02a: CP Data with Dup Average SAMPLE Text Numeric code associated with each sample. This table includes all data from Data 02: CP Data with the exception of duplicates.

Data 02a: CP Data with Dup Average LAB NAME Text Abbreviation for the lab analyzing the sample.

Data 02a: CP Data with Dup Average ANALYTE Text Name of the analyte measured.

Data 02a: CP Data with Dup Average CAS_NO Text Analyte-specific Chemical Abstracts Service (CAS) number.

Data 02a: CP Data with Dup Average METHOD Text Analytical method used to measure the concentration.

Data 02a: CP Data with Dup Average 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 02a: CP Data with Dup Average TYPE Text Type of sampling event (either EPA sampling or Long-Term Monitoring (LTM)).

Data 02a: CP Data with Dup Average UNITS Text Units associated with the AvgofAMOUNT, AvgofMDL, and AvgofRL.

Data 02a: CP Data with Dup Average AvgOfAMOUNT Number (Double) Analyte concentration. Average concentration for samples collected on the same day (original sample and duplicate sample).

Data 02a: CP Data with Dup Average AvgOfMDL Number (Double) Method detection limit. Average method detection limit for samples collected on the same day (original sample and duplicate sample).

Data 02a: CP Data with Dup Average AvgOfRL Number (Double) Reporting limit. Average reporting limit for samples collected on the same day (original sample and duplicate sample).

Data 02b: CP RPD EPISODE Text Numeric code associated with each EPA sampling episode or CWA 308 sampling event.

Data 02b: CP RPD SAMPLE Text Numeric code associated with each sample. This table only includes those chemical precipitation samples associated with original 

samples taken on the same day as duplicate samples.

Data 02b: CP RPD LAB NAME Text Abbreviation for the lab analyzing the sample.

Data 02b: CP RPD ANALYTE Text Name of the analyte measured.

Data 02b: CP RPD CAS_NO Text Analyte-specific Chemical Abstracts Service (CAS) number.

Data 02b: CP RPD METHOD Text Analytical method used to measure the concentration.

4 of 11
EPA-HQ-OW-2009-0819-DRAFT-2188

Database Table Name Database Field Name Field Type Text Field Description

Data 02b: CP RPD 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 02b: CP RPD TYPE Text Type of sampling event (either EPA sampling or Long-Term Monitoring (LTM)).

Data 02b: CP RPD UNITS Text Units associated with the amount, MDL, RL, and dilution fields.

Data 02b: CP RPD AMOUNT Text Analyte concentration.

Data 02b: CP RPD MDL Text Method detection limit.

Data 02b: CP RPD RL Text Reporting limit.

Data 02b: CP RPD DILUTION Text Dilution factor.

Data 02b: CP RPD QUALIFIERS Text Analytical qualifiers.

Data 02b: CP RPD REASON Memo Explanation for each analytical qualifier.

Data 02b: CP RPD NonDup Amount Number (Double) Analyte concentration associated with the original sample taken on the same day as the duplicate sample.

Data 02b: CP RPD Dup Amount Number (Double) Analyte concentration associated with the duplicate sample.

Data 02b: CP RPD Dup Qualifier Text Analytical qualifier associated with the duplicate sample.

Data 02b: CP RPD Average Number (Double) Average of NonDup Amount and Dup Amount.

Data 02b: CP RPD Difference Number (Double) Difference between NonDup Amount and Dup Amount.

Data 02b: CP RPD RPD Number (Double) Relative percent difference.

Data 02b: CP RPD Loads Qualifier Text New analytical qualifier based on the relative percent difference of the NonDup Amount and Dup Amount.

Data 02c: CP FB EPISODE Text Numeric code associated with each EPA sampling episode or CWA 308 sampling event.

Data 02c: CP FB FB SAMPLE Text Numeric code associated with each sample. This table only includes those chemical precipitation samples associated with field blank 

samples.

Data 02c: CP FB LAB NAME Text Abbreviation for the lab analyzing the sample.

Data 02c: CP FB ANALYTE Text Name of the analyte measured.

Data 02c: CP FB CAS_NO Text Analyte-specific Chemical Abstracts Service (CAS) number.

Data 02c: CP FB METHOD Text Analytical method used to measure the concentration.

Data 02c: CP FB 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 02c: CP FB TYPE Text Type of sampling event (either EPA sampling or Long-Term Monitoring (LTM)).

Data 02c: CP FB UNITS Text Units associated with the amount, MDL, RL, and dilution fields.

Data 02c: CP FB AMOUNT Text Analyte concentration.

Data 02c: CP FB MDL Text Method detection limit.

Data 02c: CP FB RL Text Reporting limit.

Data 02c: CP FB DILUTION Text Dilution factor.

Data 02c: CP FB QUALIFIERS Text Analytical qualifiers.

Data 02c: CP FB REASON Memo Explanation for each analytical qualifier.

Data 02c: CP FB FB_Amount Number (Double) Analyte concentration associated with the field blank sample.

Data 02c: CP FB NonFB_Amount Number (Double) Analyte concentration associated with the wastewater sample taken on the same day as the field blank.

Data 02c: CP FB 5xFB Number (Double) Five times the analyte concentration associated with the field blank sample.

Data 02c: CP FB 10xFB Number (Double) Ten times the analyte concentration associated with the field blank sample.

Data 02c: CP FB New_Amount Number (Double) New analyte concentration associated with the wastewater sample taken on the same day as the field blank based on the field blank 

analysis.

Data 02c: CP FB FB Qualifier Text New analytical qualifier associated with the wastewater sample taken on the same day as the field blank based on the field blank analysis.

Data 02c: CP FB SAMPLE Text Numeric code associated with the chemical precipitation effluent wastewater sample taken on the same day as the field blank.

Data 02d: CP data after Dup and FB EPISODE Text Numeric code associated with each EPA sampling episode or CWA 308 sampling event.

Data 02d: CP data after Dup and FB SAMPLE Text Numeric code associated with each sample. This table only includes those samples associated with original samples for chemical 

precipitation effluent.

Data 02d: CP data after Dup and FB LAB NAME Text Abbreviation for the lab analyzing the sample.

Data 02d: CP data after Dup and FB ANALYTE Text Name of the analyte measured.

Data 02d: CP data after Dup and FB CAS_NO Text Analyte-specific Chemical Abstracts Service (CAS) number.

Data 02d: CP data after Dup and FB METHOD Text Analytical method used to measure the concentration.

Data 02d: CP data after Dup and FB 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 02d: CP data after Dup and FB TYPE Text Type of sampling event (either EPA sampling or Long-Term Monitoring (LTM)).

Data 02d: CP data after Dup and FB UNITS Text Units associated with the amount field.

Data 02d: CP data after Dup and FB AMOUNT Number (Double) Analyte concentration. The concentration presented here takes into account the results of the duplicate analysis and the field blank 

analysis.

Data 02d: CP data after Dup and FB Dup Qualifier Text Analytical qualifier resulting from the duplicate analysis, if applicable.

Data 02d: CP data after Dup and FB FB Qualifier Text Analytical qualifier resulting from the field blank analysis, if applicable.

5 of 11
EPA-HQ-OW-2009-0819-DRAFT-2188

Database Table Name Database Field Name Field Type Text Field Description

Data 03: MVC Data EPISODE Text Numeric code associated with each EPA sampling episode or CWA 308 sampling event.

Data 03: MVC Data SAMPLE Text Numeric code associated with each sample. This table only includes those samples associated with vapor-compression evaporation 

effluent data.

Data 03: MVC Data LAB NAME Text Abbreviation for the lab analyzing the sample.

Data 03: MVC Data ANALYTE Text Name of the analyte measured.

Data 03: MVC Data CAS_NO Text Analyte-specific Chemical Abstracts Service (CAS) number.

Data 03: MVC Data METHOD Text Analytical method used to measure the concentration.

Data 03: MVC 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.

Data 03: MVC Data TYPE Text Type of sampling event (either EPA sampling or Long-Term Monitoring (LTM)).

Data 03: MVC Data UNITS Text Units associated with the amount, MDL, RL, and dilution fields.

Data 03: MVC Data AMOUNT Text Analyte concentration.

Data 03: MVC Data MDL Text Method detection limit.

Data 03: MVC Data RL Text Reporting limit.

Data 03: MVC Data DILUTION Text Dilution factor.

Data 03: MVC Data QUALIFIERS Text Analytical qualifiers.

Data 03: MVC Data REASON Memo Explanation for each analytical qualifier.

Data 03a: MVC FB EPISODE Text Numeric code associated with each EPA sampling episode or CWA 308 sampling event.

Data 03a: MVC FB FB SAMPLE Text Numeric code associated with each sample. This table only includes those vapor-compression evaporation samples associated with field 

blank samples.

Data 03a: MVC FB LAB NAME Text Abbreviation for the lab analyzing the sample.

Data 03a: MVC FB ANALYTE Text Name of the analyte measured.

Data 03a: MVC FB CAS_NO Text Analyte-specific Chemical Abstracts Service (CAS) number.

Data 03a: MVC FB METHOD Text Analytical method used to measure the concentration.

Data 03a: MVC FB 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 03a: MVC FB TYPE Text Type of sampling event (either EPA sampling or Long-Term Monitoring (LTM)).

Data 03a: MVC FB UNITS Text Units associated with the amount, MDL, RL, and dilution fields.

Data 03a: MVC FB AMOUNT Text Analyte concentration.

Data 03a: MVC FB MDL Text Method detection limit.

Data 03a: MVC FB RL Text Reporting limit.

Data 03a: MVC FB DILUTION Text Dilution factor.

Data 03a: MVC FB QUALIFIERS Text Analytical qualifiers.

Data 03a: MVC FB REASON Memo Explanation for each analytical qualifier.

Data 03a: MVC FB FB_Amount Number (Double) Analyte concentration associated with the field blank sample.

Data 03a: MVC FB NonFB_Amount Number (Double) Analyte concentration associated with the wastewater sample taken on the same day as the field blank.

Data 03a: MVC FB 5xFB Number (Double) Five times the analyte concentration associated with the field blank sample.

Data 03a: MVC FB 10xFB Number (Double) Ten times the analyte concentration associated with the field blank sample.

Data 03a: MVC FB New_Amount Number (Double) New analyte concentration associated with the wastewater sample taken on the same day as the field blank based on the field blank 

analysis.

Data 03a: MVC FB FB Qualifier Text New analytical qualifier associated with the wastewater sample taken on the same day as the field blank based on the field blank analysis.

Data 03a: MVC FB SAMPLE Text Numeric code associated with the vapor-compression evaporation effluent wastewater sample taken on the same day as the field blank.

Data 03b: MVC data after FB EPISODE Text Numeric code associated with each EPA sampling episode or CWA 308 sampling event.

Data 03b: MVC data after FB SAMPLE Text Numeric code associated with each sample. This table only includes those samples associated with original samples for vaporcompression evaporation effluent.

Data 03b: MVC data after FB LAB NAME Text Abbreviation for the lab analyzing the sample.

Data 03b: MVC data after FB ANALYTE Text Name of the analyte measured.

Data 03b: MVC data after FB CAS_NO Text Analyte-specific Chemical Abstracts Service (CAS) number.

Data 03b: MVC data after FB METHOD Text Analytical method used to measure the concentration.

Data 03b: MVC data after FB 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 03b: MVC data after FB TYPE Text Type of sampling event (either EPA sampling or Long-Term Monitoring (LTM)).

Data 03b: MVC data after FB UNITS Text Units associated with the amount field.

Data 03b: MVC data after FB AMOUNT Text Analyte concentration. The concentration presented here takes into account the results of the duplicate analysis and the field blank 

analysis.

Data 03b: MVC data after FB FB Qualifier Text Analytical qualifier resulting from the field blank analysis, if applicable.

Duplicate Crosswalk Sampling Episode Number Text Numeric code associated with each EPA sampling episode or CWA 308 sampling event.

6 of 11
EPA-HQ-OW-2009-0819-DRAFT-2188

Database Table Name Database Field Name Field Type Text Field Description

Duplicate Crosswalk Sample Number Text Numeric code associated with each original sample taken on the same day as the duplicate sample.

Duplicate Crosswalk Duplicate of Sample Text Numeric code associated with the duplicate sample.

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

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

EIA_ID eia_id_reported Text The U.S. Energy Information Administration identification number reported by each plant in the OW survey.

FGD Cost Matrix Plant_ID Number (Long Integer) Unique EPA Office of Water Survey plant identification number.

FGD Cost Matrix Bio_Cost Yes/No Flag indicating those plants incurring a cost for biological treatment.

FGD Cost Matrix CP_Cost Yes/No Flag indicating those plants incurring a cost for chemical precipitation.

FGD Cost Matrix Treatment Basis Text Identifies the level of FGD wastewater treatment currently used at each plant (pond, CP, Bio, or MVC)

FGD Cost Matrix CP Option Treatment Text Identifies the level of FGD wastewater treatment that will be evaluated as part of the chemical precipitation treatment option (CP, Bio, or 

MVC).

FGD Cost Matrix Bio Option Treatment Text Identifies the level of FGD wastewater treatment that will be evaluated as part of the biological treatment option (Bio or MVC).

FGD Cost Matrix MVC Option Treatment Text Identifies the level of FGD wastewater treatment that will be evaluated as part of the vapor-compression evaporation treatment option 

(MVC).

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

FGD_Flow_Data FGD_Scrubber_Purge_Baseline Number (Double) Current FGD scrubber purge flow in gallons per day.

FGD_Flow_Data FGD_Scrubber_Purge_gpd Number (Double) Post compliance FGD scrubber purge flow in gallons per day.

FGD_Flow_Data FGD_Scrubber_Purge_gpm Number (Double) Current FGD scrubber purge flow in gallons per minute as reported in Part B of the Steam Electric Survey.

FGD_Flow_Data Part D Treatment Flow (gpd) Text Current FGD scrubber purge flow in gallons per day as reported in Part D of the Steam Electric Survey.

FGD_Flow_Data Part D Treatment Frequency (dpy) Number (Double) Current FGD scrubber purge flow rate in days per year as reported in Part D of the Steam Electric Survey.

FGD_Flow_Data Surface_Water_Name Text Name of the surface water where treated FGD scrubber purge is discharged.

FGD_Flow_Data CBI_FGD_Cost Text Flag to indicate the confidential business information status of the plant-level cost.

FGD_Flow_Data CBI_FGD_Load Text Flag to indicate the confidential business information status of the plant-level cost.

FGD_Flow_Data cbi_WFGD_water_gen_tbl (Part B) Text Confidential business information flag for the WFGD_water_gen_tbl in the Steam Electric Survey.

FGD_Flow_Data cbi_fuel_tbl (Part A) Text Confidential business information flag for the fuel_tbl in the Steam Electric Survey.

FGD_Flow_Data Part D CBI Influent Text Confidential business information flag for the table of influent data in Part D of the Steam Electric Survey.

FGD_Flow_Data Part D CBI Effluent Text Confidential business information flag for the table of effluent data in Part D of the Steam Electric Survey.

FGD_Flow_Data Retired? Yes/No Indicator for whether the plant is planning to retire.

FGD_Flow_Data MW Number (Single) Capacity of Wet Scrubbed Units

FGD_Flow_Data Future Profile EIA ID Number (Single) EIA ID associated with plants in the future profile.

Loads 01: Baseline Loads Treatment Basis Text Identifies the level of FGD wastewater treatment currently used at each plant (pond, CP, Bio, or MVC)

Loads 01: Baseline Loads Flow Rate (gpd) Number (Double) Current FGD scrubber purge flow in gallons per day.

Loads 01: Baseline Loads Surface_Water_Name Text Name of the surface water where treated FGD scrubber purge is discharged.

Loads 01: Baseline Loads CBI_FGD_Load Text Flag to indicate the confidential business information status of the plant-level loads.

Loads 01: Baseline Loads Analyte Text Name of the analyte.

Loads 01: Baseline Loads Amount_(ug/L) Number (Double) Concentration in ug/L for the baseline scenario.

Loads 01: Baseline Loads Load_(lb/yr) Number (Double) Total analyte load in pounds per year.

Loads 01: Baseline Loads Current TWF Number (Double) Current toxic weighting factor.

Loads 01: Baseline Loads TWPE Number (Double) Calculated annual toxic weighted pound equivalent.

Loads 01: Baseline Loads eia_id Number (Double) Unique plant identification code associated with the U.S. Energy Information Administration.

Loads 01: Baseline Loads Plant_ID Number (Long Integer) Unique EPA Office of Water Survey plant identification number.

Loads 02: CP Loads eia_id Number (Double) Unique plant identification code associated with the U.S. Energy Information Administration.

Loads 02: CP Loads Plant_ID Number (Long Integer) Unique EPA Office of Water Survey plant identification number.

Loads 02: CP Loads Treatment Basis Text Identifies the level of FGD wastewater treatment currently used at each plant (pond, CP, Bio, or MVC)

Loads 02: CP Loads Basis for Loading Text Identifies the level of FGD wastewater treatment that will be evaluated as part of the chemical precipitation treatment option (CP, Bio, or 

MVC).

Loads 02: CP Loads Flow Rate (gpd) Number (Double) Post compliance FGD scrubber purge flow in gallons per day.

Loads 02: CP Loads Surface_Water_Name Text Name of the surface water where treated FGD scrubber purge is discharged.

Loads 02: CP Loads CBI_FGD_Load Text Flag to indicate the confidential business information status of the plant-level loads.

Loads 02: CP Loads Analyte Text Name of the analyte.

Loads 02: CP Loads Amount_(ug/L) Number (Double) Concentration in ug/L for the chemical precipitation scenario.

Loads 02: CP Loads Load_(lb/yr) Number (Double) Total analyte load in pounds per year.

Loads 02: CP Loads Current TWF Number (Double) Current toxic weighting factor.

Loads 02: CP Loads TWPE Number (Double) Calculated annual toxic weighted pound equivalent.

Loads 03: Bio Loads eia_id Number (Double) Unique plant identification code associated with the U.S. Energy Information Administration.

Loads 03: Bio Loads Plant_ID Number (Long Integer) Unique EPA Office of Water Survey plant identification number.

Loads 03: Bio Loads Treatment Basis Text Identifies the level of FGD wastewater treatment currently used at each plant (pond, CP, Bio, or MVC)

Loads 03: Bio Loads Basis for Loading Text Identifies the level of FGD wastewater treatment that will be evaluated as part of the biological treatment option (Bio or MVC).

Loads 03: Bio Loads Flow Rate (gpd) Number (Double) Post compliance FGD scrubber purge flow in gallons per day.

7 of 11
EPA-HQ-OW-2009-0819-DRAFT-2188

Database Table Name Database Field Name Field Type Text Field Description

Loads 03: Bio Loads Surface_Water_Name Text Name of the surface water where treated FGD scrubber purge is discharged.

Loads 03: Bio Loads CBI_FGD_Load Text Flag to indicate the confidential business information status of the plant-level loads.

Loads 03: Bio Loads Analyte Text Name of the analyte.

Loads 03: Bio Loads Amount_(ug/L) Number (Double) Concentration in ug/L for the biological treatment scenario.

Loads 03: Bio Loads Load_(lb/yr) Number (Double) Total analyte load in pounds per year.

Loads 03: Bio Loads Current TWF Number (Double) Current toxic weighting factor.

Loads 03: Bio Loads TWPE Number (Double) Calculated annual toxic weighted pound equivalent.

Loads 04: MVC Loads eia_id Number (Double) Unique plant identification code associated with the U.S. Energy Information Administration.

Loads 04: MVC Loads Plant_ID Number (Long Integer) Unique EPA Office of Water Survey plant identification number.

Loads 04: MVC Loads Treatment Basis Text Identifies the level of FGD wastewater treatment currently used at each plant (pond, CP, Bio, or MVC)

Loads 04: MVC Loads Basis for Loading Text Identifies the level of FGD wastewater treatment that will be evaluated as part of the vapor-compression evaporation treatment option 

(MVC).

Loads 04: MVC Loads Flow Rate (gpd) Number (Double) Post compliance FGD scrubber purge flow in gallons per day.

Loads 04: MVC Loads Surface_Water_Name Text Name of the surface water where treated FGD scrubber purge is discharged.

Loads 04: MVC Loads CBI_FGD_Load Text Flag to indicate the confidential business information status of the plant-level loads.

Loads 04: MVC Loads Analyte Text Name of the analyte.

Loads 04: MVC Loads Amount_(ug/L) Number (Double) Concentration in ug/L for the vapor-compression evaporation scenario.

Loads 04: MVC Loads Load_(lb/yr) Number (Double) Total analyte load in pounds per year.

Loads 04: MVC Loads Current TWF Number (Double) Current toxic weighting factor.

Loads 04: MVC Loads TWPE Number (Double) Calculated annual toxic weighted pound equivalent.

MVC Sample Numbers Plant Text Name of plants sampled for vapor-compression evaporation technology.

MVC Sample Numbers Sampling Episode Number Text Numeric code associated with each EPA sampling episode or CWA 308 sampling event used to calculate average vapor-compression 

evaporation effluent concentration.

MVC Sample Numbers Sample Number Text Numeric code associated with each sample used to calculate average vapor-compression evaporation effluent concentration.

MVC Sample Numbers Sample Point Text Sampling point identifier. These values correspond to the sampling episode reports for each sampling event.

MVC Sample Numbers Sample Description Text Description of the type of wastewater sampled.

POTW Removal Crosswalk ANALYTE Text List of analytes.

POTW Removal Crosswalk POTW ANALYTE Text Analyte name listed in the POTW removals table that corresponds to analyte field.

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.

Qualifiers Reasons Qualifiers Text Analytical qualifier.

Qualifiers Reasons Reason Memo Standard explanation for analytical qualifier.

Sample Numbers with Dates Plant Text Plant name.

Sample Numbers with Dates Sampling Episode Number Number (Double) Numeric code associated with each EPA sampling episode or CWA 308 sampling event.

Sample Numbers with Dates Sample Number Text Numeric code associated with each sample.

Sample Numbers with Dates Sample Point Text Sampling point identifier. These values correspond to the sampling episode reports for each sampling event.

Sample Numbers with Dates Sample Description Text Description of the type of wastewater sampled.

Sample Numbers with Dates Type of Wastewater Text Type of wastewater sampled.

Sample Numbers with Dates Data Used for Limits Text Flag to indicate which samples are used to calculate limits.

Sample Numbers with Dates Type of Sampling Text Type of sampling event (either EPA sampling or Long-Term Monitoring (LTM)).

Sample Numbers with Dates Date Collected Date/Time Date the sample was collected.

T1: Mercury EPA Sampling Data EPISODE Text Numeric code associated with each EPA sampling episode.

T1: Mercury EPA Sampling Data SAMPLE Text Numeric code associated with each sample analyzed for mercury.

T1: Mercury EPA Sampling Data LAB NAME Text Abbreviation for the lab analyzing the sample.

T1: Mercury EPA Sampling Data ANALYTE Text Name of analyte measured (only mercury).

T1: Mercury EPA Sampling Data CAS_NO Text Analyte-specific Chemical Abstracts Service (CAS) number.

T1: Mercury EPA Sampling Data METHOD Text Analytical method used to measure the concentration.

T1: Mercury EPA 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.

T1: Mercury EPA Sampling Data TYPE Text Type of sampling event (either EPA sampling or Long-Term Monitoring (LTM)).

T1: Mercury EPA Sampling Data UNITS Text Units associated with amount, MDL, RL, and dilution fields.

T1: Mercury EPA Sampling Data AMOUNT Text Concentration.

T1: Mercury EPA Sampling Data MDL Text Method detection limit.

T1: Mercury EPA Sampling Data RL Text Reporting limit.

T1: Mercury EPA Sampling Data DILUTION Text Dilution factor.

T1: Mercury EPA Sampling Data QUALIFIERS Text Analytical qualifiers.

T1: Mercury EPA Sampling Data REASON Memo Explanation for each analytical qualifier.

8 of 11
EPA-HQ-OW-2009-0819-DRAFT-2188

Database Table Name Database Field Name Field Type Text Field Description

T1: Mercury LTM Data EPISODE Text Numeric code associated with each CWA 308 sampling event.

T1: Mercury LTM Data SAMPLE Text Numeric code associated with each sample analyzed for mercury.

T1: Mercury LTM Data LAB NAME Text Abbreviation for the lab analyzing the sample.

T1: Mercury LTM Data ANALYTE Text Analyte name (only mercury).

T1: Mercury LTM Data CAS_NO Text Analyte-specific Chemical Abstracts Service (CAS) number.

T1: Mercury LTM Data METHOD Text Analytical method used to measure the concentration.

T1: Mercury LTM 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.

T1: Mercury LTM Data TYPE Text Type of sampling event (either EPA sampling or Long-Term Monitoring (LTM)).

T1: Mercury LTM Data UNITS Text Units associated with amount, MDL, RL, and dilution fields.

T1: Mercury LTM Data AMOUNT Text Concentration.

T1: Mercury LTM Data MDL Text Method detection limit.

T1: Mercury LTM Data RL Text Reporting limit.

T1: Mercury LTM Data DILUTION Text Dilution factor.

T1: Mercury LTM Data QUALIFIERS Text Analytical qualifiers.

T1: Mercury LTM Data REASON Memo Explanation for each analytical qualifier.

T2: Metals EPA Sampling Data EPISODE Text Numeric code associated with each EPA sampling episode.

T2: Metals EPA Sampling Data SAMPLE Text Numeric code associated with each sample analyzed for metals except for mercury.

T2: Metals EPA Sampling Data LAB NAME Text Abbreviation for the lab analyzing the sample.

T2: Metals EPA Sampling Data ANALYTE Text Analyte name (all metals except mercury).

T2: Metals EPA Sampling Data CAS_NO Text Analyte-specific Chemical Abstracts Service (CAS) number.

T2: Metals EPA Sampling Data METHOD Text Analytical method used to measure the concentration.

T2: Metals EPA 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.

T2: Metals EPA Sampling Data TYPE Text Type of sampling event (either EPA sampling or Long-Term Monitoring (LTM)).

T2: Metals EPA Sampling Data UNITS Text Units associated with amount, MDL, RL, and dilution fields.

T2: Metals EPA Sampling Data AMOUNT Text Concentration.

T2: Metals EPA Sampling Data MDL Text Method detection limit.

T2: Metals EPA Sampling Data RL Text Reporting limit.

T2: Metals EPA Sampling Data DILUTION Text Dilution factor.

T2: Metals EPA Sampling Data QUALIFIERS Text Analytical qualifiers.

T2: Metals EPA Sampling Data REASON Memo Explanation for each analytical qualifier.

T2: Metals LTM Data EPISODE Text Numeric code associated with each CWA 308 sampling episode.

T2: Metals LTM Data SAMPLE Text Numeric code associated with each sample analyzed for metals except for mercury.

T2: Metals LTM Data LAB NAME Text Abbreviation for the lab analyzing the sample.

T2: Metals LTM Data ANALYTE Text Analyte name (all metals except mercury).

T2: Metals LTM Data CAS_NO Text Analyte-specific Chemical Abstracts Service (CAS) number.

T2: Metals LTM Data METHOD Text Analytical method used to measure the concentration.

T2: Metals LTM 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.

T2: Metals LTM Data TYPE Text Type of sampling event (either EPA sampling or Long-Term Monitoring (LTM)).

T2: Metals LTM Data UNITS Text Units associated with amount, MDL, RL, and dilution fields.

T2: Metals LTM Data AMOUNT Text Concentration.

T2: Metals LTM Data MDL Text Method detection limit.

T2: Metals LTM Data RL Text Reporting limit.

T2: Metals LTM Data DILUTION Text Dilution factor.

T2: Metals LTM Data QUALIFIERS Text Analytical qualifiers.

T2: Metals LTM Data REASON Memo Explanation for each analytical qualifier.

T3: Classicals EPA Sampling Data EPISODE Text Numeric code associated with each EPA sampling episode.

T3: Classicals EPA Sampling Data SAMPLE Text Numeric code associated with each sample analyzed for classicals.

T3: Classicals EPA Sampling Data LAB NAME Text Abbreviation for the lab analyzing the sample.

T3: Classicals EPA Sampling Data ANALYTE Text Analyte name (all classicals).

T3: Classicals EPA Sampling Data CAS_NO Text Analyte-specific Chemical Abstracts Service (CAS) number.

T3: Classicals EPA Sampling Data METHOD Text Analytical method used to measure the concentration.

T3: Classicals EPA 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.

9 of 11
EPA-HQ-OW-2009-0819-DRAFT-2188

Database Table Name Database Field Name Field Type Text Field Description

T3: Classicals EPA Sampling Data TYPE Text Type of sampling event (either EPA sampling or Long-Term Monitoring (LTM)).

T3: Classicals EPA Sampling Data UNITS Text Units associated with amount, MDL, RL, and dilution fields.

T3: Classicals EPA Sampling Data AMOUNT Text Concentration.

T3: Classicals EPA Sampling Data MDL Text Method detection limit.

T3: Classicals EPA Sampling Data RL Text Reporting limit.

T3: Classicals EPA Sampling Data DILUTION Text Dilution factor.

T3: Classicals EPA Sampling Data QUALIFIERS Text Analytical qualifiers.

T3: Classicals EPA Sampling Data REASON Memo Explanation for each analytical qualifier.

T3: Classicals LTM Data EPISODE Text Numeric code associated with each CWA 308 sampling episode.

T3: Classicals LTM Data SAMPLE Text Numeric code associated with each sample analyzed for classicals.

T3: Classicals LTM Data LAB NAME Text Abbreviation for the lab analyzing the sample.

T3: Classicals LTM Data ANALYTE Text Analyte name (all classicals).

T3: Classicals LTM Data CAS_NO Text Analyte-specific Chemical Abstracts Service (CAS) number.

T3: Classicals LTM Data METHOD Text Analytical method used to measure the concentration.

T3: Classicals LTM 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.

T3: Classicals LTM Data TYPE Text Type of sampling event (either EPA sampling or Long-Term Monitoring (LTM)).

T3: Classicals LTM Data UNITS Text Units associated with amount, MDL, RL, and dilution fields.

T3: Classicals LTM Data AMOUNT Text Concentration.

T3: Classicals LTM Data MDL Text Method detection limit.

T3: Classicals LTM Data RL Text Reporting limit.

T3: Classicals LTM Data DILUTION Text Dilution factor.

T3: Classicals LTM Data QUALIFIERS Text Analytical qualifiers.

T3: Classicals LTM Data REASON Memo Explanation for each analytical qualifier.

T4: Belews Creek Additional Data EPISODE Text Sampling location associated with plant-self monitoring at Belews Creek.

T4: Belews Creek Additional Data SAMPLE Date/Time Date the sample was collected.

T4: Belews Creek Additional Data LAB NAME Text Abbreviation for the lab analyzing the sample.

T4: Belews Creek Additional Data ANALYTE Text Name of analyte.

T4: Belews Creek Additional Data CAS_No Text Analyte-specific Chemical Abstracts Service (CAS) number.

T4: Belews Creek Additional Data METHOD Text Analytical method used to measure the concentration.

T4: Belews Creek Additional 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.

T4: Belews Creek Additional Data TYPE Text Type of sampling event (either EPA sampling or Long-Term Monitoring (LTM)).

T4: Belews Creek Additional Data UNITS Text Units associated with amount, MDL, RL, and dilution fields.

T4: Belews Creek Additional Data AMOUNT Text Concentration.

T4: Belews Creek Additional Data MDL Text Method detection limit.

T4: Belews Creek Additional Data RL Text Reporting limit.

T4: Belews Creek Additional Data DILUTION Text Dilution factor.

T4: Belews Creek Additional Data QUALIFIERS Text Analytical qualifiers.

T4: Belews Creek Additional Data REASON Text Explanation for each analytical qualifier.

T5: Allen Additional Data EPISODE Text Sampling location associated with plant-self monitoring at Allen.

T5: Allen Additional Data SAMPLE Date/Time Date the sample was collected.

T5: Allen Additional Data LAB NAME Text Abbreviation for the lab analyzing the sample.

T5: Allen Additional Data ANALYTE Text Name of analyte.

T5: Allen Additional Data CAS_No Text Analyte-specific Chemical Abstracts Service (CAS) number.

T5: Allen Additional Data METHOD Text Analytical method used to measure the concentration.

T5: Allen Additional 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.

T5: Allen Additional Data TYPE Text Type of sampling event (either EPA sampling or Long-Term Monitoring (LTM)).

T5: Allen Additional Data UNITS Text Units associated with amount, MDL, RL, and dilution fields.

T5: Allen Additional Data AMOUNT Text Concentration.

T5: Allen Additional Data MDL Text Method detection limit.

T5: Allen Additional Data RL Text Reporting limit.

T5: Allen Additional Data DILUTION Text Dilution factor.

T5: Allen Additional Data QUALIFIERS Text Analytical qualifiers.

T5: Allen Additional Data REASON Text Explanation for each analytical qualifier.

TWF Crosswalk ANALYTE Text List of analytes.

10 of 11
EPA-HQ-OW-2009-0819-DRAFT-2188

Database Table Name Database Field Name Field Type Text Field Description

TWF Crosswalk TWF ANALYTE Text Analyte name as listed in the TWF table.

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

11 of 11