9558 FOREIGN_AGE Entity Published / External 9556 AFSC/FMA/North Pacific Observer Foreign Fishing Data Set Completed This table contains age and biological data (and some maturity data) of individual specimens of commercially-important groundfish and Pacific salmon caught in the foreign and joint venture groundfish fishery. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC This table contains age and biological data (and some maturity data) of individual specimens of commercially-important groundfish and Pacific salmon caught in the foreign and joint venture groundfish fishery. 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_AGE.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 4 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. NUMBER Refers to more than one entity 7 SPECIMEN_NUMBER NUMBER 22 Yes Yes 3 0 Active A unique number assigned a single specimen within a collection. NUMBER 8 SEX VARCHAR2 1 Yes No Active A one-digit alpha code indicating the sex of the organism. F = female, M = male, U = unknown. VARCHAR2 9 LENGTH NUMBER 22 No No 3 0 Active The fork length in centimeters. NUMBER 10 AGE NUMBER 22 No No 2 0 Active The age of the fish, recorded in years. Recorded by age readers following examination of the specimens in the age determination laboratory. NUMBER 11 INDIV_WEIGHT NUMBER 22 No No 8 2 Active The weight (to one-hundredth of a kilogram) of the individual fish from which the age structure (or maturity information) was taken. NUMBER 12 SPECIAL_HANDLING NUMBER 22 No No 2 0 Active A one-digit numeric code associated with additional information related to the fish. NORPAC.FOREIGN_SPECIAL_HANDLING provides a description of the codes. NUMBER NORPAC.FOREIGN_SPECIAL_HANDLIN 13 TOTAL_AGE NUMBER 22 No No 1 0 Active Unknown definition. Likely to have been a field used by the REFM Age Unit. A single numeric digit 0-9. Recorded for years 1975, 1976, 1977, 1983, and 1986, and only for salmon species 221, 222, and 223. NUMBER 14 MATURITY_CODE NUMBER 22 No No 1 0 Active A one-digit numeric code used to identify the developmental stage of gonads. The meaning of the maturity code depends on the species for which the information is being collected. NORPAC.FOREIGN_MATURITY_CODE uses SPECIES and MATURITY_CODE to provide a description of the codes. NUMBER NORPAC.FOREIGN_MATURITY_CODE 15 FILENAME VARCHAR2 8 No No Active he original filename on the Burroughs computer system from which this data record came. VARCHAR2 16 HAUL_JOIN NUMBER 22 Yes Yes 6 0 Active Unique assigned number. Forms a one to many link between the foreign_haul table and the foreign_age table. NUMBER NORPAC.FOREIGN_HAUL gov.noaa.nmfs.inport:9558 Doug Turnbull 2009-06-29T18:15:02 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