| 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 was 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) |
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). |
| SEX |
varchar2(1) |
A one-digit alpha code indicating the sex of the organism. F =female, M = male, U = unknown. |
| CARAPACE_LENGTH |
number(3,0) |
Observed length (cm) of the carapace of the specimen. |
| CHELA_HEIGHT |
number(3,0) |
Height (mm) of the cheliped (portion of the crab that makes up the pincher), measured from between the anterior two pairs of spines on the dorsal surface of the right chela to the closest point on the ventral surface. |
| FEMALE_CRAB_MATURITY |
number(1,0) |
A one-digit numeric code to identify the maturity of the female crab. These codes are defined in the NORPAC.FOREIGN_CRAB_MATURITY_CODE table. 1 - no eggs; 2 - eggs; 3 - egg cases. |
| 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_FCM |
number(6,0) |
For internal use only. |
