Tables / Fields Used in Generating Boring Logs

 

 

Tables / Fields Used in Generating Full-Page Boring Logs

 

DT_WATER_TABLE

The DT_WATER_TABLE table is only accessed for generation of full page boring logs.

Field Name

Obligatory to Populate

Notes

SYS_LOC_CODE

Yes

 

DEPTH

Yes

 

 

Data Sources for Boring Log Header or Footer Elements

This list describes tables and fields that may be accessed for generation of elements to be contained in the boring log header or footer.  This includes a number of calculated fields as described below.

Table

Field

DT_COORDINATES

X_COORD

Y_COORD

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_SUBCONSTRACTOR

DEPTH_TO_BEDROCK

BEARING

PLUNGE

ENGINEER

INSPECTOR

HOLE_DIAMETER

HOLE_DIAMETER_UNIT

AZIMUTH

INCLINE

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

Start_date

Complete_date

Custom_field_1

Custom_field_2

Custom_field_3

Custom_field_4

Custom_field_5

TOP_CASING_ELEV

DT_WATER_TABLE

DEPTH

Location ID

Calculated field from first non-null of DT_WELL.WELL_ID and DT_LOCATION.SYS_LOC_CODE

Class

Calculated field from first non-null of RT_LOCATION.LOCATION_TYPE_DESC, DT_LOCATION.LOC_DESC, and DT_LOCATION.LOC_TYPE

Total Depth

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

Data Sources for Lithology Elements

Lithology elements are displayed in the down-hole 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 down-hole 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

 

Data Sources for Downhole Point Data Elements

Downhole point data elements are displayed in the down-hole section of the full-page boring logs.  These elements may be plotted as simple text values or in profile charts.

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 down-hole 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.

Table

Field

DT_WELL_SEGMENT

SYS_LOC_CODE

SEGMENT_TYPE

START_DEPTH

END_DEPTH

DEPTH_UNIT

MATERIAL_TYPE_CODE