Environmental Restoration Information System
Revised Data Dictionary
Revision 4.0
March 09, 1998
1. INTRODUCTION
The original Environmental Restoration Information System (ERIS) data
dictionary was issued in June 1990. The original document number was
WM-ERIS-90-0015. Since June 1990, the system has seen many revisions,
additions and deletions. Specific interest from the user community has
resulted in the ERIS database engine being used primarily for storage and
retrieval of information in two general categories: environmental chemical
sampling information, and water well information.
This document tabulates the existing tables and columns in these current
systems. Chemical Sampling information includes all results data and
ancillary data needed to determine the accuracy and data quality of the data
contained in the system. Complete data quality information can be found in
IEDMS, a feeder system to the ERIS database. Well-related information
includes all well construction information, all available lithologic and
driller's logs, all geophysical log data that are currently available, and
supporting data.
These systems were in existence in June 1990, and as such many of the
data structures can be found in both the original data dictionary and this
collection of revisions and additions. In all cases, this document supersedes
the original data dictionary, and should be checked before the original
document.
Index to tables
ANNULAR_SEAL
BORE_HOLE
CASING
CASING_COMMENTS
COMPOUND
CONTROL_POINTS
FILTER_PACK
GEO_LOG
GEO_LOG_VALUES
INTRUMENTATION
INSTRUMENTS
INTRUMENT_PACKAGE
LABORATORY
LAB_IDL
LAB_QUAL_EXPLANATION
LOG_COMMENTS
O_S_WELL
PACKER
PERMEABILITY_DATA
POROSITY_DATA
QUALIFIER_EXPLANATION
QUANT_LIMITS
RESULTS_QUALIFIERS
SCREEN
SC_FIELD_MEASUREMENT
SC_FIELD_SAMPLE
SC_METHOD_ANALYZED
SC_RESULTS
SC_SAMPLE_METHOD
SC_SAP
SC_SOW
SC_TIC_RESULTS
SPECIFIC_VVE
STRATIGRAPHY
THEORETICAL_QUANT_LIMITS
WELL
WELL_ALIAS
WELL_BRASS_CAP
WELL_COMMENTS
WELL_LITHOLOGY
WELL_PUMP
WELL_STRATA
WORK_OVER