EQuIS Tables and Fields Used to Generate EnviroInsite Boring Logs

<< Click to Display Table of Contents >>

Navigation:  EnviroInsite > EQuIS Database > EQuIS Tables >

EQuIS Tables and Fields Used to Generate EnviroInsite Boring Logs

The Data Sources sections of this article describe the tables and fields of the EQuIS Schema that EnviroInsite uses to generate boring logs. The fields listed include those accessed by EnviroInsite to display data directly, as well as fields used to query data for display or to generate calculated values. Italicized fields are available if the Geotech Schema is applied.  

 

Data Sources for Specific Boring Log Elements:

Header or Footer

Lithology

Sample Interval

Downhole Point

Downhole Interval: Geotechnical Sample Elements

 

Downhole / Point Data: Geotechnical Test and Result Elements

Header/Footer Function Data

Downhole Function Data

Downhole Graphic Function Data

 

For information on configuring the boring log elements (headers [Page, Data, and Title Block], footer, and downhole [chart/log] section), see the Boring Log Template Design Window. For additional options, see Downhole Intervals or Downhole Point Data.

 

The display of data on an EnviroInsite boring log can also be dynamic and controlled through parameter configurations in EQuIS reference and data tables (see Parameter Configurations for Boring Log Data).

 

 

Data Sources for Boring Log Header or Footer Elements

 

This section describes tables and fields that may be accessed to generate elements contained in the boring log header or footer.

 

Note that data from DT_DRILL_ACTIVITY may be filtered if a DT_TASK.TASK_CODE is selected when creating a Boring Log. When a TASK_CODE is selected along with locations in the Select Borings window, header data will be filtered by the chosen TASK_CODE. Only DT_DRILL_ACTIVITY records with this TASK_CODE will be plotted on the boring log. For more details, see Header Elements > DT_WATER_TABLE and DT_DRILL_ACTIVITY.

 

Users can select from various EQuIS tables and fields to be plotted in EnviroInsite Boring Log headers/footers. For more information see Header Elements > EQuIS Field Tab.

 

Table

Field

DT_FACILITY

FACILITY_ID
FACILITY_NAME
CLIENT
ADDRESS_1
CITY
STATE

DT_COORDINATE

X_COORD

Y_COORD
ELEV

DT_LOCATION

LOC_NAME

LOC_TYPE

LOC_PURPOSE

CUSTOM_FIELD_1

CUSTOM_FIELD_2

CUSTOM_FIELD_3

CUSTOM_FIELD_4

CUSTOM_FIELD_5

REMARK_1

BORE_ID

REMARK_2

START_DATE

END_DATE

DRILLING_METHOD

GEOLOGIST

DRILLER

DRILLING_SUBCONTRACTOR

DEPTH_TO_BEDROCK

BEARING

PLUNGE

ENGINEER

INSPECTOR

HOLE_DIAMETER

HOLE_DIAMETER_UNIT

DT_WELL

WELL_ID

INSTALLATION_DATE

GEOLOGIST_NAME

DRILLER

DRILLING_METHOD

WELL_OWNER

TOP_CASING_ELEV

HISTORICAL_REFERENCE_ELEV

DEPTH_OF_WELL

PUMP_TYPE

REMARK

DEPTH_TO_BEDROCK

CONSTRUCT_CONTRACTOR

CONSTRUCT_START_DATE

CONSTRUCT_COMPLETE_DATE

CUSTOM_FIELD_1

CUSTOM_FIELD_2

CUSTOM_FIELD_3

CUSTOM_FIELD_4

CUSTOM_FIELD_5

DT_WATER_TABLE

SYS_LOC_CODE1
DEPTH/DEPTH_AVG*2

STRIKE_DATE
READING#_DEPTH**
READING#_HOURS_AFTER**

READING#_SEQUENCE**

 
* If no specific water table reading is chosen, this will give an average of all the readings for this location.

**Number of available readings is the maximum number of up to five (5) readings for a single location for the entire facility.

DT_DRILL_ACTIVITY

SYS_LOC_CODE1

DRILL_EVENT*
START_DEPTH

END_DEPTH

START_DATE

END_DATE

ABANDON_YN

DIAMETER

DIAMETER_UNIT

REPLACE_YN

DRILL_METHOD

PURPOSE

FLUID

VISCOSITY

HAMMER_WT

HAMMER_FALL

CASING_SIZE

LIFT_MECHANISM

RIG_DESC

RIG_MAKE

RIG_MODEL

FLUID

ROD_DESC

BIT_DESC

HAMMER_DESC

AUGER DESC

SAMPLER_DESC

DRILLING_PRESSURE

REMARK

