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.

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

The primary purpose of the FGD Settling Pond Concentrations Loadings Model (DCN SE02902) is to calculate the average effluent concentration from 

FGD settling ponds. This average concentration is then used as part of the FGD Wastewater Loadings Model (DCN SE02900) to calculate plant-specific 

pollutant loadings.

Tables: Provides a listing of all tables found within the FGD Settling Pond Concentrations 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 Settling Pond Concentrations Loadings Model. The fields are 

organized by table name.

Flue Gas Desulfurization (FGD) Settling Pond Concentration Loadings Model Data Element Dictionary - Summary

4/19/2013

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 from FGD settling 

ponds. These calculations are executed in the queries contained within the database. The database also includes a listing of the specific sampling data 

used in the analysis.

This MS Excel file is the data element dictionary that provides a description of the data elements contained within the FGD Settling Pond Concentrations 

Loadings Model. The elements of the dictionary include: 

Database Table Name Description

Conc Data 02: Final CP Concentration Average effluent concentration for chemical precipitation effluent. The data contained 

in this table is calculated in the FGD Wastewater Loadings Model (DCN SE02900).

Conc Data 04: Average Pond Effluent Conc Average effluent concentration for FGD settling pond effluent. The data contained in 

this table is the final output of the FGD Settling Pond Concentrations Loadings Model.

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 00a: Combined Data with FB Result A listing of all sampling data, from Data 00, but excludes field blanks and reflects 

changes to concentrations or qualifiers resulting from the field blank analysis.

Data 01: FB Analysis A list of a subset of the sampling data containing information for field blanks and all 

samples collected on the same day as the field blank. This table also includes the 

results of the field blank analysis.

Data 02: Roxboro Avg Settling Pond Effluent Average concentration for all sampling data associated with the Roxboro Plant.

Field Blank Crosswalk Crosswalk between sample numbers associated with field blanks and the sample 

numbers associated with the sample collected on the same day as the field blank.

Final 01: Combined Pond Effluent Conc Plant-level average FGD settling pond effluent concentrations.

Final 01a: Manual Adds to Combined Pond Effluent Conc Plant-level concentrations for total dissolved solids, total suspended solids, and 

chlorides. 

Final 02: Average Pond Effluent Conc Analyte-level average FGD settling pond effluent concentrations.

HF: Crosswalk between filt and solids Table containing plant-specific information on filtrate and solids samples for Hatfield's 

Ferry.

KS: Crosswalk between filt and solids Table containing plant-specific information on filtrate and solids samples for Keystone.

MF: Crosswalk between filt and solids Table containing plant-specific information on filtrate and solids samples for Miami Fort.

Roxboro Data Sampling data associated with the Roxboro Plant.

Sample Numbers List of sample numbers for samples collected during EPA's sampling episodes 

conducted as part of the Steam Rulemaking.

Solids Data 01: Biphase Samples A listing of all sampling data analyzed using biphasic separation.

Solids Data 02: Non-BiPhase Samples A listing of all sampling data not analyzed using biphasic separation.

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.
EPA-HQ-OW-2009-0819-DRAFT-2187

Database Table Name Database Field Name Field Type Text Field Description

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

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 04: Average Pond Effluent Conc Analyte Text List of analytes for FGD settling pond effluent concentration dataset.

Conc Data 04: Average Pond Effluent Conc Amount Number (Double) FGD settling pond effluent concentration. Blank records indicate that no data are 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.

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 00a: Combined Data with FB Result EPISODE Text Numeric code associated with each EPA sampling episode or CWA 308 sampling event.

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

Data 00a: Combined Data with FB Result LAB NAME Text Abbreviation for the lab analyzing the sample.

Data 00a: Combined Data with FB Result ANALYTE Text Name of the analyte measured.

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

Data 00a: Combined Data with FB Result METHOD Text Analytical method used to measure the concentration.

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

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

Data 00a: Combined Data with FB Result AMOUNT Text Analyte concentration.

Data 00a: Combined Data with FB Result MDL Text Method detection limit.

Data 00a: Combined Data with FB Result RL Text Reporting limit.

Data 00a: Combined Data with FB Result DILUTION Text Dilution factor.

Data 00a: Combined Data with FB Result QUALIFIERS Text Analytical qualifiers.

Data 00a: Combined Data with FB Result REASON Memo Explanation for each analytical qualifier.

Data 00a: Combined Data with FB Result FB Qualifier Text Qualifier resulting from the field blanks analysis.

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

