View Name: VW_WELL_SEGMENT
View Type: Standard
Description: VW_WELL_SEGMENT returns data from DT_WELL_SEGMENT with additional data from RT_WELL_SEGMENT_TYPE and VW_WELL.
Language: English
Output Columns: All fields are pulled directly from DT_WELL_SEGMENT unless otherwise noted.
X_COORD = VW_WELL.X_COORD
Y_COORD = VW_WELL.Y_COORD
BEARING = VW_WELL.BEARING
PLUNGE = VW_WELL.PLUNGE
REF_ELEV = VW_WELL.REF_ELEV
REF_ELEV_FIELD = VW_WELL.REF_ELEV_FIELD
START_ELEV = VW_WELL.REF_ELEV - (DT_WELL_SEGMENT.START_DEPTH converted to units in VW_WELL_SEGMENT.ELEV_UNIT)
END_ELEV = VW_WELL.REF_ELEV - (DT_WELL_SEGMENT.END_DEPTH converted to units in VW_WELL_SEGMENT.ELEV_UNIT)
ELEV_UNIT = VW_WELL.ELEV_UNIT or VW_WELL.DEPTH_UNIT or DT_WELL_SEGMENT.DEPTH_UNIT (the first non-null value from this list will be selected)
FACILITY_ID = DT_WELL_SEGMENT.FACILITY_ID = VW_WELL.FACILITY_ID
SYS_LOC_CODE = DT_WELL_SEGMENT.SYS_LOC_CODE = VW_WELL.SYS_LOC_CODE
SEGMENT_TYPE = DT_WELL_SEGMENT.SEGMENT_TYPE = RT_WELL_SEGMENT_TYPE.SEGMENT_TYPE
MATERIAL_TYPE_CODE = DT_WELL_SEGMENT.MATERIAL_TYPE_CODE = RT_WELL_SEGMENT_TYPE.MATERIAL_TYPE_CODE
START_DEPTH = DT_WELL_SEGMENT.START_DEPTH
END_DEPTH = DT_WELL_SEGMENT.END_DEPTH
DEPTH_UNIT
INNER_DIAMETER
OUTER_DIAMETER
DIAMETER_UNIT
THICKNESS
THICKNESS_UNIT
SLOT_TYPE
SLOT_SIZE
SLOT_SIZE_UNIT
PERF_LENGTH
SCREEN_TYPE
MATERIAL_QUANTITY
MATERIAL_DENSITY
REMARK
EBATCH
PERF_LENGTH_UNIT
CUSTOM_FIELD_1
CUSTOM_FIELD_2
CUSTOM_FIELD_3
CUSTOM_FIELD_4
CUSTOM_FIELD_5
EUID
IS_SCREEN_YN = RT_WELL_SEGMENT_TYPE.IS_SCREEN_YN
Tables: DT_WELL_SEGMENT, RT_WELL_SEGMENT_TYPE, VW_WELL
Database Type: SQL
Database Schema: Standard (no custom or add-on schemas required)
Database Version: EQuIS 6.0+
Data Requirements: Since this view is based in part on VW_WELL, please see the VW_WELL data requirements here.
Output Type: Grid
Example Output: View the following example or download the attachment.