CUSTOM_FIELD_1

CUSTOM_FIELD_2

CUSTOM_FIELD_3

CUSTOM_FIELD_4

CUSTOM_FIELD_5

*Fields from a specific drill event can be used in the boring log by first selecting the DRILL_EVENT in the drop-down. For details, see Header Elements > DT_WATER_TABLE and DT_DRILL_ACTIVITY.

Page No.

Posts "Page [current page] of [total number of pages]".

Today's Date

Post the day the boring log is created.

Total Depth1

First non-null of DT_LOCATION.TOTAL_DEPTH and DT_WELL.DEPTH_OF_WELL

1EnviroInsite uses these fields in the background for querying data. They are not available for display on the boring logs.

2EnviroInsite uses the values in these fields to output a calculated value.

Italics - Italicized fields are available in the header/footer if the Geotech Schema is applied.

 

 

Data Sources for Lithology Elements

 

Lithology elements are displayed in the downhole section of the full page boring logs. These elements may be plotted using hatch symbology or as simple text values.

 

Table

Field

DT_LITHOLOGY

SYS_LOC_CODE

REMARK_1

REMARK_2

MATERIAL_NAME

GEO_UNIT_CODE_1

GEO_UNIT_CODE_2

GEO_UNIT_CODE_3

GEO_UNIT_CODE_4

GEO_UNIT_CODE_5

MOISTURE

PERMEABLE

COLOR

OBSERVATION

GRAINSIZE

ODOR

CUSTOM_FIELD_1

CUSTOM_FIELD_2

CUSTOM_FIELD_3

CUSTOM_FIELD_4

CUSTOM_FIELD_5

 

 

Data Sources for Sample Interval Elements

 

Sample interval elements are displayed in the downhole section of the full page boring logs. These elements may be plotted as fill or other types to indicate the sample depth range or simple text values representative of values in DT_SAMPLE_PARAMETER.

 

Table

Field

DT_SAMPLE

SYS_LOC_CODE

TOP_DEPTH

BOTTOM_DEPTH

DT_SAMPLE_PARAMETER

SYS_SAMPLE_CODE

PARAM_CODE

PARAM_VALUE

PARAM_UNIT

DT_DRILL_PARAMETER

SYS_LOC_CODE

PARAM_CODE

PARAM_VALUE

PARAM_UNIT

START_DEPTH

END_DEPTH

 

 

Data Sources for Downhole Point Data Elements

 

Downhole point data elements are displayed in the downhole section of the full page boring logs. These elements may be plotted as simple text values or in profile charts. For more options, see Downhole Point Data.

 

Note: 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

 

Table

Field

DT_DOWNHOLE_POINT_DATA

SYS_LOC_CODE

PARAM_VALUE

DEPTH

 

 

Data Sources for Well Construction Data Elements

 

Well construction data elements are displayed in the downhole section of the full page boring logs. These elements may be plotted using scaled drawings or simple schematics. The values are all accessed from DT_WELL_SEGMENT. Records from DT_WELL_SEGMENT may refer to either annular fill material or well hardware. The SEGMENT_TYPE record is used to distinguish between the two, based on selections made with EnviroInsite. For more options, see Well Construction.

 

Table

Field

DT_WELL_SEGMENT

SYS_LOC_CODE

SEGMENT_TYPE

START_DEPTH

END_DEPTH

DEPTH_UNIT

MATERIAL_TYPE_CODE

 

 

Data Sources for Downhole Interval: Geotechnical Sample Elements

 

The geotechnical data sources require that the database is configured with the Geotechnical Module.  

 

Geotechnical sample elements are displayed in the downhole section of the boring log via the Downhole Interval Data section in the Boring Log Template Design window. These elements are either directly mapped to values in the database fields named or they are calculated and plotted as fill/symbol or simple text values based on values in DT_GEO_STANDARD_PENETRATION or DT_GEO_CORING.

 

Table

Field

DT_GEO_STANDARD_PENETRATION

SYS_LOC_CODE

START_DEPTH

END_DEPTH

DEPTH_UNIT

SPT_TYPE

MAIN_BLOWS_1

MAIN_BLOWS_2

MAIN_BLOWS_3

MAIN_BLOWS_4

N_VALUE

n60

n160

DT_GEO_CORING

SYS_LOC_CODE
START_DEPTH
END_DEPTH
DEPTH_UNIT
RECOVERY_PERCENT
RQD_PERCENT

RECOVERY_LENGTH (calculated)
RQD_LENGTH (calculated)

 

Note: When plotting numeric data for Geotechnical elements, values are rounded to the nearest tenth decimal.

 

 

