9565 FOREIGN_DETAIL_HAUL Entity Published / External 9556 AFSC/FMA/North Pacific Observer Foreign Fishing Data Set Completed For the years 1985-1990, both the set position and retrieval position were often recorded for each haul. This table provides whatever set position, retrieval position, delivery position, and noon position information that was recorded for each haul for those years. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC For the years 1985-1990, both the set position and retrieval position were often recorded for each haul. This table provides whatever set position, retrieval position, delivery position, and noon position information that was recorded for each haul for those years. 1 CRUISE NUMBER 22 Yes No 4 0 Active A unique four-digit number to represent each occasion that an observer was aboard a different fishing vessel during deployment. A unique four-digit number assigned to the observer for the length of their contract period. This number alone identifies and groups a set of observer information. NUMBER NORPAC.FOREIGN_FISHING_OPERATI 2 VESSEL VARCHAR2 4 Yes No Active A unique, four-digit, alpha-numeric code identifying each vessel that contracts for observer coverage. All vessel codes begin with the alpha code B, followed by a three-digit number. VARCHAR2 Refers to more than one entity 3 DT DATE 7 Yes No Active Similar to NORPAC.DOMESTIC_HAUL.HAUL_DATE, this is the date in Greenwich Mean Time. Format is stored in the database as DD-MON-YY format (i.e., 15-MAR-86), and displayed as MM/DD/YYYY HH:MI:SS (i.e., 3/15/86 00:00:00). DATE 4 YEAR NUMBER 22 Yes No 4 0 Active A four-digit number identifying the year in which the gear retrieval of the haul began. NUMBER 5 HAUL NUMBER 22 Yes No 3 0 Active A unique number which identifies a specific occurrence of net, pot, or longline fishing effort. This table does not include "no fishing" days. NUMBER 6 LOCATION_ID VARCHAR2 1 Yes No Active A one-digit alpha code that indicates what type of fishing activity occurred at the latitude and longitude recorded. R = the position of the vessel when the retrieval of the haul/set was begun, D = the position of the vessel when a delivery was completed to a mothership, N = the position of the vessel at noon (Greenwich Mean Time) on a day when no fishing took place and the vessel was not in port, S = the position of the vessel when gear began being set. VARCHAR2 7 LATITUDE NUMBER 22 Yes No 4 0 Active A four-digit number recorded in degrees and minutes north. The geographical position associated with the LOCATION_ID. NUMBER 8 E_W VARCHAR2 1 Yes No Active Direction of longitude, E = east and W = west of the 180th meridian. VARCHAR2 9 LONGITUDE NUMBER 22 Yes No 5 0 Active A five-digit number recorded in degrees and minutes west of 0 degrees. Any position west of 180 degrees is stored as a value greater than 18000, e.g., 170 degrees east longitude = 19000. The geographical position associated with the LOCATION_ID. NUMBER 10 HAUL_JOIN NUMBER 22 Yes No 6 0 Active An assigned, unique number (up to 6 digits) used to link records in this table back to a single haul record in the NORPAC.FOREIGN_HAUL table. NUMBER NORPAC.FOREIGN_HAUL 11 PK_FDH NUMBER 22 Yes Yes 6 0 Active For internal use only. NUMBER gov.noaa.nmfs.inport:9565 Doug Turnbull 2009-06-29T18:15:04 SysAdmin InPortAdmin 2022-08-09T17:11:02 2016-05-18 Alaska Fisheries Science Center AFSC 7600 Sand Point Way N.E., Building 4 Seattle WA 98115 USA https://www.afsc.noaa.gov 0700-1700 Pacific Time 1001 Public No 2016-05-18 1 Year 2017-05-18