| Table name |
Definition |
| NORPAC.DOMESTIC_AGE |
Age and biological data taken from individual fish. |
| 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. |
| SPECIMEN_TYPE |
number(2,0) |
A one-digit numeric code which identifies the type of age structure(s) taken
from the species: 1 = otoliths, 2 = scales, 3 = fin rays, 4 = otoliths and scales, 5 = otoliths and fin rays,
6 = scales and fin rays, 7 = otoliths, scales, and fin rays, 8 = maturity only, 9 = maturity and age structures. |
| SAMPLING_SYSTEM |
number(2,0) |
A one-digit numeric code which identifies the sampling strategy employed by
the observer: 1 = stratified random, 2 = random, 3 = systematic. |
| SPECIMEN_NUMBER |
number(6,0) |
A unique number assigned to a single specimen within a collection. |
| LENGTH |
number(3,0) |
The fork length in centimeters. |
| WEIGHT |
number(5,2) |
The weight (to one-hundredth of a kilogram) of the individual fish from which
the age structure (or maturity information) was taken. |
| FORM_7 |
varchar2(1) |
A yes/no character field (Y = yes, N = no) which identifies whether or not a
fish selected for the removal of age structures (or maturity information) was taken
from a group of randomly selected fish recorded in the DOMESTIC_LENGTH or INSEASON_LENGTH table.
Effective 1/1/1999, all age records were required to be a subsample of the length data, i.e., the value in
the FORM_7 field in the age table was required to be 'Y'. Effective 1/1/2000, observers were no longer
collecting data pertaining to the FORM_7 field. All age data were still required to be a subsample of
the length data, but the FORM_7 field is null for all data of the year 2000 and later. |
| MATURITY_STAGE |
varchar2(2) |
A numeric code used to identify the developmental stage of gonads. The meaning of the maturity codes are largely unknown. |
| AGE |
number(3,0) |
The age of the fish, recorded in years. Recorded by age readers following
examination of the specimens in the age determination laboratory. |
| NOTES |
varchar2(2) |
For use by age readers. |
| REMARKS |
varchar2(20) |
For use by age readers. |
| SEQUENCE_NUMBER |
number(5,0) |
For use by age readers. |
| 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, marine mammal, and viability interactions. |
| PORT_JOIN |
number(9,0) |
An assigned, unique number (up to nine 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. |
| AGE_TRAY |
number(6,0) |
For use by age readers. |
| AGE_TRAY_X |
varchar2(2) |
For use by age readers. |
| AGE_TRAY_Y |
varchar2(2) |
For use by age readers. |
| 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. |
|
