| Column name |
Type |
Definition |
| 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. |
| 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. This table does not include “no fishing” days. |
| MM_SPECIES |
varchar2(2) |
A two-digit alpha code representing a marine mammal species. NORPAC.MAMMAL_CODES provides the definitions. |
| INTERACTION_NUMBER |
number(5,0) |
An observer-assigned number for each marine mammal interaction noted for a
particular cruise/vessel. The first interaction is assigned the number 1 and consecutive numbers to
the following interactions. Each interaction must have a different code even if the interaction is by the
same individual mammal. For example, two separate records, interaction codes, and interaction numbers would
be documented for an animal that was feeding on catch and then was deterred by the vessel. |
| MM_INTERACTION |
number(2,0) |
A two-digit numeric code identifying what type of interaction occurred and
(if known) the viability of the marine mammal after the interaction. NORPAC.MAMMAL_INTERACTION provides the definitions. |
| MM_NUMBER |
number(3,0) |
The number of marine mammals of that particular species that were involved in
the interaction. |
| MM_CONDITION |
number(1,0) |
A one-digit numeric code identifying the condition of the marine mammal after
the interaction. NORPAC.MAMMAL_CONDITION provides the definitions: 1 = Carcass, dead animal; 2 = Bones other than the skull; 3 = Live animal; 4 = Skull; 5 = Skull and bones; 6 = Tusk/teeth only (no skull); 7 = Baleen only; 9 = Fur, Flesh, or Skin. |
| MM_OBSERVED |
varchar2(1) |
A one-digit alpha code. 'Y' indicates that the observer actually
saw the marine mammal or interaction. 'N' indicates that the observer was informed about the interaction
by a crew member. |
| MM_VERIFIED |
varchar2(1) |
A one-digit alpha code indicating whether or not the species of marine mammal has been verified by staff from the National Marine Mammal Laboratory, began in 1993. Y = Yes; N = No. |
| INJURIED |
varchar2(1) |
A one-digit alpha code indicating whether or not a marine mammal was
injured, where: Y = Yes; N = No; and U = Unknown. |
| DETERRENCE_METHOD |
number(1,0) |
A one-digit number indicating the method of marine mammal deterrence employed. NORPAC.MAMMAL_DETERRENCE provides the definitions: 1 = Seal bombs; 2 = Pole gaff; 3 = Skiff; 4 = Acoustical device; 5 = Yelling; 6 = Making noise; 7 = Other means; 8 = Unknown. |
| DETERRENCE_SUCCESSFUL |
varchar2(1) |
A one-digit alpha code indicating whether or not deterrence was
successful, where: Y = Yes; N = No; and U = Unknown. |
| FOOD_SPECIES
|
number(3,0) |
A three-digit numeric code identifying the food species of a feeding marine
mammal (MM_INTERACTION = 10). This code is associated with species name in NORPAC.DOMESTIC_SPECIES (using the column name SPECIES_NO in place of SPECIES). This data was first collected during 1999. |
| ANOTHER_TRANSACTION |
varchar2(1) |
For Observer Program internal use only. |
| YEAR |
number(4,0) |
A four-digit number identifying the year in which the gear retrieval of the haul
began. |
| IN_MONITORED_Y_N |
varchar2(1) |
A one-digit alpha code indicating whether or not the mammal was observed in
the monitored segment of a longline or pot set for which only a segment of the set is monitored, where:
Y = Yes; N = No. |
| COMMENTS |
varchar2(2000) |
Comments about the interaction from the observer and from the staff from the
National Marine Mammal Laboratory. |
| DATE_OF_ENTRY |
date |
Date that data entered the database system. |
| LAST_EDITOR |
varchar2(12) |
Observer program editor who last made changes to the record. |
| SEQUENCE_NUMBER |
number(5,0) |
For Observer Program internal use only. |
| ANOTHER_INTERACTION |
varchar2(1) |
A one-digit alpha code indicating whether or not the marine mammal was
involved in another interaction, where: Y = Yes; N = No; and U = Unknown. Contains information on
individual marine mammals involved in interactions. |
| 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. |
