| Column name |
Type |
Definition |
| CRUISE |
number(4,0) |
A unique four-digit number to represent each occasion that an observer was aboard a different fishing vessel during deployment. Cruise number is associated with all of the data collected by the observer aboard the vessel. |
| 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 B, followed by a three-digit number. |
| JV_Y_N |
varchar2(1) |
A one-digit alpha code which identifies whether the data associated with this cruise and vessel are joint venture data or not. Y = Yes; N = No. |
| VESSEL_TYPE_CODE |
number(1,0) |
A one-digit numeric code associated with vessel type. NORPAC.FOREIGN_VESSEL_TYPE provides a description of the codes. |
| PROCESSING_TYPE_CODE |
number(1,0) |
A one-digit numeric code associated with processing type. NORPAC.FOREIGN_PROCESSING_TYPE provides a description of the codes. |
| OLD_CRUISE |
number(4,0) |
The original cruise number associated with this cruise and vessel. The original cruise number is the cruise number that is recorded on the paper forms. |
| OLD_VESSEL |
varchar2(4) |
The original vessel code associated with this cruise and vessel. The original vessel code is the vessel code that is recorded on the paper forms. |
| COMMENTS |
varchar2(200) |
This field is usually empty. It contains additional information about the cruise and vessel. |
| FILENAME_HAUL |
varchar2(8) |
The original filename on the Burroughs computer system from which the haul data for this record came. |
| FILENAME_LENGTH |
varchar2(8) |
The original filename on the Burroughs computer system from which the length data for this record came. |
| FILENAME_SPCOMP |
varchar2(8) |
The original filename on the Burroughs computer system from which the species composition data for this record came. |
| FILENAME_AGE |
varchar2(8) |
The original filename on the Burroughs computer system from which the age data for this record came. |
