9556 AFSC/FMA/Foreign Fishing Data Set Published / External 9554 Foreign Fishing Observer Data Dictionary Project Completed 2012 The National Marine Fisheries Service (NMFS) began placing observers on foreign fishing vessels operating off the northwest and Alaskan coasts of the United States in 1973, creating the North Pacific Foreign Fisheries Observer Program. Initially, observers were placed on vessels only upon invitation by host countries. In the early years of the program the primary purposes of observers were to determine incidental catch rates of Pacific halibut in groundfish catches and to verify catch statistics in the Japanese crab fishery. Later, observers collected data on the incidence of king crab, snow (Tanner) crab, and Pacific salmon, and obtained biological data on other important species. Following the implementation of the Magnuson Fishery Conservation and Management Act of 1976, which mandated that fishery observers be placed on foreign fishing vessels operating within the US 200-mile Exclusive Economic Zone (EEZ) off the Alaska coast of the Bering Sea and Gulf of Alaska, observer coverage rapidly expanded. By 1986, the foreign fisheries that were not joint-venture were halted. Document Foreign Fishery Catch and Effort Statistics by Fishery Observers. Japan initiated a fishery for yellowfin sole in the eastern Bering Sea in 1933. This fishery continued until 1941 when it was terminated by the outbreak of World War II. Japanese fishing vessels returned in 1954 and were joined in 1959 by fishing vessels from the former U.S.S.R. During the 1950s and 1960s, the number of participating vessels increased and began targeting other species and exploring new fishing areas. Flatfish were the principal targets of the Japanese and Russian fleets during the '50s and '60s. By the mid-1960s, after a decline in flatfish stocks, both Japan and Russia began targeting walleye pollock. During the late 1960s and early 1970s vessels from other countries began fishing in the eastern Bering Sea including; Taiwan, the Republic of Korea, and Poland. photo of foreign fishing vesselThe National Marine Fisheries Service (NMFS) began placing observers on foreign fishing vessels operating off the northwest and Alaskan coasts of the United States in 1973, creating the North Pacific Foreign Fisheries Observer Program. Initially, observers were placed on vessels only upon invitation by host countries. In the early years of the program the primary purposes of observers were to determine incidental catch rates of Pacific halibut in groundfish catches and to verify catch statistics in the Japanese crab fishery. Later, observers collected data on the incidence of king crab, snow (Tanner) crab, and Pacific salmon, and obtained biological data on other important species. Following the implementation of the Magnuson Fishery Conservation and Management Act of 1976, which mandated that foreign vessels accept observers, observer coverage greatly expanded. In 1978 American fishers began fishing for groundfish in joint ventures with foreign processing vessels. By 1986 all nonjoint-venture foreign fisheries were halted, and by 1991 all foreign fishing within the 200 mile Exclusive Economic Zone (EEZ) of the Bering Sea and Gulf of Alaska was terminated. Theme Fisheries Fishery-Dependent Theme Fisheries Tracked Asset Theme 1986 Theme Foreign Theme Observer Temporal 1973 Spatial BSAI Spatial GOA Spatial West Coast US Alaska Fisheries Science Center Seattle WA USA Data Set Database None Planned Table (digital) This data set is for historical documentation only. The data it contains is static and although no longer used for fishery management remains confidential. https://www.afsc.noaa.gov/FMA/PDF_DOCS/Foreign%20Fishing%20Table%20Diagram.pdf Jerry Berger N/A N/A N/A 9557 DOMESTIC_SPECIES Published / External Completed A table which provides all of the three-digit numeric codes assigned by the NMFS Observer Program, complete with their common name, scientific name, associated RACE Division species code, and the maximum and minimum weights and lengths typically reported by observers. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC A table which provides all of the three-digit numeric codes assigned by the NMFS Observer Program, complete with their common name, scientific name, associated RACE Division species code, and the maximum and minimum weights and lengths typically reported by observers. 1 SPECIES_NO NUMBER 22 Yes Yes 3 0 Active A three-digit numeric code assigned by the NMFS Observer Program to each different marine organism expected to be seen in the Bering Sea and northeast Pacific Ocean. Each number is uniquely associated with a SPECIES_NAME and a SCIENTIFIC_NAME. NUMBER 2 SPECIES_NAME VARCHAR2 60 Yes No Active The common name of the marine organism. VARCHAR2 3 PROHIB VARCHAR2 1 No No Active A one-digit alpha code indicating whether the species is allowed to be retained in the Alaska groundfish fishery and the West Coast Pacific whiting fishery, where: Y = Yes; N = No. VARCHAR2 4 GENKEY VARCHAR2 10 No No Active The prohibited species grouping associated with the SPECIES_NAME. This fieldis NULL unless PROHIB = "Y". The groupings are: HALIBUT, KINGCRAB, OTHCRAB,SALMON. VARCHAR2 5 RACE_SPECIE_NUM VARCHAR2 5 No No Active A 5-digit numeric code assigned by the RACE division that is associated withthe SPECIES_NAME VARCHAR2 6 SCIENTIFIC_NAME VARCHAR2 41 No No Active The scientific name associated with the common SPECIES_NAME. VARCHAR2 7 MAX_WT NUMBER 22 No No 11 2 Active The maximum weight expected for an individual of this species. This value comes from several sources, the primary one being the NORPAC.DOMESTIC_SPCOMP_DETAIL table. NUMBER 8 MIN_WT NUMBER 22 No No 11 2 Active The minimum weight expected for an individual of this species. This value comes from several sources, the primary one being the NORPAC.DOMESTIC_SPCOMP_DETAIL table. NUMBER 9 MAX_LEN NUMBER 22 No No 3 0 Active The maximum length expected for an individual of this species. This value comes from several sources, the primary one being the NORPAC_DOMESTIC_LENGTH table. NUMBER 10 MIN_LEN NUMBER 22 No No 3 0 Active The minimum length expected for an individual of this species. This value comes from several sources, the primary one being the NORPAC.DOMESTIC_LENGTH table. NUMBER 11 NICKNAME VARCHAR2 60 Yes No Active Nickname is the same as the common SPECIES_NAME. VARCHAR2 12 AGGREGATION VARCHAR2 60 No No Active Indicates species aggregation and possible species_no in the aggregation. VARCHAR2 13 AGE_TRAY NUMBER 22 No No 6 0 Active For internal use by Age Determination Unit. NUMBER 14 AGE_TRAY_X VARCHAR2 2 No No Active For internal use by Age Determination Unit. VARCHAR2 15 AGE_TRAY_Y VARCHAR2 2 No No Active For internal use by Age Determination Unit. VARCHAR2 16 AGE_TRAY_GOA NUMBER 22 No No 6 0 Active For internal use by Age Determination Unit. NUMBER 17 AGE_TRAY_GOA_X VARCHAR2 2 No No Active For internal use by Age Determination Unit. VARCHAR2 18 AGE_TRAY_GOA_Y VARCHAR2 2 No No Active For internal use by Age Determination Unit. VARCHAR2 9558 FOREIGN_AGE Published / External 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 9559 FOREIGN_BLEND Published / External Completed Total groundfish catch information from the foreign and joint venture fishing operations in the Bering Sea and Aleutian Islands, Gulf of Alaska, and Washington-Oregon-California Regions for the years 1977-90. Information is summed by week, nation, area, vessel class, and species (also by company for joint venture operations in the years 1987-90). Provided information includes number of vessels processing fish (for years 1978 and 1982-90), number of days the vessels were on the fishing grounds, number of days observers were monitoring catches, the percentage of the days that were monitored, the foreign estimate of the catch, the observer estimate of the catch expanded to the number of days the vessels were on the grounds), and the official estimate (blend estimate) of the catch. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC Total groundfish catch information from the foreign and joint venture fishing operations in the Bering Sea and Aleutian Islands, Gulf of Alaska, and Washington-Oregon-California Regions for the years 1977-90. Information is summed by week, nation, area, vessel class, and species (also by company for joint venture operations in the years 1987-90). Provided information includes number of vessels processing fish (for years 1978 and 1982-90), number of days the vessels were on the fishing grounds, number of days observers were monitoring catches, the percentage of the days that were monitored, the foreign estimate of the catch, the observer estimate of the catch expanded to the number of days the vessels were on the grounds), and the official estimate (blend estimate) of the catch. 1 WEEKENDING_DATE NUMBER 22 No No 8 0 Active The foreign_blend data are a weekly summation of catch (except for 1977, when the data were summed on a monthly basis). The weekending_date is the date (YYMMDD) of the last day associated with the summation period. NUMBER 2 NATION VARCHAR2 13 No No Active The name of the nation(s) associated with each fishing operation. These nations are: BULGARIA, JAPAN, MEXICO, POLAND, PORTUGAL, PRC (People's Republic of China), ROK (Republic of Korea), TAIWAN, USSR (United Soviet Socialist Republic), WEST GERMANY, US-BULGARIA, US-ICELAND, US-JAPAN, US-POLAND, US-PORTUGAL, US-PRC, US-ROK, US-SPAIN, US-TAIWAN, US-USSR, US-W.GERMANY. All nation names beginning with US- are joint venture operations between the United States and a foreign nation. VARCHAR2 3 AREA_NAME VARCHAR2 14 No No Active The name of the International North Pacific Fish Commission area in which the catch was made. These areas are: BERING SEA 1, BERING SEA 2, BERING SEA 3, ALEUTIANS, SHUMAGIN, CHIRIKOF, SHELIKOF STR. (1986 only), KODIAK, YAKUTAT, S. E. ALASKA, VANCOUVER, COLUMBIA, EUREKA, MONTEREY. VARCHAR2 4 SPECIES_NAME VARCHAR2 16 No No Active The name of the species group. In the Bering Sea/Aleutians, the species groups are: ALL FLOUNDERS (1977 Japan only), ARROWTOOTH FL (1986-90), ATKA MACKEREL, FLOUNDER WO YFS, GREENLAND TURBOT (1986 only), HERRING, OTHER FISH, PACIFIC COD, POLLOCK, POP, ROCKFISH WO POP, ROCK SOLE (1989-90), SABLEFISH, SNAILS, SQUID, TURBOTS, YELLOWFIN SOLE. In the Gulf of Alaska, the species groups are: ALL FLOUNDERS, ATKA MACKEREL, DEMERSAL RF (1988 only), HERRING, OTHER FISH, PACIFIC COD, PELAGIC RF (1988 only), POLLOCK, POP, RATTAILS, ROCKFISH WO POP, SABLEFISH, SLOPE ROCKFISH (1988 only), SQUID, SS THORNYHEAD. In Washington-Oregon-California, the species groups are: ALL FLOUNDERS, ALL ROCKFISH (1977-79), FLATFISH DISC, JACK DISCARD, JACK MACKEREL, OTHER DISCARD, OTHER FISH, OTHER RF DISC, PACIFIC WHITING, POP, POP DISCARDS, ROCKFISH WO POP, SABLEFISH, SABLEFISH DIS, SHORTBELLY RF (1982 only). Refer to NOAA TECH.MEM. NMFS F/NWC-99 for changes that occurred within the species groups for years 1977-84. After 1984, very few changes occurred and are all noted here. VARCHAR2 5 VESSEL_CLASS VARCHAR2 16 No No Active The vessel type used in the fishing operations. In 1977-79, larger trawlers were separated by size into MED TRAWLER and LG TRAWLER. From 1980 on, larger trawlers were separated based on their ability to make surimi. If they could make surimi, they were SURIMI TRAWL; if not, they were LG FRZ TRAWL. Longliners were all listed as LONGLINER in 1977-79. From 1980 on, they were separated by target into LONGLINE COD (targeting Pacific cod) and LONGLINE SAB (targeting sablefish). From 1977-79, all surimi motherships were combined into SURIMI MSHIP. From 1980 on, each surimi mothership was classified separately (SURIMI MSHIP1, SURIMI MSHIP2, SURIMI MSHIP3, SURIMI MSHIP4, SURIMI MSHIP5). From 1977-85, all joint venture motherships were listed as a single vessel type (JV MSHIP). From 1986 on, joint venture motherships were separated by target and surimi capability (OTHER FREEZER JV, OTHER SURIMI JV, YELL/FLAT FRZ JV, YELL/FLAT SUR JV, POLL-BOT FRZ JV (1989 only), POLL-BOT SUR JV (1989 only), POLL-MID FRZ JV (1989 only), POLL-MID SUR JV (1989 only) [No joint ventures targeted pollock in 1990]). Three additional vessel types, JV/LG FRZ TRAWL, JV/SURIMI TRAWL, AND LL COD/JV MSHIP identified the portion of fish caught by a fishing vessel itself, in the same week that it was processing another vessel's catch in a joint venture operation. The other vessel types were: FREEZER MSHIP (no surimi capability), SNAILPOT, SMALL TRAWL. VARCHAR2 6 COMPANY CHAR 4 No No Active A code initiated in 1987 to differentiate between the different companies involved in joint venture operations. The first two digits identified the nationality of the processing vessel, and the second two digits identified different companies within that nationality. IJ designated Iceland, JA designated Japan, KS designated the Republic of Korea (ROK), PC designated the People's Republic of China (PRC), PL designated Poland, and UR designated the USSR. A list associating company name with company code is not currently available. CHAR 7 AREA_NUMBER NUMBER 22 No No 4 0 Active The number associated with the International North Pacific Fish Commission area_name. From 1977-85, the numbers (and areas) were: 51 (BERING SEA 1), 52 (BERING SEA 2), 53 (BERING SEA 3), 54 (ALEUTIANS), 61 (SHUMAGIN), 62 (CHIRIKOF), 63 (KODIAK), 64 (YAKUTAT), 65 (S.E. ALASKA), 67 (VANCOUVER), 71 (COLUMBIA), 72 (EUREKA), 73 (MONTEREY). In 1986, the numbers (and areas) were: 510 (BERING SEA 1), 520 (BERING SEA 2), 530 (BERING SEA 3), 540 (ALEUTIANS), 610 (SHUMAGIN), 620 (CHIRIKOF), 621 (SHELIKOF STR.), 630 (KODIAK), 640 (YAKUTAT), 650 (S.E. ALASKA), 670 (VANCOUVER), 710 (COLUMBIA), 720 (EUREKA), 730 (MONTEREY). Also, in 1986, in BERING SEA 1, joint venture operations were recorded by sub-areas and had area_numbers of 511, 513 and 514. In 1987-90, all fishing operations in BERING SEA 1 and BERING SEA 2 were recorded by sub-areas. Within BERING SEA 1, the sub-areas were: 511, 513, 514, 515, 516, 517. Within BERING SEA 2, the sub-areas were: 521, 522. All other areas had the same area numbers as in 1986. SHELIKOF STR (621) was only listed as a separate area in 1986. NUMBER 8 WEEK_NUMBER NUMBER 22 No No 2 0 Active The week number of the year (i.e., the first calendar week of each year [whether a full week or not] was week number 1, the second calendar week was week number 2, etc.). NUMBER 9 NO_OF_VESSELS NUMBER 22 No No 3 0 Active The number of foreign vessels involved in fishing operations for the weekending_date, nation, area_number, vessel_class, and company (where applicable). NUMBER 10 NO_OF_FOREIGN_DAYS NUMBER 22 No No 4 0 Active The combined number of days that foreign vessels involved in fishing operations were on the grounds for the weekending_date, nation, area_number, vessel_class, and company (where applicable). NUMBER 11 NO_OF_OBSERVER_DAYS NUMBER 22 No No 4 0 Active The combined number of days that observers were available to sample aboard foreign vessels for the weekending_date, nation, area_number, vessel_class, and company (where applicable). NUMBER 12 PERCENT_COVERAGE NUMBER 22 No No 3 0 Active The no_of_observer_days divided by the no_of_foreign_days multiplied by 100 and rounded to the nearest whole number. NUMBER 13 FOREIGN_TONNAGE NUMBER 22 No No 10 3 Active The number of tons of the species group caught by the foreign vessels for the weekending_date, nation, area_number, vessel_class, and company (where applicable) as reported by the foreign nation. NUMBER 14 OBSERVER_TONNAGE NUMBER 22 No No 10 3 Active The number of tons of the species group caught by the foreign vessels for the weekending_date, nation, area_number, vessel_class, and company (where applicable) as estimated and reported by the observers. NUMBER 15 BLEND_TONNAGE NUMBER 22 No No 10 3 Active The best estimate of the number of tons of the species group caught by the foreign vessels for the weekending_date, nation, area_number, vessel_class, and company (where applicable). This value is either the foreign_tonnage or the observer_tonnage and which value is selected depends on the following algorithm. If the percent coverage is less than 20.0% (not rounded), the foreign_tonnage is selected. If the result of the foreign_tonnage divided by the observer_tonnage is between 0.9 and 1.1 (not rounded), the foreign_tonnage is selected. If neither of these conditions are met, the observer_tonnage is selected. NUMBER 16 YR NUMBER 22 No No 4 0 Active The four digits of the year in which fishing occurred. NUMBER 17 WEEK_DATE DATE 7 No No Active The week_date is the weekending_date converted into a date format (MM/DD/YYYY HH:MM:SS). Hours, minutes, and seconds are all 0. DATE 9560 FOREIGN_CATCHER_BOAT Published / External Completed This table links the ADFG_number in the NORPAC.FOREIGN_HAUL table with the catcher_boat_name. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC This table links the ADFG_number in the NORPAC.FOREIGN_HAUL table with the catcher_boat_name. 1 ADFG_NUMBER NUMBER 22 Yes Yes 6 0 Active The Alaska Department of Fish and Game (ADF&G) vessel code number of the delivering US vessel. NUMBER 2 COAST_GUARD_NUMBER NUMBER 22 No No 6 0 Active The US Coast Guard vessel code number of the delivering US vessel. NUMBER 3 CATCHER_BOAT_NAME VARCHAR2 50 Yes No Active The name of the delivering US vessel. VARCHAR2 9561 FOREIGN_CATCHER_BOAT_GEAR Published / External Completed This table links the catcher_boat_gear code in the NORPAC.FOREIGN_DETAIL_MOTHERSHIP table with the catcher_boat_gear descriptions. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC This table links the catcher_boat_gear code in the NORPAC.FOREIGN_DETAIL_MOTHERSHIP table with the catcher_boat_gear descriptions. 1 CATCHER_BOAT_GEAR NUMBER 22 Yes Yes 1 0 Active A one-digit numeric code associated with the catcher_boat_gear. NUMBER 2 CATCHER_BOAT_GEAR_NAME VARCHAR2 50 Yes No Active A description of the gear associated with this code: 1 - Pair trawl; 2 - Danish seine; 3 - Otter trawl; 4 - Danish seine and Otter trawl combined; 5 - Danish seine and Pair trawl combined; 6 - Danish seine, Pair Trawl, and Otter trawl combined; 7 - Pair trawl and Otter trawl combined. VARCHAR2 9562 FOREIGN_CONTRACTOR Published / External Completed This table links the contractor code in the NORPAC.FOREIGN_OBSERVER table with a description of the code. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC This table links the contractor code in the NORPAC.FOREIGN_OBSERVER table with a description of the code. 1 CONTRACTOR VARCHAR2 5 Yes Yes Active Abbreviation of the name of the organization that provided the observer. VARCHAR2 2 CONTRACTOR_NAME VARCHAR2 50 Yes No Active Name of the organization that provided the observer. VARCHAR2 9563 FOREIGN_CRAB_MATURITY Published / External Completed This table contains golden king crab maturity data collected aboard 3 Japanese stern trawlers in 1981. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC This table contains golden king crab maturity data collected aboard 3 Japanese stern trawlers in 1981. 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 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 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 CARAPACE_LENGTH NUMBER 22 Yes No 3 0 Active Observed length (cm) of the carapace of the specimen. NUMBER 9 CHELA_HEIGHT NUMBER 22 No No 3 0 Active Height (mm) of the cheliped (portion of the crab that makes up the pincher), measured from between the anterior two pairs of spines on the dorsal surface of the right chela to the closest point on the ventral surface. NUMBER 10 FEMALE_CRAB_MATURITY NUMBER 22 No No 1 0 Active A one-digit numeric code to identify the maturity of the female crab. These codes are defined in the NORPAC.FOREIGN_CRAB_MATURITY_CODE table. 1 - no eggs; 2 - eggs; 3 - egg cases. NUMBER NORPAC.FOREIGN_CRAB_MATURITY_C 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_FCM NUMBER 22 Yes Yes 6 0 Active For internall use only. NUMBER 9564 FOREIGN_CRAB_MATURITY_CODE Published / External Completed This table links the Golden king crab female_crab_maturity codes in the NORPAC.FOREIGN_CRAB_MATURITY table with the female_crab_maturity definitions. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC This table links the Golden king crab female_crab_maturity codes in the NORPAC.FOREIGN_CRAB_MATURITY table with the female_crab_maturity definitions. 1 FEMALE_CRAB_MATURITY NUMBER 22 Yes Yes 1 0 Active A one-digit numeric code to identify the maturity of the female crab. NUMBER 2 FEMALE_CRAB_MATURITY_DEF VARCHAR2 50 Yes No Active A description of the maturity associated with this code. 1 - no eggs; 2 - eggs; 3 - egg cases. VARCHAR2 9565 FOREIGN_DETAIL_HAUL Published / External Completed For the years 1985-1990, both the set position and retrieval position were often recorded for each haul. This table provides whatever set position, retrieval position, delivery position, and noon position information that was recorded for each haul for those years. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC For the years 1985-1990, both the set position and retrieval position were often recorded for each haul. This table provides whatever set position, retrieval position, delivery position, and noon position information that was recorded for each haul for those years. 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. 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 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 LOCATION_ID VARCHAR2 1 Yes No Active A one-digit alpha code that indicates what type of fishing activity occurred at the latitude and longitude recorded. R = the position of the vessel when the retrieval of the haul/set was begun, D = the position of the vessel when a delivery was completed to a mothership, N = the position of the vessel at noon (Greenwich Mean Time) on a day when no fishing took place and the vessel was not in port, S = the position of the vessel when gear began being set. VARCHAR2 7 LATITUDE NUMBER 22 Yes No 4 0 Active A four-digit number recorded in degrees and minutes north. The geographical position associated with the LOCATION_ID. NUMBER 8 E_W VARCHAR2 1 Yes No Active Direction of longitude, E = east and W = west of the 180th meridian. VARCHAR2 9 LONGITUDE NUMBER 22 Yes No 5 0 Active A five-digit number recorded in degrees and minutes west of 0 degrees. Any position west of 180 degrees is stored as a value greater than 18000, e.g., 170 degrees east longitude = 19000. The geographical position associated with the LOCATION_ID. NUMBER 10 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 11 PK_FDH NUMBER 22 Yes Yes 6 0 Active For internal use only. NUMBER 9566 FOREIGN_DETAIL_MOTHERSHIP Published / External Completed This table contains much the same information as NORPAC.FOREIGN_HAUL but only for non-joint venture motherships. It contains only the fields that are pertinent to motherships. It contains an additional field, CATCHER_BOAT_GEAR, which is used to subdivide daily mothership data by gear type code. The NORPAC.FOREIGN_CATCHER_BOAT_GEAR table provides a description of the codes. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC This table contains much the same information as NORPAC.FOREIGN_HAUL but only for non-joint venture motherships. It contains only the fields that are pertinent to motherships. It contains an additional field, CATCHER_BOAT_GEAR, which is used to subdivide daily mothership data by gear type code. The NORPAC.FOREIGN_CATCHER_BOAT_GEAR table provides a description of the codes. 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 CATCHER_BOAT_GEAR NUMBER 22 Yes Yes 1 0 Active A one-digit numeric code to identify the gear used by the catcher boat(s) delivering to a mothership. NUMBER NORPAC.FOREIGN_CATCHER_BOAT_GE 6 LOCATION_ID VARCHAR2 1 Yes No Active A one-digit alpha code that indicates what type of fishing activity occurred at the latitude and longitude recorded. R = the position of the vessel when the retrieval of the haul/set was begun, D = the position of the vessel when a delivery was completed to a mothership, N = the position of the vessel at noon (Greenwich Mean Time) on a day when no fishing took place and the vessel was not in port, S = the position of the vessel when gear began being set. VARCHAR2 7 LATITUDE NUMBER 22 Yes No 4 0 Active A four-digit number recorded in degrees and minutes north. The geographical position associated with the LOCATION_ID. NUMBER 8 E_W VARCHAR2 1 Yes No Active Direction of longitude, E = east and W = west of the 180th meridian. VARCHAR2 9 LONGITUDE NUMBER 22 Yes No 5 0 Active Five-digit longitude in degrees and minutes. A five-digit number recorded in degrees and minutes west of 0 degrees. Any position west of 180 degrees is stored as a value greater than 18000, e.g., 170 degrees east longitude = 19000. The geographical position associated with the LOCATION_ID. NUMBER 10 FISHING_DEPTH NUMBER 22 No No 3 0 Active The average fishing depth at which fishing took place, in meters. NUMBER 11 DURATION NUMBER 22 No No 5 0 Active Average duration (minutes) of the tows delivered. NUMBER 12 NUMBER_OF_TOWS NUMBER 22 No No 3 0 Active Number of tows delivered during that day. Is null where individual hauls are identified separately. NUMBER 13 OFFICIAL_TOTAL_CATCH NUMBER 22 No No 6 2 Active Final estimate of catch weight (MT) for the set or haul, made by vessel personnel, includes both retained and discarded species, and is recorded to the nearest one-hundredth of a metric ton. If original_ships_estimate is not null, official_total_catch is the original_ships_estimate adjusted by the observer to include prohibited species and non-allocated species. If NUMBER_OF_TOWS>0, then OFFICIAL_TOTAL_CATCH is the total catch for the day. NUMBER 14 WEATHER NUMBER 22 No No 1 0 Active A one-digit numeric code identifying the weather conditions during the fishing operation. NORPAC.FOREIGN_WEATHER provides a description of the codes. NUMBER NORPAC.FOREIGN_WEATHER 15 SEA NUMBER 22 No No 1 0 Active A one-digit numeric code identifying the sea conditions during the fishing operation. NORPAC.FOREIGN_SEA provides a description of the codes. NUMBER NORPAC.FOREIGN_SEA 16 SURFACE_WATER_TEMP NUMBER 22 No No 3 1 Active The temperature of the surface water in degrees Celsius. NUMBER 17 BOTTOM_WATER_TEMP NUMBER 22 No No 3 1 Active The temperature of the water at fishing depth in degrees Celsius. NUMBER 18 FILENAME VARCHAR2 8 No No Active The original filename on the Burroughs computer system from which this data record came. VARCHAR2 19 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 20 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 9567 FOREIGN_DETAIL_PROHIBS Published / External Completed This table contains the original (corrected) observer data for foreign trawlers, motherships, snail pot vessels, and joint venture operations. No data have been extrapolated in this database. These data are from all species of king crab (species 2), Tanner crab (species 3), Pacific halibut (species 101), and Pacific salmon (species 220 and 226) that were found in the prohibited species samples. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC This table contains the original (corrected) observer data for foreign trawlers, motherships, snail pot vessels, and joint venture operations. No data have been extrapolated in this database. These data are from all species of king crab (species 2), Tanner crab (species 3), Pacific halibut (species 101), and Pacific salmon (species 220 and 226) that were found in the prohibited species samples. 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 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 4 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 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 SAMPLE_NUMBER NUMBER 22 Yes No 2 0 Active In sampling a longline set or a day's mothership operation or a day's joint venture operation, each portion of the set or delivery that was sampled received a unique sample_number within the set (usually, a 1, 2, or 3). NUMBER 7 SPECIES NUMBER 22 Yes No 3 0 Active A three-digit numeric code representing a marine species. NUMBER NORPAC.DOMESTIC_SPECIES 8 NUMBER_IN_SAMPLE NUMBER 22 Yes No 6 0 Active The number (count) of the specified species which occurred within the sample. NUMBER 9 WEIGHT_IN_SAMPLE NUMBER 22 Yes No 10 2 Active The total weight in kilograms of the specified species which occurred within the sample. NUMBER 10 NUMBER_OF_SKATES_SAMPLED NUMBER 22 No No 3 0 Active The number of hachi (skates) that were sampled for prohibited species. NUMBER 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 WEIGHT_SAMPLED NUMBER 22 Yes No 10 2 Active The total weight in kilograms of all of the sampled species in the sample. NUMBER 13 PK_FDP NUMBER 22 Yes Yes 7 0 Active For internal use only. NUMBER 9568 FOREIGN_DETAIL_PRO_SEX_COMP Published / External Completed This table contains species composition data for the prohibited species found within the haul samples. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC This table contains species composition data for the prohibited species found within the haul samples. 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 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 4 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 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 SAMPLE_NUMBER NUMBER 22 Yes No 2 0 Active In sampling a longline set or a day's mothership operation or a day's joint venture operation, each portion of the set or delivery that was sampled received a unique sample_number within the set, (usually 1, 2, or 3). NUMBER 7 SPECIES NUMBER 22 Yes No 3 0 Active A three-digit numeric code representing a marine species. NUMBER NORPAC.DOMESTIC_SPECIES 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 NUMBER_IN_SAMPLE NUMBER 22 Yes No 6 0 Active The number (count) of the specified species which occurred within the sample. NUMBER 10 WEIGHT_IN_SAMPLE NUMBER 22 Yes No 10 2 Active The total weight in kilograms of the specified species which occurred within the sample. NUMBER 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_FDPSC NUMBER 22 Yes Yes 6 0 Active For internal use only. NUMBER 9569 FOREIGN_DETAIL_SPCOMP Published / External Completed This table contains the original (corrected) observer data for foreign trawlers, motherships, snail pot vessels, and joint venture operations. No data have been extrapolated in this database. These data are from all species (including prohibited species) that were found in the species composition samples. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC This table contains the original (corrected) observer data for foreign trawlers, motherships, snail pot vessels, and joint venture operations. No data have been extrapolated in this database. These data are from all species (including prohibited species) that were found in the species composition samples. 1 CRUISE NUMBER 22 Yes No 4 0 Active Four-digit number to represent each occasion that an observer was aboard a different 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 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 4 DT DATE 7 Yes No Active Similar to NORPAC.DOMESTIC_SPCOMP.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 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 SAMPLE_NUMBER NUMBER 22 Yes No 2 0 Active In sampling a longline set or a day's mothership operation or a day's joint venture operation, each portion of the set or delivery that was sampled received a unique sample_number within the set (usually, a 1, 2, or 3). NUMBER 7 SPECIES NUMBER 22 Yes No 3 0 Active A three-digit numeric code representing a marine species. NUMBER NORPAC.DOMESTIC_SPECIES 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 WEIGHT_SAMPLED NUMBER 22 No No 10 2 Active The total weight in kilograms of all of the sampled species in the sample. NUMBER 10 NUMBER_IN_SAMPLE NUMBER 22 Yes No 7 0 Active The number (count) of the specified species which occurred within the sample. NUMBER 11 WEIGHT_IN_SAMPLE NUMBER 22 Yes No 10 2 Active The total weight in kilograms of the specified species which occurred within the sample. NUMBER 12 NUMBER_OF_POTS_SAMPLED NUMBER 22 No No 5 0 Active The number of pots in the set that were sampled for species composition. NUMBER 13 NUMBER_OF_SKATES_SAMPLED NUMBER 22 No No 5 0 Active The number of hachi (skates) that were sampled for species composition. NUMBER 14 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 15 PK_FDSP NUMBER 22 Yes Yes 7 0 Active For internal use only. NUMBER 9570 FOREIGN_EXTRAPOLATION Published / External Completed This table links the extrapolation_type code in the NORPAC.FOREIGN_SPCOMP table with a description of the code. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC This table links the extrapolation_type code in the NORPAC.FOREIGN_SPCOMP table with a description of the code. 1 EXTRAPOLATION_TYPE NUMBER 22 Yes Yes 1 0 Active A one-digit numeric extrapolation code. NUMBER 2 EXTRAPOLATION_TYPE_DEFINITION VARCHAR2 250 Yes No Active A description of the extrapolation code. 0 - non-prohibited species. Are extrapolated up to an official_total_catch adjusted by subtracting out the expanded weight of extrapolation_type 2 species. 1 - prohibited species not separated out prior to species composition sampling. Are extrapolated up to an official_total_catch adjusted by subtracting out the expanded weight of extrapolation_type 2 species. 2 - prohibited species separated out before species composition sampling occurred. Are extrapolated up to official_total_catch. VARCHAR2 9571 FOREIGN_FISHING_OPERATION Published / External Completed This table links the cruise and vessel in several of the major foreign tables (HAUL, SPCOMP, LENGTH, AGE) with pertinent information associated with the cruise and vessel. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC This table links the cruise and vessel in several of the major foreign tables (HAUL, SPCOMP, LENGTH, AGE) with pertinent information associated with the cruise and vessel. 1 CRUISE NUMBER 22 Yes Yes 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 2 VESSEL VARCHAR2 4 Yes Yes 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 NORPAC.FOREIGN_VESSEL 3 JV_Y_N VARCHAR2 1 Yes No Active A one-digit alpha code which identifies whether the data associated with this cruise and vessel are joint venture data or not. Y = Yes; N = No. VARCHAR2 4 VESSEL_TYPE_CODE NUMBER 22 Yes No 1 0 Active A one-digit numeric code associated with vessel type. NORPAC.FOREIGN_VESSEL_TYPE provides a description of the codes. NUMBER NORPAC.FOREIGN_VESSEL_TYPE 5 PROCESSING_TYPE_CODE NUMBER 22 Yes No 1 0 Active A one-digit numeric code associated with processing type. NORPAC.FOREIGN_PROCESSING_TYPE provides a description of the codes. NUMBER NORPAC.FOREIGN_PROCESSING_TYPE 6 OLD_CRUISE NUMBER 22 Yes No 4 0 Active The original cruise number associated with this cruise and vessel. The original cruise number is the cruise number that is recorded on the paper forms. NUMBER 7 OLD_VESSEL VARCHAR2 4 Yes No Active The original vessel code associated with this cruise and vessel. The original vessel code is the vessel code that is recorded on the paper forms. VARCHAR2 8 COMMENTS VARCHAR2 200 No No Active This field is usually empty. It contains additional information about the cruise and vessel. VARCHAR2 9 FILENAME_HAUL VARCHAR2 8 No No Active The original filename on the Burroughs computer system from which the haul data for this record came. VARCHAR2 10 FILENAME_LENGTH VARCHAR2 8 No No Active The original filename on the Burroughs computer system from which the length data for this record came. VARCHAR2 11 FILENAME_SPCOMP VARCHAR2 8 No No Active The original filename on the Burroughs computer system from which the species composition data for this record came. VARCHAR2 12 FILENAME_AGE VARCHAR2 8 No No Active The original filename on the Burroughs computer system from which the age data for this record came. VARCHAR2 9572 FOREIGN_HAUL Published / External Completed This table contains haul-by-haul vessel data, fishing effort, and total catch in the foreign and joint venture groundfish fishery. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC This table contains haul-by-haul vessel data, fishing effort, and total catch in the foreign and joint venture groundfish fishery. 1 CRUISE NUMBER 22 Yes No 4 0 Active If a U. S. vessel delivered the haul to a vessel carrying an observer, this field contains the 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 YEAR NUMBER 22 Yes No 4 0 Active A four-digit number identifying the year in which the gear retrieval of the haul began or in which the noon position occurred. NUMBER 4 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 5 HAUL NUMBER 22 Yes No 3 0 Active A unique number which identifies a specific occurrence of net, pot, or longline fishing effort. Additionally, a day in which a vessel was on grounds is occasionally recorded with a haul number of 0 (zero) if no codend, longline set, or pot group retrievals were begun. NUMBER 6 LOCATION_ID VARCHAR2 1 Yes No Active A one-digit alpha code that indicates what type of fishing activity occurred at the latitude and longitude recorded. R = the position of the vessel when the retrieval of the haul/set was begun, D = the position of the vessel when a delivery was completed to a mothership, N = the position of the vessel at noon (Greenwich Mean Time) on a day when no fishing took place and the vessel was not in port, S = the position of the vessel when gear began being set. VARCHAR2 7 LATITUDE NUMBER 22 Yes No 4 0 Active A four-digit number recorded in degrees and minutes north. The geographical position associated with the LOCATION_ID. NUMBER 8 E_W VARCHAR2 1 Yes No Active Direction of longitude, E = east and W = west of the 180th meridian. VARCHAR2 9 LONGITUDE NUMBER 22 Yes No 5 0 Active A five-digit number recorded in degrees and minutes west of 0 degrees. Any position west of 180 degrees is stored as a value greater than 18000, e.g., 170 degrees east longitude = 19000. The geographical position associated with the LOCATION_ID. NUMBER 10 FISHING_DEPTH NUMBER 22 No No 4 0 Active The average fishing depth at which fishing took place, in meters. NUMBER 11 BOTTOM_DEPTH NUMBER 22 No No 4 0 Active The average of the lowest points on the ocean floor where fishing took place (in meters). This is only recorded for joint venture vessels. NUMBER 12 NETS_ON_BOTTOM NUMBER 22 No No 4 0 Active The time when the net reached fishing depth (in Greenwich Mean Time). Use DURATION and NETS_OFF_BOTTOM and subtract to determine the date. NUMBER 13 NETS_OFF_BOTTOM NUMBER 22 No No 4 0 Active The time when the net began to be retrieved from fishing depth (in Greenwich Mean Time). The date is the same date as DT. NUMBER 14 DURATION NUMBER 22 No No 5 0 Active For longline or pot vessels, the time interval from the time that the first part of the line/pot-group was set until the time that the last of the line/pot-group was retrieved (also known as soak time). For trawlers, duration is the length of time during which the net was at fishing level. Duration is the difference between the NETS_ON_BOTTOM and the NETS_OFF_BOTTOM. Recorded in minutes. NUMBER 15 NUMBER_OF_TOWS NUMBER 22 No No 3 0 Active Is only not null for vessels where fishing information is recorded as a daily event. Prior to 1977, all data were compiled as a daily event and are associated with a Noon Position. When HAUL=0, then NUMBER_OF_TOWS is the number of tows that occurred that day. After 1976, only true motherships and, through 1983, joint venture motherships were combined on a daily basis. In 1988, two cruises (2943 B002 and 2977 B002) were the exception to this rule. The observers made a mistake and the data were combined by day. For an unknown reason, there are also 17 records where HAUL=0, NUMBER_OF_TOWS>0, and OFFICIAL_TOTAL_CATCH is null. NUMBER 16 OFFICIAL_TOTAL_CATCH NUMBER 22 No No 6 2 Active Final estimate of catch weight (MT) for the set or haul, made by vessel personnel, includes both retained and discarded species, and is recorded to the nearest one-hundredth of a metric ton. If original_ships_estimate is not null, official_total_catch is the original_ships_estimate adjusted by the observer to include prohibited species and non-allocated species. If NUMBER_OF_TOWS>0, then OFFICIAL_TOTAL_CATCH is the total catch for the day. NUMBER 17 SPEED NUMBER 22 No No 2 1 Active Average towing speed of the vessel during the tow, recorded to the tenth of a knot. Recorded from the vessel logbook. NUMBER 18 WEATHER NUMBER 22 No No 1 0 Active A one-digit numeric code identifying the weather conditions during the fishing operation. NORPAC.FOREIGN_WEATHER provides a description of the codes. NUMBER NORPAC.FOREIGN_WEATHER 19 SEA NUMBER 22 No No 1 0 Active A one-digit numeric code identifying the sea conditions during the fishing operation. NORPAC.FOREIGN_SEA provides a description of the codes. NUMBER NORPAC.FOREIGN_SEA 20 SURFACE_WATER_TEMP NUMBER 22 No No 3 1 Active The temperature of the surface water in degrees Celsius. NUMBER 21 BOTTOM_WATER_TEMP NUMBER 22 No No 3 1 Active The temperature of the water at fishing depth in degrees Celsius. NUMBER 22 DELIVERY_TIME NUMBER 22 No No 4 0 Active The time (Greenwich Mean Time) when the tow was delivered to the joint venture mothership. Recorded from vessel logs or observer observation. NUMBER 23 NUMBER_OF_SKATES NUMBER 22 No No 3 0 Active The number of hachi (skates) for a single set. NUMBER 24 HOOKS_PER_SKATE NUMBER 22 No No 6 0 Active The average number of hooks in a (hachi) skate. NUMBER 25 OBSERVER_CATCH_ESTIMATE NUMBER 22 No No 6 2 Active Estimate of total catch for the set or haul made by the observer, recorded to the nearest one-hundredth of a metric ton. See observer instruction manuals for specific information on possible estimation methods. NUMBER 26 ORIGINAL_SHIPS_ESTIMATE NUMBER 22 No No 6 2 Active Similar to NORPAC.DOMESTIC_HAUL.VESSEL_ESTIMATE, this is the initial estimate of the catch made by the vessel, recorded to one-hundredth of a metric ton. NUMBER 27 ADFG_NUMBER NUMBER 22 No No 6 0 Active If a U. S. vessel delivered the haul to a vessel carrying an observer, this field contains the Alaska Department of Fish and Game (ADF&G) vessel code number of the delivering vessel. NORPAC.FOREIGN_CATCHER_BOAT provides the names of the catcher boats and the coast guard numbers associated with the codes. NUMBER NORPAC.FOREIGN_CATCHER_BOAT 28 NUMBER_OF_POTS NUMBER 22 No No 3 0 Active For pot vessels, the total number of pots in a set, i.e., the number of pots or group of pots in the set that were retrieved. NUMBER 29 MM_MONITORED_RANDOM VARCHAR2 1 No No Active This field is null. VARCHAR2 30 HAUL_JOIN NUMBER 22 Yes Yes 6 0 Active An assigned, unique number (up to 6 digits) that uniquely identifies each haul/set associated with vessel data. NORPAC.FOREIGN_HAUL.HAUL_JOIN links a single haul record to records in many of the foreign tables. NUMBER 31 GENERIC_AREA NUMBER 22 Yes No 3 0 Active A three-digit number representing NORPAC database management subareas which, in most cases, are similar to NPFMC management areas. NORPAC.AREA links latitude and longitude to GENERIC_AREA (called GENERIC). NUMBER 32 HAUL_SAMPLED_BY VARCHAR2 1 No No Active A one-digit numeric code indicating whether or not a haul was sampled for species composition: 0 = not sampled, 9 = sampled. If more than one observer was onboard the vessel, there is no way of knowing which observer sampled the haul.. VARCHAR2 9573 FOREIGN_LENGTH Published / External Completed This table contains length-frequency data of prohibited species and commercially-important groundfish caught in the foreign and joint venture groundfish fishery. Also contains viability condition data for Pacific halibut. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC This table contains length-frequency data of prohibited species and commercially-important groundfish caught in the foreign and joint venture groundfish fishery. Also contains viability condition data for Pacific halibut. 1 CRUISE NUMBER 22 Yes No 5 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 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 4 DT DATE 7 Yes No Active Similar to NORPAC.DOMESTIC_LENGTH.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 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. NUMBER NORPAC.DOMESTIC_SPECIES 7 SEX VARCHAR2 1 Yes Yes Active A one-digit alpha code indicating the sex of the organism. F = female, M = male, U = unknown. VARCHAR2 8 SIZE_GROUP NUMBER 22 Yes Yes 3 0 Active Similar to NORPAC.DOMESTIC_LENGTH.LENGTH, this is the length measurement group for a species and sex. For fish, the fork length in centimeters. For crabs, the carapace width (Tanner crab) or carapace length (king crab) to the nearest 5 mm interval, ending in a 3 or an 8. NUMBER 9 FREQUENCY NUMBER 22 Yes No 3 0 Active The number of individuals in the species, sex, and size group for the haul/set. NUMBER 10 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 9574 FOREIGN_LONGLINE_PROHIB_SAMPLE Published / External Completed This table contains the original (corrected) observer data for foreign longliners from all species of king crab (species 2), Tanner crab (species 3), Pacific halibut (species 101), and Pacific salmon (species 220 and 226) that were found in the prohibited species samples. 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 original (corrected) observer data for foreign longliners from all species of king crab (species 2), Tanner crab (species 3), Pacific halibut (species 101), and Pacific salmon (species 220 and 226) that were found in the prohibited species samples. 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 YEAR NUMBER 22 Yes No 4 0 Active A four-digit number identifying the year in which the gear retrieval of the set began. NUMBER 4 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 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 SAMPLE_NUMBER NUMBER 22 Yes No 2 0 Active In sampling a longline set or a day's mothership operation or a day's joint venture operation, each portion of the set or delivery that was sampled received a unique sample_number within the set (usually, a 1, 2, or 3). NUMBER 7 SPECIES NUMBER 22 Yes No 3 0 Active A three-digit numeric code representing a marine species. NUMBER NORPAC.DOMESTIC_SPECIES 8 WEIGHT_SAMPLED NUMBER 22 Yes No 10 2 Active The total weight in kilograms of all of the sampled species in the sample. NUMBER 9 NUMBER_IN_SAMPLE NUMBER 22 Yes No 6 0 Active The number (count) of the specified species which occurred within the sample. NUMBER 10 WEIGHT_IN_SAMPLE NUMBER 22 Yes No 10 2 Active The total weight in kilograms of the specified species which occurred within the sample. NUMBER 11 NUMBER_OF_SKATES_SAMPLED NUMBER 22 No No 3 0 Active The number of hachi (skates) that were sampled for prohibited species. NUMBER 12 HAUL_JOIN NUMBER 22 No 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_FLPS NUMBER 22 Yes Yes 6 0 Active Foro internal use only. NUMBER 9575 FOREIGN_LONGLINE_SPCOMP_SAMPLE Published / External Completed This table contains the original (corrected) observer data for foreign longliners and contains data from all species (including prohibited species) that were found in the species composition samples. 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 original (corrected) observer data for foreign longliners and contains data from all species (including prohibited species) that were found in the species composition samples. 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 YEAR NUMBER 22 Yes No 4 0 Active A four-digit number identifying the year in which the gear retrieval of the set began. NUMBER 4 DT DATE 7 Yes No Active Similar to NORPAC.DOMESTIC_SPCOMP.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 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 SAMPLE_NUMBER NUMBER 22 Yes No 2 0 Active In sampling a longline set or a day's mothership operation or a day's joint venture operation, each portion of the set or delivery that was sampled received a unique sample_number within the set (usually, a 1, 2, or 3). NUMBER 7 SPECIES NUMBER 22 Yes No 3 0 Active A three-digit numeric code representing a marine species. NUMBER NORPAC.DOMESTIC_SPECIES 8 WEIGHT_SAMPLED NUMBER 22 No No 10 2 Active The total weight in kilograms of all of the sampled species in the sample. NUMBER 9 NUMBER_IN_SAMPLE NUMBER 22 Yes No 6 0 Active The number (count) of the specified species which occurred within the sample. NUMBER 10 WEIGHT_IN_SAMPLE NUMBER 22 Yes No 10 2 Active The total weight in kilograms of the specified species which occurred within the sample. NUMBER 11 NUMBER_OF_SKATES_SAMPLED NUMBER 22 No No 3 0 Active The number of hachi (skates) that were sampled for species composition. NUMBER 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_FLSS NUMBER 22 Yes Yes 6 0 Active For internal use only. NUMBER 9576 FOREIGN_MAMMAL Published / External Completed This table contains data collected for each haul (trawl vessels) or day (joint venture operations) monitored for marine mammals. Data from 1989 and 1990 only. Contains only records from joint venture operations except for 68 entries for a single Polish stern trawler fishing in the donut hole. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC This table contains data collected for each haul (trawl vessels) or day (joint venture operations) monitored for marine mammals. Data from 1989 and 1990 only. Contains only records from joint venture operations except for 68 entries for a single Polish stern trawler fishing in the donut hole. 1 CRUISE NUMBER 22 No No 3 0 Active A unique number representing the number of different times that an observer had been assigned to a vessel from that specific country. Each time an observer was assigned to a different vessel, a new cruise number was assigned. Each country had it's own set of cruise numbers starting with "1". The cruise number is associated with all of the data collected by the observer aboard the vessel. The combination of cruise number and vessel code creates a unique index of observer, vessel, country and year. Corresponds to OLD_CRUISE in the NORPAC.FOREIGN_FISHING_OPERATION table. NUMBER 2 VESSEL CHAR 4 No No Active A unique four-digit alpha-numeric code assigned to each fishing vessel, indicating specific vessel, gear type or activity (for a specific data set), and country of registry. The first letter gives the country of registry (J,A,N - Japan, R - U.S.S.R., P - Poland, K - Republic of Korea (ROK), M - Mexico, G - West Germany, B - Bulgaria, T - Taiwan, H - Portugal, C - People's Republic of China (PROC), W - U.S./Japan Joint Venture, Z - U.S./U.S.S.R. Joint Venture, X - U.S./Poland Joint Venture, Y - U.S./ROK Joint Venture, V - U.S./Bulgaria Joint Venture, U - U.S./Greece Joint Venture, O - U.S./West Germany Joint Venture, I - U.S./Spain Joint Venture, L - U.S./Taiwan Joint Venture, Q - U.S./PROC Joint Venture, S - U.S./Portugal Joint Venture, E - U.S./Iceland Joint Venture). The second letter gives the vessel gear type or activity (M - mothership or joint venture operation, S - stern trawler, L - longliner, P- snail pots). The last 2 characters are a code for the name of the specific vessel. Corresponds to OLD_VESSEL in the NORPAC.FOREIGN_FISHING_OPERATION table. CHAR 3 YEAR NUMBER 22 No No 2 0 Active The last two digits of the year in which the haul or set was retrieved. Yearis part of the day's date, which is recorded on all forms and used along withhaul as a cross reference between data forms to link related sets ofinformation. NUMBER 4 MONTH_DAY NUMBER 22 No No 4 0 Active A four-digit number representing the month and day in which a monitored haul retrieval began for trawl vessels. NUMBER 5 ENTRY_NUMBER NUMBER 22 No No 3 0 Active A number that corresponds to the record number in this table for a cruise, vessel combination. This is simply a sequential number that does not correspond to a haul_join value. Recorded for trips from 1989 forward. NUMBER 6 HAUL NUMBER 22 No 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 7 MOTHERSHIP_TONNAGE NUMBER 22 No No 5 0 Active An estimate of the day's catch delivered to a mothership vessel for the day that the catch of a marine mammal occurred. (Is currently a null field.) NUMBER 8 MOTHERSHIP_MONTH NUMBER 22 No No 2 0 Active The month in which hauls were monitored for marine mammals on a vessel acting as a mothership. (Is currently a null field.) NUMBER 9 MOTHERSHIP_DAY NUMBER 22 No No 2 0 Active The day in which hauls were monitored for marine mammals on a vessel acting as a mothership. (Is currently a null field.) NUMBER 10 NO_ANIMALS_CAUGHT NUMBER 22 No No 2 0 Active The number of marine mammals recorded in the catch for a haul. NUMBER 11 NO_ALIVE_RELEASED NUMBER 22 No No 2 0 Active The number of marine mammals released alive from a haul. NUMBER 12 NO_KILLED_BY_CREW NUMBER 22 No No 2 0 Active The number of marine mammals in the haul killed by the crew. NUMBER 13 NO_DEAD_IN_CATCH NUMBER 22 No No 2 0 Active The number of marine mammals that died prior to the catch being retrieved. NUMBER 14 NO_DECOMPOSED NUMBER 22 No No 2 0 Active The number of marine mammals found decomposed in a haul. NUMBER 9577 FOREIGN_MATURITY_CODE Published / External Completed This table links the maturity code in the NORPAC.FOREIGN_AGE table with a description of the code. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC This table links the maturity code in the NORPAC.FOREIGN_AGE table with a description of the code. 1 MATURITY_CODE NUMBER 22 Yes Yes 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. NUMBER 2 MATURITY_CODE_DEFINITION VARCHAR2 210 Yes No Active A description of the maturity level associated with this code. VARCHAR2 3 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 9578 FOREIGN_NATION Published / External Completed This table links the nation_code in the NORPAC.FOREIGN_VESSEL table with a description of the code. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC This table links the nation_code in the NORPAC.FOREIGN_VESSEL table with a description of the code. 1 NATION_CODE VARCHAR2 1 Yes Yes Active A one-digit alpha code associated with the vessel's country of registry. VARCHAR2 2 NATION_NAME VARCHAR2 30 Yes No Active Country of registry associated with the nation code. VARCHAR2 9579 FOREIGN_OBSERVER Published / External Completed This table provides the observer name and contractor code associated with each cruise and vessel. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC This table provides the observer name and contractor code associated with each cruise and vessel. 1 CRUISE NUMBER 22 Yes Yes 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 Yes 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 CONTRACTOR VARCHAR2 5 No No Active Abbreviation of the name of the organization that provided the observer. The NORPAC.FOREIGN_CONTRACTOR table contains a description of each abbreviation. VARCHAR2 NORPAC.FOREIGN_CONTRACTOR 4 LAST_NAME VARCHAR2 20 Yes Yes Active Last name of the observer who collected the sample data. VARCHAR2 5 FIRST_NAME VARCHAR2 15 Yes Yes Active First name of the observer who collected the sample data. VARCHAR2 6 MIDDLE_NAME VARCHAR2 15 No No Active Middle name of the observer who collected the sample data. VARCHAR2 7 DOMESTIC_OBSERVER_LINK NUMBER 22 No No 5 0 Active For internal use only (is currently null). NUMBER 9580 FOREIGN_POT_SNAILS Published / External Completed This table contains snail meat catch information for years 1984, 1985, 1986, 1987, and 1989. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC This table contains snail meat catch information for years 1984, 1985, 1986, 1987, and 1989. 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 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 OBSERVER_EST_WHOLE_SNAILS NUMBER 22 No No 6 2 Active The observer estimate of the whole weight of the catch of snails in metric tons (including shells). NUMBER 7 VESSEL_EST_WHOLE_SNAILS NUMBER 22 No No 6 2 Active The vessel estimate of the whole weight of the catch of snails in metric tons (including shells). NUMBER 8 OBSERVER_EST_RAW_SNAIL_MEAT NUMBER 22 No No 5 2 Active The observer estimate of the weight of the snail meat (metric tons). NUMBER 9 VESSEL_EST_RAW_SNAIL_MEAT NUMBER 22 No No 5 2 Active The vessel estimate of the weight of the snail meat (metric tons). NUMBER 10 OBSERVER_EST_COOKED_SNAIL_MEAT NUMBER 22 No No 5 2 Active The observer estimate of the weight of the cooked snail meat (metric tons). NUMBER 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 9581 FOREIGN_PREDATION_CODE Published / External Completed This table links the sea_lion_predation_code in the NORPAC.FOREIGN_VIABILITY table with a description of the code (how many sea lions were preying on the catch). Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC This table links the sea_lion_predation_code in the NORPAC.FOREIGN_VIABILITY table with a description of the code (how many sea lions were preying on the catch). 1 SEA_LION_PREDATION_CODE NUMBER 22 Yes Yes 1 0 Active A one-digit numeric code associated with sea lion predation. NUMBER 2 SEA_LION_PREDATION_DEFINITION VARCHAR2 50 Yes No Active The definition associated with the code (1: 0 sea lions, 2: 1-3 sea lions, 3: >3 sea lions). VARCHAR2 9582 FOREIGN_PROCESSING_TYPE Published / External Completed This table links the processing_type_code in the NORPAC.FOREIGN_FISHING_OPERATION table with a description of the code. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC This table links the processing_type_code in the NORPAC.FOREIGN_FISHING_OPERATION table with a description of the code. 1 PROCESSING_TYPE_CODE NUMBER 22 Yes Yes 1 0 Active A one-digit numeric code to identify the type of processing that occurs aboard the vessel. NUMBER 2 PROCESSING_TYPE_DEFINITION VARCHAR2 10 No No Active A description of the processing type code (1 - surimi, 2 - freezer). VARCHAR2 9583 FOREIGN_PRODUCT Published / External Completed This table provides product information for a wide range of species and products, 1980-1990. Some information was provided by ship's personnel. Other information was collected by observers' monitoring and weighing the products as they were being processed. The product codes can be found in the Observer Program's collection of Manuals for Biologists Aboard Foreign Groundfish Vessels. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC This table provides product information for a wide range of species and products, 1980-1990. Some information was provided by ship's personnel. Other information was collected by observers' monitoring and weighing the products as they were being processed. The product codes can be found in the Observer Program's collection of Manuals for Biologists Aboard Foreign Groundfish Vessels. 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 MONTH NUMBER 22 Yes No 2 0 Active A two-digit number representing the month in which the haul or set gear retrieval began. Month is part of the day's date, which is recorded on all forms and used along with haul as a cross reference between data forms to link related sets of information. NUMBER 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 INPFC_REGION NUMBER 22 Yes No 2 0 Active A two-digit numeric code representing the International North Pacific Fisheries Commission (INPFC) area or region in which the data were collected: 50 - Bering Sea/Aleutian Islands Region; 51 - Eastern Bering Sea Area; 52 - Central Bering Sea Area; 53 - Western Bering Sea Area; 54 - Aleutian Islands Area; 55 - Donut Hole Area; 60 - Gulf of Alaska Region; 61 - Shumagin Area; 62 - Chirikof Area; 63 - Kodiak Area; 64 - Yakutat/SE Alaska Area; 67 - Vancouver Area; 70 - Washington-Oregon-California Region; 71 - Columbia Area; 72 - Eureka Area; 73 - Monterey Area. NUMBER 6 SPECIES NUMBER 22 Yes No 3 0 Active A three-digit numeric code representing a marine species. NUMBER NORPAC.DOMESTIC_SPECIES 7 PRODUCT_CODE NUMBER 22 Yes No 2 0 Active A two-digit numeric code identifying the type of product associated with the recovery rate. NORPAC.FOREIGN_PRODUCT_CODE provides a description of the codes. NUMBER NORPAC.FOREIGN_PRODUCT_CODE 8 H_M VARCHAR2 7 No No Active A one-digit alpha code to identify whether the product was obtained by processing the fish by hand (H) or by machine (M). VARCHAR2 9 VESSEL_PERCT_RECOVERY NUMBER 22 No No 3 0 Active The product recovery percentage used by vessel personnel to back-calculate to total weight. NUMBER 10 VESSEL_UNIT_WEIGHT NUMBER 22 No No 6 2 Active The weight (in kg) of the standard sized packaging of the product as reported by the vessel (before freezing or addition of water). NUMBER 11 OBSERVER_PERCT_RECOVERY NUMBER 22 No No 3 0 Active The product recovery percentage obtained by the observer by first weighing the fish before processing and then weighing the resultant product. If two product recovery percentages exist for the same vessel, date, area, species, and product, they represent a range of percentages for the product. NUMBER 12 OBSERVER_UNIT_WEIGHT NUMBER 22 No No 6 2 Active The weight (in kg) of the standard sized packaging of the product as weighed by the observer (before freezing or addition of water). NUMBER 13 FILENAME VARCHAR2 8 No No Active The original filename on the Burroughs computer system from which this data record came. VARCHAR2 14 PK_FPRD NUMBER 22 Yes Yes 6 0 Active For internal use only. NUMBER 9584 FOREIGN_PRODUCT_CODE Published / External Completed This table links the product code in the NORPAC.FOREIGN_PRODUCT table with a description of the code. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC This table links the product code in the NORPAC.FOREIGN_PRODUCT table with a description of the code. 1 PRODUCT_CODE NUMBER 22 Yes Yes 2 0 Active A two-digit numeric code to identify the type of product associated with the recovery rate. NUMBER 2 PRODUCT_CODE_DEFINITION VARCHAR2 50 No No Active A description of the product code. VARCHAR2 9585 FOREIGN_PROHIB7886 Published / External Completed Prohibited species catch information from foreign and joint venture fishing operations in the Bering Sea and Aleutian Islands, Gulf of Alaska, and Washington-Oregon-California Regions for the years 1978-86. These are monthly compilations separated by nation, area, vessel class and species. The information are provided for Pacific halibut, all king crab (combined), all Tanner crab (combined), all salmon (combined), and steelhead. The official groundfish catch estimate (blend estimate) is given as well as average weight per individual, number of individuals per ton of groundfish, total number of individuals, and total tons of individuals. A source code is listed, to identify whether the information came from data collected that month or from some other source. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC Prohibited species catch information from foreign and joint venture fishing operations in the Bering Sea and Aleutian Islands, Gulf of Alaska, and Washington-Oregon-California Regions for the years 1978-86. These are monthly compilations separated by nation, area, vessel class and species. The information are provided for Pacific halibut, all king crab (combined), all Tanner crab (combined), all salmon (combined), and steelhead. The official groundfish catch estimate (blend estimate) is given as well as average weight per individual, number of individuals per ton of groundfish, total number of individuals, and total tons of individuals. A source code is listed, to identify whether the information came from data collected that month or from some other source. 1 YEAR NUMBER 22 No No 2 0 Active The last two digits of the year in which the fishing occurred. NUMBER 2 MONTH NUMBER 22 No No 2 0 Active The two digit numerical representation of the month in which the fishing occurred. NUMBER 3 NATION CHAR 13 No No Active The name of the nation(s) associated with each fishing operation. These nations are: BULGARIA, JAPAN, MEXICO, POLAND, PORTUGAL, PRC (People's Republic of China), ROK (Republic of Korea), TAIWAN, USSR (United Soviet Socialist Republic), WEST GERMANY, US-BULGARIA, US-GREECE, US-JAPAN, US-POLAND, US-PORTUGAL, US-PRC, US-ROK, US-SPAIN, US-TAIWAN, US-USSR, US-W. GERMANY. All nation names beginning with US- are joint venture operations between the United States and a foreign nation. CHAR 4 AREA_NAME CHAR 12 No No Active The name of the International North Pacific Fish Commission area in which the catch was made. These areas are: BERING SEA 1, BERING SEA 2, BERING SEA 3, ALEUTIANS, SHUMAGIN, CHIRIKOF, KODIAK, YAKUTAT, S. E. ALASKA, VANCOUVER, COLUMBIA, EUREKA, MONTEREY. CHAR 5 VESSEL_CLASS CHAR 16 No No Active The vessel type used in the fishing operations. In 1978 and 1979, larger trawlers were separated by size into MED TRAWLER and LG TRAWLER. From 1980 on, larger trawlers were separated based on their ability to make surimi. If they could make surimi, they were called SURIMI TRAWL; if not, they were called LG FRZ TRAWL. Longliners were listed as a single vessel type (LONGLINER) in 1978-81. From 1982 on, they were separated by target into LONGLINE COD (targeting Pacific cod) and LONGLINE SAB (targeting sablefish). Two additional vessel types, JV/SURIMI TRAWL and LL COD/JV MSHIP, identified the portion of the catch caught by a fishing vessel itself, in the same week that it was processing another vessel's catch in a joint venture operation; JV MSHIP identified the portion of the catch delivered to the fishing vessel for processing. The other vessel types were: FREEZER MSHIP (no surimi capability), SNAIL POT, and SMALL TRAWL. CHAR 6 AREA_NUMBER NUMBER 22 No No 3 0 Active The number associated with the International North Pacific Fish Commission area_name. These numbers are: 51 (BERING SEA 1), 52 (BERING SEA 2), 53 (BERING SEA 3), 54 (ALEUTIANS), 61 (SHUMAGIN), 62 (CHIRIKOF), 63 (KODIAK), 64 (YAKUTAT), 65 (S. E. ALASKA), 67 (VANCOUVER), 71 (COLUMBIA), 72 (EUREKA), 73 (MONTEREY). NUMBER 7 BLEND_TONNAGE NUMBER 22 No No 12 3 Active The best estimate of the allocated tonnage caught (i.e., combined tonnage caught of those species groups that had catch allocations) for the year, month, nation, vessel_class, and area_number. NUMBER 8 HALIBUT_KG_PER_IND NUMBER 22 No No 12 3 Active The average weight (kg) of the individual halibut found in the observers' samples. NUMBER 9 HALIBUT_NOS_PER_TON NUMBER 22 No No 12 3 Active The number of halibut caught per ton of allocated groundfish sampled for the presence of halibut. NUMBER 10 HALIBUT_EST_NOS NUMBER 22 No No 12 3 Active The estimated total number of halibut caught for the year, month, nation, vessel_class, and area_number. NUMBER 11 HALIBUT_EST_TONS NUMBER 22 No No 12 3 Active The estimated tonnage of halibut caught for the year, month, nation, vessel_class, and area_number. NUMBER 12 HALIBUT_SOURCE NUMBER 22 No No 1 0 Active A one-digit number that indicates where the halibut information came from. 4 - the halibut information came from sampling from that year, month, nation, vessel_class, area_number. 5 - no halibut sample data was collected for that cell (year, nation, vessel_class, area_number) for that month, so the information on halibut average weight and numbers per ton came from sampling from that cell for the same quarter. 6 - no halibut sample data was collected for that cell for that month or quarter, so the information on halibut average weight and numbers per ton came from sampling from that cell from the other quarters of the year. 7 - no halibut sample data was collected for that cell for that month, quarter, or year, so the information on halibut average weight and numbers per ton came from sampling from that year, but from a different cell that was judged to give results similar to what would have been found for that cell. NUMBER 13 KINGCRAB_KG_PER_IND NUMBER 22 No No 12 3 Active The average weight (kg) of the individual king crab found in the observers' samples. NUMBER 14 KINGCRAB_NOS_PER_TON NUMBER 22 No No 12 3 Active The number of king crab caught per ton of allocated groundfish sampled for the presence of king crab. NUMBER 15 KINGCRAB_EST_NOS NUMBER 22 No No 12 3 Active The estimated total number of king crab caught for the year, month, nation, vessel_class, and area_number. NUMBER 16 KINGCRAB_EST_TONS NUMBER 22 No No 12 3 Active The estimated tonnage of king crab caught for the year, month, nation, vessel_class, and area_number. NUMBER 17 KINGCRAB_SOURCE NUMBER 22 No No 1 0 Active A one-digit number that indicates where the king crab information came from. 4 - the king crab information came from sampling from that year, month, nation, vessel_class, area_number. 5 - no king crab sample data was collected for that cell (year, nation, vessel_class, area_number) for that month, so the information on king crab average weight and numbers per ton came from sampling from that cell for the same quarter. 6 - no king crab sample data was collected for that cell for that month or quarter, so the information on king crab average weight and numbers per ton came from sampling from that cell from the other quarters of the year. 7 - no king crab sample data was collected for that cell for that month, quarter, or year, so the information on king crab average weight and numbers per ton came from sampling from that year, but from a different cell that was judged to give results similar to what would have been found for that cell. NUMBER 18 TANNERCRAB_KG_PER_IND NUMBER 22 No No 12 3 Active The average weight (kg) of the individual Tanner crab found in the observers' samples. NUMBER 19 TANNERCRAB_NOS_PER_TON NUMBER 22 No No 12 3 Active The number of Tanner crab caught per ton of allocated groundfish sampled for the presence of Tanner crab. NUMBER 20 TANNERCRAB_EST_NOS NUMBER 22 No No 12 3 Active The estimated total number of Tanner crab caught for the year, month, nation, vessel_class, and area_number. NUMBER 21 TANNERCRAB_EST_TONS NUMBER 22 No No 12 3 Active The estimated tonnage of Tanner crab caught for the year, month, nation, vessel_class, and area_number. NUMBER 22 TANNERCRAB_SOURCE NUMBER 22 No No 1 0 Active A one-digit number that indicates where the Tanner crab information came from. 4 - the Tanner crab information came from sampling from that year, month, nation, vessel_class, area_number. 5 - no Tanner crab sample data was collected for that cell (year, nation, vessel_class, area_number) for that month, so the information on Tanner crab average weight and numbers per ton came from sampling from that cell for the same quarter. 6 - no Tanner crab sample data was collected for that cell for that month or quarter, so the information on Tanner crab average weight and numbers per ton came from sampling from that cell from the other quarters of the year. 7 - no Tanner crab sample data was collected for that cell for that month, quarter, or year, so the information on Tanner crab average weight and numbers per ton came from sampling from that year, but from a different cell that was judged to give results similar to what would have been found for that cell. NUMBER 23 SALMON_KG_PER_IND NUMBER 22 No No 12 3 Active The average weight (kg) of the individual salmon found in the observers' samples. NUMBER 24 SALMON_NOS_PER_TON NUMBER 22 No No 12 3 Active The number of salmon caught per ton of allocated groundfish sampled for the presence of salmon. NUMBER 25 SALMON_EST_NOS NUMBER 22 No No 12 3 Active The estimated total number of salmon caught for the year, month, nation, vessel_class, and area_number. NUMBER 26 SALMON_EST_TONS NUMBER 22 No No 12 3 Active The estimated tonnage of salmon caught for the year, month, nation, vessel_class, and area_number. NUMBER 27 SALMON_SOURCE NUMBER 22 No No 1 0 Active A one-digit number that indicates where the salmon information came from. 4 - the salmon information came from sampling from that year, month, nation, vessel_class, area_number. 5 - no salmon sample data was collected for that cell (year, nation, vessel_class, area_number) for that month, so the information on salmon average weight and numbers per ton came from sampling from that cell for the same quarter. 6 - no salmon sample data was collected for that cell for that month or quarter, so the information on salmon average weight and numbers per ton came from sampling from that cell from the other quarters of the year. 7 - no salmon sample data was collected for that cell for that month, quarter, or year, so the information on salmon average weight and numbers per ton came from sampling from that year, but from a different cell that was judged to give results similar to what would have been found for that cell. NUMBER 28 STEELHEAD_KG_PER_IND NUMBER 22 No No 12 3 Active The average weight (kg) of the individual steelhead found in the observers' samples. NUMBER 29 STEELHEAD_NOS_PER_TON NUMBER 22 No No 12 3 Active The number of steelhead caught per ton of allocated groundfish sampled for the presence of steelhead. NUMBER 30 STEELHEAD_EST_NOS NUMBER 22 No No 12 3 Active The estimated total number of steelhead caught for the year, month, nation, vessel_class, and area_number. NUMBER 31 STEELHEAD_EST_TONS NUMBER 22 No No 12 3 Active The estimated tonnage of steelhead caught for the year, month, nation, vessel_class, and area_number. NUMBER 32 STEELHEAD_SOURCE NUMBER 22 No No 1 0 Active A one-digit number that indicates where the steelhead information came from. 4 - the steelhead information came from sampling from that year, month, nation, vessel_class, area_number. 5 - no steelhead sample data was collected for that cell (year, nation, vessel_class, area_number) for that month, so the information on steelhead average weight and numbers per ton came from sampling from that cell for the same quarter. 6 - no steelhead sample data was collected for that cell for that month or quarter, so the information on steelhead average weight and numbers per ton came from sampling from that cell from the other quarters of the year. 7 - no steelhead sample data was collected for that cell for that month, quarter, or year, so the information on steelhead average weight and numbers per ton came from sampling from that year, but from a different cell that was judged to give results similar to what would have been found for that cell. 0 - no steelhead were caught in that region (Bering Sea/Aleutians, or Gulf of Alaska, or Washington-Oregon-California) and year for any nation or vessel_class. NUMBER 9586 FOREIGN_PROHIB8790 Published / External Completed Prohibited species catch information from foreign and joint venture fishing operations in the Bering Sea and Aleutian Islands, Gulf of Alaska, and Washington-Oregon-California Regions for the years 1987-90. These are weekly compilations separated by nation, area, vessel class, company (for joint venture operations), and species. The information are provided for Pacific halibut, red king crab, blue king crab, other king crab (combined), bairdi Tanner crab, other Tanner crab (combined), Chinook salmon, and other salmon (combined). The official groundfish catch estimate (blend estimate) is given as well as average weight per individual (Pacific halibut only), number of individuals per ton of groundfish, total number of individuals, and total tons of individuals (Pacific halibut only). A source code is listed, to identify whether the information came from data collected that week or from some other source. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC Prohibited species catch information from foreign and joint venture fishing operations in the Bering Sea and Aleutian Islands, Gulf of Alaska, and Washington-Oregon-California Regions for the years 1987-90. These are weekly compilations separated by nation, area, vessel class, company (for joint venture operations), and species. The information are provided for Pacific halibut, red king crab, blue king crab, other king crab (combined), bairdi Tanner crab, other Tanner crab (combined), Chinook salmon, and other salmon (combined). The official groundfish catch estimate (blend estimate) is given as well as average weight per individual (Pacific halibut only), number of individuals per ton of groundfish, total number of individuals, and total tons of individuals (Pacific halibut only). A source code is listed, to identify whether the information came from data collected that week or from some other source. 1 WEEKENDING_DATE NUMBER 22 No No 6 0 Active These data are a weekly compilation. The weekending_date is the date (YYMMDD) of the last day associated with the compilation period. NUMBER 2 NATION VARCHAR2 13 No No Active The name of the nation(s) associated with each fishing operation. These nations are: JAPAN, POLAND, PRC (People's Republic of China), ROK (Republic of Korea), US-ICELAND, US-JAPAN, US-POLAND, US-PRC, US-ROK, US-USSR (United Soviet Socialist Republic). All nation names beginning with US- are joint venture operations between the United States and a foreign nation. VARCHAR2 3 AREA_NAME VARCHAR2 14 No No Active The name of the International North Pacific Fish Commission area in which the catch was made. These areas are: BERING SEA 1, BERING SEA 2, BERING SEA 3, ALEUTIANS, SHUMAGIN, CHIRIKOF, KODIAK, VANCOUVER, COLUMBIA, EUREKA, MONTEREY. VARCHAR2 4 SPECIES_NAME VARCHAR2 20 No No Active The name of the prohibited species group. The species groups are: BAIRDI TANNER CRAB, OTHER TANNER CRAB, RED KING CRAB, BLUE KING CRAB, OTHER KING CRAB, CHINOOK SALMON, OTHER SALMON, PACIFIC HALIBUT. VARCHAR2 5 VESSEL_CLASS VARCHAR2 16 No No Active The vessel type used in the fishing operations. The larger trawlers were separated based on their ability to make surimi. If they could make surimi, they were called SURIMI TRAWL; if not, they were called LG FRZ TRAWL. The smaller trawlers were called SMALL TRAWL. In 1987-90, longliners only targeted Pacific cod and so were called LONGLINE COD. Joint venture motherships were separated by target and surimi capability (OTHER FREEZER JV, OTHER SURIMI JV, YELL/FLAT FRZ JV, YELL/FLAT SUR JV, POLL-BOT FRZ JV (1989 only), POLL-BOT SUR JV (1989 only), POLL-MID FRZ JV (1989 only), POLL-MID SUR JV (1989 only) [No joint ventures targeted pollock in 1990]). VARCHAR2 6 COMPANY CHAR 4 No No Active A code used to differentiate between the different companies involved in joint venture operations. The first two digits identified the nationality of the processing vessel, and the second two digits identified different companies within that nationality. IJ designated Iceland, JA designated Japan, KS designated the Republic of Korea (ROK), PC designated the Peoples Republic of China (PRC), PL designated Poland, and UR designated the USSR. A list associating company name with company code is not currently available. CHAR 7 AREA_NUMBER NUMBER 22 No No 4 0 Active The number associated with the International North Pacific Fish Commission area_name. Within BERING SEA 1, the sub-areas were: 511, 513, 514, 515, 516, 517. Within BERING SEA 2, the sub-areas were: 521, 522. The other areas were: 530 (BERING SEA 3), 540 (ALEUTIANS), 610 (SHUMAGIN), 620 (CHIRIKOF), 630 (KODIAK), 670 (VANCOUVER), 710 (COLUMBIA), 720 (EUREKA), 730 (MONTEREY). NUMBER 8 BLEND_TONNAGE NUMBER 22 No No 12 3 Active The best estimate of the allocated tonnage caught (i.e., combined tonnage caught of those species groups that had catch allocations) for the year, month, nation, vessel_class, and area_number. NUMBER 9 KG_PER_IND NUMBER 22 No No 12 3 Active The average weight (kg) of the individuals of that species found in the observers' samples (only collected for Pacific halibut). NUMBER 10 NOS_PER_TON NUMBER 22 No No 12 3 Active The number of individuals caught per ton of allocated groundfish sampled for the presence of that species. NUMBER 11 EST_NOS NUMBER 22 No No 12 3 Active The estimated total number of individuals of that species caught for the weekending_date, nation, vessel_class, area_number, and company (if applicable). NUMBER 12 EST_TONS NUMBER 22 No No 12 3 Active The estimated tonnage of that species caught for the weekending_date, nation, vessel_class, area_number, and company (if applicable) (only collected for Pacific halibut). NUMBER 13 SOURCE CHAR 1 No No Active A one-digit alpha code that indicates where the prohibited species information came from. If the field is null, the information came directly from sampling that occurred for that weekending_date and cell (nation, vessel_class, area_number, and company [company can be null]). If the field contains an M, no sampling occurred for that weekending_date and cell, so the information came from sampling that occurred from the same month for that cell. If the field contains a Q, no sampling occurred for that weekending_date or month for that cell, so the information came from sampling that occurred from the same quarter for that cell. If the field contains a Y, no sampling occurred for that weekending_date, month, or quarter for that cell, so the information came from sampling that occurred from the same year for that cell. If the field contains a C, there was no sampling data at all for that cell [company can't be null], so the sampling information came from the same weekending_date, nation, and vessel_class, but for all companies combined. If the field contains a D, there was no sampling data at all for that cell [company can't be null], so the sampling information came from the same month, nation, and vessel_class but for all companies combined. If the field contains an E, there was no sampling data for that cell [company can't be null], so the sampling information came from the same quarter, nation, and vessel_class but for all companies combined. If the field contains an F, there was no sampling data for that cell [company can't be null], so the sampling information came from the same year, nation, and vessel_class but for all companies combined. CHAR 14 YR NUMBER 22 No No 2 0 Active The last two digits of the year in which the fishing occurred. NUMBER 9587 FOREIGN_SEA Published / External Completed This table links the sea code in the NORPAC.FOREIGN_HAUL table with a description of the code. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC This table links the sea code in the NORPAC.FOREIGN_HAUL table with a description of the code. 1 SEA NUMBER 22 Yes Yes 1 0 Active A one-digit numeric sea code (0 - 9) to identify the average wave height of the larger well-formed waves being observed. NUMBER 2 SEA_DEFINITION VARCHAR2 35 Yes No Active A definition of the sea code. VARCHAR2 9588 FOREIGN_SHELL_CONDITION Published / External 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 9589 FOREIGN_SPAWN Published / External 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 9590 FOREIGN_SPCOMP Published / External Completed This table contains species composition sampling data from catch made in the foreign and joint venture groundfish fishery. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC This table contains species composition sampling data from catch made in the foreign and joint venture groundfish fishery. 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_SPCOMP.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 Code used by the NMFS Observer Program to identify an organism or material. This code is associated with species name in the domestic_species table (using the column name species_no in place of species). NUMBER NORPAC.DOMESTIC_SPECIES 7 SEX VARCHAR2 1 Yes Yes Active A one-digit alpha code indicating the sex of the organism. F = female, M = male, U = unknown. VARCHAR2 8 WEIGHT_SAMPLED NUMBER 22 Yes No 10 2 Active The total weight in kilograms of all of the sampled species in the sample. NUMBER 9 NUMBER_IN_SAMPLE NUMBER 22 Yes No 7 0 Active The number (count) of the specified species which occurred within the sample. NUMBER 10 WEIGHT_IN_SAMPLE NUMBER 22 Yes No 10 2 Active The total weight in kilograms of the specified species which occurred within the sample. NUMBER 11 NUMBER_OF_POTS_SAMPLED NUMBER 22 No No 5 0 Active The number of pots in the set that were sampled for species composition. NUMBER 12 NUMBER_OF_SKATES_SAMPLED NUMBER 22 No No 5 0 Active The number of (hachi) skates that were sampled for species composition. NUMBER 13 SPECIES_HAUL_NUMBER NUMBER 22 Yes No 8 0 Active The estimated number of the specified species in the entire haul extrapolated from the sample. NUMBER 14 SPECIES_HAUL_WEIGHT NUMBER 22 Yes No 13 2 Active The estimated weight in kilograms of the specified species in the entire haul extrapolated from the sample. NUMBER 15 EXTRAPOLATION_TYPE NUMBER 22 Yes No 1 0 Active A one-digit code associated with the procedure used to extrapolate the NUMBER_IN_SAMPLE and WEIGHT_IN_SAMPLE to SPECIES_HAUL_NUMBER and SPECIES_HAUL_WEIGHT. NORPAC.FOREIGN_EXTRAPOLATION provides a description of the codes. NUMBER NORPAC.FOREIGN_EXTRAPOLATION 16 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 9591 FOREIGN_SPECIAL_HANDLING Published / External Completed This table links the special_handling code in the NORPAC.FOREIGN_AGE table with a description of the code. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC This table links the special_handling code in the NORPAC.FOREIGN_AGE table with a description of the code. 1 SPECIAL_HANDLING NUMBER 22 Yes Yes 2 0 Active A one-digit numeric special_handling code added by the age reader. NUMBER 2 SPECIAL_HANDLING_DEFINITION VARCHAR2 50 Yes No Active A description of the special_handling code. VARCHAR2 9592 FOREIGN_VESSEL Published / External Completed This table links the vessel code in several of the major foreign tables (HAUL, SPCOMP, LENGTH, AGE) with the name of the vessel and other features of the vessel. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC This table links the vessel code in several of the major foreign tables (HAUL, SPCOMP, LENGTH, AGE) with the name of the vessel and other features of the vessel. 1 VESSEL VARCHAR2 4 Yes Yes 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 2 VESSEL_NAME VARCHAR2 50 Yes No Active The name of the vessel. VARCHAR2 3 NATION_CODE VARCHAR2 1 Yes No Active A one-digit alpha code associated with the vessel's country of registry. The NORPAC.FOREIGN_NATION table provides a description of the codes. VARCHAR2 NORPAC.FOREIGN_NATION 4 PERMIT_NUMBER VARCHAR2 7 Yes No Active A seven-digit value assigned to each distinct foreign fishing vessel upon receiving a permit to fish in U.S. waters. VARCHAR2 5 VESSEL_LENGTH NUMBER 22 No No 4 0 Active The total length (in meters) of the vessel. NUMBER 6 GRT NUMBER 22 No No 5 0 Active The Gross registered tons of the vessel. NUMBER 7 COMMENTS VARCHAR2 200 No No Active Name changes and permit number changes of the vessel. VARCHAR2 9593 FOREIGN_VESSEL_TYPE Published / External Completed This table links the vessel_type_code in the NORPAC.FOREIGN_FISHING_OPERATION table with a description of the code. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC This table links the vessel_type_code in the NORPAC.FOREIGN_FISHING_OPERATION table with a description of the code. 1 VESSEL_TYPE_CODE NUMBER 22 Yes Yes 1 0 Active A one-digit numeric code to identify the type of fishing operation performed by the vessel. NUMBER 2 VESSEL_TYPE_DEFINITION VARCHAR2 20 Yes No Active A description of the fishing operation associated with the vessel_type_code. VARCHAR2 9594 FOREIGN_VIABILITY Published / External 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 9595 FOREIGN_WEATHER Published / External Completed This table links the weather code in the NORPAC.FOREIGN_HAUL table with a description of the code. Loaded by batch 2364, 06-29-2009 18:15 Data Table Yes NORPAC This table links the weather code in the NORPAC.FOREIGN_HAUL table with a description of the code. 1 WEATHER NUMBER 22 Yes Yes 1 0 Active A one-digit numeric weather code (0 - 9). NUMBER 2 WEATHER_DEFINITION VARCHAR2 50 Yes No Active A description associated with the weather code. VARCHAR2 Author 1973 2012 Person Berger, Jerry jerry.berger@noaa.gov Retired Data Steward 2025 Person Thompson, Lisa lisa.thompson@noaa.gov 7600 Sand Point Way NE Seattle WA 98115-6349 USA 206-526-4229 Data Steward 1980 2022 Person Narita, Renold E ren.narita@noaa.gov Email Distributor 1980 2022 Person Narita, Renold E ren.narita@noaa.gov Email Metadata Contact 2022 Person Kingham, Andy andy.kingham@noaa.gov Metadata Contact 2008 2019 Person Turnbull, Doug doug.turnbull@noaa.gov 7600 Sandpoint Way NE Seattle WA 98115 USA (206)526-4053 (206)526-4066 0700-1630 206 526 4053 Point of Contact 2022 Person Campbell, Glenn glenn.campbell@noaa.gov Point of Contact 2012 2022 Person Narita, Renold E ren.narita@noaa.gov 206 526 6697 170 -122 64 37 BSAI, GOA, West Coast US Range 1973 1986 Duration of Foreign Fishing in USEEZ Confidential MSA confidentiality constraints. Purpose and confidentiality documentation must be on file prior to release of unaggredated catch and effort statistics. Purpose and confidentiality documentation must be on file prior to release of unaggredated catch and effort statistics. N/A Purpose and confidentiality documentation must be on file prior to release of unaggredated catch and effort statistics. Approved Research and Status of Stocks Analysis None None https://www.afsc.noaa.gov/FMA/default.htm N/A These data are confidential and not available in unaggregated form. https://www.afsc.noaa.gov/FMA/PDF_DOCS/Foreign%20Fishing%20Table%20Diagram.pdf Foreign Fishing Table Diagram Online Resource Schematic of database tables. https://www.afsc.noaa.gov/FMA/foreign_tables.htm Foreign Tables Online Resource A list of the tables associated with observer samples taken aboard vessels from foreign nations fishing or processing groundfish catch in the Bering Sea, Aleutian Islands, or the Gulf of Alaska, 1973-1990. Each table name links to a page which provides details about the table and about each column associated with the table. With the revision of the Magnuson-Stevens Act, the data contained within these tables are confidential and are protected from general release. The staff authorized to use these data include NOAA Fisheries' scientists and managers participating in a broad range of activities including: stock assessments, marine mammal interactions, food habits, fish age analyses, economic analyses, fishery management plan development, in-season fishery management. The data are also shared with other authorized users in the Alaska Department of Fish and Game (ADF&G) and North Pacific Fishery Management Council staff with similar responsibilities. Data was recorded on paper deck sheets, and entered into an Oracle database once the observer returned to port, or reported for debriefing. Currently the data reside in static tables at the AFSC. The data reflect the early efforts to compile observer data of an ongoing fishery. They may be considered representative of the actual fishing activity within the constraints of an activly developing program. The data reflect the early efforts to compile observer data of an ongoing fishery. They may be considered representative of the actual fishing activity within the constraints of an activly developing program. These data retain any sampling bias the may have resulted from the practices followed at the time of collection These data are static and complete. These data were subject to debriefing at the conclusion of the observer cruise. Yes Unknown No Yes N/A N/A Under the Magnuson-Stevens Act section 402(b)(2) any observer data shall be confidential and shall not be disclosed except in accordance with certain exceptions. Confidentiality of observer statistics is to be maintained under 50 CFR 600.415 - Access to statistics. Access to these data are provided to Federal, State, Council, Research Institutions and others who have a demonstrated need for such access, and who have submitted and been been granted approval, of limited access confidentiality agreements. These agreements are valid only for the duration of approved projects or research, the data released No Archiving Intended N/A These data are contained within a fully backed up and mirrored Oracle database at the AFSC The National Marine Fisheries Service (NMFS) began placing observers on foreign fishing vessels operating off the northwest and Alaskan coasts of the United States in 1973, creating the North Pacific Foreign Fisheries Observer Program. Initially, observers were placed on vessels only upon invitation by host countries. In the early years of the program the primary purposes of observers were to determine incidental catch rates of Pacific halibut in groundfish catches and to verify catch statistics in the Japanese crab fishery. Later, observers collected data on the incidence of king crab, snow (Tanner) crab, and Pacific salmon, and obtained biological data on other important species. Following the implementation of the Magnuson Fishery Conservation and Management Act of 1976, which mandated that foreign vessels accept observers, observer coverage greatly expanded. 9557 Entity 9558 Entity 9559 Entity 9560 Entity 9561 Entity 9562 Entity 9563 Entity 9564 Entity 9565 Entity 9566 Entity 9567 Entity 9568 Entity 9569 Entity 9570 Entity 9571 Entity 9572 Entity 9573 Entity 9574 Entity 9575 Entity 9576 Entity 9577 Entity 9578 Entity 9579 Entity 9580 Entity 9581 Entity 9582 Entity 9583 Entity 9584 Entity 9585 Entity 9586 Entity 9587 Entity 9588 Entity 9589 Entity 9590 Entity 9591 Entity 9592 Entity 9593 Entity 9594 Entity 9595 Entity gov.noaa.nmfs.inport:9556 Doug Turnbull 2009-06-29T17:00:56 Lisa Peterson 2025-09-23T14:02:52 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 No 2016-05-18 1 Year 2017-05-18