9594 FOREIGN_VIABILITY Entity Published / External 9556 AFSC/FMA/North Pacific Observer Foreign Fishing Data Set Completed This table links viability data for Pacific halibut caught in the foreign and joint venture groundfish fishery with the length data from the same cruise, vessel, dt, year, and haul. Observers use a viability key developed by the International Pacific Halibut Commission (IPHC) to judge viability. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC This table links viability data for Pacific halibut caught in the foreign and joint venture groundfish fishery with the length data from the same cruise, vessel, dt, year, and haul. Observers use a viability key developed by the International Pacific Halibut Commission (IPHC) to judge viability. 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 vessell. 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 No 3 0 Active Species code 101, the code for Pacific halibut. NUMBER NORPAC.DOMESTIC_SPECIES 7 NUMBER_EXCELLENT NUMBER 22 No No 4 0 Active The number of Pacific halibut examined and determined to be in excellent condition. NUMBER 8 NUMBER_POOR NUMBER 22 No No 4 0 Active The number of Pacific halibut examined and determined to be in poor condition. NUMBER 9 NUMBER_DEAD NUMBER 22 No No 4 0 Active The number of Pacific halibut examined and determined to be dead or soon to be dead. NUMBER 10 SEA_LION_PREDATION_CODE NUMBER 22 No No 1 0 Active A one-digit numeric code associated with the amount of sea lion predation. NORPAC.FOREIGN_PREDATION_CODE provides a description of the codes. NUMBER NORPAC.FOREIGN_PREDATION_CODE 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 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 13 PK_FVIA NUMBER 22 Yes Yes 6 0 Active For internal use only. NUMBER gov.noaa.nmfs.inport:9594 Doug Turnbull 2009-06-29T18:15:12 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