Data Dictionary



  

Export to Excel

Application Template/Section Column Field Name Description Requirements Type Valid Values and Conditions Examples and Guidance Active
Loader Location AT Well Tag ID

The unique Washington State Department of Ecology Well Tag ID, consisting of three letters and three numbers (e.g. ABC123).

REQUIRED for WELLS IF

a monitoring well or other well if available

Text (6)

Format: ABC123

Leave blank If you don’t have a valid well tag ID and it isn’t practical to get one.

  • AAB489
  • BFR225

Must be the unique number off the Ecology well tag attached to a well. The ID is stamped on an aluminum tag and typically affixed to the well by the driller at the time of construction or later by Ecology staff. The ID is also included on the well log submitted by the driller. See Ecology’s Well Report Viewer to find Well Tag IDs.

If a well isn’t tagged, you can get one from Ecology.

Because the Well Tag ID is unique in Washington, you can use it as the EIM Location ID and Location Name.

Yes
Loader Discrete result AT Fraction Analyzed

Indicates the fraction (total, dissolved, or suspended) of an aqueous sample that was analyzed.

Also includes analyses performed on lab-generated leachates derived from solid samples.

REQUIRED FOR

Samples with Sample Matrix of “Water,” unless Sample Source is “Freshwater Taxonomy” or “Salt/Marine Taxonomy.”

Also required if you analyzed sediments which were suspended in a water column or for lab leachates.

Text (15) Valid values:

Dissolved - Analysis performed on an aqueous sample that has been filtered in the lab or the field such that only the soluble portion is analyzed,
Lab Leachate - Analysis performed on lab-generated leachate derived from a solid sample using TCLP or similar sample preparation,
Suspended - Analysis performed on solids retained from an aqueous sample after separation by filtering or centrifuging, etc.,
Total - Analysis performed on an unfiltered or unseparated aqueous sample (dissolved + solids)

Download help for Fraction Analyzed.

Don’t fill this out for Measurements.

If Lab Leachate, Sample Preparation Method (AB) is required.

Download help for Entering TCLP/SPLP Data.

Yes
Loader Location AU Well Owner Organization Name

The organization name of the well owner.

REQUIRED for WELLS IF available Text (50)

Free text

  • City of Olympia

This information isn’t made public.

Yes
Loader Discrete result AU Field Filtered Flag

Indicates if a sample was filtered in the field (not the lab).

REQUIRED IF

Fraction Analyzed is Dissolved

Text (1) Valid values:

N - No,
Y - Yes

If “Yes,” enter the filtration method in the Sample Preparation Method field (Column AB).

Important for groundwater samples.

Yes
Loader Discrete result AV Result Basis

Physical state in which the analyte concentration was reported - either as the sample was received by the lab (wet weight) or adjusted to remove moisture (dry weight).

REQUIRED FOR

Sediment, Soil and Tissue chemistry data or if this information was reported by the lab

Text (3) Valid values:

DRY - Dry Weight,
WET - Wet Weight

Result Basis is sometimes concatenated with units in lab reports, like “mg/kg-dry.” EIM stores Result Basis and units separately.

Don’t populate Result Basis for Measurements or Water Samples - leave it blank.

Download help for Result (Weight) Basis.

Yes
Loader Location AV Well Owner Last Name

The last name of the well owner.

REQUIRED for WELLS IF available Text (50)

Free text

  • Jones

This information isn’t made public.

Yes
Loader Location AW Well Owner First Name

The first name of the well owner.

REQUIRED for WELLS IF available Text (50)

Free text

  • John

This information isn’t made public.

Yes
Loader Discrete result AW Digestion Method

Indicates the degree of digestion or breakdown performed on a solid sample prior to analysis.

Leave Blank

EIM no longer takes this info

Text (20)

Historical Valid Values:

  • Total - solid sample digested with acid to free up analyte prior to analysis; includes total recoverable
  • Complete - similar to Total, but completely dissolves solids. Often uses HF acid.

Previously required for metals in soil and sediment unless Fraction Analyzed is “Lab Leachate”

Yes
Loader Location AX Groundwater Location Type

The primary use or type of well or monitoring location.

REQUIRED for WELLS Text (50) Valid values:

Dewatering Well,
Geothermal Well,
In-Water Piezometer,
Injection Well - ASR - Injection Well - Aquifer Storage and Recovery,
Injection Well - Carbon Sequestration,
Injection Well - Remediation,
Irrigation Well,
Monitoring Well,
Other,
Pumping Well - Remediation,
Soil Gas Probe,
Stockwater Well,
Temporary Well - EIW - Temporary Environmental Investigation Well,
Water Supply Well - Domestic,
Water Supply Well - Industrial,
Water Supply Well - Public

Download help for EIWs (Temporary Environmental Investigation Wells) and Air, Vapor, and Soil Gas Data.

