| 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. |
| DELIVERY_DATE |
date |
The date of delivery in Alaska Local Time. 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). This is
the date of completion of the delivery to the processing plant. If the delivery continues over two or
more days, use the date when the delivery is complete. This delivery date is entered as the haul_date in
the NORPAC.DOMESTIC_LENGTH and the NORPAC.DOMESTIC_AGE tables even if the actual collection of lengths or age data was on a
different date. This date should coincide with the one used in the NMFS processor logbook and on the
fish ticket. |
| DELIVERY |
number(4,0) |
A unique number which identifies a specific delivery made by a vessel to the port. A day in which no deliveries occurred is recorded with a delivery number of 0 (zero).
|
| GEAR_TYPE |
number(2,0) |
A one- or two-digit numerical code that indicates the kind of fishing device
used by the vessel, where: 1 = non-pelagic trawl, 2 = pelagic trawl, 3 = unknown or mixed trawl,
4 = pair trawl, 5 = shrimp trawl, 6 = pot or trap, 7 = jig, 8 = longline, 9 = gill net, and
10 = Scottish seine. |
| NMFS_AREA_CODE |
number(3,0) |
A three-digit numeric code that represents the marine management subarea where
the majority of the delivery was caught. A subarea is a portion of the Alaska region or the
Washington-Oregon-California region monitored by the National Marine Fisheries Service. |
| TOTAL_DELIVERED |
number(10,3) |
The total weight of fish in a specific delivery (delivery weight), in either metric
tons (to the nearest 1/1000th of a metric ton) or in whole pounds. When cut or bled fish are
delivered, the round weight must be used. |
| DELIVERING_VESSEL |
number(7,0) |
A five-digit numeric code identifying the vessel which caught and/or delivered
fish to the plant or floating processor. This code is either the ADF&G identification code for the vessel,
if it has one, or its U.S. Coast Guard number. |
| FISH_TICKET_NO |
varchar2(10) |
Beginning in 1997, a ten-character field which contains the fish ticket number
assigned to the delivery by plant personnel and used by the state of Alaska to identify catch made by
the delivering vessel. |
| SEQUENCE_NUMBER |
number(5,0) |
A generated field for internal use only. |
| 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. |
| YEAR |
number(4,0) |
A four-digit number identifying the year in which the delivery was completed or a day in which no deliveries occurred. |
| NO_OF_TOWS |
number(2,0) |
For trawl vessels, the number of tows or hauls that were made to catch the
delivery weight. For longline or pot vessels, the number of sets that were made to catch the delivery weight.
|
| AVG_DURATION |
number(4,0) |
The average length of time in minutes of each tow associated with the delivery.
|
| DATE_OF_ENTRY |
date |
Date that data entered the database system. |
| GROUNDFISH_WEIGHED |
varchar2(1) |
A one-digit alpha code indicating whether all groundfish delivered to plant was actually weighted, where Y = Yes; N = No; U = Unknown. |
| FISHING_START_DATE |
date |
The date a catcher boat made the first tow of a trip. |
| 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. |
| TOTAL_POLLOCK_WEIGHT |
number(10,3) |
Data first collected in 2004. Plant observers complete this column if 1) their
plant is: Alyeska, Westward, Unisea, Trident Seafoods (Akutan), Arctic Enterprise, Northern Victor or Peter
Pan Seafoods (King Cove); 2) the Gear code is pelagic trawl ('2'); and 3) all pollock are from the Bering Sea.
The total weight of all pollock in that delivery is recorded here in either metric tions (to the nearest
1/1000th of a metric ton) or in whole pounds. When cut or bled fish are delivered, the round weight must be
used. |
| ATLAS_VERSION |
number(4,0) |
Version number of the 'at-sea' software used for data input and transmission.
First entered in 2004. |
| TOTAL_DELIVERED_MT |
number(10,3) |
The total round weight delivered (including pollock) to the plant for that trip.
The weight is in metric tons recorded to the nearest 1/1000th of a metric ton. When cut or bled fish are delivered, the round weight must be used. |
| TOTAL_POLLOCK_WEIGHT_MT |
number(10,3) |
Total pollock weight converted to metric tons (to the nearest
1/1000th of a metric ton). |
| MT_LB |
varchar2(2) |
Indicates units of measurement of the total delivered weight (metric tons = 'MT',
or pounds = 'LB'). |
