| Table name |
Definition |
| NORPAC.DOMESTIC_VESSEL_TYPE |
This table provides a definition for each vessel_type code. |
| Column name |
Type |
Definition |
| VESSEL_TYPE |
number(2,0) |
A one or two-digit numeric code that indicates whether the vessel processes fish or delivers it to a processing plant where: 1 = a catcher processor vessel, 2 = a mothership or a ship that receives unsorted codends from other vessels, 3 = a catcher only vessel that delivers unprocessed fish to a shoreside or floating plant or vessel, 4 = a mothership that receives sorted codends, 5 = a vessel that sells the majority of their catch over the side to other fishing vessels who will utilize the fish for bait, 6 = vessels that discard all catch from a haul. Would be used for codend dumping of an entire haul (added January 2004). The vessel_type values greater than 6 are not found in NORPAC.DOMESTIC_HAUL or NORPAC.DOMESTIC_HAUL_V. These are defined in the VESSEL_TYPE_DESC column. |
| VP_VESSEL_TYPE |
varchar2(2) |
A one or two-digit alpha code. CP = catcher processor vessel, M = mothership
or ship that receives unsorted codends from other vessels, C = catcher only vessel that delivers unprocessed
fish, F = floating plant, P = shoreside plant, T = tender, S = support vessel. |
| VESSEL_TYPE_DESC |
varchar2(40) |
Descriptions associated with the vessel_type code. 1 = a catcher processor vessel, 2 = a mothership or a ship that receives
unsorted codends from other vessels, 3 = a catcher only vessel that delivers unprocessed fish to a
shoreside or floating plant or vessel, 4 = a mothership that receives sorted codends, 5 = a vessel that
sells the majority of their catch over the side to other fishing vessels who will utilize the fish for bait,
6 = vessels that discard all catch from a haul (would be used for codend dumping of an entire haul
[added January 2004]). 12 = a vessel that acts both as a catcher processor and a mothership,
13 = a vessel that acts both as a catcher vessel and a catcher processor, 90 = floating plant,
91 = floater and a catcher processor, 92 = floater and a mothership, 93 = floater, catcher processor
and a mothership, 94 = shoreside plant, 95 = tender, 96 = support vessel, 0 = unknown vessel type. |
|
