Tables and Fields used to Generate Full Page Boring Logs

<< Click to Display Table of Contents >>

EQuIS 7  >>  EnviroInsite > EQuIS Database > EQuIS Tables >

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_CONTRACTORr

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

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

REMARK