69746 CATCH Entity Published / External 22008 AFSC/RACE/GAP: RACEBASE Database Data Set Completed Summary values for organisms caught in the net, summarized by species and haul. Fields contain total weight and number of each species and whether any organisms were collected for voucher specimens Data Table Yes RACEBASE Summary values for organisms caught in the net, summarized by species and haul. Fields contain total weight and number of each species and whether any organisms were collected for voucher specimens 1 CRUISEJOIN NUMBER 22 Yes No 12 0 Active This is a unique numeric identifier assigned to each VESSEL, CRUISE) combination NUMBER 2 HAULJOIN NUMBER 22 Yes No 12 0 Active This is a unique numeric identifier assigned to each (VESSEL, CRUISE, HAUL) combination NUMBER 3 CATCHJOIN NUMBER 22 Yes Yes 12 0 Active This is a unique numeric identifier assigned to each (VESSEL, CRUISE, HAUL, SPECIES_CODE) combination NUMBER 4 REGION VARCHAR2 3 Yes No Active Valid Values: AI=Aleutian Islands, BS=Bering Sea, GOA=Gulf of Alaska, WC=West Coast,HBS=Hydroacoustic Bering Sea, HG=Hydroacoustic Gulf of Alaska, HWC=Hydroacoustic West Coast, TAG=Denotes that no biological data exist for this cruise other than those related to tags released or recovered. VARCHAR2 5 VESSEL NUMBER 22 Yes No 4 0 Active Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual NUMBER 6 CRUISE NUMBER 22 Yes No 6 0 Active This is a six-digit number identifying the Cruise number of the form: YYYY99 (where YYYY = year of the cruise; 99 = 2-digit number and is sequential; 01 denotes the first cruise that vessel made in this year, 02 is the second, etc. NUMBER 7 HAUL NUMBER 22 Yes No 4 0 Active This number uniquely identifies a haul within a cruise. It is a sequential number, in chronological order of occurrence. NUMBER 8 SPECIES_CODE NUMBER 22 Yes No 5 0 Active Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual NUMBER 9 WEIGHT NUMBER 22 Yes No 9 3 Active Kilogram (kg). This value is the extrapolated Weight, to nearest thousandth of a kg, for each species in the catch. Collected in pounds in 1993 and prior years and has since been converted to kg NUMBER 10 NUMBER_FISH NUMBER 22 No No 6 0 Active Valid Values: whole numbers, 0, and null. This value is the extrapolated total number of individuals of this species caught in the haul. NUMBER 11 SUBSAMPLE_CODE VARCHAR2 2 No No Active Unused attribute VARCHAR2 12 VOUCHER NUMBER 22 No No 4 0 Active Reference number given to specimens that are collected and preserved for taxonomic identification purposes. These are assigned sequentially beginning with 1 and re-initiated for each haul NUMBER 13 AUDITJOIN NUMBER 22 No No 12 0 Active This is a unique identifier for each record in the base table, to be used in corresponding audit tables to identify the original record in the base table NUMBER gov.noaa.nmfs.inport:69746 Nancy Roberson 2023-05-01T17:42:38 Nancy Roberson 2023-10-26T16:31:38 2023-10-26 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 2023-10-26 1 Year 2024-10-26