Data 01: FB Analysis FB SAMPLE Text Numeric code associated with the field blank sample.

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

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

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

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

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

Data 01: FB Analysis UNITS Text Units associated with amount, MDL, RL, dilution, FB amount, NonFB amount, 5x FB, 10x FB, and New Amount fields.

Data 01: FB Analysis AMOUNT Text Analyte concentration.

Data 01: FB Analysis MDL Text Method detection limit.

Data 01: FB Analysis RL Text Reporting limit.

Data 01: FB Analysis DILUTION Text Dilution factor.

Data 01: FB Analysis QUALIFIERS Text Analytical qualifiers.

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

Data 01: FB Analysis FB Amount Number (Double) Concentration associated with the field blank sample.

Data 01: FB Analysis NonFB Amount Number (Double) Concentration associated with the sample taken on the same day as the field blank.

Data 01: FB Analysis 5x FB Number (Double) Five times the field blank concentration.

Data 01: FB Analysis 10x FB Number (Double) Ten times the field blank concentration.

Data 01: FB Analysis New Amount Number (Double) New concentration associated with the sample taken on the same day as the field blank. The result of the field blank analysis.

Data 01: FB Analysis FB Qualifier Text Qualifier resulting from the field blanks analysis.

Data 01: FB Analysis SAMPLE Text Numeric code associated with the sample taken on the same day as the field blank.

1 of 4
EPA-HQ-OW-2009-0819-DRAFT-2187

Database Table Name Database Field Name Field Type Text Field Description

Data 02: Roxboro Avg Settling Pond Effluent Sampling_Location Text Description of the location from which the sample was taken.

Data 02: Roxboro Avg Settling Pond Effluent Analyte Text Name of the analyte measured.

Data 02: Roxboro Avg Settling Pond Effluent AvgOfConcentration Number (Double) Average concentration.

Data 02: Roxboro Avg Settling Pond Effluent Units Text Units associated with the AvgOfConcentration field.

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

Field Blank Crosswalk FB Sample Number Text Numeric code associated with the field blank sample.

Field Blank Crosswalk FB of Sample Text Numeric code associated with the sample taken on the same day as the field blank.

Final 01: Combined Pond Effluent Conc Sampling_Location Text Description of sample location, either text description or numeric code to identify EPA sampling episode.

Final 01: Combined Pond Effluent Conc Analyte Text Name of the analyte measured.

Final 01: Combined Pond Effluent Conc AvgOfConcentration Number (Double) Plant-level average concentration.

Final 01: Combined Pond Effluent Conc Units Text Units associated with AvgOfConcentration field.

Final 01a: Manual Adds to Combined Pond Effluent Conc Sampling Location Text Numeric code associated with each EPA sampling episode or CWA 308 sampling event.

Final 01a: Manual Adds to Combined Pond Effluent Conc Analyte Text List of analytes associated with combined pond effluent that were added to the dataset manually (TDS, TSS, and chlorides).

Final 01a: Manual Adds to Combined Pond Effluent Conc Amount Number (Double) Analyte concentration.

Final 01a: Manual Adds to Combined Pond Effluent Conc Units Text Units associated with the amount field.

Final 02: Average Pond Effluent Conc Analyte Text List of analytes associated with the FGD settling pond effluent dataset.

Final 02: Average Pond Effluent Conc Amount Number (Double) Analyte concentration.

Final 02: Average Pond Effluent Conc Units Text Units associated with amount field.

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

HF: Crosswalk between filt and solids Lab Text Abbreviation for the lab analyzing the sample.

HF: Crosswalk between filt and solids Sample Text Numeric code associated with each sample associated with Hatfields Ferry.

HF: Crosswalk between filt and solids Weight solids Number (Double) Weight of the solids contained in the sample.

HF: Crosswalk between filt and solids vol filtrate Number (Double) Volume of filtrate contained in the sample.

HF: Crosswalk between filt and solids Total vol Number (Double) Total volume of filtrate and solids.

HF: Crosswalk between filt and solids per solids in dec Number (Double) Percent solids in decimal form.

HF: Crosswalk between filt and solids Units Text Units associated with the data. Includes weight and volume units in the same field.

KS: Crosswalk between filt and solids Lab Text Abbreviation for the lab analyzing the sample.

KS: Crosswalk between filt and solids Sample Text Numeric code associated with each sample associated with Keystone.

KS: Crosswalk between filt and solids Weight solids Number (Double) Weight of the solids contained in the sample.

KS: Crosswalk between filt and solids vol filtrate Number (Double) Volume of filtrate contained in the sample.

