| 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_AGE.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(4,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). |
| SPECIMEN_NUMBER |
number(3,0) |
A unique number assigned a single specimen within a collection. |
| SEX |
varchar2(1) |
A one-digit alpha code indicating the sex of the organism. F =female, M = male, U = unknown. |
| LENGTH |
number(3,0) |
The fork length in centimeters. |
| AGE |
number(2,0) |
The age of the fish, recorded in years. Recorded by age readers following examination of the specimens in the age determination laboratory. |
| INDIV_WEIGHT |
number(8,2) |
The weight (to one-hundredth of a kilogram) of the individual fish from which the age structure (or maturity information) was taken. |
| SPECIAL_HANDLING |
number(2,0) |
A one-digit numeric code associated with additional information related to the fish. NORPAC.FOREIGN_SPECIAL_HANDLING provides a description of the codes. |
| TOTAL_AGE |
number(1,0) |
Unknown definition. Likely to have been a field used by the REFM Age Unit. A single numeric digit 0-9. Recorded for years 1975, 1976, 1977, 1983, and 1986, and only for salmon species 221, 222, and 223. |
| MATURITY_CODE |
number(1,0) |
A one-digit numeric code used to identify the developmental stage of gonads. The meaning of the maturity code depends on the species for which the information is being collected. NORPAC.FOREIGN_MATURITY_CODE uses SPECIES and MATURITY_CODE to provide 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. |
