| Table name |
Definition |
| NORPAC.DOMESTIC_LENGTH |
This table contains information from measured fish and crab. |
| Column name |
Type |
Definition |
| CRUISE |
number(8,0) |
A unique five-digit number assigned to the observer for the length of their
contract period. This number alone identifies and groups a set of observer information. |
| 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 A, followed by a three-digit
number, or for plants, the codes begin with the alpha code P, followed by a three-digit number. |
| HAUL_DATE |
date |
The date of gear retrieval in Alaska Local Time; for trawls, the time that the
retrieval of the net began, i.e., when the winding of the cables began, and the net left the fishing level.
Format is stored in the database as DD-MON-YY format (i.e., 15-MAR-96), and displayed as YYMMDD HH:MI:SS
(i.e., 960315 00:00:00). |
| HAUL |
number(4,0) |
A unique number which identifies a specific occurrence of net, pot, longline or
jig fishing effort or delivery to a plant or floating processor. 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. |
| LENGTH |
number(3,0) |
A length measurement group for a species and sex. For fish, the fork length in
centimeters. For crabs, the carapace width (Tanner crab) or carapace length (king crab) to the nearest 5 mm interval, ending in a 3 or an 8. |
| FREQUENCY |
number(3,0) |
The number of individuals in the species, sex, and length group for the haul/set. |
| EGGS |
varchar2(1) |
Beginning in 1997, a one-digit alpha code used only for female crabs.
N = female crabs not carrying eggs, Y = female crabs carrying eggs, U = unknown. |
| VIABILITY |
varchar2(1) |
Condition of halibut: E = excellent, P = poor, D = dead, U = unknown.
Longline data included up to 1999. Since 2000, longline data recorded in the Injury column. |
| INJURY |
varchar2(1) |
Condition of halibut on longline vessels: 1 = minor, 2 = moderate, 3 = severe,
4 = sand fleas/bleeding. Data series began in 2000. |
| HAUL_JOIN |
number(9,0) |
For vessel data only (not plant data); an assigned, unique number (up to nine
digits) that uniquely identifies each haul/set associated with vessel data. NORPAC.DOMESTIC_HAUL.HAUL_JOIN links a single haul record to records in the domestic tables for data on species composition, length, age, marine mammal, and viability interactions. |
| PORT_JOIN |
number(9,0) |
For plant data only, an assigned, unique number (up to 9 digits) that uniquely identifies each delivery associated with port data. NORPAC.DOMESTIC_PORT.PORT_JOIN links a single delivery record to records in the domestic tables for data on port species composition, length, and age. |
| SEQUENCE_NUMBER |
number(6,0) |
A generated field for internal use only. |
| YEAR |
number(4,0) |
A four-digit number identifying the year in which the gear retrieval of the haul
began. |
| CREATE_DATE |
date |
Date record was inputted into database. |
| CREATED_BY |
varchar2(30) |
Person who loaded data into database. |
| LAST_UPDATE_DATE |
date |
Date data record was last altered. First entered in December 2003. |
| LAST_UPDATED_BY |
varchar2(30) |
Person who last altered data record. First entered in December 2003. |
| ATLAS_VERSION |
number(4,0) |
Version number of the 'at-sea' software used for data input and transmission.
First entered in 2004. |
|