KS: Crosswalk between filt and solids Total vol Number (Double) Total volume of filtrate and solids.

KS: Crosswalk between filt and solids per solids in dec Number (Double) Percent solids in decimal form.

KS: Crosswalk between filt and solids Units Text Units associated with the data. Includes weight and volume units in the same field.

MF: Crosswalk between filt and solids Lab Text Abbreviation for the lab analyzing the sample.

MF: Crosswalk between filt and solids Sample Text Numeric code associated with each sample associated with Miami Fort.

MF: Crosswalk between filt and solids Weight solids Number (Double) Weight of the solids contained in the sample.

MF: Crosswalk between filt and solids vol filtrate Number (Double) Volume of filtrate contained in the sample.

MF: Crosswalk between filt and solids Total vol Number (Double) Total volume of filtrate and solids.

MF: Crosswalk between filt and solids Per solids in dec Number (Double) Percent solids in decimal form.

MF: Crosswalk between filt and solids Units Text Units associated with the data. Includes weight and volume units in the same field.

Roxboro Data Plant_EIA_ID Text Unique plant identification code associated with the U.S. Energy Information Administration.

Roxboro Data Plant_Name Text Plant name.

Roxboro Data Plant_City Text City where the plant is located.

Roxboro Data Plant_State Text State where the plant is located.

Roxboro Data Date_ Date/Time Date of the sample.

Roxboro Data Analyte Text List of analytes sampled at Roxboro.

Roxboro Data Units Text Units associated with concentration.

Roxboro Data Concentration Number (Double) Analyte concentration.

Roxboro Data Non_Detected_Indicator Text Flag for non-detect results.

Roxboro Data Method Text Analytical method used to measure the concentration.

Roxboro Data Sampling_Location Text Description of sample location.

Sample Numbers Plant Text Plant name.

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

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

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

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

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

Solids Data 01: Biphase Samples SAMPLE Text Numeric code associated with each sample analyzed using biphasic separation.

Solids Data 01: Biphase Samples ANALYTE Text Name of the analyte measured.

Solids Data 01: Biphase Samples SOLIDS AMOUNT Number (Double) Analyte concentration, only concentrations associates with samples identified as solids.

Solids Data 01: Biphase Samples SOLIDS UNITS Text Units associated with solids amount field.

Solids Data 01: Biphase Samples DISSOLVED AMOUNT Number (Double) Analyte concentration, only concentrations associated with samples identified as dissolved.

Solids Data 01: Biphase Samples DISSOLVED UNITS Text Units associated with dissolved amount field.

Solids Data 01: Biphase Samples SETTLING AMOUNT Number (Double) Analyte concentration. Calculated value associated with the amount of each analyte that will fall out of suspension during settling.

Solids Data 01: Biphase Samples SETTLING UNITS Text Units associated with settling amount field.

Solids Data 02: Non-BiPhase Samples EPISODE Text Numeric code associated with each EPA sampling episode or CWA 308 sampling event.

Solids Data 02: Non-BiPhase Samples SAMPLE Text Numeric code associated with each sample analyzed not using biphasic separation.

Solids Data 02: Non-BiPhase Samples ANALYTE Text Name of the analyte measured.

Solids Data 02: Non-BiPhase Samples SOLIDS AMOUNT Number (Double) Analyte concentration, only concentrations associates with samples identified as solids.

Solids Data 02: Non-BiPhase Samples SOLIDS UNITS Text Units associated with solids amount field.

2 of 4
EPA-HQ-OW-2009-0819-DRAFT-2187

Database Table Name Database Field Name Field Type Text Field Description

Solids Data 02: Non-BiPhase Samples DISSOLVED AMOUNT Number (Double) Analyte concentration, only concentrations associated with samples identified as dissolved.

Solids Data 02: Non-BiPhase Samples DISSOLVED UNITS Text Units associated with dissolved amount field.

Solids Data 02: Non-BiPhase Samples SETTLNG AMOUNT Number (Double) Analyte concentration. Calculated value associated with the amount of each analyte that will fall out of suspension during settling.

Solids Data 02: Non-BiPhase Samples SETTLING UNITS Text Units associated with settling amount field.

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 Analyte name (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 Analyte 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.

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 Analyte 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 Analyte 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 Analyte concentration.

T2: Metals LTM Data MDL Text Method detection limit.

T2: Metals LTM Data RL Text Reporting limit.

3 of 4
EPA-HQ-OW-2009-0819-DRAFT-2187

Database Table Name Database Field Name Field Type Text Field Description

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.

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

4 of 4