9589 FOREIGN_SPAWN Entity Published / External 9556 AFSC/FMA/North Pacific Observer Foreign Fishing Data Set Completed This table provides information on the percentage of pollock spawners encountered for selected cruises in 1984-88. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC This table provides information on the percentage of pollock spawners encountered for selected cruises in 1984-88. 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. Cruise number is associated with all of the data collected by the observer aboard the vessel. 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 SPECIES NUMBER 22 Yes Yes 3 0 Active A three-digit numeric code representing a marine species. This code is associated with species name in NORPAC.DOMESTIC_SPECIES (using the column name SPECIES_NO in place of SPECIES). NUMBER NORPAC.DOMESTIC_SPECIES 7 LENGTH_TAKEN VARCHAR2 1 Yes No Active A one-digit numeric code. 1 - Yes, lengths were taken. 2 - No, lengths were not taken. (Other responses in this field are 3, 4, and null. The meaning of these responses are unknown and are likely erroneous.) VARCHAR2 8 PERCENT_SPAWN_FEMALES NUMBER 22 No No 2 0 Active The percentage of female pollock observed that were spawners. NUMBER 9 AGE_STRUCTURE_TAKEN VARCHAR2 1 Yes No Active A one-digit numeric code. 1 - Yes, age structures were taken. 2 - No, age structures were not taken. (The other response in this field was a null value. Likely, the observer neglected to fill in this field.) VARCHAR2 10 FEEDING_OBSERVED VARCHAR2 1 Yes No Active A one-digit numeric code. 1 - Yes, feeding was observed. 2 - No, feeding was not observed. (The other responses are 3 and null. The meaning of these responses are unknown and are likely erroneous.) VARCHAR2 11 FILENAME VARCHAR2 8 No No Active The original filename on the Burroughs computer system from which this data record came. VARCHAR2 12 HAUL_JOIN NUMBER 22 Yes Yes 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 gov.noaa.nmfs.inport:9589 Doug Turnbull 2009-06-29T18:15:11 SysAdmin InPortAdmin 2022-08-09T17:11:03 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