| Table name |
Definition |
| NORPAC.FOREIGN_VIABILITY |
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. |
| 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. |
| 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). |
| YEAR |
number(4,0) |
A four-digit number identifying the year in which the gear retrieval of the haul began. |
| 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. |
| SPECIES |
number(3,0) |
Species code 101, the code for Pacific halibut. |
| NUMBER_EXCELLENT |
number(4,0) |
The number of Pacific halibut examined and determined to be in excellent condition.
|
| NUMBER_POOR |
number(4,0) |
The number of Pacific halibut examined and determined to be in poor condition.
|
| NUMBER_DEAD |
number(4,0) |
The number of Pacific halibut examined and determined to be dead or soon to be dead.
|
| SEA_LION_PREDATION_CODE |
number(1,0) |
A one-digit numeric code associated with the amount of sea lion predation. NORPAC.FOREIGN_PREDATION_CODE provides a description of the codes. |
| FILENAME |
varchar2(8) |
The original filename on the Burroughs computer system from which this data record came.
|
| 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_FVIA |
number(6,0) |
For internal use only. |
|
