View Name: VW_WELL
View Type: Standard
Description: VW_WELL combines well data from several tables to provide a summary view of well information.
Language: English
Output Columns:
X_COORD = VW_LOCATION.X_COORD
Y_COORD = VW_LOCATION.Y_COORD
BEARING = VW_LOCATION.BEARING
PLUNGE = VW_LOCATION.PLUNGE
REF_ELEV = DT_WELL.TOP_CASING_ELEV or if that is null then VW_LOCATION.SURF_ELEV
ELEV_UNIT = VW_LOCATION.ELEV_UNIT or DT_WELL.DEPTH_UNIT
REF_ELEV_FIELD = DT_WELL.TOP_CASING_ELEV or VW_LOCATION.SURF_ELEV
OUTER_DIAMETER = maximum DT_WELL_SEGMENT.OUTER_DIAMETER
DIAMETER_UNIT = DT_WELL_SEGMENT.DIAMETER_UNIT
FACILITY_ID = VW_LOCATION.FACILITY_ID = DT_WELL.FACILITY_ID
SYS_LOC_CODE = VW_LOCATION.SYS_LOC_CODE = DT_WELL.SYS_LOC_CODE
WELL_ID = DT_WELL.WELL_ID
GEOLOGIC_UNIT_CODE = DT_WELL.GEOLOGIC_UNIT_CODE
INSTALLATION_DATE = DT_WELL.INSTALLATION_DATE
HISTORICAL_REFERENCE_ELEV = DT_WELL.HISTORICAL_REFERENCE_ELEV
GEOLOGIST_NAME = DT_WELL.GEOLOGIST_NAME
DRILLER = DT_WELL.DRILLER
DRILLING_METHOD = DT_WELL.DRILLING_METHOD
WELL_OWNER = DT_WELL.WELL_OWNER
WELL_PURPOSE = DT_WELL.WELL_PURPOSE
TOP_CASING_ELEV = DT_WELL.TOP_CASING_ELEV
DEPTH_OF_WELL = DT_WELL.DEPTH_OF_WELL
DEPTH_TO_BEDROCK = DT_WELL.DEPTH_TO_BEDROCK
DEPTH_UNIT = DT_WELL.DEPTH_UNIT
CONSTRUCT_START_DATE = DT_WELL.CONSTRUCT_START_DATE
CONSTRUCT_COMPLETE_DATE = DT_WELL.CONSTRUCT_COMPLETE_DATE
CONSTRUCT_CONTRACTOR = DT_WELL.CONSTRUCT_CONTRACTOR
STICKUP_HEIGHT = DT_WELL.STICKUP_HEIGHT
STICKUP_UNIT = DT_WELL.STICKUP_UNIT
WEEP_HOLE = DT_WELL.WEEP_HOLE
PUMP_TYPE = DT_WELL.PUMP_TYPE
PUMP_CAPACITY = DT_WELL.PUMP_CAPACITY
PUMP_UNIT = DT_WELL.PUMP_UNIT
PUMP_YIELD = DT_WELL.PUMP_YIELD
PUMP_YIELD_METHOD = DT_WELL.PUMP_YIELD_METHOD
DEPTH_MEASURE_METHOD = DT_WELL.DEPTH_MEASURE_METHOD
SUMP_LENGTH = DT_WELL.SUMP_LENGTH
SUMP_UNIT = DT_WELL.SUMP_UNIT
WELL_STATUS = DT_WELL.WELL_STATUS
REMARK = DT_WELL.REMARK
HEAD_CONFIGURATION = DT_WELL.HEAD_CONFIGURATION
ACCESS_PORT_YN = DT_WELL.ACCESS_PORT_YN
CASING_JOINT_TYPE = DT_WELL.CASING_JOINT_TYPE
PERFORATOR_USED = DT_WELL.PERFORATOR_USED
INTAKE_DEPTH = DT_WELL.INTAKE_DEPTH
DISINFECTED_YN = DT_WELL.DISINFECTED_YN
CUSTOM_FIELD_1 = DT_WELL.CUSTOM_FIELD_1
CUSTOM_FIELD_2 = DT_WELL.CUSTOM_FIELD_2
CUSTOM_FIELD_3 = DT_WELL.CUSTOM_FIELD_3
CUSTOM_FIELD_4 = DT_WELL.CUSTOM_FIELD_4
CUSTOM_FIELD_5 = DT_WELL.CUSTOM_FIELD_5
EBATCH = DT_WELL.EBATCH
Tables: DT_WELL, DT_WELL_SEGMENT, VW_LOCATION
Database Type: SQL
Database Schema: Standard (no custom or add-on schemas required)
Database Version: EQuIS 6.0+
Data Requirements: Since this view is largely based on VW_LOCATION, please see the VW_LOCATION data requirements and troubleshooting documentation here.
Output Type: Grid
Example Output: View the following example or download the attachment.