Yes
Loader Discrete result AX Water Level Accuracy

Estimated accuracy of a well water measurement or a vertical hydraulic gradient measurement.

REQUIRED ONLY FOR

well water level and vertical hydraulic gradient measurements.

Text (3) Valid values:

WL0 - Water level accurate to +/- 1ft,
WL1 - Water level accurate to +/- 0.1ft,
WL2 - Water level accurate to +/- 0.01ft,
WL6 - Water level accurate to > 1ft
Yes
Loader Discrete result AY Result Method (Code)

Procedure, method or instrument technology used to obtain a result. Includes lab (analysis), and field (measurement) methods.

REQUIRED IF

Field Collection Type is Sample, Measurement, or QC Blank

Text (20)

Must be valid EIM Method Code.



Search for valid values online
  • SW8260B
  • GWLMT

Download help for learning About EIM Methods.

Need a method added to EIM? Contact us online or ask your data coordinator.

Yes
Loader Location AY Well Completion Depth

The depth of the completed well below land surface. In feet or meters.

REQUIRED for WELLS

except for EIWs with groundwater chemistry data only

Number (5)
  • 48.84
  • 20.00

Usually found on the well log.

Yes
Loader Location AZ Well Completion Depth Units

Units in which a Well Completion Depth is expressed.

REQUIRED for WELLS

except for EIWs with groundwater chemistry data only

Number (5) Valid values:

FT - Feet,
M - Meters
Yes
Loader Discrete result AZ Result Comment

Comments about the Result Value.

REQUIRED FOR

results qualified with EST

Text (2000)

Free text

  • Result was qualified due to metal contamination during sampling and analysis
  • Sample exceeded the 48 hour hold time as outlined in the QAPP

If you qualified your data because it exceeded holding time, say that in the comment.

Download help for How to Use EIM’s Comment fields.

Yes
Loader Location BA Well Completion Type

The type of completion or nature of the openings that allow water to enter the well.

REQUIRED for WELLS

except for EIWs with groundwater chemistry data only

Text (30) Valid values:

Cased, Open Interval,
Cased, Open-Ended,
Other,
Uncased, Open Interval

Does your well have a screen? Use “Cased, Open Interval.”

If “Other,” explain the Completion Type in the Well Construction Comment (column BJ).

Yes
Loader Discrete result BA Result Additional Comment

Additional comments about the Result Value.

Optional Text (2000)

Free text

For chemistry data from WHM or related SAM studies, enter the DCE (data collection event) information here.

Download help for How to Use EIM’s Comment fields.

Yes
Loader Location BB Well Open Interval Upper Depth

Distance from land surface to the top of the Well Open Interval. Includes screens, perforations, etc. In feet or meters.

REQUIRED for WELLS

except for EIWs with groundwater chemistry data only

Number (10)
  • 20

Usually, depth to top of well screen. To include more information about this, use Well Construction Comment.

For open-ended wells, repeat Well Completion Depth (column AZ) in both Well Open Interval Upper Depth and Lower Depth.

Yes
Loader Discrete result BB Result Lab Replicate ID

Additional ID for lab replicate samples with the same primary Sample ID.

REQUIRED FOR

lab replicates with same Sample ID

Text (4)

Free text / preferred format

  • 1, 2
  • LR1, LR2
  • REX1, REX2
  • DIL1, DIL2

Lab (analytical) replicates are separate analyses of sub-samples created in the lab from a single field sample. They are used to assess error associated with sample heterogeneity, sample treatment, and analytical procedures - or variability of organism responses to toxicity tests.

Download help for Lab Dilutions and Re-Extractions.

Yes
Loader Discrete result BC Result Lab Name

Name of lab that analyzed the sample.

REQUIRED IF

Field Collection Type is Sample

Text (254)

Must be valid EIM Lab Name.



Search for valid values online
  • ALS Lab Group, Kelso WA
  • EcoAnalysts Inc, Port Gamble WA

Don’t fill this out for Measurements.

Some labs have new names due to mergers. Use the name the lab was under when your samples were analyzed.

Need a lab added to EIM? Contact us online or ask your data coordinator.

Yes
Loader Location BC Well Open Interval Lower Depth

Distance from land surface to the bottom of the well open interval. Includes screens, perforations, etc. In feet or meters.

REQUIRED for WELLS IF

except for EIWs with groundwater chemistry data only

Number (10)
  • 23

Usually depth to bottom of well screen. To include more information about this, use Well Construction Comment.

For open-ended wells, use Well Completion Depth (AZ) for both Well Open Interval Upper Depth and Lower Depth.

Yes
Loader Location BD Well Open Interval Units

Units in which the Well Open Interval Upper and Lower Depth is expressed.

REQUIRED for WELLS

except for EIWs with groundwater chemistry data only

