EQuIS Data Tables and Fields Used in EnviroInsite

DT_ACTION_LEVEL

Field Name	Obligatory to Populate	Notes
ACTION_LEVEL_CODE	Yes	Used to populate action level selection list.
MATRIX	Yes	Must match DT_SAMPLE.MATRIX to be applied to a particular sample / result.
FRACTION	No	If not populated, the fraction field in DT_ACTION_LEVEL_PARAMETER must be populated.

DT_ACTION_LEVEL_PARAMETER

Field Name	Obligatory to Populate	Notes
PARAM_CODE	Yes
ACTION_LEVEL	Yes
UNIT	Yes	Value against which results are compared to determine exceedance.
ACTION_LEVEL_MIN	No	If populated, result will be flagged as exceedance based on value being less than this field’s value.
MATRIX	No	If not populated, the matrix field in DT_ACTION_LEVEL must be populated.
FRACTION	No	If not populated, the fraction field in DT_ACTION_LEVEL must be populated.

DT_COORDINATE

Plot types that are not location-dependent, such as boring logs, Stiff diagrams and Piper diagrams, may be created with no associated DT_COORDINATE record. Other plot types require a DT_COORDINATE value with a legitimate X and Y coordinate.

EnviroInsite determines the coordinate system recorded in the DT_COORDINATES table based on the value in the EQuIS data fields DT_FACILITY.COORD_TYPE and the associated record in RT_COORD_TYPE.SRID.

•An SRID value of 4326 in RT_COORD_TYPE.SRID indicates that the coordinate values are in latitude-longitude coordinates. In that case, the display coordinates will be in UTM, within the UTM zone at the center of the extent of the location positions.

•SRID values starting with 326 are presumed to indicate UTM coordinates within the northern hemisphere. SRID values starting with 327 are presumed to indicate UTM coordinates within the southern hemisphere. The final two digits in either of these cases are taken to be the UTM longitudinal zone. For example, an SRID value of 32617 would represent UTM longitudinal zone 17 in the northern hemisphere. State plane coordinates are not supported at this time.

•Other SRID values for MTM, State Plane or Spherical Mercator coordinates are not presently supported.

Field Name	Obligatory to Populate	Notes
SYS_LOC_CODE	Yes	Foreign key to DT_LOCATION
COORD_TYPE_CODE	Yes
IDENTIFIER	Yes
X_COORD Y_COORD	No*	Time-history plots, boring logs, Stiff diagrams, Durov diagrams and Piper diagrams can be created with these values not populated. The values are either provided as latitude-longitude pairs or assumed to have length units that are consistent with the coordinate system selected in EnviroInsite. If the user has selected either State Plane and metric or UTM, the horizontal units are in meters. If the user has selected State Plane and feet, the units are in feet. If the user has selected Local, the units are ambiguous and assigned within EnviroInsite. * These values are required to plot DT_DOWNHOLE_POINT_DATA in a boring log.
ELEV	No*	This value is used to determine the ground surface elevation. The program will assign the maximum value of the DT_COORDINATE.ELEV for records where the value is not populated. *If DT_WELL.TOP_CASING_ELEV is populated, DT_COORDINATE.ELEV is required to plot locations.
ELEV_UNIT	No	If not populated, the value will default to DT_WELL.DEPTH_UNIT, DT_LOCATION.UNITS or DT_FACILITY.ELEV_UNIT in that order.

DT_DOWNHOLE_POINT_DATA

Data from this table is used to generate profile charts on cross sections and strip logs. The following fields are required to plot DT_DOWNHOLE_POINT_DATA in a boring log:

•DT_COORDINATE.X_COORD

•DT_COORDINATE.Y_COORD

•DT_LOCATION.LOC_TYPE

Field Name	Obligatory to Populate	Notes
SYS_LOC_CODE	Yes	Foreign key to DT_LOCATION
DEPTH	Yes	Values are presumed to be in the same units as DT_FACILITY.ELEV_UNITS.
PARAM	Yes
PARAM_VALUE	Yes
PARAM_UNIT	No	The program does not make any unit conversions based on the PARAM_UNIT value. All PARAM_VALUES for a particular plot are presumed to be in consistent units.