Data Sources for Downhole / Point Data: Geotechnical Test and Result Elements

 

The geotechnical data sources require that the database is configured with the Geotechnical Module.

 

Geotechnical test and result elements are displayed in the downhole section of the boring log as defined in the Downhole/Point Data section in the Boring Log Template Design window. These elements may be directly mapped from the database or based on filter logic, and are plotted as either simple text values or profile charts.

 

The GEO_RESULT_CODEs, defined in RT_GEO_RESULT are user-configured parameter codes that define the type of result being stored. Accordingly for these codes, the Boring Log Template Design window displays the user-defined name, rather than the field name. Certain GEO_RESULT_CODEs are hard coded in the EarthSoft Geotechnical format.

 

The Sample-Test-Result geotechnical data are stored in three tables, where DT_SAMPLE and DT_GEO_RESULT records are related via DT_GEO_TEST as follows:

DT_SAMPLE.SAMPLE_ID = DT_GEO_TEST.OBJECT_EUID

DT_GEO_TEST GEO_TEST_ID=DT_GEO_RESULT.GEO_TEST_ID

 

Table

Field

DT_SAMPLE

SAMPLE_ID

START_DEPTH*
END_DEPTH*

*Unless start/end depths are populated in DT_GEO_TEST

DT_GEO_TEST

GEO_TEST_ID

OBJECT_EUID1

TEST_TYPE2

START_DEPTH3

END_DEPTH 3

DEPTH_UNIT  

1The DT_GEO_TEST.OBJECT_EUID may be used as either DT_LOCATION.EUID or DT_SAMPLE.SAMPLE_ID. EnviroInsite will only plot data mapped to DT_SAMPLE.SAMPLE_ID

2Only test_types of Unconf_Compression and UnconsolidateUndrain are plotted. See Downhole Point Data > Test Types for additional information.

3If populated, else start/end depths pull from DT_SAMPLE

DT_BASIC_RESULT

SYS_LOC_CODE

DEPTH

CAS_RN

RESULT_VALUE

DT_GEO_RESULT

GEO_TEST_ID

GEO_RESULT_CODE

RESULT_VALUE

RESULT_VALUE_TEXT

 

 

Data Sources for Header/Footer Function Data

 

Data from SQL scalar functions may be plotted as header/footer text if configured with the following requirements:

The function name must begin with "EI_".

The inputs to the function must be the FACILITY_ID followed by the SYS_LOC_CODE.

Optional inputs for TopDepthRange (real) and BottomDepthRange (real) can also be included to specify a depth range to output specific text on each page of the boring log (see example image below).

The output of the function should return a formatted text string.

 

The image below is an example of a compatible custom database function created in SQL Server Management Studio.

 

EI-Boring_Log_SQL_Header_Example

 

 

Data Sources for Downhole Function Data

 

Data from SQL functions may be plotted as boring log columns if configured with the following requirements:

The function name must begin with "EI_".

The inputs to the function must be the FACILITY_ID followed by the SYS_LOC_CODE.

The output of the function must return columns named start_depth, end_depth, depth_unit, column_header, and column_value.

 

The column_value contains the data to be plotted. If column_header is populated, it will replace the Title Text of the column (if enabled). The start_depth and end_depth columns represent the depth intervals for each column_value. The depth_unit is used for English/metric conversion if applied by the template.

 

The image below is an example of a compatible custom database function created in SQL Server Management Studio.

 

EI-Boring_Log_SQL_Function_Example

 

 

Formatting Text in Downhole Function Data

 

Parts of the text returned from the function data may be displayed as bold or underlined. This can be accomplished using the following syntax:

Bold – <B>Some text</B>

Underline – <UL>Some text</UL>

 

The following is an example of bold and underlined text in a boring log using the above syntax.

 

EI-Boring_Log_Downhole_Text_Example

 

 

Data Sources for Downhole Graphic Function Data

 

To properly configure a downhole function that returns a graphic, the function must follow these requirements:

The function name must begin with "EI_"

The inputs to the function must be the FACILITY_ID followed by the SYS_LOC_CODE.

The output of the function must return columns named start_depth, end_depth, depth_unit, column_header, and column_value.

An optional output column named column_color may also be returned. This is an integer value representing the RBG color to be used as the background color for the log interval.

The column_value of type binary is the graphic that will be displayed on the log.

The graphic file type must be in .DXF format.

 

The image below is an example of a custom database function created in SQL Server Management Studio. In this example, the function returns a graphic associated with the sample_method at the specified depth. This function searches the DT_FILE table for a place_code that matches the sample_method and returns the content field as the column_value.

 

EI-Boring_Log_Graphic_Function_Example