Well Construction

Report Name: Well Construction (example)

File Name: EarthSoft.Reports.Library.103887.dll

Dependencies: N/A

Software: EQuIS Professional and EQuIS Enterprise

Source: contact EarthSoft Support

Language: English

Output Type: Report Grid1

Description: The Well Construction Report outputs well construction information.

Overview:

Locations with well construction details stored in DT_WELL and DT_WELL_SEGMENT with the appropriate SEGMENT_TYPE per default set in ST_CONFIG.STRING_VALUE. This report generates output from DT_WELL, DT_LOCATION, DT_COORDINATE, and DT_WELL_SEGMENT with default SEGMENT_TYPE='SCREEN'. The default value of SEGMENT_TYPE can be modified in ST_CONFIG by populating a new SEGMENT_TYPE value in STRING_VALUE where CONFIG_SECTION='well construction' and CONFIG_KEY='segment_type'.

The X_COORD and Y_COORD columns are renamed as LONG/LAT, SPX/SPY, EASTING/NORTHING accordingly based on COORD_TYPE_CODE like '%LAT%LONG%', '%SPCS%' or '%UTM%'.

Tables: DT_WELL, DT_WELL_SEGMENT, DT_LOCATION, DT_COORDINATE

Report Parameters

Location
Individual(s)	Parameter for selecting individual locations.
Group(s)	Parameter for selecting location groups.
Coordinate Type Code	Parameter for selecting the coordinate type code.
Identifier	Select the identifier for the wells.

Report Output
SYS_LOC_CODE LOC_NAME LOC_DESC IS_WELL LOC_STATE_CODE LOC_COUNTRY_CODE STREAM_MILE UNITS LOC_TYPE LOC_TYPE_2 ELEV_DATUM_CODE REFERENCE_POINT HORZ_DATUM_CODE HOR_ACCURACY_VALUE HORZ_COLLECT_METHOD_CODE SOURCE_SCALE	ELEVATION_OF TOP_CASING_ELEV ELEV_ACCURACY_VALUE ELEV_COLLECT_METHOD_CODE TOC STICKUP_HEIGHT STICKUP_UNIT WELL_ID WELL_OWNER DEPTH_OF_WELL WELL_DEPTH_UNIT HEAD_CONFIGURATION CONSTRUCT_COMPLETE_DATE WELL_REMARK START_DEPTH END_DEPTH	DEPTH_UNIT OUTER_DIAMETER INNER_DIAMETER MATERIAL_TYPE_CODE AQUIFER COORD_TYPE_CODE LAT LONG SPX SPY SPZ EASTING NORTHING UTMZONE

Report Output

SYS_LOC_CODE

LOC_NAME

LOC_DESC

IS_WELL

LOC_STATE_CODE

LOC_COUNTRY_CODE

STREAM_MILE

UNITS

LOC_TYPE

LOC_TYPE_2

ELEV_DATUM_CODE

REFERENCE_POINT

HORZ_DATUM_CODE

HOR_ACCURACY_VALUE

HORZ_COLLECT_METHOD_CODE

SOURCE_SCALE

ELEVATION_OF

TOP_CASING_ELEV

ELEV_ACCURACY_VALUE

ELEV_COLLECT_METHOD_CODE

TOC

STICKUP_HEIGHT

STICKUP_UNIT

WELL_ID

WELL_OWNER

DEPTH_OF_WELL

WELL_DEPTH_UNIT

HEAD_CONFIGURATION

CONSTRUCT_COMPLETE_DATE

WELL_REMARK

START_DEPTH

END_DEPTH

DEPTH_UNIT

OUTER_DIAMETER

INNER_DIAMETER

MATERIAL_TYPE_CODE

AQUIFER

COORD_TYPE_CODE

LAT

LONG

SPX

SPY

SPZ

EASTING

NORTHING

UTMZONE

Remap Options:

The report output fields shown below can be remapped using REMAP_CODE = WELL_CONSTRUCTION.

•COORD_TYPE_CODE

•REFERENCE_POINT

•HORZ_DATUM_CODE

•HORZ_ACCURACY_VALUE

•HORZ_COLLECT_METHOD_CODE

•SOURCE_SCALE

•ELEV_ACCURACY_VALUE

•ELEV_COLLECT_METHOD_CODE

•LOC_TYPE_2

•HEAD_CONFIGURATION

The details are populated in RT_REMAP_DETAIL as follows:

•EXTERNAL_FIELD = the name of the field to be remapped. These values may be upper or lower characters (e.g., Coord_Type_Code is valid if needed).

•EXTERNAL_VALUE = the new target value

•INTERNAL_VALUE = the old source value to be remapped

1The Report Grid provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML, or a printer.