| Table name |
Definition |
| NORPAC.FOREIGN_LONGLINE_PROHIB_SAMPLE |
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.
|
| 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. |
| YEAR |
number(4,0) |
A four-digit number identifying the year in which the gear retrieval of the set began. |
| DT |
date |
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). |
| HAUL |
number(3,0) |
A unique number which identifies a specific occurrence of net, pot, or longline fishing effort. This table does not include “no fishing” days. |
| SAMPLE_NUMBER |
number(2,0) |
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).
|
| 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). |
| WEIGHT_SAMPLED |
number(10,2) |
The total weight in kilograms of all of the sampled species in the sample.
|
| NUMBER_IN_SAMPLE |
number(6,0) |
The number (count) of the specified species which occurred within the sample.
|
| WEIGHT_IN_SAMPLE |
number(10,2) |
The total weight in kilograms of the specified species which occurred within the sample. |
| NUMBER_OF_SKATES_SAMPLED |
number(3,0) |
The number of hachi (skates) that were sampled for prohibited species.
|
| HAUL_JOIN |
number(6,0) |
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. |
| PK_FLPS |
number(6,0) |
For internal use only. |
|
