FMA norpac.foreign_vessel Table Documentation

Note: You need to enable scripting and Javascript in your browser settings to best view and navigate our website. Otherwise, use our keyboard navigation and search page. For keyboard tabbing on this page you can bypass the top menu bar navigation and jump to the page sidebar navigation (if applicable), or jump to the page body. Our print link for screen media is scripted. Your computer's normal print command will print this page. Please contact us if you have difficulty in accessing our web pages.

Mobile users can use the Site Map to access the principal pages

FMA norpac.foreign_vessel Table Documentation

Table name	Definition
NORPAC.FOREIGN_VESSEL	This table links the vessel code in several of the major foreign tables (HAUL, SPCOMP, LENGTH, AGE) with the name of the vessel and other features of the vessel.

Column name	Type	Definition
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.
VESSEL_NAME	varchar2(50)	The name of the vessel.
NATION_CODE	varchar2(1)	A one-digit alpha code associated with the vessel's country of registry. The NORPAC.FOREIGN_NATION table provides a description of the codes.
PERMIT_NUMBER	varchar2(7)	A seven-digit value assigned to each distinct foreign fishing vessel upon receiving a permit to fish in U.S. waters.
VESSEL_LENGTH	number(4,0)	The total length (in meters) of the vessel.
GRT	number(5,0)	The Gross Registered Tons of the vessel.
VESSEL_COMMENTS	varchar2(200)	Name changes and permit number changes of the vessel.

Return to Foreign_tables

Last Updated 28 - May - 2009