Tables and Fields used to Generate Full Page Boring Logs

<< Click to Display Table of Contents >>

Tables and Fields used to Generate 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 to generate elements contained in the boring log header or footer. This includes a number of calculated fields.

 

Table

Field

DT_COORDINATE

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

TYPE

SEQUENCE

DT_DRILL_ACTIVITY

SYS_LOC_CODE

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

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

 

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.

 

Table

Field

DT_WELL_SEGMENT

SYS_LOC_CODE

SEGMENT_TYPE

START_DEPTH

END_DEPTH

DEPTH_UNIT

MATERIAL_TYPE_CODE

REMARK

 

Data Sources for Geotechnical Elements

 

Table

Field

DT_GEO_STANDARD_PENETRATION

SYS_LOC_CODE

START_DEPTH

END_DEPTH

DEPTH_UNIT

DT_FACILITY

SYS_LOC_CODE

ELEV_UNIT

COORD_TYPE_CODE

IDENTIFIER

DT_GEO_TEST

START_DEPTH

END_DEPTH

TEST_TYPE

GEO_TEST_ID

OBJECT_EUID

DT_LOCATION

SYS_LOC_CODE

LOC_TYPE

UNITS

DT_GEO_RESULT

RESULT_VALUE

RESULT_VALUE_TEXT

GEO_TEST_ID

DT_COORDINATE

SYS_LOC_CODE

X_COORD

Y_COORD

ELEV

ELEV_UNIT

COORD_TYPE_CODE

IDENTIFIER

DT_BASIC_RESULT

SYS_LOC_CODE

DEPTH

CAS_RN

RESULT_VALUE

 

Data Sources for Geotechnical Sample Elements

 

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

 

Geotechnical sample elements are displayed in the Down-hole section of the full page boring logs. These elements may be directly mapped from the database or calculated and are plotted as fill or simple text values representative of values in DT_GEO_STANDARD_PENETRATION.

 

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

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 Geotechnical Test Elements

 

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

 

Geotechnical test elements are displayed in the Down-hole section of the full page boring logs. These elements may be directly mapped from the database or based on filter logic and are plotted as simple text values or in profile charts.

 

Table

Field

DT_GEO_TEST

START_DEPTH

END_DEPTH

GEO_TEST_ID

OBJECT_EUID

DT_GEO_RESULT

RESULT_VALUE

RESULT_VALUE_TEXT

GEO_TEST_ID
GEO_RESULT_CODE

DT_BASIC_RESULT

SYS_LOC_CODE

DEPTH

CAS_RN

RESULT_VALUE