FMA norpac.vessel_plant View 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.vessel_plant View Documentation

View name	Definition
NORPAC.VESSEL_PLANT	This is a view that links the vessel or plant code with it's name or with other codes.

Column name	Type	Definition
VESSEL	varchar2(4)	A unique four-digit, alpha-numeric code identifying each domestic vessel or plant 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.
VESSEL_NAME	varchar2(30)	The name of the vessel.
PERMIT	number(5,0)	The last four (or five) digits of the permit number.
CG_NUMBER	varchar2(8)	This is the US Coast Guard number of the vessel.
ADFG_NUMBER	varchar2(8)	This is the ADFG number of the vessel.
VESSEL_LENGTH	number(4,0)	This is the length overall (in feet) of the vessel.
OLD_VESSEL	varchar2(4)	This is the old 4-digit alpha-numeric code of the vessel or plant.

Return to Domestic_tables

Last Updated 23 - June - 2009