| 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. |
| OBSERVER_EST_WHOLE_SNAILS |
number(6,2) |
The observer estimate of the whole weight of the catch of snails in metric tons (including shells).
|
| VESSEL_EST_WHOLE_SNAILS |
number(6,2) |
The vessel estimate of the whole weight of the catch of snails in metric tons (including shells).
|
| OBSERVER_EST_RAW_SNAIL_MEAT |
number(5,2) |
The observer estimate of the weight of the snail meat (metric tons).
|
| VESSEL_EST_RAW_SNAIL_MEAT |
number(5,2) |
The vessel estimate of the weight of the snail meat (metric tons).
|
| OBSERVER_EST_COOKED_SNAIL_MEAT |
number(5,2) |
The observer estimate of the weight of the cooked snail meat (metric tons). |
| 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. |