DT_FACILITY

Field Name	Obligatory to Populate	Notes
FACILITY_ID	Yes	Must be populated in this instance and in all other tables where it appears, whether or not cited in this document.
COORD_TYPE_CODE IDENTIFIER	Yes	Change either of these to select rows within DT_COORDINATE.
ELEV_UNIT	Yes	All elevation and depth values will be converted to these coordinates.
X_MIN X_MAX Y_MIN Y_MAX	No	EnviroInsite uses these values as the default query limits and the initial view limits. If not populated, the program will use the calculated limits of the coordinates from DT_COORDINATE for the specified COORD_TYPE_CODE and identifier.

Geotechnical Data

If the Geotechnical Schema has been applied to the database, the following Geotechnical tables will be available in the Downhole Point Data section or Downhole Intervals section for boring logs:

•Downhole Point Data - DT_GEO_RESULT

•Downhole Intervals - DT_GEO_STANDARD_PENETRATION and DT_GEO_CORING

DT_LITHOLOGY

EnviroInsite treats lithology data as being derived from either borehole-scale inspection at a single location, or regional-scale observations representative of stratigraphic units. The latter, referred to as stratigraphy, may be used to generate geologic models in both 3D and on cross-sections. The former, referred to as geology, are not used within EnviroInsite to interpolate between boreholes. The stratigraphy values are required to conform to a layer-cake representation, although pinch-outs and missing units are handled within EnviroInsite.

Field Name	Obligatory to Populate	Notes
SYS_LOC_CODE	Yes	Foreign key to DT_LOCATION
START_DEPTH	Yes	Values are presumed to be in the same units as DT_FACILITY.ELEV_UNITS. Each record’s end-depth is given by the START_DEPTH of the succeeding interval (from top to bottom). For the deepest interval, the interval bottom is taken from the first non-null of DT_LOCATION.TOTAL_DEPTH or DT_WELL.DEPTH_OF_WELL.
MATERIAL_NAME	No	Should be populated for representation of small-scale variation in soil and rock. Used in boring logs and boreholes plotted on cross-sections and in 3D.
GEO_UNIT_CODE_1 GEO_UNIT_CODE_2 GEO_UNIT_CODE_3 GEO_UNIT_CODE_4 GEO_UNIT_CODE_5 CUSTOM_FIELD_1 CUSTOM_FIELD_2 CUSTOM_FIELD_3 CUSTOM_FIELD_4 CUSTOM_FIELD_5	No	At least one of these records should be populated for representation of regional scale stratigraphy. Used in generation of geologic models sets at a document scale within EnviroInsite. Selection is made from the EQuIS Options dialog box.

DT_LOCATION

Field Name	Obligatory to Populate	Notes
SYS_LOC_CODE	Yes
LOC_NAME	No	This field may be specified as the source of the plotted location ID. If not populated, the location ID will default to the SYS_LOC_CODE value.
LOC_DESC	Yes
LOC_TYPE	No*	Used to filter selection of plotted locations. * Required to plot DT_DOWNHOLE_POINT_DATA in a boring log.
UNITS	No	A fallback exists if the units are not provided, but results may be unpredictable. Should not be populated if the TOTAL_DEPTH is not populated. Otherwise, may interfere with specification of depth units for DT_WELL.DEPTH_OF_WELL.
TOTAL_DEPTH	No	If not entered, the total depth at a location will be accessed from DT_WELL.DEPTH_OF_WELL. If neither is populated, then the total depth value will default to zero.
BEARING	No	Will default to vertical well if not populated.
PLUNGE	No

DT_LOCATION_PARAMETER

This table is only accessed by EnviroInsite for the generation of Wind Rose diagrams.

Field Name	Obligatory to Populate	Notes
SYS_LOC_CODE	Yes
PARAM_CODE	Yes	Records containing either wind speed or wind direction are indicated based on value of PARAM_CODE field.
MEASUREMENT_DATE	Yes
PARAM_VALUE	Yes
PARAM_UNIT	Yes	Only needs to be populated for wind speed. The direction is presumed to be degrees clockwise relative to due north. There is no unit conversion of speed units.

DT_MEASURE_DATUM

