| Column name |
Type |
Definition |
| CRUISE |
number(4,0) |
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. |
| VESSEL |
varchar2(4) |
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. |
| MONTH |
number(2,0) |
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. |
| YEAR |
number(4,0) |
A four-digit number identifying the year in which the gear retrieval of the haul began. |
| INPFC_REGION |
number(2,0) |
A two-digit 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. |
| SPECIES
|
number(3,0) |
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). |
| PRODUCT_CODE |
number(2,0) |
A two-digit code identifying the type of product associated with the recovery rate. NORPAC.FOREIGN_PRODUCT_CODE provides a description of the codes.
|
| H_M |
varchar2(7) |
A one-digit alpha code to identify whether the product was obtained by processing the fish by hand (H) or by machine (M).
|
| VESSEL_PERCT_RECOVERY |
number(3,0) |
The product recovery percentage used by vessel personnel to back-calculate to total weight.
|
| VESSEL_UNIT_WEIGHT |
number(6,2) |
The weight (in kg) of the standard sized packaging of the product as reported by the vessel (before freezing or addition of water).
|
| OBSERVER_PERCT_RECOVERY |
number(3,0) |
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. |
| OBSERVER_UNIT_WEIGHT |
number(6,2) |
The weight (in kg) of the standard sized packaging of the product as weighed by the observer (before freezing or addition of water).
|
| FILENAME |
varchar2(8) |
The original filename on the Burroughs computer system from which this data record came.
|
| PK_FPRD |
number(6,0) |
For internal use only. |
