34235 VERS_EFFORT Entity Published / External 26730 Vessel Electronic Reporting System (VERS) Data Set Completed Table contains effort level records for electronically reported data Loaded by batch 9189, 08-11-2016 10:02 Data Table Yes FVTR Table contains effort level records for electronically reported data 1 TRIP_ID NUMBER 22 Yes Yes 14 0 Active Unique trip identifier NUMBER FVTR.VERS_TRIP 2 EFFORT_NUM NUMBER 22 Yes Yes 3 0 Active Unique identifier for the effort NUMBER 3 START_SET_DATE_GMT DATE 7 No No Active Datetime (UTC) when the gear is first placed in the water at the start of the fishing effort DATE 4 START_SET_LAT NUMBER 22 No No 11 6 Active Latitude where the gear is first placed in the water at the start of the fishing effort (ddmm.mmmm) NUMBER 5 START_SET_LON NUMBER 22 No No 11 6 Active Longitude where the gear is first placed in the water at the start of the fishing effort (dddmm.mmmm) NUMBER 6 END_SET_DATE_GMT DATE 7 No No Active Datetime (UTC) when setting of the gear has stopped and the gear begins to fish DATE 7 END_SET_LAT NUMBER 22 No No 11 6 Active Latitude where the setting of the gear has stopped and the gear begins to fish (ddmm.mmmm) NUMBER 8 END_SET_LON NUMBER 22 No No 11 6 Active Longitude where the setting of the gear has stopped and the gear begins to fish (dddmm.mmmm) NUMBER 9 START_HAUL_DATE_GMT DATE 7 No No Active Datetime (UTC) when fishing stops and hauling the gear starts DATE 10 START_HAUL_LAT NUMBER 22 No No 11 6 Active Latitude where fishing stops and hauling the gear starts (ddmm.mmmm) NUMBER 11 START_HAUL_LON NUMBER 22 No No 11 6 Active Longitude where fishing stops and hauling the gear starts (dddmm.mmmm) NUMBER 12 END_HAUL_DATE_GMT DATE 7 No No Active Datetime (UTC) when the gear has been completely hauled and is back aboard the vessel DATE 13 END_HAUL_LAT NUMBER 22 No No 11 6 Active Latitude where the gear has been completely hauled and is back aboard the vessel (ddmm.mmmm) NUMBER 14 END_HAUL_LON NUMBER 22 No No 11 6 Active Longitude where the gear has been completely hauled and is back aboard the vessel (dddmm.mmmm) NUMBER 15 DEPTH NUMBER 22 No No 4 0 Active Fishing depth of the gear NUMBER 16 DEPTH_UOM VARCHAR2 2 No No Active Unit of measure for DEPTH VARCHAR2 FVTR.FVTR_UNITS_OF_MEASURE 17 TEMP NUMBER 22 No No 5 2 Active Water temperature (degrees C) NUMBER 18 GC_GEAR_CODE VARCHAR2 6 Yes No Active Gear code for the gear type used during the fishing effort; see FVTR_GEAR_CODES VARCHAR2 FVTR.FVTR_GEAR_CODES 19 GEAR_QUANTITY NUMBER 22 No No 4 0 Active Number of pieces of gear fished simultaneously (for subtrip reporting, this will be an average of gear pieces fished for the relevant hauls) NUMBER 20 GEAR_SIZE NUMBER 22 No No 6 1 Active Size of the gear being fished (for subtrip reporting, this will be an average of gears fished for the relevant hauls) NUMBER 21 MESH_SIZE NUMBER 22 No No 6 3 Active Size of the mesh or ring used on the fishing gear (for subtrip reporting, this will be an average of gears fished for the relevant hauls) NUMBER 22 MESH_TYPE VARCHAR2 1 No No Active Type of mesh being fished on trawl or gillnet gear; see FVTR_MESH_TYPES VARCHAR2 FVTR.FVTR_MESH_TYPES 23 NUM_HAULS NUMBER 22 No No 3 0 Active Number of hauls contained within the subtrip (always equals 1 when reporting at the haul-by-haul level) NUMBER 24 SOAK_DURATION_DH NUMBER 22 No No 6 2 Active Soak or haul duration of the fishing effort (h.hh) NUMBER 25 FAILED_EFFORT VARCHAR2 1 No No Active Binary code used to indicate a 'water haul' or fishing effort without catch; 0=valid effort, 1=failed effort VARCHAR2 26 EFFORT_ENTRY_DATE_GMT DATE 7 No No Active Datetime (UTC) at which the effort record was entered into the ELB DATE 27 UPLOAD_DATE_GMT DATE 7 No No Active Datetime (UTC) at which the submitted data was loaded to NEFSC servers DATE 28 FA_AREA_CODE VARCHAR2 3 Yes No Active Statistical area in which the fishing effort occurred, value assigned based on the START_HAUL_LAT and START_HAUL_LON point location (see FVTR_FISHING_AREAS) VARCHAR2 FVTR.FVTR_FISHING_AREAS 29 FA_SUB_AREA_CODE VARCHAR2 5 Yes No Active Inshore area code within the statistical area in which the fishing effort occurred, value assigned based on the START_HAUL_LAT and START_HAUL_LON point location (see FVTR_FISHING_AREAS) VARCHAR2 FVTR.FVTR_FISHING_AREAS 30 LORAN_BEARING1 VARCHAR2 12 No No Active First loran chain bearing corresponding to the average position of all efforts within a sub-trip (not collected when reporting via ELB at the haul-by-haul level) VARCHAR2 31 LORAN_BEARING2 VARCHAR2 12 No No Active Second loran chain bearing corresponding to the average position of all efforts within a sub-trip (not collected when reporting via ELB at the haul-by-haul level) VARCHAR2 32 START_HAUL_LAT_DMS VARCHAR2 6 No No Active Currently not used VARCHAR2 33 START_HAUL_LON_DMS VARCHAR2 7 No No Active Currently not used VARCHAR2 gov.noaa.nmfs.inport:34235 Patricia Jones 2016-08-11T10:02:33 SysAdmin InPortAdmin 2022-08-09T17:11:05 2016-08-23 Northeast Fisheries Science Center NEFSC 166 Water Street Woods Hole MA 02543-1026 USA (508)495-2000 https://www.nefsc.noaa.gov 8:00 a.m. to 4:30 p.m. Monday - Friday 1001 Public No 2016-08-23 1 Year 2017-08-23