This table is accessed for water elevation calculation in those instances where DT_MEASURE_DATUM.DATA_VALUE has been specified in EnviroInsite as the reference elevation source.

Field Name	Obligatory to Populate	Notes
SYS_LOC_CODE	Yes
START_DATE	Yes
DATUM_VALUE	Yes
DATUM_UNIT	Yes
STEP_OR_LINEAR	Yes

DT_RESULT

Field Name	Obligatory to Populate	Notes
TEST_ID	Yes
CAS_RN	Yes
RESULT_TEXT	No	The content of this field will be used, by default, in Spider diagrams / data table plots. If not populated, the value of RESULT_NUMERIC will be formatted and used instead. If neither are populated and result is non-detect, a text string will be constructed using a less-than sign (<) and the detection limit.
RESULT_NUMERIC	No	See RESULT_TEXT
REPORTABLE_RESULT	Yes	Used for filtering of result values.
DETECT_FLAG	Yes	Used for filtering of result values.
LAB_QUALIFIERS VALIDATOR_QUALIFIERS INTERPRETED_QUALIFIERS DQM_QUALIFIERS	No	One of these fields will be selected in the EQuIS options dialog box for representation of result qualifiers in the Spider diagram / data table and posted-value plots.
REPORTING_DETECTION _LIMIT METHOD_DETECTION_ LIMIT QUANTITATION_LIMIT	No	The first non-null value of these fields, in order presented at left, will be used for representation of the reported detection limit.
RESULT_UNIT	Yes
DETECTION_LIMIT_UNIT	No	Does not generally need to be populated, but must to be populated if one of the detection limit fields specified above are populated.

DT_SAMPLE

Field Name	Obligatory to Populate	Notes
SAMPLE_ID	Yes
SAMPLE_TYPE_CODE	Yes	Used to determine duplicates. “FD” is hard-wired in the code to represent field duplicates.
SAMPLE_NAME	No	Used as reported Sample ID value. If not populated, the SYS_SAMPLE_CODE will be used instead.
SYS_LOC_CODE	Yes
START_DEPTH END_DEPTH	No	Start and end depths will be assigned a zero-value. Some MATRIX_CODE values will be associated with depths assigned within DT_WELL_SEGMENT. For those instances, the DT_SAMPLE.START_DEPTH and END_DEPTH may be left unpopulated.
DEPTH_UNIT	No	Should be populated if START_DEPTH and END_DEPTH are populated.
SAMPLE_DATE	Yes
TASK_CODE	Yes	Used for filtering of sample values.
MATRIX_CODE	Yes	Essential to populate

DT_SDG

Field Name	Obligatory to Populate	Notes
SDG_NAME	No	Populate to filter results based on the value of DT_TEST.LAB_SDG. Used to populate selection list for task delivery groups. Values of SDG_NAME must match values of DT_TEST.LAB_SDG.

DT_SOIL_GAS_SURVEY

Field Name	Obligatory to Populate	Notes
SYS_LOC_CODE	Yes
SURVEY_DATE	Yes
PARAM_CODE	Yes
READING_DEPTH	No	Assigned to zero depth if not populated.
READING_UNIT	Yes
READING	Yes
DEPTH_UNIT	No	Needs to be populated if the READING_DEPTH field is populated.

DT_TASK

Field Name	Obligatory to Populate	Notes
TASK_CODE	No	Populate to be able to filter DT_SAMPLE records based on the task code. Field contents must match with values in DT_SAMPLE.TASK_CODE.

DT_TEST

Field Name	Obligatory to Populate	Notes
TEST_ID	Yes
SAMPLE_ID	Yes
ANALYTIC_METHOD	No	Used in filtering of test values.
FRACTION	Yes
LAB_SDG	No	Used in filtering of test values. Should match with values in DT_SDG.SDG_NAME.

DT_WATER_LEVEL

