| 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. |
| DT |
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).
|
| 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). |
| MAIN_PRODUCT |
number(2,0) |
A two-digit numeric code used to identify the type of product into which the
majority of the sampled fish were made. |
| DATA_SORTED |
varchar2(1) |
A one-digit alpha code indicating whether or not the target fish were sorted by size prior to delivery, where: Y = Yes; N = No; null = Unknown. |
| SAMPLE_DISCARDED |
number(10,3) |
The weight (MT) of fish that were discarded at sea before the delivery was made.
|
| SAMPLE_DELIVERED |
number(10,3) |
The weight (MT) of fish that were delivered. |
| WSD_MT_LB |
varchar2(2) |
Indicates units of measurement of the total delivered weight (metric tons = 'MT', pounds = 'LB'). |
| YR |
number(4,0) |
A four-digit number identifying the year in which the delivery was completed or a day in which no deliveries occurred. |
| 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. |
| 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. |
