drilled, or wound. The depth of the well intake intake_depth Numeric dt_well.intake_depth below ground surface. Y" if the well (Enumeration: was disinfected_yn Text(1) dt_well.disinfected_yn yes_no_values) disinfected, "N" if not. The historical historical_reference_elev Numeric dt_well.historical_reference_elev reference elevation. The geologic rt_geologic_unit.geologic_unit_code unit in which geologic_unit_code Text(20) dt_well.geologic_unit_code the well intake is installed. Any additional information remark Text(2000) dt_well.remark about the well. A custom custom_field_2 Text(255) dt_well.custom_field_2 field. A custom custom_field_3 Text(255) dt_well.custom_field_3 field. A custom custom_field_4 Text(255) dt_well.custom_field_4 field. A custom custom_field_5 Text(255) dt_well.custom_field_5 field. Well Construction Field Name Data Type Key Required Default Parent Lookup Database Mapping(s) Comment Checks The unique identifier of the location. Must be a valid code for the facility sys_loc_code Text(20) PK Y Location_v1.sys_loc_code dt_well_segment.sys_loc_code and reported value in the sys_loc_code field of the Location section. The type of well segment, such as rt_well_segment_type.segment_type segment_type Text(20) PK Y rt_well_segment_type.segment_type protective dt_well_segment.segment_type casing, well casing, screen, etc. The material rt_well_segment_type.material_type_code material_type_code Text(20) PK Y rt_well_segment_type.material_type_code of the well dt_well_segment.material_type_code segment.
drilled, or wound. intake_depth Numeric dt_well.intake_depth The depth of the well intake below ground surface. disinfected_yn Text(1) (Enumeration: yes_no_values) dt_well.disinfected_yn Y" if the well was disinfected, "N" if not. historical_reference_elev Numeric dt_well.historical_reference_elev The historical reference elevation. geologic_unit_code Text(20) rt_geologic_unit.geologic_unit_code dt_well.geologic_unit_code The geologic unit in which the well intake is installed. remark Text(2000) dt_well.remark Any additional information about the well. custom_field_2 Text(255) dt_well.custom_field_2 A custom field. custom_field_3 Text(255) dt_well.custom_field_3 A custom field. custom_field_4 Text(255) dt_well.custom_field_4 A custom field. custom_field_5 Text(255) dt_well.custom_field_5 A custom field. Well Construction Field Name Data Type Key Required Default Parent Lookup Database Mapping(s) Comment Checks sys_loc_code Text(20) PK Y Location_v1.sys_loc_code dt_well_segment.sys_loc_code The unique identifier of the location. Must be a valid code for the facility and reported value in the sys_loc_code field of the Location section. segment_type Text(20) PK Y rt_well_segment_type.segment_type rt_well_segment_type.segment_type dt_well_segment.segment_type The type of well segment, such as protective casing, well casing, screen, etc. material_type_code Text(20) PK Y rt_well_segment_type.material_type_code rt_well_segment_type.material_type_code dt_well_segment.material_type_code The material of the well segment.