Well_v1 Field Name Data Type Key Required Default Parent Lookup Database Mapping(s) Comment Checks The unique identifier of the location. Must be a code for the facility and sys_loc_code Text(20) PK Y Location_v1.sys_loc_code dt_well.sys_loc_code reported value in the sys_loc_code field of the Location section. The ID of the well_id Text(30) dt_well.well_id well. The well_desc Text(255) dt_well.custom_field_1 description of the well. The name of well_owner Text(50) dt_well.well_owner the well owner. The purpose well_purpose Text(20) dt_well.well_purpose of the well. The status of well_status Text(20) dt_well.well_status the well. The top of casing top_casing_elev Numeric dt_well.top_casing_elev elevation of the well. The total depth of the depth_of_well Numeric dt_well.depth_of_well well below ground surface. The unit of depth_unit Text(15) rt_unit.unit_code dt_well.depth_unit measurement of the depth. The method depth_measure_method Text(20) dt_well.depth_measure_method of depth measurement. The height of the casing stickup_height Text(8) dt_well.stickup_height above ground surface. The unit of measure of stickup_unit Text(15) rt_unit.unit_code dt_well.stickup_unit the stickup height. The length of sump_length Text(20) dt_well.sump_length the sump. The unit of measure of sump_unit Text(15) rt_unit.unit_code dt_well.sump_unit the sump length.
Well_v1 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.sys_loc_code The unique identifier of the location. Must be a code for the facility and reported value in the sys_loc_code field of the Location section. well_id Text(30) dt_well.well_id The ID of the well. well_desc Text(255) dt_well.custom_field_1 The description of the well. well_owner Text(50) dt_well.well_owner The name of the well owner. well_purpose Text(20) dt_well.well_purpose The purpose of the well. well_status Text(20) dt_well.well_status The status of the well. top_casing_elev Numeric dt_well.top_casing_elev The top of casing elevation of the well. depth_of_well Numeric dt_well.depth_of_well The total depth of the well below ground surface. depth_unit Text(15) rt_unit.unit_code dt_well.depth_unit The unit of measurement of the depth. depth_measure_method Text(20) dt_well.depth_measure_method The method of depth measurement. stickup_height Text(8) dt_well.stickup_height The height of the casing above ground surface. stickup_unit Text(15) rt_unit.unit_code dt_well.stickup_unit The unit of measure of the stickup height. sump_length Text(20) dt_well.sump_length The length of the sump. sump_unit Text(15) rt_unit.unit_code dt_well.sump_unit The unit of measure of the sump length.