Text (2) Valid values:

FT - Feet,
M - Meters
Yes
Loader Discrete result BD Result Validation Level

Third-party or independent expert data validation following the most updated versions of USEPA guidance and national functional guidelines.

Pre-August 2013 data follows older guidance.

REQUIRED ONLY FOR

samples analyzed by EPA1668A, EPA1668B, EPA1668C, EPA1613A, EPA1613B, EPA1614, EPA1699

OR for studies where data are validated by third-party or independent experts following USEPA guidance and national functional guidelines.

This may include certain Ecology Toxics Cleanup Program (TCP) and U.S. Army Corps of Engineers (USACE) sediment studies, TCP federal studies, and TCP cleanup studies.

Text (1) Valid values:

EPA1 - Stage 1: Completeness and compliance checks of sample receipt conditions,
EPA2A - Stage 2A: Completeness and compliance checks of sample receipt conditions AND ONLY sample-related QC results. (Sediment QA1 is equal to EPA stage 2A.),
EPA2B - Stage 2B: Completeness and compliance checks of sample receipt conditions and Both sample-related AND instrument-related QC results,
EPA3 - Stage 3: Completeness and compliance checks of sample receipt conditions, both sample-related and instrument-related QC results, AND recalculation checks,
EPA4 - Stage 4: Completeness and compliance checks of sample receipt conditions, both sample-related and instrument-related QC results, recalculation checks, AND evaluations of actual instrument outputs. (Sediment QA2 is equal to EPA stage 4.),
QA1 - QA1 - For sediment investigations conducted under Sediment Management Standards and sediment dredging projects,
QA2 - QA2 - More rigorous QA for sediment investigations used to develop sediment AET values and Sediment Management Standards numerical chemical criteria

If the data were NOT validated by third-party or independent experts, leave this field blank and specify QA information ONLY at the Study level (Study QA Assessment Level).

If your data were externally validated by third-party or independent experts and you are using this field to indicate the EPA validation stage, set your Study QA Assessment Level to “See Results.”

The minimum data validation stage for Toxics Cleanup Program data is EPA2B.

Pre-August 2013 data only:

  • QA1
  • QA2
Yes
Loader Location BE Well Maximum Casing Diameter

The inner diameter of the outermost permanent casing used to complete the well. In centimeters or inches.

Optional Number (5)
  • 2
  • 2.00

Report the inner diameter of the well itself and not that of the outer protective casing.

Yes
Loader Discrete result BE Result Taxon Name

Scientific or common name of the subject taxon. This is used if what you are reporting is an organism count. This is not used if an analysis was performed on animal or plant tissue.

REQUIRED FOR

macro-invertebrate, periphyton, vertebrate, shellfish or plant counts or other taxonomic data submitted as counts.

Text (254)

Must be valid EIM Taxon Name.



Search for valid values online
  • Leptoceridae
  • Achelia gracilipes

If your data are not counts, but rather results from an analysis performed on animal or plant tissue, fill out Sample Taxon Name instead.

Need a critter added to EIM? Contact us online or ask your data coordinator.

Yes
Loader Location BF Well Maximum Casing Diameter Units

Units in which Well Maximum Casing Diameter is expressed.

REQUIRED IF

Well Maximum Casing Diameter is populated

Text (2) Valid values:

CM - Centimeters,
IN - Inches
Yes
Loader Discrete result BF Result Taxon TSN

Integrated Taxon Identification System (ITIS) Taxonomic Serial Number (TSN).

Optional Text (10)

Must be valid EIM Taxon TSN.



Search for valid values online
  • 116547
  • 83584
Yes
Loader Location BG Well Casing Material

Material from which the well casing is made.

Optional Text (15) Valid values:

Concrete,
Iron,
Other - Other material,
Plastic, other,
PTFE/Teflon,
PVC - Plastic, pvc,
Steel, other,
Steel, stainless
Yes
Loader Discrete result BG Result Taxon Unidentified Species

Indicates that a subject taxon hasn’t been positively identified to the species level. The next highest taxonomic level (usually genus) is indicated in the Result Taxon Name field.

REQUIRED IF

more than one unidentified species in the same sample is reported under the same parent taxon.

Text (10) Valid values:

SP1,
SP2,
SP3,
SP4,
SP5,
SP6,
SP7,
SP8,
SP9

For unidentified taxa, roll the Result Taxon Name and TSN up to the next taxonomic level (usually genus).

Assign codes sequentially for each unidentified, rolled up species with the same parent taxon in a sample.

Download help for Entering Unidentified Species Data.

Yes
Loader Discrete result BH Result Taxon Life Stage

Describes life stage of an organism.

REQUIRED FOR

some macro-invertebrate taxonomic data and vertebrate and shellfish counts.

Text (50) Valid values:

Adult,
Egg,
Juvenile,
Larva,
Megalopa,
Nauplius,
Nymph,
Pupa,
Zoea

This field is used to separate counts, for example when there are both adults and larvae of the same taxon in an individual sample. For freshwater macroinvertebrates it is required if other than larvae. For marine macroinvertebrates it's required if other than adult.

Download help for Benthic Invertebrate Identification and Counts.

Yes
Loader Location BH Well Construction End Date

Date that well construction was completed.

REQUIRED for WELLS IF available Date

Format: MM/DD/YYYY

  • 01/01/2000"
Yes
Loader Location BI Well Construction Method

The method used to create the borehole and construct the well.

REQUIRED for WELLS IF available Text (2) Valid values:

AP - Air Percussion,
AR - Air Rotary,
BA - Bored/Augered,
CT - Cable Tool,
DR - Driven,
DU - Dug,
HR - Hydraulic Rotary,
JE - Jetted,
RR - Reverse Rotary,
SO - Sonic
Yes
Loader Discrete result BI QC Blank Type

Type of QC blank reported.

Currently, EIM accepts method blank data only for low-level PCB congener methods (EPA1668C, B, or A).

REQUIRED FOR

method blank data by EPA1668C, B, or A

Text (50) Valid values:

Method Blank

For method blank data, also enter “QC Blank” in Field Collection Type (column D) to distinguish it from regular results.

EIM won’t save method blank data for any other methods besides EPA1668C, B, or A.

Currently, EIM doesn’t accept other types of blank data, like trip or transfer.

Download help for Low-Level PCB Congener Data.

Yes
Loader Location BJ Well Construction Comment

Comments or other important information about the construction of a well.

Optional Text (2000)

Free text

  • Well constructed by owner. Depth is unknown.
Yes
Loader Discrete result BJ QC Blank Censor Factor

Blank-censor indicator or factor. QC blank data are multiplied by this number to get the detection limit threshold.

For uncensored low-level PCB congener data, EIM auto-calculates 1x, 3x, 5x, 8x, and 10x blank-censored results. The data are downloadable via EIM Search.

REQUIRED FOR

uncensored low-level PCB data by EPA1668C, B, or A

Text (50)

Leave this field blank if it doesn't apply to your data.



Valid values:

10x,
1x,
2x,
3x,
5x,
8x,
Factor Unknown,
Historical Uncensored - Historical data that is known to be uncensored/blank corrected but lacks method blank info needed for auto-censoring.,
Uncensored

For uncensored low-level PCB congener data by EPA1668C, B, or A, enter “Uncensored.”

Note: You can submit ANY data (PCB or otherwise) that’s already blank-censored and qualified. Indicate the blank-censor factor here. If you don’t know the blank censor factor, use “Factor Unknown.”

Download help for Low-Level PCB Congener Data.

Historical Uncensored - Historical data that is known to be uncensored/blank corrected but lacks method blank info needed for auto-censoring.

Yes
Loader Discrete result BK Lab Batch ID

ID given to all environmental and QC samples analyzed in the same batch. Also known as analytical batch ID.

REQUIRED FOR

uncensored low-level PCB data by EPA1668C, B, or A

Text (50)

Free text

EIM accepts whatever format a lab provides.

Note: This field was added for low-level PCB congener data. Do not use this field for any other data types.

Download help for Low-Level PCB Congener Data.

Yes
Loader Location BK Is Well Upgradient Of A FacilitySite

Indicates a well that is used to represent upgradient conditions at a particular facility or site, and is (known or assumed to be) unaffected by that site. Doesn’t necessarily reflect "pristine" or "natural" conditions.

Leave Blank

EIM no longer takes this info

Text (1)

Yes
Loader Location BL Aquifer Test Conducted

Aquifer or pumping test report is available for this well. Download from EIM Search, Well Location Data Summary page (Logs and Other Documents). Does not include short-term bailer or air-lift tests performed by the driller during well construction or development.

Leave Blank

EIM no longer takes this info

Text (1) Yes
Loader Discrete result BL Lab GC Column ID

ID of gas chromatography (GC) column used in the analysis.

REQUIRED FOR

uncensored low-level PCB data by EPA1668C, B, or A

Text (50) Valid values:

DB-1,
DB-1HT,
DB-1MS,
DB-5,
SGE-HT8,
SPB-OCTYL,
ZB-1

This field was added for low-level PCB congener data, but you can enter this for any pertinent data.

Download help for Low-Level PCB Congener Data.

Yes
Loader Location BM Naturally Flowing Well

Indicates whether an uncapped well would naturally flow due to artesian pressure.

REQUIRED for WELLS IF

well is naturally flowing

Text (1) Valid values:

N - No,
Y - Yes
Yes
Page 5 of 5    <<--    <-    ->  ->>
239 records