9588 FOREIGN_SHELL_CONDITION Entity Published / External 9556 AFSC/FMA/North Pacific Observer Foreign Fishing Data Set Completed This table contains the shell condition of crabs caught during 1988-1990. These are the original (corrected) observer data. No data have been extrapolated in this database. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC This table contains the shell condition of crabs caught during 1988-1990. These are the original (corrected) observer data. No data have been extrapolated in this database. 1 CRUISE NUMBER 22 Yes No 4 0 Active 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 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 5 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 6 SPECIES NUMBER 22 Yes No 3 0 Active A three-digit numeric code representing a marine species. NUMBER NORPAC.DOMESTIC_SPECIES 7 SEX VARCHAR2 1 Yes No Active A one-digit alpha code indicating the sex of the organism. F = female, M = male, U = unknown. VARCHAR2 8 NUMBER_IN_SAMPLE NUMBER 22 Yes No 3 0 Active The number (count) of the specified species which occurred within the sample. NUMBER 9 SHELL_CONDITION VARCHAR2 1 Yes No Active H - hard. S - soft. VARCHAR2 10 FILENAME VARCHAR2 8 No No Active original filename on the Burroughs computer system from which this data record came. VARCHAR2 11 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 12 PK_FSC NUMBER 22 Yes Yes 6 0 Active For internal use only. NUMBER gov.noaa.nmfs.inport:9588 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