| 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 date 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. 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. |
| SAMPLE_TYPE |
varchar2(1) |
A one-digit alpha code which identifies the type of sample taken: B = basket,
L = longline, P = partial haul, Q = second partial haul (only used 1990, 1997, 1998), T = trap/pot,
W = whole haul, X = pre-sorted (started 1999), and O = other (only used 1989-1990). |
| SAMPLE_SIZE |
number(11,2) |
The weight (to the hundredth of a kg) of the entire sample. |
| SAMPLE_NUMBER |
number(6,0) |
The number (count) of the organism in the sample. |
| SAMPLE_WEIGHT |
number(11,2) |
The weight (to the hundredth of a kg) of the organism in the sample. |
| PERCENT_RETAINED |
number(4,0) |
Estimate of the percentage (by weight) of the species that was retained for
processing, began in 1997. |
| EXTRAPOLATED_NUMBER |
number(15,2) |
Extrapolated number (count) of the organism to the entire haul. |
| EXTRAPOLATED_WEIGHT |
number(15,2) |
The weight (to the hundredth of a kg) of the organism extrapolated to the entire haul.
|
| ALLOCATED_SAMPLE_WEIGHT |
number(11,3) |
The amount (weight) of the sample_weight made up of allocated species. |
| SEQUENCE_NUMBER |
number(6,0) |
A generated field for internal use only. |
| HAUL_JOIN |
number(9,0) |
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, and marine mammal interactions. |
| YEAR |
number(4,0) |
A four-digit number identifying the year in which the gear retrieval of the haul
began. |
| DATE_OF_ENTRY |
date |
Date that data entered the database system. |
| 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. |
