| Table name |
Definition |
| NORPAC.FOREIGN_LONGLINE_SPCOMP_SAMPLE |
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. |
| 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_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). |
| 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 species composition.
|
| 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_FLSS |
number(6,0) |
For internal use only. |
|