This table contains information regarding water level collection data. The fields to be populated are determined based on the selected option in the Data Mapping tab of the EQuIS options dialog box within EnviroInsite. If the DT_WATER_LEVEL.WATER_LEVEL_ELEV option is selected, WATER_LEVEL_ELEV and DEPTH_UNIT should be populated. If DT_WATER_LEVEL.CORRECTED_ELEVATION is selected, CORRECTED_ELEVATION and DEPTH_UNIT should be populated. If Calculate Elevation is the selected option, there are additional dependencies of the fields to be populated on the selected reference elevation (either DT_WATER_LEVEL.HISTORICAL_REFERENCE_ELEV, DT_MEASURE_DATUM.DATUM_VALUE, VW_LOCATION.SURF_ELEV, OR DT_WELL.TOP_CASING_ELEV) and the selected depth field (calculated based on product density, DT_WATER_LEVEL.CORRECTED_DEPTH or DT_WATER_LEVEL.WATER_LEVEL_DEPTH).

Field Name	Obligatory to Populate	Notes
SYS_LOC_CODE	Yes
MEASUREMENT_DATE	Yes
HISTORICAL_REFERENCE _ELEV	Depends on EQuIS Options set in EI	Obligatory if Calculate Elevation is selected and HISTORICAL_REFERENCE_ELEVATION are identified as data source.
WATER_LEVEL_DEPTH	Depends on EQuIS Options set in EI	Obligatory if Calculate Elevation is selected and either Calculate based on Product Density, or WATER_LEVEL_DEPTH are selected.
WATER_LEVEL_ELEV	Depends on EQuIS Options set in EI	Obligatory if WATER_LEVEL_ELEV option is selected.
CORRECTED_ELEVATION	Depends on EQuIS Options set in EI	Obligatory if CORRECTED_ELEVATION option is selected.
CORRECTED_DEPTH	Depends on EQuIS Options set in EI	Obligatory if Calculate Elevation and CORRECTED_DEPTH options are selected.
DEPTH_UNIT	Yes
DIP_OR_ELEVATION	Depends on EQuIS Options set in EI	Obligatory if Calculate Elevation is selected.
LNAPL_DEPTH	Depends on EQuIS Options set in EI	Obligatory if Calculate Elevation and Calculate based on Product Density are both selected.
LNAPL_CAS_RN	Depends on EQuIS Options set in EI	Obligatory if Calculate Elevation and Calculate based on Product Density are both selected. Must also populate the specific gravity in the associated RT_ANALYTE record.

DT_WELL

Field Name	Obligatory to Populate	Notes
SYS_LOC_CODE	Yes
WELL_ID	Yes
GEOLOGIC_UNIT_CODE	No	Populated if intend to filter based on geologic unit code.
DEPTH_UNIT	No	Should be populated if DEPTH_OF_WELL field is populated.
TOP_CASING_ELEV	No	May be accessed by water level calculations where the Calculate Water Elevation option is selected and the top of casing elevation is designated as the reference point. Also used in plotting of wells on cross-sections and in 3D. * If this field is populated, populating DT_COORDINATE.ELEV is required in order to plot locations.
DEPTH_OF_WELL	No	EnviroInsite uses DT_LOCATION.TOTAL_DEPTH to determine total depth at a particular location. If TOTAL_DEPTH field is not populated, then DT_WELL.DEPTH_OF_WELL will be accessed. If both fields are null, then the total depth will be assigned a zero value.

DT_WELL_SEGMENT

The DT_WELL_SEGMENT table will be used to specify the elevation horizon of sample intervals for sample matrix values designated as such in the EQuIS Options dialog box. For example, when repeat samples are collected from the same interval (e.g. well screens), it may not be advisable to use the depth fields in DT_SAMPLE. In those cases, the sample intervals would be a record in the DT_WELL_SEGMENT table. The option to use DT_WELL_SEGMENT for the sample interval is selected by the EnviroInsite user as described in the Sample Interval Horizon Tab section of the EQuIS Options dialog box.

Field Name	Obligatory to Populate	Notes
SYS_LOC_CODE	Yes
SEGMENT_TYPE	Yes	Value of this field that corresponds to a well screen is specified in the EQuIS Options dialog box.
MATERIAL_TYPE_CODE	No	Used only by full-page boring logs.
START_DEPTH	Yes
END_DEPTH	Yes
DEPTH_UNIT	Yes
INNER_DIAMETER OUTER_DIAMETER	No	Used only by full-page boring logs and only if scaled diameter option is selected.